mysqli 实战01

user.php

$link = mysqli_connect('127.0.0.1','root','root','bbs');
if(!$link)
{
	exit('连接失败');
}
//mysqli_set_charset($link,'utf8');
//mysqli_select_db($link,'bbs');
$sql = "select * from bbs_user";
$obj = mysqli_query($link,$sql);
//var_dump(mysqli_fetch_assoc($obj));
echo '<table width="600" border="1">';
	echo '<th>编号</th><th>用户名</th><th>地址</th><th>性别</th><th>年龄</th><th>操作</th>';
	while ($rows = mysqli_fetch_assoc($obj)) {
		echo '<tr>';
			echo '<td>'.$rows['id'].'</td>';
			echo '<td>'.$rows['user'].'</td>';
			echo '<td>'.$rows['addres'].'</td>';
			echo '<td>'.$rows['sex'].'</td>';
			echo '<td>'.$rows['age'].'</td>';
			echo '<td><a href="del.php?id='.$rows['id'].'">删除</a><a href="update.php?id='.$rows['id'].'">修改</a></td>';
		echo '</tr>';
	}
echo '</table>';