ajax第六天

在php中以表格的形式输出数据库的内容

.sql文件

SET NAMES UTF8;
DROP DATABASE IF EXISTS product;
CREATE DATABASE product CHARSET=UTF8;
USE product;
CREATE TABLE  phone(
   pid INT PRIMARY KEY AUTO_INCREMENT,
   log VARCHAR(16),
   pic VARCHAR(32),
   tit VARCHAR(64),
   price FLOAT(6,2) 
);
INSERT INTO phone VALUES(NULL,'促销','img/1.jpg','vivo  x23','3498.00');
INSERT INTO phone VALUES(NULL,'促销','img/1.jpg','vivo  x23','3498.00');
INSERT INTO phone VALUES(NULL,'促销','img/1.jpg','vivo  x23','3498.00');

SELECT * FROM phone;

执行插入的php

<?php
  $log=$_REQUEST['log'];
  $pic=$_REQUEST['pic'];
  $tit=$_REQUEST['tit'];
  $price=$_REQUEST['price'];
  //连接数据库
  $conn=mysqli_connect('127.0.0.1','root','','product',3306);
  //设置编码
  $sql='set names UTF8';
  mysqli_query($conn,$sql);
  //执行插入语句
  $sql="insert into phone values(NULL,'$log','$pic','$tit','$price')";
  $result=mysqli_query($conn,$sql);
  if($result===true){
    echo '插入成功';
  }else{
    echo '插入失败';

执行插入的html

<form action="homework_add.php">
     <p>
        logo:<input type="" name="log">
     </p>
     <p>
        图片:<input type="" name="pic">
     </p>
     <p>
        标题:<input type="" name="tit">
     </p>
     <p>
        价格:<input type="" name="price">
     </p>
      <input type="submit" name="" value='提交'>
   </form>

执行删除的php

<?php
//根据商品的编号删除
$pid=$_REQUEST['pid'];
$conn=mysqli_connect('127.0.0.1','root','','product',3306);
$sql='SET NAMES UTF8';
mysqli_query($conn,$sql);
$mysql="DELETE FROM phone WHERE pid='$pid'";
$result=mysqli_query($conn,$mysql);
if($result===true){
    echo "删除成功";
    echo "<a href='homework_select_table.php'>查看所有</a>";
}else{
    echo "删除失败";
}

执行删除的html

<form action='homework_delete.php'>
      <p>id:<input type="" name="pid"></p>
      <p><input type="submit" name="" value='提交'></p>
   </form>

数据显示成表格形式的php

<?php
  //连接数据库
  $conn=mysqli_connect('127.0.0.1','root','','product',3306);
  //设置编码
  $sql="SET NAMES UTF8";
  mysqli_query($conn,$sql);
  //执行select 语句
  $sql="SELECT * FROM phone";//  输出所有的结果集

  $result=mysqli_query($conn,$sql);
  var_dump($result);

  if($result===false){
     echo '错误';
  }else{
    echo "<table width='100%' border=1>";
    echo "<thead><tr><th>pid</th><th>log</th><th>pic</th><th>tit</th><th>price</th><th>操作</th></tr></thead>";
    echo "<tbody>";
    while(true){
        //抓取一行数据
        $row=mysqli_fetch_assoc($result);//把数据按照关联数组输出
        var_dump($row);
        if($row===null){
            break;
        }else{
            echo "<tr>";
            echo "<td>$row[pid]</td>";
            echo "<td>$row[log]</td>";
            echo "<td>$row[pic]</td>";
            echo "<td>$row[tit]</td>";
            echo "<td>$row[price]</td>";
            echo "<td><a href='homework_delete.php?pid=$row[pid]'>删除</a></td>";
            echo "</tr>";
        }
    }  
    echo "</tbody>";
    echo "</table>";
  }

$row=mysqli_fetch_assoc($result);将数据按索引数组输出
$row=mysqli_fetch_assoc($result);只输出一行　并按照关联数组输出
$row=mysqli_fetch_assoc($result,MYSQLT_ASSOC);将所有数组按照关联数组输出

break：结束当前整个循环，执行当前循环下边的语句。