深圳全飞鸿

标题: php的mysqli库（非mysql库) [打印本页]

---

作者: zhgc    时间: 2021-7-31 18:54
标题: php的mysqli库（非mysql库)
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    时间: 2022-6-12 12:10

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);

复制代码

---

欢迎光临 深圳全飞鸿 (http://www.nagomes.com/disc/)

Powered by Discuz! X3.2