首頁 > 教學 > PHP 教學

php資料庫增刪改查方式

來源：互聯網
上載者：User
創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！
首先建立一個資料庫db_0808，將db_0808中表格student匯入網頁。

CURD.php

<!DOCTYPE html><html><head>    <meta charset="utf-8">    <title>Title</title></head><body><?php$db = new Mysqli("localhost","root","root","db_0808");//!$db?"":die("連結錯誤");empty(mysqli_connect_error())?"":die("連結錯誤");$sql = "select * from student where is_delete='0'";//$data = $db->query($sql)->fetch_all();//索引數組形式的所有資料?><table border="1">    <tr>        <td>id</td>        <td>名字</td>        <td>性別</td>        <td>班級</td>        <td>生日</td>        <td>操作</td>    </tr>    <?php    $result=$db->query($sql);    while ($data=$result->fetch_row()){  //索引數組形式的第一條資料//    foreach ($data as $i){        if ($data[2]==1){            $data[2]="男";        }else if ($data[2]==0){            $data[2]="女";        }else{            $data[2]="保密";        }        echo "<tr>                 <td>{$data[0]}</td>                 <td>{$data[1]}</td>                 <td>{$data[2]}</td>                 <td>{$data[3]}</td>                 <td>{$data[4]}</td>                 <td><a href='delete.php?id={$data[0]}'>刪除</a>                     <a href='xiugai.php?id={$data[0]}'>修改</a>                 </td>              </tr>";    }    ?></table><a href="add.php">新增使用者</a></body></html>

向資料庫中添加新資訊add.php


<!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>Title</title></head><body><form method="post" action="addpost.php">    <input type="text" name="name" placeholder="姓名">    <input type="radio" name="sex" value="1" id="man"><label for="man">男</label>    <input type="radio" name="sex" value="0" id="nv"><label for="nv">女</label>    <input type="text" name="banji" placeholder="班級"><!--    <input type="text" name="age" placeholder="年齡">-->    <input type="text" name="birthday" placeholder="出生年月">    <input type="submit" value="提交"></form></body></html>

對add.php資訊處理addpost.php


<?php/** * Created by fcc * User: Administrator * Date: 2017/10/13 * Time: 15:49 */$name = $_POST['name'];// var_dump($name); $sex = $_POST['sex']; $ban=$_POST['banji'];// $age = $_POST['age']; $birthday = $_POST['birthday']; $db=new Mysqli("localhost","root","root","db_0808"); $sql = "INSERT INTO student VALUES (null,'{$name}',{$sex},{$ban},'{$birthday}',DEFAULT,null)"; if ($db->query($sql)){header("location:CURD.php");}else{    header("location:add.php");}

添加資訊成功

刪除資訊delete.php


<?php/** * Created by fcc * User: Administrator * Date: 2017/10/14 * Time: 10:56 */$id=$_GET['id'];$db=new Mysqli("localhost","root","root","db_0808");empty(mysqli_connect_error())?"":die("連結錯誤");//$sql="DELETE FROM student WHERE Sno='{$id}'";//徹底刪除，資料庫中內容刪除$sql = "update student set is_delete = '1' where Sno= '{$id}'";//表面刪除,資料庫中內容仍存在if ($db->query($sql)){    header("location:CURD.php");};

更改資訊頁面xiugai.php


<!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>Title</title></head><body><?php    $s = null;if(isset($_GET['id'])){        $id = $_GET['id'];        $db=new Mysqli("localhost","root","root","db_0808");        empty(Mysqli_connect_error())?"":die("串連錯誤");        $sql="select * from student where Sno='{$id}'";        $r=$db->query($sql);//var_dump($r);    $s=$r->fetch_row();}?><form method="post" action="xiugaichuli.php">    <input type="hidden" name="id" value="<?php echo $s[0]?>">    <input type="text" name="name" placeholder="<?php echo $s[1]?>">    <input type="radio" name="sex" value="0" <?php echo $s[2]?"":"checked='checked'";   ?> id="nv"><label for="nv">女</label>    <input type="radio" name="sex" value="1" <?php echo $s[2]?"checked='checked'":"";   ?> id="nan"><label for="nan">男</label>    <input type="text" name="banji" placeholder="<?php echo $s[3]?>">    <!--    <input type="text" name="age" placeholder="年齡">-->    <input type="text" name="birthday" placeholder="<?php echo $s[4]?>">    <input type="submit" value="提交"></form></body></html>

更改資訊處理頁面xiugaichuli.php

<?php/** * Created by fcc * User: Administrator * Date: 2017/10/17 * Time: 9:07 */$id=$_POST['id'];$name=$_POST['name'];$sex=$_POST['sex'];$banji=$_POST['banji'];$birthday=$_POST['birthday'];$db=new Mysqli("localhost","root","root","db_0808");empty(Mysqli_connect_error())?"":"串連錯誤";$sql="UPDATE student SET Sname='{$name}',Ssex='{$sex}',class='{$banji}',birthday='{$birthday}'WHERE Sno='{$id}'";//var_dump($sql);if ($db->query($sql)){    header("location:CURD.php");}

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

聯繫我們

該頁面正文內容均來源於網絡整理，並不代表阿里雲官方的觀點，該頁面所提到的產品和服務也與阿里云無關，如果該頁面內容對您造成了困擾，歡迎寫郵件給我們，收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容，歡迎發送郵件至： info-contact@alibabacloud.com 進行舉報並提供相關證據，工作人員會在 5 個工作天內聯絡您，一經查實，本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More