php中mysql的封装

rihi

正常数据库连接是这样的

• [PHP] 纯文本查看 复制代码

  <?php 
   
      //连接数据库 
      $link = mysql_connect('localhost', 'root', '123456') 
      mysql_select_db('ruida'); 
   
      //执行查询语句 
      $query = 'select * from user where name="xiaoming"'; 
      $result = mysql_query($query); 
   
      //整理格式输出 
      while ($line = mysql_fetch_assoc($result)) { 
          echo "..."; 
      }    
   
      //释放结果集,关闭链接 
      mysql_free_result($result); 
      mysql_close($link);   
  ?>   
   
   
  
      
  <?php 
  
      
      //连接数据库
  
      
      $link = mysql_connect('localhost', 'root', '123456')
  
      
      mysql_select_db('ruida');
  
      
   
  
      
      //执行查询语句
  
      
      $query = 'select * from user where name="xiaoming"';
  
      
      $result = mysql_query($query);
  
      
   
  
      
      //整理格式输出
  
      
      while ($line = mysql_fetch_assoc($result)) {
  
      
          echo "...";
  
      
      }
  
      
   
  
      
      //释放结果集,关闭链接 
  
      
     mysql_free_result($result);
  
      
      mysql_close($link);
  
      
  ?>   
  
   
   
   
   
  //玩家提问，创建了一个任务 
  $task   = $user->createTask(); 
   
  //客服拉取任务 
  $task    = $cs->pullTask(); 
   
  //客服开始解决问题 
  $cs->startTask(); 
   
  //客服解决问题后，结束此次服务 
  $cs->endTask(); 
   
  //玩家提问，创建了一个任务 
  $task   = $user->createTask(); 
   
  //客服拉取任务 
  $task   = $cs->pullTask(); 
   
  //客服开始解决问题 
  $cs->startTask($task); 
   
  //客服解决问题后，结束此次服务 
  $cs->endTask($task); 
   
  //玩家提问，创建了一个任务 
  $result  = $user->createTask(); 
  $this->assertEqual(true,$result); 
   
  //客服拉取任务 
  $task   = $cs->pullTask(); 
  $this->assertNotEqual(null,$task->id); 
   
  //客服开始解决问题 
  $result = $cs->startTask($task); 
  $this->assertEqual(true,$result); 
   
  //客服解决问题后，结束此次服务 
  $result = $cs->endTask($task); 
  $this->assertEqual(true,$result); 
   
  sudo crontab -e 
   
  */5 * * * * (  sh  cs_check.sh >> /cs.log 2>&1 ) 
   
  $area   = 100; 
  if($city == "北京") 
  { 
      $unit_price     = 20000;                            
      $tax_rate       = 0.2;                              
      $total_price    = $area*$unit_price+$tax_rate($area*$unit_price); 
  }                           
  elseif($city == "上海" || $city == "广州" ) 
  {    
      $unit_price     = 18000; 
      $tax_rate       = 0.1; 
      $total_price    = $area*$unit_price+$tax_rate($area*$unit_price); 
  } 
  else 
  { 
      $unit_price     = 5000; 
      $total_price    = $area*$unit_price; 
  } 
   
  $area   = 100; 
  if($city == "北京") 
  { 
      $unit_price     = 20000;                            
      $tax_rate       = 0.2;                              
      $total_price    = $area*$unit_price+$tax_rate($area*$unit_price); 
  }                           
  elseif($city == "上海" || $city == "广州" ) 
  {    
      $unit_price     = 18000; 
      $total_price    = $area*$unit_price; 
  }    
  else 
  { 
      //... 
  } 
  
  $area           = 100; 
  $unit_price     = priceLookUp($city); 
  $tax_rate       = rateLookUp($city); 
  $total_price    = (1+$tax_rate)$area*$unit_price; 
   
  if($city == "北京") 
  { 
      $unit_price     = 20000; 
      $tax_rate       = 0.2; 
      $total_price    = (1+$tax_rate)$area*$unit_price; 
  } 
  elseif($city == "上海" || $city == "广州" ) 
  { 
      $unit_price     = 18000; 
      $tax_rate       = 0.1; 
      $total_price    = (1+$tax_rate)$area*$unit_price; 
  }    
  else 
      //... 
  
  $unit_price     = priceLookUp($city); 
  $tax_rate       = rateLookUp($city); 
  $total_price    = (1+$tax_rate)$area*$unit_price; 

  
  

xiaui520

不知该说些什么。。。。。。就是谢谢

浪人

饭在锅里,我在床上*^_^*

roger2001c

不在放荡中变坏，就在沉默中变态！

zzbb

修养的艺术,其实就是说谎的艺术。

mr923

恋爱就是无数个饭局，结婚就是一个饭局。

zhaoke0727

要是我灌水，就骂我“三个代表”没学好吧。