The content of this article is about PHP script reading local database data. It has certain reference value. Now I share it with everyone. Friends in need can refer to it.
The code is as follows:
<!DOCTYPE html><html><body> <center>
<?php
//设置编码格式
header("Content-type:text/html;charset=utf-8");
//新建连接
$con = mysql_connect("localhost","root","000000");
//检测连接
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
//选择数据库
mysql_select_db("ycf", $con);
//执行sql语句
$result = mysql_query("SELECT * FROM tempdata");
//设置表格格式
echo "<table border='1'>
<tr>
<th>ion</th>
<th>temperature</th>
<th>humidity</th>
</tr>";
//遍历数据库，将数据放入表格
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['ion'] . "</td>";
echo "<td>" . $row['temperature']/10 . "</td>";
echo "<td>" . $row['humidity'] . "</td>"; echo "</tr>";
}
echo "</table>";
//关闭数据库连接mysql_close($con);
?>
</center>
</body>
</html>Related recommendations:
Using Crontab to implement PHP script timing tasks under Linux
php script daemon process principle and implementation code
The above is the detailed content of PHP script to read local database data. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
