Home > Article > Backend Development > PHP script to read local database data

PHP script to read local database data

不言Original: 2018-04-17 15:39:173029browse

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(&#39;Could not connect: &#39; . mysql_error());
  } 
  //选择数据库
  mysql_select_db("ycf", $con); 
  //执行sql语句
  $result = mysql_query("SELECT * FROM tempdata"); 
  //设置表格格式  
  echo "<table border=&#39;1&#39;>
<tr>
<th>ion</th>
<th>temperature</th> 
<th>humidity</th>
</tr>"; 

 //遍历数据库，将数据放入表格
 while($row = mysql_fetch_array($result))
  {  
  echo "<tr>";  
  echo "<td>" . $row[&#39;ion&#39;] . "</td>"; 
  echo "<td>" . $row[&#39;temperature&#39;]/10 . "</td>"; 
  echo "<td>" . $row[&#39;humidity&#39;] . "</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!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：PHP two-dimensional array sortingNext article：PHP two-dimensional array sorting

See more

PHP script to read local database data

Related articles