PHP学习笔记之三 数据库基本操作
";
$res=$mysql->query($query);
while($row=$res->fetch_array()) {
?>
<tr>
<td><?= $row[''UserName''] ?></td>
<td><?= date(''Y-m-d'',strtotime($row[''CreateTime'']))?> </td>
<td><a href="UserEdit.php?action=update&ID=<?= $row[''UserName''] ?>">Edit</a>
<a href="action=delete&ID=<?= $row[''UserName''] ?>">Delete</a>
</td>
</tr>
<?php
}
$res->close();
$mysql->close();
?>
</table>
$res=$mysql->query($query);
while($row=$res->fetch_array()) {
?>
<tr>
<td><?= $row[''UserName''] ?></td>
<td><?= date(''Y-m-d'',strtotime($row[''CreateTime'']))?> </td>
<td><a href="UserEdit.php?action=update&ID=<?= $row[''UserName''] ?>">Edit</a>
<a href="action=delete&ID=<?= $row[''UserName''] ?>">Delete</a>
</td>
</tr>
<?php
}
$res->close();
$mysql->close();
?>
</table>