PHP implements methods to obtain data in the database

This article mainly introduces the method of obtaining data in the database in PHP. Interested friends can refer to it. I hope it will be helpful to everyone.

No more nonsense, just go to the code

<?php 
header("Content-type:text/html;charset=utf-8");//字符编码设置 
$servername = "localhost"; 
$username = "root"; 
$password = "root"; 
$dbname = "web"; 
 
// 创建连接 
$con =mysqli_connect($servername, $username, $password, $dbname); 
 
// 检测连接 
 
  
$sql = "SELECT * FROM users"; 
$result = mysqli_query($con,$sql); 
if (!$result) {
  printf("Error: %s\n", mysqli_error($con));
  exit();
}
 
$jarr = array();
while ($rows=mysqli_fetch_array($result,MYSQL_ASSOC)){
  $count=count($rows);//不能在循环语句中，由于每次删除 row数组长度都减小 
  for($i=0;$i<$count;$i++){ 
    unset($rows[$i]);//删除冗余数据 
  }
  array_push($jarr,$rows);
}
echo $str=json_encode($jarr);//将数组进行json编码
?>

This is after getting it Convert to json format

Related recommendations:

php automatic backupDatabasetable method

How to read large CSV files with PHP and import them into database

php mysqldatabaseHow to encapsulate classes

The above is the detailed content of PHP implements methods to obtain data in the database. For more information, please follow other related articles on the PHP Chinese website!