PHP数据库的连接与代码实现

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>"
?>