实际操作,附上代码,将内容展现出来
<?php $link = mysqli_connect('localhost' , 'root' , 'root'); if(!$link){ exit('数据库链接失败'); } mysqli_set_charset($link,'utf8'); mysqli_select_db($link,'pikachu'); $sql = 'select * from users'; $obj = mysqli_query($link,$sql); echo '<table width="600" border="1">'; echo '<th>id</th><th>username</th><th>password</th><th>level</th><th>操作</th>'; while($rows = mysqli_fetch_assoc($obj)){ echo '<tr>'; echo '<td>'.$rows['id'].'</td>'; echo '<td>'.$rows['username'].'</td>'; echo '<td>'.$rows['password'].'</td>'; echo '<td>'.$rows['level'].'</td>'; echo '<td><a href="del.php?id='.$rows['id'].'">删除</a>/<a href="update.php?id='.$rows['id'].'">修改</a></td>'; echo '</tr>'; } echo '</table>'; mysqli_close($link);
