php的mysqli库（非mysql库)

zhgc

php的mysqli库（非mysql库)

数据库的连接

1. $db = mysqli_connect("127.0.0.1", "root", "******");
   
2. if (!$db) {
   
3.         $data["msg"]="prepare_db: ".mysqli_connect_error();
   
4.         die(json_encode($data,JSON_UNESCAPED_UNICODE));
   
5. } else {
   
6.         $data["msg"]="mes database connect ok!";
   
7. }

复制代码

简单查询

1. $sql="select date_format(now(),\"%Y-%m-%d %H:%i:%s\") DT from dual";
   
2. $result = mysqli_query($db,$sql);
   
3. if (!$result) {
   
4.         $data["msg"]="a1:".mysqli_error($db);
   
5.         die(json_encode($data,JSON_UNESCAPED_UNICODE));
   
6. }
   
7. if($row = mysqli_fetch_assoc($result))
   
8. {
   
9.         $data["tick"]=$row["DT"];  
   
10.   
    
11. }
    
12. mysqli_free_result($result);

复制代码

zhgc

1. $sql="select aa.TEST_CODE,bb.ERROR_DESC,aa.QTY from (
   
2. select test_code,count(1) qty from sfc.r109 where test_line='{$line}'
   
3. and test_time > date_add(now(),interval -1 day)
   
4. group by test_code order by qty desc
   
5. ) aa left join sfc.c_error_code_t bb on aa.test_code=bb.error_code";
   
6. $result = mysqli_query($db,$sql);
   
7. if (!$result) {
   
8.         $data["msg"]="a1:".mysqli_error($db);
   
9.         die(json_encode($data,JSON_UNESCAPED_UNICODE));
   
10. }
    
11. while($row = mysqli_fetch_assoc($result))
    
12. {
    
13.         $data["top10"][]=$row;  
    
14.         $data["etotal"]=$data["etotal"]+$row["QTY"]*1;
    
15. }
    
16. mysqli_free_result($result);

复制代码