php 7 mysqli接続mysqlのいくつかの方法

一.プロセスは方法です

function connect(){
     static $conn;
     if(!$conn){
         $conn = mysqli_connect(DB_HOST,DB_USER,DB_PWD) ;
     }

    if (mysqli_connect_errno($conn))
    {
        echo "   MySQL   : " . mysqli_connect_error();
    }
    mysqli_set_charset($conn,DB_CHARSET);
    mysqli_select_db($conn,DB_DBNAME) or die("         ");
/* //       
    $sql="select category_id,category_name from category";
    //$sql = "SELECT * FROM admin";
    $result = mysqli_query($conn, $sql);
//        
//var_dump(mysqli_fetch_all($result));die;
//        
    $data = [];
    while($row = mysqli_fetch_assoc($result)) {
//mysqli_fetch_array
        $data[] = $row;
    }
//      
    var_dump($data);*/
return $conn;
}
/*    */
function fetchAll($sql,$result_type=MYSQLI_ASSOC){
    $conn=connect();
   $result=mysqli_query($conn,$sql);
   while(@$row=mysqli_fetch_array($result,$result_type)){
      $rows[]=$row;
   }
   return $rows;
}

 
転載先:https://www.cnblogs.com/jiangfeilong/p/11189067.html