本文主要和大家分享PHP数据库操作基础入门,希望能帮助到大家。
获取表单数据
_POST[”]获取POST提交的数据,而
_REQUEST获取一个类似于map的键值对数据结构。
1 查询数据
// 数据库信息 $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 添加数据
$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 "插入新记录失败"; }
参考:
查询结果输出为json格式:https://www.cnblogs.com/yiven/p/6491019.html
批量获取数据并存入数据:http://bbs.blueidea.com/thread-3056406-1-1.html
获取表单数据
_POST[”]获取POST提交的数据,而
_REQUEST获取一个类似于map的键值对数据结构。
1 查询数据
// 数据库信息 $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 添加数据
$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 "插入新记录失败"; }
相关推荐:
Atas ialah kandungan terperinci PHP数据库操作基础入门. Untuk maklumat lanjut, sila ikut artikel berkaitan lain di laman web China PHP!