?? ??? ???? PHP ?? ?? ????
?? ?? ??? ?? ????? ??? ??? ??????.
????? ??? ?? ??? ??? ?????. ?? ?? ????? ???? ?? ???? ???? ? ??? ?? ??? ????? ??? ? ????.
???????? ?? ???? ??? ??? ???? ????? ???.
1. ?????? ??, ?? ??, ??? ??
??, ?? ??, ??? ??? ?? ??? ??? ??. ?? ??? ? ?? ??? mysqli_connect? ???? ??????? ???? ????. ? ?? ???? ???? ? ?? ????? ????? ??? ??? ? ????. ??? ??????? ?? ???? ?? ? ?? mysqli_select_db ??? ??? ??? ????.
??? ??? ?? ??????. ?? ??? ???? ??? ????? mysqli_errno, mysqli_error ? mysqli_set_charset? ???? ???? ???.
$conn = mysqli_connect('localhost', 'root', 'secret', 'book');
if (mysqli_errno($conn)) {
mysqli_error($conn);
exit;
}
mysqli_set_charset($conn, 'utf8');2. SQL ? ?? ? ???
??? ???? ? ?? ??? ID, ??? ??, ?? ? IP? ?? ????. ?????? ????? ID ?? ??? ?????.
??? ??? ??? ???? ????? ?? ?? ???? ?? ?? ?????. ID? ???? ?????. ?, ID? ??? ?? ???? ? ?? ?????. ??? SQL ?? ??? ? id desc? ???? order? ?????.
$sql = "select id,username,createtime,createip from user order by id desc"; $result = mysqli_query($conn, $sql);
3. ?? ??
SQL ?? ??? ?? ?? ?? $result? ????. ??? $result ?? ??? ?? ? ?? ??? ?? ? ???? ???. ?? ??? ? ?? ?????.
? ?? ????? mysqli_num_rows? ???? ???. ? ??? ????? $result ??? ?? ??? ????? ???.
??? ??? ??? ?????. ??? ??? ????? ??? ? ????.
?? ???? ??? ????.
if($result && mysqli_num_rows($result)){
//顯示列表代碼段
}else{
//提示沒有結(jié)果的代碼段
}4. ?? ?? ???
??? ?? ??? ?????. ?? ???? ?????. ???? ?? ?? ??? ???? ?? ?? ?????. ??? ?? ???? ????.
?? ???? ???? ??? ??? ? ?? ?????. ? ?? ??? ?????.
??? ??? ?? ??? ???? mysqli_fetch_assoc???.
?? ??? ?? ?? ? ? ???? ?????. ?? ? ??? ??? bool ? false? ?????. ??? ??? mysqli_fetch_assoc? ????? ??????.
? ??? ??? ?? ??? $row? ?????. ??? ? ???? ?? ?? ?? ??? ? ????.
echo '<table width="800" border="1">';
while ($row = mysqli_fetch_assoc($result)) {
echo '<tr>';
echo '<td>' . $row['username'] . '</td>';
echo '<td>' . date('Y-m-d H:i:s', $row['createtime']) . '</td>';
echo '<td>' . long2ip($row['createip']) . '</td>';
echo '</tr>';
}
echo '</table>';5. ?? ? ?? ?? ??
??? ? ??? ????. ?? ?? ? ?? ?? ??.
?? ? ???? ?????
?? ??? ???? ???? ? ?? ?? ??? ???? ??? ??????. ??? ??.
???? ?? ??? ???? ?? ?? ???? ???????.
?? ??? ????. ?? ???? ?? ??:
?? ?? ??? ?? ???? ?? get ???? ???? ID? ???? ?? ????? ? ? ????. ?? ?? ???????.
?? ?? ??? ??? ?? ?? ???? ???? ???. ??? ?? ??? ?? ???? ???? ? ??? ID ??? ??? ? ????.
?? ?? ??? ?? delete.php? ?? id? ?? ???? ?? ? ?? ??? ? ? ????.
echo '<td><a href="delete.php?id=' . $row['id'] . '">刪除用戶</a></td>';
edit.php? ?? ???? ???? ?? ???? ???? ??? ? ? ????.
echo '<td><a href="edit.php?id=' . $row['id'] . '">編輯用戶</a></td>';
?? ?? ??? ?? HTML?? ???? ???? ???. ?? ??? ID? ??? ? ?? ?? id[]? ???? ???. ??? ???? ???? ???? ??? ??? ?? ??? ???? ?? ?? ??? ?????.
<form action="delete.php" method="post"> echo '<td><input type="checkbox" name="id[]" value="' . $row['id'] . '" /></td>'; echo '<input type="submit" value="刪除" />'; echo '</form>';
??? ??? ????.
echo '<form action="delete.php" method="post">';
echo '<table width="800" border="1">';
while ($row = mysqli_fetch_assoc($result)) {
echo '<tr>';
echo '<td><input type="checkbox" name="id[]" value="' . $row['id'] . '" /></td>';
echo '<td>' . $row['username'] . '</td>';
echo '<td>' . date('Y-m-d H:i:s', $row['createtime']) . '</td>';
echo '<td>' . long2ip($row['createip']) . '</td>';
echo '<td><a href="edit.php?id=' . $row['id'] . '">編輯用戶</a></td>';
echo '<td><a href="delete.php?id=' . $row['id'] . '">刪除用戶</a></td>';
echo '</tr>';
}
echo '</table>';
echo '<input type="submit" value="刪除" />';
echo '</form>';6. ?????? ??? ????
?????? ??? ?????. ?????? ??? ????.
mysqli_close($conn);
??? ??? ??? ?? list.php ??? ??? ????.
<?php
$conn = mysqli_connect('localhost', 'root', 'secret', 'book');
if (mysqli_errno($conn)) {
mysqli_error($conn);
exit;
}
mysqli_set_charset($conn, 'utf8');
$sql = "select id,username,createtime,createip from user order by id desc";
$result = mysqli_query($conn, $sql);
if ($result && mysqli_num_rows($result)) {
echo '<table width="800" border="1">';
while ($row = mysqli_fetch_assoc($result)) {
echo '<tr>';
echo '<td>' . $row['username'] . '</td>';
echo '<td>' . date('Y-m-d H:i:s', $row['createtime']) . '</td>';
echo '<td>' . long2ip($row['createip']) . '</td>';
echo '<td><a href="edit.php?id=' . $row['id'] . '">編輯用戶</a></td>';
echo '<td><a href="delete.php?id=' . $row['id'] . '">刪除用戶</a></td>';
echo '</tr>';
}
echo '</table>';
} else {
echo '沒有數(shù)據(jù)';
}
mysqli_close($conn);
