Home > Article > Backend Development > Introduction to basics of PHP database operations
This article mainly shares with you the basic introduction to PHP database operations, hoping to help everyone.
Get form data
_POST[”]Get the data submitted by POST, and
_REQUEST Obtains a key-value pair data structure similar to map
1 Query data
// 数据库信息 $url = "192.168.199.146"; //$url = "localhost"; $username = "root"; $password = "123123"; $db_name = "test"; // 获取数据 $conn = new mysqli ( $url, $username, $password, $db_name ); if ($conn->connect_error) { die ( "db connection error" ); } $start_rows = ($page-1) * $rows; $sql = "SELECT * FROM user LIMIT " . $start_rows . "," . $rows; $result = $conn->query ( $sql ); $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); } $jobj=new stdclass();//实例化stdclass,这是php内置的空类,可以用来传递数据,由于json_encode后的数据是以对象数组的形式存放的, //$jobj->total=$result->num_rows;//总数 //获取总数 $get_all_user_sql="SELECT count(*) as total FROM user"; $result_total = $conn->query ( $get_all_user_sql ); $rows_total=$result_total->fetch_assoc()["total"]; $jobj->total = $rows_total; $jobj->rows=$jarr; //所以我们生成的时候也要把数据存储在对象中 /*foreach($jarr as $key=>$value){ $jobj->$key=$value; }*/ echo json_encode($jobj);
2 Add data
$url = "192.168.199.146"; //$url="localhost"; $username = "root"; $password = "123123"; $db_name = "test"; //连接数据库 $conn = new mysqli ( $url, $username, $password, $db_name ); if ($conn->connect_error) { die ( "db connection error" ); } //保存数据 $insert_sql="INSERT user(name,password)"; $insert_sql=$insert_sql." VALUES('".$param['name']."','".$param['password']."')"; echo $insert_sql; $result=$conn->query($insert_sql); if($result===true){ echo "新记录插入成功"; }else{ echo "插入新记录失败"; }
Reference:
The query results are output in json format: https://www.cnblogs.com/yiven/p/6491019.html
Get data in batches and store the data: http://bbs.blueidea.com/thread- 3056406-1-1.html
Get form data
_POST[”]Get the data submitted by POST, and
#_REQUEST Gets a map-like key-value pair data structure.
1 Query data
// 数据库信息 $url = "192.168.199.146"; //$url = "localhost"; $username = "root"; $password = "123123"; $db_name = "test"; // 获取数据 $conn = new mysqli ( $url, $username, $password, $db_name ); if ($conn->connect_error) { die ( "db connection error" ); } $start_rows = ($page-1) * $rows; $sql = "SELECT * FROM user LIMIT " . $start_rows . "," . $rows; $result = $conn->query ( $sql ); $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); } $jobj=new stdclass();//实例化stdclass,这是php内置的空类,可以用来传递数据,由于json_encode后的数据是以对象数组的形式存放的, //$jobj->total=$result->num_rows;//总数 //获取总数 $get_all_user_sql="SELECT count(*) as total FROM user"; $result_total = $conn->query ( $get_all_user_sql ); $rows_total=$result_total->fetch_assoc()["total"]; $jobj->total = $rows_total; $jobj->rows=$jarr; //所以我们生成的时候也要把数据存储在对象中 /*foreach($jarr as $key=>$value){ $jobj->$key=$value; }*/ echo json_encode($jobj);
2 Add data
$url = "192.168.199.146"; //$url="localhost"; $username = "root"; $password = "123123"; $db_name = "test"; //连接数据库 $conn = new mysqli ( $url, $username, $password, $db_name ); if ($conn->connect_error) { die ( "db connection error" ); } //保存数据 $insert_sql="INSERT user(name,password)"; $insert_sql=$insert_sql." VALUES('".$param['name']."','".$param['password']."')"; echo $insert_sql; $result=$conn->query($insert_sql); if($result===true){ echo "新记录插入成功"; }else{ echo "插入新记录失败"; }
Related recommendations:
php database operation and database connection tutorial
Detailed explanation of basic command examples for MySQL database operation
The above is the detailed content of Introduction to basics of PHP database operations. For more information, please follow other related articles on the PHP Chinese website!