...............................................................................................................................................................................................
按上次程序上的基础来的(查询,添加)。这次弄更新修改、删除,代码如下:
include("conn.php");
$sql="select * FROM `text` order by u_id desc ";
$result=mysql_query($sql,$conn);
?>
id号 | 姓名 | 内容 | 日期 | 选项 |
while($rows=mysql_fetch_row($result))
{
?>
>
>>>}
?>
$id=$_REQUEST['id']; // $_REQUEST 获取table 表 横向的值
$name=$_REQUEST['name'];
$content=$_REQUEST['content'];
//...............................修改更新.................................
$sql_update="update text set u_name='$name',u_content='$content',u_date=now() where u_id='$id'";
if($_POST['update'])
{
$query=mysql_query($sql_update,$conn);
if($query){echo "更新成功";}else{ echo "更新失败";}
}
//...............................删除.................................
$sql_delete="delete from text where u_id='$id'";
if($_POST['delete'])
{
$query=mysql_query($sql_delete,$conn);
if($query){echo "删除成功";}else{ echo "删除失败";}
}
?>
截图: