增删改查是对数据库最基本的操作,下面详细为大家介绍下如何连接数据库以及增删改查等等相关知识,感兴趣的朋友可以参考下
1.链接数据库通用方法:conn.php
复制代码 代码如下:
//第一步:链接数据库
$conn=@mysql_connect("localhost:3306","root","root")or die ("mysql链接失败");
//第二步: 选择指定的数据库,设置字符集
@mysql_select_db("php_blog",$conn) or die ("db链接失败".mysql_error());
mysql_query('SET NAMES UTF8')or die ("字符集设置错误");
?>
2.增加 add.php
复制代码 代码如下:
include("conn.php");//引入链接数据库
if(!empty($_POST['sub'])){
$title=$_POST['title'];
$con=$_POST['con'];
echo $sql="insert into news(id,title,dates,contents) value (null,'$title',now(),'$con')" ;
mysql_query($sql);
echo"插入成功";
}
?>
3.删除del.php
复制代码 代码如下:
include("conn.php");//引入链接数据库
<?php <BR>include("conn.php");//引入链接数据库 <br>if(!empty ($_GET['id'])){ <br>$sql="select * from news whereid']."'"; <br>$query=mysql_query($sql); <br>$rs=mysql_fetch_array($query); <br>} <br>if(!empty($_POST['sub'])){ <br>$title=$_POST['title']; <br>$con=$_POST['con']; <br>$hid=$_POST['hid']; <br>$sql="update news set title='$title',contents='$con' where limit 1 "; <br>mysql_query($sql); <br>echo "<script> alert('更新成功'); location.href='index.php'</script>"; <br>echo"更新成功"; <br>} <br>?> <br>
if(!empty($_GET['del'])){ $d=$_GET['del']; $sql="delete from news where id ='$d'"; } $query=mysql_query($sql); echo "删除成功"; ?>
4,改 edit.php页面
<?php <BR>include("conn.php");//引入链接数据库 <br>if(!empty ($_GET['id'])){ <br>$sql="select * from news whereid']."'"; <br>$query=mysql_query($sql); <br>$rs=mysql_fetch_array($query); <br>} <br>if(!empty($_POST['sub'])){ <br>$title=$_POST['title']; <br>$con=$_POST['con']; <br>$hid=$_POST['hid']; <br>$sql="update news set title='$title',contents='$con' where limit 1 "; <br>mysql_query($sql); <br>echo "<script> alert('更新成功'); location.href='index.php'</script>"; <br>echo"更新成功"; <br>} <br>?> <br>
5.查,,列表页面
<a href="add.php">添加内容</a> <br><hr> <br><hr> <br>
include("conn.php");//引入链接数据库
if(!empty($_GET['keys'])){
$w=" title like '%".$_GET['keys']."%'";
}else{
$w=1;
}
$sql="select * from news where $w order by id desc";
$query=mysql_query($sql);
while($rs=mysql_fetch_array($query)){
?>
标题: 编辑||删除
}
?>

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

Dreamweaver Mac version
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

WebStorm Mac version
Useful JavaScript development tools