php mysqli扩展库
示例:<?php
#连接数据库
$link=mysqli_connect("localhost","root","root");
#选择数据库
$link->select_db("rorely") or die("could not find database");
#查询数据库
$result=$link->query("select * from test");
#输出数据库表各个记录的内容
while($row=mysqli_fetch_object($result)){
echo $row->id." ".$row->name." ".$row->age." ".$row->sex." ".$row->address."<hr>";
}
#关闭数据库
mysqli_close($link);
?>
1 Jane26 female wenming cun 123#3 Tome21 male wenming cun 32#4 Lily25 female wenming cun 2#5 Lucy25 female wenming cun 2#6 Jim22 male wenmin cun 45#7 Jim22 male wenmin cun 45#8 Jim22 male wenmin cun 45#9 Jim22 male wenmin cun 45#10 Jim22 male wenmin cun 45#11 Jim22 male wenmin cun 45#12 Jim22 male wenmin cun 45#13 Jniu22 female address14 Jim22 male wenmin cun 45#15 Jim22 male wenmin cun 45#18 Jim22 male wenmin cun 45#20 Jim22 male wenmin cun 45#78 lili22 female wenming cun 23#79 hj30 male wenming cun 23#80 hj30 male wenming cun 23#
页:
[1]