<?php
@mysql_connect('localhost','root','') or die('数据库连接失败<br/>ERROR'.mysql_errno().':'.mysql_error());
mysql_set_charset('UTF8');
mysql_select_db('smarty_test') or die('指定数据库打开失败');
$sql="select id,username,email,addr from user";
$result=mysql_query($sql);
if($result && mysql_num_rows($result)>0){
while($row = mysql_fetch_assoc($result)){
$rows[] = $row;
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>第一个Smarty引擎</title>
</head>
<body>
<h1>用户列表</h1>
<table border="1" cellpadding="0" cellspacing="0" bgcolor="#ABCDEF">
<tr>
<th>编号</th>
<th>用户名</th>
<th>地址</th>
<th>邮箱</th>
</tr>
<?php foreach ($rows as $user): ?>
<tr>
<td><?php echo $user['id']; ?></td>
<td><?php echo $user['username']; ?></td>
<td><?php echo $user['addr']; ?></td>
<td><?php echo $user['email']; ?></td>
</tr>
<?php endforeach; ?>
</table>
</body>
</html>
@mysql_connect('localhost','root','') or die('数据库连接失败<br/>ERROR'.mysql_errno().':'.mysql_error());
mysql_set_charset('UTF8');
mysql_select_db('smarty_test') or die('指定数据库打开失败');
$sql="select id,username,email,addr from user";
$result=mysql_query($sql);
if($result && mysql_num_rows($result)>0){
while($row = mysql_fetch_assoc($result)){
$rows[] = $row;
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>第一个Smarty引擎</title>
</head>
<body>
<h1>用户列表</h1>
<table border="1" cellpadding="0" cellspacing="0" bgcolor="#ABCDEF">
<tr>
<th>编号</th>
<th>用户名</th>
<th>地址</th>
<th>邮箱</th>
</tr>
<?php foreach ($rows as $user): ?>
<tr>
<td><?php echo $user['id']; ?></td>
<td><?php echo $user['username']; ?></td>
<td><?php echo $user['addr']; ?></td>
<td><?php echo $user['email']; ?></td>
</tr>
<?php endforeach; ?>
</table>
</body>
</html>