Home >Backend Development >PHP Tutorial >PHP and mysql create data tables and obtain content to render to the front-end page

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

小云云
小云云Original
2018-03-13 10:45:513907browse

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)

);

2. mysqlCommand line view table structure:


#3.phpConnectionmysqli Database

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

if($connect){
     echo '连接数据库成功!';
}else{
     echo '连接数据库失败';
}

//连接数据表
mysqli_select_db($connect,'lgc');


4. phpInsert data into the database

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

 mysqli_query($connect,'set names utf8');

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

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

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

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

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

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


##5. php

Send query information to the database

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

$info = mysqli_query($connect,'select * from myvalues');


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"}]

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn