mysql的query_使用mysql_query()方法操纵数据库以及综合实例

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

?>

２.利用delete语句删除数据

require(‘conn.php’);

mysql_query(“Delete from lyb where ID in(158,162,163,169)”) or die(‘执行失败’);?>本次操作共有= mysql_affected_rows() ?>条记录被删除！

３.利用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秒后 页面跳转

}?>

添加数据页面

添加新闻页面

5.6.php为从数据库后台提取数据 显示在前台的页面

* @Authors peng–jun

* @Email 1098325951@qq.com

* @Date 2015-11-07 15:10:04

* @Linkhttp://www.cnblogs.com/xs-yqz/* @version $Id$

==========================================*/header(“Content-type: text/html; charset=UTF-8”);

require(“include/conn.php”);

mysql_select_db(“lyb”,$conn);//选择数据库

$result = mysql_query(“select * from `lyb1`”,$conn);//选择数据库表

?>

Document

添加记录

}?>

共有= mysql_num_rows($result) ?>条记录

mysql_free_result($result);

mysql_close($result);?>

delete.php删除程序

* @Authors peng–jun

* @Email 1098325951@qq.com

* @Date 2015-11-07 15:26:27

* @Linkhttp://www.cnblogs.com/xs-yqz/* @version $Id$

==========================================*/header(“Content-type: text/html; charset=UTF-8”);

require(“include/conn.php”);

mysql_select_db(“lyb”,$conn);//选择数据库

$id = intval($_GET[‘id’]);//获取5-6.php传来的id参数并转换为整型

$sql = “delete from `lyb1` where `id` = $id”;//删除指定的内容

if (mysql_query($sql) && mysql_affected_rows()==1) {//执行sql语句并判断执行是否成功

echo “”;

}else{

echo””;

}?>

多选删除页面deleteall.php

* @Authors peng–jun

* @Email 1098325951@qq.com

* @Date 2015-11-07 15:10:04

* @Linkhttp://www.cnblogs.com/xs-yqz/* @version $Id$

==========================================*/header(“Content-type: text/html; charset=UTF-8”);

require(“include/conn.php”);

mysql_select_db(“lyb”,$conn);//选择数据库

if ($_GET[“del”]==1) {//如果用户按了“删除”按钮

$selectid=$_POST[“selected”];//获取所有选中多选框的值，保存到数组中

if( count($selectid)>0){//防止selectid值为空时执行SQL语句出错

$sel = implode(“,”, $selectid);//将各个数组元素用“,”号连接起来

mysql_query(“delete from `lyb1` where `id` in($sel)”)or die(“执行失败”.mysql_error());

header(“Location:deleteall.php”);//删除完毕，刷新页面

}else{

echo”没有被选中的数据”;

}

}

$result= mysql_query(“select * from `lyb1`”,$conn);//选择数据库表

?>

Document

添加记录

}?>

共有= mysql_num_rows($result) ?>条记录

mysql_free_result($result);

mysql_close($result);?>

更新页面的代码 editform.php

* @Authors peng–jun

* @Email 1098325951@qq.com

* @Date 2015-11-07 16:39:42

* @Linkhttp://www.cnblogs.com/xs-yqz/* @version $Id$

==========================================*/header(“Content-type: text/html; charset=UTF-8”);

require(“include/conn.php”);

mysql_select_db(“lyb”,$conn);//选择数据库

$id= intval($_GET[‘id’]);//将获取的id强制转换为整型

$sql = “select * from `lyb1` where id = $id”;

echo $sql;

$result= mysql_query($sql,$conn);//选择数据库表

$row = mysql_fetch_assoc($result);//将待更新记录各字段的值存入数组中

if ($_POST[“submit”]) {//当单击确认按钮后执行更新语句

$title = $_POST[‘title’];

$author= $_POST[‘author’];

$content= $_POST[‘content’];

$email= $_POST[’email’];

$sql_del= “Update `lyb1` Set title=’$title’,author=’$author’,email=’$email’,content=’$content’ Where id=’$id'”;

echo $sql_del;

mysql_query($sql_del)or die(“执行失败”.mysql_error());

echo””;

}?>

添加数据页面

添加新闻页面

查询记录的实现search.php

* @Authors peng–jun

* @Email 1098325951@qq.com

* @Date 2015-11-07 17:31:16

* @Linkhttp://www.cnblogs.com/xs-yqz/* @version $Id$

==========================================*/header(“Content-type: text/html; charset=UTF-8”);

require(“include/conn.php”);

mysql_select_db(“lyb”,$conn);//选择数据库

$result = mysql_query(“select * from `lyb1`”,$conn);?>

查询页面

}?>

共有= mysql_num_rows($result) ?>条记录

查询结果的显示页面search_result.php

* @Authors peng–jun

* @Email 1098325951@qq.com

* @Date 2015-11-07 17:40:21

* @Linkhttp://www.cnblogs.com/xs-yqz/* @version $Id$

==========================================*/header(“Content-type: text/html; charset=UTF-8”);

require(“include/conn.php”);

mysql_select_db(“lyb”,$conn);//选择数据库

$keyword=trim($_GET[‘keyword’]);//获取输入的关键字

$sel=$_GET[‘sel’];//获取选择的查询类型

$sql=”select * from `lyb1`”;if ($keyword<>””) {

$sql=$sql .”where $sel like ‘%$keyword%'”; //构造查询语句

}

$result=mysql_query($sql) or die(‘执行失败’);if (mysql_num_rows($result)>0) {

echo”

关键字为“ $keyword ”，共找到”.mysql_num_rows($result).”条留言

“;?>查询结果

}

}else echo “没有搜索到任何留言”;?>

至此，整个所有的操作都完成了。over！！！