PHP笔记（7）链接MySQL且查询

<?php
$ServerName = 'localhost';
$UserName	= 'root';
$PassWord 	= 'root';
$con = mysql_connect($ServerName,$UserName,$PassWord);
if(!$con)
{
	die('Could not Connect Server! Error'.mysql_error());
}else
{
	echo 'Connect MySql SuccessFul!'.'<br />';
}
mysql_select_db('test',$con);

$result = mysql_query('select * from dasemimi');
echo "<table border='0' bgcolor=red>
<tr>
<th>user</th><th>pwd</th>
</tr>
";
while($row = mysql_fetch_array($result))
{
echo '<tr>';
echo '<td>'.$row['user'].'</td>';
echo '<td>'.$row['pwd'].'</td>';
echo "</tr>";
}
mysql_free_result($result);
mysql_close($con);
?>

在这个之前，您必须先建立一个test数据库，然后表明为dasemimi,在里面添加一些数据即可！

表有三个字段 id user pwd这三个字段，id为主建，自动增加，其他两个自己定义长度范围