php的增删改基础教程

增加数据

<?php
include("linksql.php");
$add="inset into new1(table,content) 
values('qwerty','qasedfdssddsd')";
if($coon->query($add))
echo "插入成功";
else
echo "插入失败".$coon->error;
conn->close();
header("location:linksql.php");
?>

删除数据

<?php
include("linksql.php");
$delet=("delete from new1 where id='1'");
if($coon->query($delet))
echo "删除成功";
else
echo "删除失败".$coon->error;
$coon->close();
header("location:linksql.php");
?>

更改数据

<?php
include("linksql.php");
$ta=$_POST[""];
$co=$_POST[""];
$upd=("update new1 set table'$ta',content'$co' where id='1'");
if($coon->query($upd))
echo "更新成功";
else
echo "更新失败".$coon->error;
$coon->close();
header("location:linksql.php");