PHP与数据库连接具体代码实现
<?php
$mysql_server = "localhost";
$mysql_username = "root";
$mysql_password = "1234";
$mysql_dbbase = "test";
$conn = mysql_connect($mysql_server, $mysql_username, $mysql_password) or die("数据库连接失败");
mysql_select_db("test",$conn) or die("关连失败");
$sqlstr = "select * from user";
$result = mysql_query($sqlstr) or die("进行数据表操作失败");
echo "<table>";
echo "<tr>";
//获取所查询的字段
for($i = 0; $i < mysql_numfields($result); $i++){
echo "<td>";
echo mysql_field_name($result,$i);
echo "</td>";
}
echo "</tr>";
//循环输出所查询的内容
while($row=mysql_fetch_row($result)){
echo "<tr>";
$i = 0;
while($i < mysql_numfields($result)){
echo "<td>";
echo $row[$i++];
echo "</td>";
}
echo "</tr>";
}
echo "</table>"
?>