开发日志 PHP连接mysql数据库

最新推荐文章于 2024-04-18 05:00:00 发布

可可与二宝

最新推荐文章于 2024-04-18 05:00:00 发布

阅读量725

点赞数

本文链接：https://blog.csdn.net/namelb/article/details/45458827

版权

说明：my_db_query 已废弃掉了，改用my_query，表名前名加上数据库实例名字就可以了。

<html>
<head>
<title>WEB database sample index</title>
</head>

<body bgcolor=#ffffff>
   <h2>data from tbl</h2>
<?php
mysql_connect ( 'localhost', 'root', '' ) or die ( "problem connecting to database" );
$query = "select * from example.tbl";
$result = mysql_query ( $query );

if ($result) {

   echo "Found thest entries in the database:<br><p></p>";
   echo "<table width =90% align =center border =1> <tr>
    <td align =center bgcolor =#00ffff> User Name </td>
    <td align=center bgcolor=#00FFFF>Last Name</td>
　　<td align=center bgcolor=#00FFFF>Domain Name</td>
　　<td align=center bgcolor=#00FFFF>Request Date</td>
　　</tr>";

   while ( $r = mysql_fetch_array ( $result ) ) {
       $idx = $r ["idx"];
       $user = $r ["UserName"];
       $last = $r ["LastName"];
       $text = $r ["FreeText"];
       echo "<tr>
     　　<td>$idx</td>
     　　<td>$user</td>
     　　<td>$last</td>
     　　<td>$text</td>
     　　</tr>";

       echo "</table>";

   }
}
   else
   {
echo "no data";

}
mysql_free_result($result);
?>
</body>
</html>