PHP - 简单增删改查DEMO

目录

PHP.jpg

1.链接数据库通用方法:conn.php

<?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

<?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"插入成功"; 
    } 
?> 
<form action="add.php" method="post"> 
    标题: <input type="text" name="title"><br> 
    内容: <textarea rows="5" cols="50" name="con"></textarea><br> 
    <input type="submit" name="sub" value="发表"> 
</form> 

3.删除del.php

<?php 
    include("conn.php");//引入链接数据库
?>
<pre name="code" class="html">
<?php 
    include("conn.php");//引入链接数据库 
    if(!empty ($_GET['id'])){ 
        $sql="select * from news where id='".$_GET['id']."'"; 
        $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 id='$hid' limit 1 "; 
        mysql_query($sql); 
        echo "<script> alert('更新成功'); location.href='index.php'</script>"; 
        echo"更新成功"; 
    } 
?> 
<form action="edit.php" method="post"> 
    <input type="hidden" name="hid" value="<?php echo $rs['id']?>"/> 
    标题: <input type="text" name="title" value="<?php echo $rs['title']?>"><br> 
    内容: <textarea rows="5" cols="50" name="con"><?php echo $rs['contents']?></textarea><br> 
    <input type="submit" name="sub" value="发表"> 
</form>
</pre><br> 
<?php
    if(!empty($_GET['del'])){
        $d=$_GET['del']; $sql="delete from news where id ='$d'"; } $query=mysql_query($sql); echo "删除成功"; 
?>

4,改 edit.php页面

<pre name="code" class="html">
<?php 
    include("conn.php");//引入链接数据库 
    if(!empty ($_GET['id'])){ 
        $sql="select * from news where id='".$_GET['id']."'"; 
        $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 id='$hid' limit 1 "; 
        mysql_query($sql); 
        echo "<script> alert('更新成功'); location.href='index.php'</script>"; 
        echo"更新成功"; 
    } 
?> 
<form action="edit.php" method="post"> 
    <input type="hidden" name="hid" value="<?php echo $rs['id']?>"/> 
    标题: <input type="text" name="title" value="<?php echo $rs['title']?>"><br> 
    内容: <textarea rows="5" cols="50" name="con"><?php echo $rs['contents']?></textarea><br> 
    <input type="submit" name="sub" value="发表"> 
</form>
</pre>

5.查,列表页面

<pre name="code" class="html"><a href="add.php">添加内容</a>  
<hr> 
<form> 
    <input type="text" name="keys" /> 
    <input type="submit" name="subs" value="搜索"/> 
</form> 
<?php 
    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)){ 
?> 
    <h2>标题:<a href="view.php?id=<?php echo $rs['id'] ?>"><?php echo $rs['title'] ?></a> <a href="edit.php?id=<?php echo $rs['id'] ?>">编辑</a>||<a href="del.php?del=<?php echo $rs['id'] ?>">删除</a></h2> 
    <li><?php echo $rs['dates'] ?></li> 
    <p><?php echo $rs['contents'] ?></p> 
    <hr> 
    <?php 
    } 
    ?> 
</pre>

文章最后编辑时间为:2016-08-30 13:35:06

标签: php demo

声明:本博客如无特殊说明皆为原创,转载请注明来源:PHP - 简单增删改查DEMO谢谢!

相关文章

精彩评论
  1. DanLot DanLot  Windows 10 x64 Edition Google Chrome 67.0.3396.99

    bitcoin casino invest crypto slots xbox one top crypto slotsdo vegas casinos accept bitcoin crypto poker askgamblers bitcoin casino

发表评论:

icon_question.pngicon_razz.pngicon_sad.pngicon_evil.pngicon_exclaim.pngicon_smile.pngicon_redface.pngicon_biggrin.pngicon_surprised.pngicon_eek.pngicon_confused.pngicon_cool.pngicon_lol.pngicon_mad.pngicon_twisted.pngicon_rolleyes.pngicon_wink.pngicon_idea.pngicon_arrow.pngicon_neutral.pngicon_cry.pngicon_mrgreen.png