php简单实现查询数据库返回json数据(返回json数据函数实例)

1. <meta charset="utf-8">
   <?php 
   include("config.php");
    
    function json($code,$message="",$data=array()){  
               $result=array(  
                 'code'=>$code,  
                 'message'=>$message,  
                 'data'=>$data   
               );  
               //输出json  
               echo json_encode($result);  
               exit;  
   }  
    
   	
   	
       $sqla = "SELECT * from data_type";  
       $result = mysqli_query($conn, $sqla);
       $dataarr = array();  
       //while($row = mysql_fetch_array($result)){  
   	while($row = mysqli_fetch_assoc($result)) {
           $dataarr[]=$row;  
       }  
    echo json(1,'数据返回成功',$dataarr);  
    
   //    if($id==1){  
   //       echo json(1,'数据返回成功',$dataarr);  
   //    }else if($id==2){  
   //        echo json(0,'失败');  
   //    } 
    
   ?>