一个小作业

2018-11-05_080244.png

.sql文件

SET NAMES UTF8;
DROP DATABASE IF EXISTS meishichina;
CREATE DATABASE meishichina CHARSET=UTF8;
USE meishichina;
CREATE TABLE dish(
  did INT PRIMARY KEY AUTO_INCREMENT,
  dname VARCHAR(16),
  pic VARCHAR(16),
  author VARCHAR(8),
  pubTime DATE
);
INSERT INTO dish VALUES(NULL,'麻辣香锅','img/1.jpg','王国魁','2018-11-5');
INSERT INTO dish VALUES(NULL,'夫妻肺片','img/2.jpg','张世远','2018-11-5');
INSERT INTO dish VALUES(NULL,'脆皮鸡盖饭','img/3.jpg','脆皮鸡','2018-11-5');
SELECT * FROM dish;

执行添加语句的php

<?php
$dname=$_REQUEST['dname'];
$pic=$_REQUEST['pic'];
$author=$_REQUEST['author'];
$pubTime=$_REQUEST['pubTime'];

//连接数据库
$conn=mysqli_connect('127.0.0.1','root','','meishichina',3306);
//设置编码
$sql="SET NAMES UTF8";
mysqli_query($conn,$sql);
//执行插入语句
$sql="INSERT INTO dish VALUES(NULL,'$dname','$pic','$author','$pubTime')";
$result=mysqli_query($conn,$sql);
var_dump($result);//true   false

if($result===true){
    echo '成功';
}else{
    echo '失败';
}

执行添加语句的html

<form action='dish_add.php'>
    <p>dname: <input type="" name="dname"></p>
    <p>pic: <input type="" name="pic"></p>
    <p>author: <input type="" name="author"></p>
    <p>pubTime: <input type="" name="pubTime"></p>
    <p><input type="submit" name="" value='提交'></p>
  </form>

执行删除语句的php

<?php
$did=$_REQUEST['did'];
$conn=mysqli_connect('127.0.0.1','root','','meishichina',3306);
$sql="SET NAMES UTF8";
mysqli_query($conn,$sql);
$sql="DELETE FROM dish WHERE did='$did'";
$result=mysqli_query($conn,$sql);
var_dump($result);
if($result===true){
    echo '删除成功';
    echo "<a href='dish_select.php'>返回查看</a>";
}else{
    echo '删除失败';
}

div显示所有列表的php

   <?php
      $conn=mysqli_connect('127.0.0.1','root','','meishichina',3306);
      $sql="SET NAMES UTF8";
      mysqli_query($conn,$sql);
      $sql="select * from dish";//执行正确，把结果输出来，执行错误了，报false
      $result=mysqli_query($conn,$sql);
      // $all=mysqli_fetch_all($result);//把数据按照索引数组输出
     // $row=mysqli_fetch_assoc($result);//输出一行，并且按照关联数组输出
      // var_dump($row);
      if($result===false){
            echo 'err';
      }else{
        echo "<div class='box'>";
         while(true){
            //抓取一行数据
            $row=mysqli_fetch_assoc($result);
            // var_dump($row);
            if($row===null){
                break;
            }else{
                echo "<div class='list'>";
                    echo "<ul class='list_top'>";  
                        echo "<li>$row[did]</li>";
                        echo "<li><a href='dish_delete.php?did=$row[did]'>X</a></li>";
                    echo "</ul>";  
                    echo "<ul class='list_mid'>";  
                        echo "<li><img src='$row[pic]'></li>";
                        echo "<li>$row[dname]</li>";
                    echo "</ul>"; 
                    echo "<p><span>$row[author]</span><span>$row[pubTime]</span></p>"; 
                echo "</div>";
           }
       }
        echo "</div>";
      }
   ?>