php数据访问之增删改查操作

5年以前 | 阅读数：1015 次 | 编程语言：PHP

增删改查操作小练习，大家练练手吧

一、查看新闻页面-----主页面


    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>查看新闻</title>
    </head>

    <body>
    <h1>查看新闻</h1>
    <table width="100%" border="1" cellpadding="0" cellspacing="0">
    <tr>
      <td>id</td>
      <td>title</td>
      <td>author</td>
      <td>source</td>
       <td>content</td>
      <td>date</td>
      <td>update</td>
      <td>delete</td>
    </tr>
    <?php
    $db=new MySQLi("localhost","root","","mydb");
    !mysqli_connect_error() or die("连接失败！");
    $sql="select * from news";
    $result=$db->query($sql);
    $arr=$result->fetch_all();
    foreach ($arr as $v)
    {
      echo "<tr>
      <td>{$v[0]}</td>
      <td>{$v[1]}</td>
      <td>{$v[2]}</td>
      <td>{$v[3]}</td>
      <td>{$v[4]}</td>
      <td>{$v[5]}</td>
      <td><a href='Update.php?newsid={$v[0]}'>update</a></td>
      <td><a href='Delete.php?newsid={$v[0]}'>delete</a></td>

      </tr>";
      }

    ?>
    </table>
    <br>
    <br />
    <div class="xw"><a href="xinwen.php">发布新闻</a></div>

    </body>
    </html>

二、发布新闻页面-----添加内容


    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>发布新闻</title>
    <style>
    .xw
    {

      margin-top:10px;
      margin-left:400px;
      border:thick; 
      }
    .a
    {
      float:left;

      }

    </style>

    </head>

    <body>
    <h1><center>发布新闻</center></h1>

    <form action="AddChu.php" method="post">
    <div class="xw">标题：<input type="text" name="title" style="width:400px"></div>
    <div class="xw">作者：<input type="text" name="author"></div>
    <div class="xw">来源：<input type="text" name="source"></div>
    <div class="xw">内容:
    <textarea rows="10" cols="80" name="content"></textarea></div>

    <div class="a"><input type="submit" value="提交" style="margin-left:600px;"></div>
    <div class="a"><a href="ChaKan.php"><input type="button" value="查看" style="margin-left:6px;"></a></div>

    </form>


    </body>
    </html>

提交内容后的处理：


    <?php
    $newsid=$_POST["newsid"];
    $title=$_POST["title"];
    $author=$_POST["author"];
    $source=$_POST["source"];
    $content=$_POST["content"];
    $time=date("Y-m-d",time());

    $db=new MySQLi("localhost","root","","mydb");
    !mysqli_connect_error() or die("联系失败!");
    $sql="insert into news values('{$newsid}','{$title}','{$author}','{$source}','{$content}','{$time}')";
    $result=$db->query($sql);
    if($result)
    {
      header ("location:xinwen.php");
      }
    else
    {
      echo "添加新闻失败！";
      }

三、删除内容处理


    <?php
    $newsid=$_GET["newsid"];
    $db=new MySQLi("localhost","root","","mydb");
    !mysqli_connect_error() or die("连接失败!");
    $sql="delete from news where newsid='{$newsid}'";
    $result=$db->query($sql);
    if($result)
    {
      header ("location:ChaKan.php");
      }
    else
    {
      echo "删除数据失败";
      }
    ?>

四、修改新闻页面----修改新闻内容后提交查看


    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>修改新闻</title>
    <style>
    .xw
    {

      margin-top:10px;
      margin-left:400px;
      border:thick; 
      }

    .a
    {
      float:left;

      }

    </style>
    </head>

    <body>
    <h1><center>修改新闻</center></h1>
    <?php
    $newsid = $_GET["newsid"];
    $db = new MySQLi("localhost","root","","mydb");
    $sinfo = "select * from news where newsid='{$newsid}'";
    $r = $db->query($sinfo);
    $arr = $r->fetch_row(); //这个人的所有信息
    ?>

    <form action="UpdateChu.php" method="post">
    <div class="xw"><input type="hidden" name="newsid" value="<?php echo $arr[0] ?>"></div>
    <div class="xw">标题：<input type="text" name="title" style="width:400px" value="<?php echo $arr[1] ?>"></div>
    <div class="xw">作者：<input type="text" name="author" value="<?php echo $arr[2] ?>"></div>
    <div class="xw">来源：<input type="text" name="source" value="<?php echo $arr[3] ?>"></div>
    <div class="xw">内容:
    <textarea rows="10" cols="80" name="content"><?php echo $arr[4] ?></textarea></div>

    <div class="a"><input type="submit" value="修改" style="margin-left:600px;"></div>
    <div class="a"><a href="ChaKan.php"><input type="button" value="查看" style="margin-left:6px;"></a></div>

    </form>

    </body>
    </html>

提交修改内容后进行处理：


    <?php
    $newsid=$_POST["newsid"];
    $title=$_POST["title"];
    $author=$_POST["author"];
    $source=$_POST["source"];
    $content=$_POST["content"];
    $time=date("Y-m-d",time());

    $db=new MySQLi("localhost","root","","mydb");
    !mysqli_connect_error() or die("联系失败!");
    $sql="update news set title='{$title}',author='{$author}',source='{$source}',content='{$content}',time='{$time}' where newsid='{$newsid}'";
    $result=$db->query($sql);
    if($result)
    {
      header ("location:Update.php");
      }
    else
    {
      echo "修改数据失败!";
      }

以上就是本文的全部内容，希望对大家学习php程序设计有所帮助。