<?php
//选择数据库文件
$host ="127.0.0.1"; //mysql地址
$username="root";
$password="";
$dbname="db_study"; //数据库名字
$tablename="tb2"; //表名
echo"现在开始尝试连接mysql"."<br>";
if($connID= mysqli_connect($host,$username,$password,$dbname) ) //连接mysql
{
echo"数据库连接成功!"."<p>";
mysqli_query($connID,"set names utf8mb4"); //没有此行代码 一会儿插入内容就是乱码
mysqli_query($connID,"SELECT * FROM $tablename ");
mysqli_query($connID,"INSERT INTO $tablename (id, name, pwd, addr)
VALUES (6,'剑圣','4008','部落')");
}
else{
echo"数据库连接失败!"."<p>";
}
?>
//================从mysql数据库表中读取数据,显示到网页表格中==================================
<?php
//选择数据库文件
$host ="127.0.0.1"; //mysql地址
$username="root";
$password="";
$dbname="db_study"; //数据库名字
$tablename="tb2"; //表名
$retn=0; //mysqli_query()成功执行返回1
echo"现在开始尝试连接mysql"."<br>";
if($connID= mysqli_connect($host,$username,$password,$dbname) ) //连接mysql
{
echo"数据库连接成功!"."<p>";
mysqli_query($connID,"set names utf8mb4");
$retn= mysqli_query($connID,"INSERT INTO $tablename (id, name, pwd, addr)
VALUES (6,'剑圣','4008','部落')");
if($retn){echo"语句执行成功!"."<p>";}else{echo"语句执行失败!"."<p>";}
echo " /*//表格*/
<table border= \"1px\" align=\"left\">
<tr>
<td>id</td>
<td>name</td>
<td>pwd</td>
<td>addr</td>
</tr>
";
$retn= mysqli_query($connID,"SELECT * FROM $tablename ");
当mysqli_query的具体内容为查询时,此函数的返回值是一个多行代码,并且无法转换成字符串
while($result=mysqli_fetch_array($retn))
{
echo" <tr>行 <td>列
<tr>
<td>".$result["id"]."</td>
<td>".$result["name"]."</td>
<td>".$result["pwd"]."</td>
<td>".$result["addr"]."</td>
</tr>
";
}
}
else{
echo"数据库连接失败!"."<p>";
}
?>