PHP and mysql create data tables and obtain content to render to the front-end page-PHP Tutorial-php.cn

PHP and mysql create data tables and obtain content to render to the front-end page

小云云

Release： 2023-03-21 09:42:02

Original

3925 people have browsed it

This article mainly shares with you the methods of creating data tables with php and mysql and getting the content to render to the front-end page. I hope it can help you.

1. mysqlCommand line to create a data table (table structure):

Source code:

create table myValues(

 id int(4) not null primary key auto_increment,

 name char(20) not null,

 year int(20) not null,

 sex char(20) not null,

 class char(20) not null,

 degree double(16,2)

);

Copy after login

2. mysqlCommand line view table structure:

#3.phpConnectionmysqli Database

$connect = mysqli_connect(&#39;localhost&#39;,&#39;root&#39;,&#39;root&#39;); //连接数据库

if($connect){
     echo &#39;连接数据库成功！&#39;;
}else{
     echo &#39;连接数据库失败&#39;;
}

//连接数据表
mysqli_select_db($connect,&#39;lgc&#39;);

Copy after login

4. phpInsert data into the database

 //向数据库发送操作信息

 mysqli_query($connect,&#39;set names utf8&#39;);

 mysqli_query($connect,&#39;insert into myvalues values(1,"王二",20,"男","13.1班","98.68")&#39;);  

 mysqli_query($connect,&#39;insert into myvalues values(2,"李三",22,"男","12.5班","88.66")&#39;);  

 mysqli_query($connect,&#39;insert into myvalues values(3,"小花",16,"女","13.1班","78.32")&#39;);  

 mysqli_query($connect,&#39;insert into myvalues values(4,"小明",15,"男","12.6班","69.95")&#39;);  

 mysqli_query($connect,&#39;insert into myvalues values(5,"小刚",18,"男","13.2班","83.75")&#39;);  

 mysqli_query($connect,&#39;insert into myvalues values(6,"小贝",23,"女","12.3班","93.63")&#39;);

Copy after login

##5. php

Send query information to the database

//像数据库提交查询信息(所有信息) 返回查询到资源句柄

$info = mysqli_query($connect,&#39;select * from myvalues&#39;);

Copy after login

6.php

Get the data queried in the database: (Important)

$newArr = array();
while($arry = mysqli_fetch_array($info,MYSQLI_ASSOC))
{
     array_push($newArr,$arry);
}

exit(json_encode($newArr));

//获取数据：
//Array ( [0] => Array ( [id] => 1 [name] => 王二 [year] => 20 [sex] => 男 [class] => 13.1班 [degree] => 98.68 ) [1] => Array ( [id] => 2 [name] => 李三 [year] => 22 [sex] => 男 [class] => 12.5班 [degree] => 88.66 ) [2] => Array ( [id] => 3 [name] => 小花 [year] => 16 [sex] => 女 [class] => 13.1班 [degree] => 78.32 ) [3] => Array ( [id] => 4 [name] => 小明 [year] => 15 [sex] => 男 [class] => 12.6班 [degree] => 69.95 ) [4] => Array ( [id] => 5 [name] => 小刚 [year] => 18 [sex] => 男 [class] => 13.2班 [degree] => 83.75 ) [5] => Array ( [id] => 6 [name] => 小贝 [year] => 23 [sex] => 女 [class] => 12.3班 [degree] => 93.63 ) )

//json_encode()之后：
[{"id":"1","name":"\u738b\u4e8c","year":"20","sex":"\u7537","class":"13.1\u73ed","degree":"98.68"},{"id":"2","name":"\u674e\u4e09","year":"22","sex":"\u7537","class":"12.5\u73ed","degree":"88.66"},{"id":"3","name":"\u5c0f\u82b1","year":"16","sex":"\u5973","class":"13.1\u73ed","degree":"78.32"},{"id":"4","name":"\u5c0f\u660e","year":"15","sex":"\u7537","class":"12.6\u73ed","degree":"69.95"},{"id":"5","name":"\u5c0f\u521a","year":"18","sex":"\u7537","class":"13.2\u73ed","degree":"83.75"},{"id":"6","name":"\u5c0f\u8d1d","year":"23","sex":"\u5973","class":"12.3\u73ed","degree":"93.63"}]

Copy after login

7. ajax

Load data:

8. The page displays mysqldata table information:

Related recommendations:

How about React Get data from backend and render to frontend?

The above is the detailed content of PHP and mysql create data tables and obtain content to render to the front-end page. For more information, please follow other related articles on the PHP Chinese website!