//第一步:链接数据库 $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");//引入链接数据库
include("conn.php");//引入链接数据库 if(!empty ($_GET['id'])){ $sql="select * from news whereid']."'"; $query=mysql_query($sql); $rs=mysql_fetch_array($query); } if(!empty($_POST['sub'])){ $title=$_POST['title']; $con=$_POST['con']; $hid=$_POST['hid']; $sql="update news set title='$title',cOntents='$con' where limit 1 "; mysql_query($sql); echo ""; echo"更新成功"; } ?> 标题:
内容:
if(!empty($_GET['del'])){ $d=$_GET['del']; $sql="delete from news where id ='$d'"; } $query=mysql_query($sql); echo "删除成功"; ?>
4,改 edit.php页面
include("conn.php");//引入链接数据库 if(!empty ($_GET['id'])){ $sql="select * from news whereid']."'"; $query=mysql_query($sql); $rs=mysql_fetch_array($query); } if(!empty($_POST['sub'])){ $title=$_POST['title']; $con=$_POST['con']; $hid=$_POST['hid']; $sql="update news set title='$title',cOntents='$con' where limit 1 "; mysql_query($sql); echo ""; echo"更新成功"; } ?> 标题:
内容:
5.查,,列表页面
添加内容 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)){ ?>