<?php
//读取数据的写法:
$servername="localhost";
$usename="root";
$password="";
$mydb="demo";
//创建链接
$mysqli=new mysqli($servername,$usename,$password,$mydb);
//判断连接是否成功
if($mysqli->connect_error){
die("连接失败。。").$mysqli->connect_error();
}
echo "连接成功";
$sql="select * from student";
$rowww=$mysqli->query($sql);
if($rowww->num_rows>0){
//输出每行数据
while($row=$rowww->fetch_assoc()){
echo "<br/>ID是:".$row['id']."<br/>名字是:".$row['stuname']."<br/>年龄是:".$row['stuAge']."<br/>电话是:".$row['tel'];
}
}
关闭数据库
?>
//读取数据的写法:
$servername="localhost";
$usename="root";
$password="";
$mydb="demo";
//创建链接
$mysqli=new mysqli($servername,$usename,$password,$mydb);
//判断连接是否成功
if($mysqli->connect_error){
die("连接失败。。").$mysqli->connect_error();
}
echo "连接成功";
$sql="select * from student";
$rowww=$mysqli->query($sql);
if($rowww->num_rows>0){
//输出每行数据
while($row=$rowww->fetch_assoc()){
echo "<br/>ID是:".$row['id']."<br/>名字是:".$row['stuname']."<br/>年龄是:".$row['stuAge']."<br/>电话是:".$row['tel'];
}
}
关闭数据库
$mysqli->close();
红色的部分是关键字也是需要记忆的地方
?>