php抓取网页数据插入数据库(1.mysql创建数据表及获取内容渲染到前端页面的方法 )

　　php抓取网页数据插入数据库(1.mysql创建数据表及获取内容渲染到前端页面的方法

)

　　本文主要与大家分享php和mysql创建数据表和获取内容渲染到前端页面的方法。希望能帮到你。

　　1. mysql 命令行创建数据表（表结构）：

　　源代码：创建表 myValues(

　　id int(4) not null 主键 auto_increment,

　　name char(20) not null,

　　year int(20) not null,

　　sex char(20) 非空，

　　class char(20) not null,

　　度双(16,2)

　　);

　　2.mysql命令行查看表结构：

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

　　if($connect){

　　echo'连接数据库成功！ ';

　　}其他{

　　echo'连接数据库失败';

　　}

　　//连接数据表

　　mysqli_select_db($connect,'lgc');

　　4. php向数据库插入数据//向数据库发送操作信息

　　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 向数据库发送查询信息//提交查询信息如数据库（所有信息）返回查询到资源句柄

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

　　6.php获取数据库中查询到的数据：（重要）$newArr = array();

　　while($arry = mysqli_fetch_array($info,MYSQLI_ASSOC))

　　{

　　array_push($newArr,$arry);

　　}

　　退出(json_encode($newArr));

　　//获取数据：

　　//Array([0] => Array([id] => 1 [name] => Wang Er[year] => 20 [sex] => 男[class] => 13. 1 class [degree] => 98.68) [1] => Array ([id] => 2 [name] => Li San[year] => 22 [sex] => male [class] => 12.5班[degree] => 88.66) [2] => Array ([id] => 3 [name] => Xiaohua[year] => 16 [sex] ] => 女[class] => 13.1班[degree] => 78.32) [3] => Array ([id] => 4 [name] => Xiaoming[ year] => 15 [sex] => 男[class] => 12.6班[degree] => 69.95) [4] => Array ([id] => 5 [姓名] => 小刚[年] => 18 [性别] => 男[班级] => 13.2班[度] => 83.75) [5] => 阵列([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":"7< @8.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 加载数据：

　　8.页面显示mysql数据表信息：