1.利用insert 语句添加记录
require('conn.php');
mysql_query("insert into lyb ( title, content, author, email,`date`) values ('大家好', 'PHP学习园地', '小浣熊', 'sdf@sd.com','2012-3-3')") or die('执行失败');
echo'新增记录的id是'.mysql_insert_id(); //可选,输出新记录的id
?>
2.利用delete语句删除数据
require('conn.php');
mysql_query("Delete from lyb where ID in(158,162,163,169)") or die('执行失败');?>本次操作共有= mysql_affected_rows() ?>条记录被删除!
3.利用updata语句更新数据
require('conn.php');
mysql_query("Update lyb set email='rong@163.com', author='蓉蓉' where ID>133 and ID<143") or die('执行失败');?>
接下来演示一个完整的例子
5.1.php为插入页面
* @Authors peng--jun
* @Email 1098325951@qq.com
* @Date 2015-11-07 13:50:48
* @Linkhttp://www.cnblogs.com/xs-yqz/* @version $Id$
==========================================*/header("Content-type: text/html; charset=UTF-8");if (isset($_POST['submit'])) {
require("include/conn.php");
mysql_select_db("lyb",$conn);//选择数据库
$title= $_POST['title'];
$author= $_POST['author'];
$content= $_POST['content'];
$email= $_POST['email'];
$result= mysql_query("insert into `lyb1`(`id`,`title`,`content`,`author`,`email`) values(null,'$title','$content','$author','$email')")or die('执行失败');;
var_dump($result);
echo"新增的记录的id为".mysql_insert_id();
mysql_free_result($result);
mysql_close($result);
echo"";
header("Location:5.6.php");/*header("refresh:3;url=5.6.php");*/ //3秒后 页面跳转
}?>
添加数据页面添加新闻页面