2020年5月7日

    1. <?php
    2. $link =mysqli_connect('127.0.0.1','root','root','class06')or exit('数据库连接失败'); 
    3. mysqli_set_charset($link,'utf-8');
    4. //查询语句
    5. $sql="SELECT * FROM books ORDER BY book_id DESC";
    7. $res =mysqli_query($link,$sql);
    8. var_dump($res);
    10. $row=mysqli_fetch_row($res);
    11. $row=mysqli_fetch_assoc($res);
    12. $row=mysqli_fetch_object($res);
    13. var_dump($row);
    15. $data = [];
    16. while($row=mysqli_fetch_assoc($res)){
    17. $data[] =$row;
    18. }
    19. var_dump($data);
    20. mysqli_close($link);
    21. ?>
    22. <!DOCTYPE html>
    23.   <html>
    24. <head>
    25.     <meta charset="UTF-8">
    26.   <title>sql留言板</title>
    27.   <style>
    28.     .cb{
    29.     border: 1px solid blue;
    30.     }
    32.   </style>
    33.     </head>
    34. <body>
    35. <h1>留言板</h1>
    36.  <p><a herf="./add.php">添加留言</a></p>
    37.  <div class="cb"><p>内容</p>
    38.  <div class="ca">
    39.     <b>姓名</b><sapn>邮箱</span> 
    40.  </div>
    41.    <div class="c-act">
    42.    <a herf="">编辑</a>
    43.  <a herf="">删除</a>
    44.   </div>
    45.  </div>
    46. </body>
    47. </html>
    49.   <!DOCTYPE html>
    50.   <html>
    51. <head>
    52.    <meta charset="UTF-8">
    53.   <title>添加留言</title>
    54.   </head>
    55.     <body>
    56.     <h1>添加留言</h1>
    57.     <form action="./demo.php" method="post">
    58.     <p>昵称：<input type="text" name="name"></p>
    59.      <p>邮箱：<input type="text" name="email"></p>
    60.           <p>留言：<input type="text" name="comment"></p>
    61.       <input type="submit" value="添加">
    62.       </form>
    63.       </body>
    64.     </html>
    65. <?php
    66. $post =$_POST;
    67. var_dump($post);
    69. $link =mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败');
    71. mysqli_set_charset($link,'UTF-8');
    73. $sql=sprintf("INSERT INTO COMMENT VALUES(DEFAULT, '%S','%S','%S')", $post['comment'],$post['name'],$post['email']);
    75. $res=mysqli_query($link,$sql);
    77. if($res && mysqli_afffected_rows($link)>0){
    78.     echo"成功"；
    79. }else{
    80. echo"失败";
    81. }
    82. mysqli_close($link);    
    85. CREATE TABLE comment(
    86. id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
    87. content varchar(255) NOT NULL COMMENT '留言内容',
    88. name varchar(10) NOT NULL COMMENT '姓名',
    89. email varchar(60) NOT NULL COMMENT '邮箱'
    90. );
    92. //首页显示功能
    93. <?php
    94.   $link = mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败');
    95. mysqli_set_charset($link,'utf8');
    96. $sql= "SELECT * FROM comment";
    98. $res=mysqli_query($link,$sql);
    99. if($res ≡ false){
    100.     echo mysqli_errno($link),"<br>";
    101.   echo mysqli_error($link),"<br>";
    102. exit('sql语句执行失败！');
    103. }
    105. $data =[];
    106. while($row = mysqli_fetch_assoc($res)){
    107. $data[]=$row;
    108. }
    109. mysqli_close($link);
    110. ?>
    113.   <!DOCTYPE html>
    114.   <html>
    115. <head>
    116.   <meta charset="UTF-8">
    117.   <title>内容</title>
    118.   <style></style>
    119.   </head>
    120.     <body>
    121.       <h1>留言板</h1>
    122.       <p><a herf="./add.php">添加留言</a></p>
    123.         <?php foreach($data as $key → $liuyan){ ?>
    124.     <div class="cb">
    125.       <p><?php echo $liuyan['content'] ?></p>
    126.       <div class="ca"><b><?php echo $liuyan['name'] ?></b><span><?php echo $liuyan['email'] ?></span></div>
    127.       </div>
    128.       <div class="c-act">
    129.       <a herf="">编辑</a>
    130.         <a herf="">删除</a>
    131.       </div>
    132.       </div>
    133.       <?php }?>
    134.     </body>
    135.     </html>
    138.     <?php
    139. $link =mysqli_connect('127.0.0.1','root','root','class06')or exit('数据库连接失败'); 
    140. mysqli_set_charset($link,'utf-8');
    141. //查询语句
    142. $sql="SELECT * FROM books ORDER BY book_id DESC";
    144. $res =mysqli_query($link,$sql);
    145. var_dump($res);
    147. $row=mysqli_fetch_row($res);
    148. $row=mysqli_fetch_assoc($res);
    149. $row=mysqli_fetch_object($res);
    150. var_dump($row);
    152. $data = [];
    153. while($row=mysqli_fetch_assoc($res)){
    154. $data[] =$row;
    155. }
    156. var_dump($data);
    157. mysqli_close($link);
    158. ?>
    159. <!DOCTYPE html>
    160.   <html>
    161. <head>
    162.     <meta charset="UTF-8">
    163.   <title>sql留言板</title>
    164.   <style>
    165.     .cb{
    166.     border: 1px solid blue;
    167.     }
    169.   </style>
    170.     </head>
    171. <body>
    172. <h1>留言板</h1>
    173.  <p><a herf="./add.php">添加留言</a></p>
    174.  <div class="cb"><p>内容</p>
    175.  <div class="ca">
    176.     <b>姓名</b><sapn>邮箱</span> 
    177.  </div>
    178.    <div class="c-act">
    179.    <a herf="">编辑</a>
    180.  <a herf="">删除</a>
    181.   </div>
    182.  </div>
    183. </body>
    184. </html>
    186.   <!DOCTYPE html>
    187.   <html>
    188. <head>
    189.    <meta charset="UTF-8">
    190.   <title>添加留言</title>
    191.   </head>
    192.     <body>
    193.     <h1>添加留言</h1>
    194.     <form action="./demo.php" method="post">
    195.     <p>昵称：<input type="text" name="name"></p>
    196.      <p>邮箱：<input type="text" name="email"></p>
    197.           <p>留言：<input type="text" name="comment"></p>
    198.       <input type="submit" value="添加">
    199.       </form>
    200.       </body>
    201.     </html>
    202. <?php
    203. $post =$_POST;
    204. var_dump($post);
    206. $link =mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败');
    208. mysqli_set_charset($link,'UTF-8');
    210. $sql=sprintf("INSERT INTO COMMENT VALUES(DEFAULT, '%S','%S','%S')", $post['comment'],$post['name'],$post['email']);
    212. $res=mysqli_query($link,$sql);
    214. if($res && mysqli_afffected_rows($link)>0){
    215.     echo"成功"；
    216. }else{
    217. echo"失败";
    218. }
    219. mysqli_close($link);    
    222. CREATE TABLE comment(
    223. id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
    224. content varchar(255) NOT NULL COMMENT '留言内容',
    225. name varchar(10) NOT NULL COMMENT '姓名',
    226. email varchar(60) NOT NULL COMMENT '邮箱'
    227. );
    229. //首页显示功能
    230. <?php
    231.   $link = mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败');
    232. mysqli_set_charset($link,'utf8');
    233. $sql= "SELECT * FROM comment";
    235. $res=mysqli_query($link,$sql);
    236. if($res ≡ false){
    237.     echo mysqli_errno($link),"<br>";
    238.   echo mysqli_error($link),"<br>";
    239. exit('sql语句执行失败！');
    240. }
    242. $data =[];
    243. while($row = mysqli_fetch_assoc($res)){
    244. $data[]=$row;
    245. }
    246. mysqli_close($link);
    247. ?>
    250.   <!DOCTYPE html>
    251.   <html>
    252. <head>
    253.   <meta charset="UTF-8">
    254.   <title>内容</title>
    255.   <style></style>
    256.   </head>
    257.     <body>
    258.       <h1>留言板</h1>
    259.       <p><a herf="./add.php">添加留言</a></p>
    260.         <?php foreach($data as $key → $liuyan){ ?>
    261.     <div class="cb">
    262.       <p><?php echo $liuyan['content'] ?></p>
    263.       <div class="ca"><b><?php echo $liuyan['name'] ?></b><span><?php echo $liuyan['email'] ?></span></div>
    264.       </div>
    265.       <div class="c-act">
    266.       <a herf="">编辑</a>
    267.         <a herf="">删除</a>
    268.       </div>
    269.       </div>
    270.       <?php }?>
    271.     </body>
    272.     </html>
    275.     <?php
    276. $link =mysqli_connect('127.0.0.1','root','root','class06')or exit('数据库连接失败'); 
    277. mysqli_set_charset($link,'utf-8');
    278. //查询语句
    279. $sql="SELECT * FROM books ORDER BY book_id DESC";
    281. $res =mysqli_query($link,$sql);
    282. var_dump($res);
    284. $row=mysqli_fetch_row($res);
    285. $row=mysqli_fetch_assoc($res);
    286. $row=mysqli_fetch_object($res);
    287. var_dump($row);
    289. $data = [];
    290. while($row=mysqli_fetch_assoc($res)){
    291. $data[] =$row;
    292. }
    293. var_dump($data);
    294. mysqli_close($link);
    295. ?>
    296. <!DOCTYPE html>
    297.   <html>
    298. <head>
    299.     <meta charset="UTF-8">
    300.   <title>sql留言板</title>
    301.   <style>
    302.     .cb{
    303.     border: 1px solid blue;
    304.     }
    306.   </style>
    307.     </head>
    308. <body>
    309. <h1>留言板</h1>
    310.  <p><a herf="./add.php">添加留言</a></p>
    311.  <div class="cb"><p>内容</p>
    312.  <div class="ca">
    313.     <b>姓名</b><sapn>邮箱</span> 
    314.  </div>
    315.    <div class="c-act">
    316.    <a herf="">编辑</a>
    317.  <a herf="">删除</a>
    318.   </div>
    319.  </div>
    320. </body>
    321. </html>
    323.   <!DOCTYPE html>
    324.   <html>
    325. <head>
    326.    <meta charset="UTF-8">
    327.   <title>添加留言</title>
    328.   </head>
    329.     <body>
    330.     <h1>添加留言</h1>
    331.     <form action="./demo.php" method="post">
    332.     <p>昵称：<input type="text" name="name"></p>
    333.      <p>邮箱：<input type="text" name="email"></p>
    334.           <p>留言：<input type="text" name="comment"></p>
    335.       <input type="submit" value="添加">
    336.       </form>
    337.       </body>
    338.     </html>
    339. <?php
    340. $post =$_POST;
    341. var_dump($post);
    343. $link =mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败');
    345. mysqli_set_charset($link,'UTF-8');
    347. $sql=sprintf("INSERT INTO COMMENT VALUES(DEFAULT, '%S','%S','%S')", $post['comment'],$post['name'],$post['email']);
    349. $res=mysqli_query($link,$sql);
    351. if($res && mysqli_afffected_rows($link)>0){
    352.     echo"成功"；
    353. }else{
    354. echo"失败";
    355. }
    356. mysqli_close($link);    
    359. CREATE TABLE comment(
    360. id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
    361. content varchar(255) NOT NULL COMMENT '留言内容',
    362. name varchar(10) NOT NULL COMMENT '姓名',
    363. email varchar(60) NOT NULL COMMENT '邮箱'
    364. );
    366. //首页显示功能
    367. <?php
    368.   $link = mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败');
    369. mysqli_set_charset($link,'utf8');
    370. $sql= "SELECT * FROM comment";
    372. $res=mysqli_query($link,$sql);
    373. if($res ≡ false){
    374.     echo mysqli_errno($link),"<br>";
    375.   echo mysqli_error($link),"<br>";
    376. exit('sql语句执行失败！');
    377. }
    379. $data =[];
    380. while($row = mysqli_fetch_assoc($res)){
    381. $data[]=$row;
    382. }
    383. mysqli_close($link);
    384. ?>
    387.   <!DOCTYPE html>
    388.   <html>
    389. <head>
    390.   <meta charset="UTF-8">
    391.   <title>内容</title>
    392.   <style></style>
    393.   </head>
    394.     <body>
    395.       <h1>留言板</h1>
    396.       <p><a herf="./add.php">添加留言</a></p>
    397.         <?php foreach($data as $key → $liuyan){ ?>
    398.     <div class="cb">
    399.       <p><?php echo $liuyan['content'] ?></p>
    400.       <div class="ca"><b><?php echo $liuyan['name'] ?></b><span><?php echo $liuyan['email'] ?></span></div>
    401.       </div>
    402.       <div class="c-act">
    403.       <a herf="">编辑</a>
    404.         <a herf="">删除</a>
    405.       </div>
    406.       </div>
    407.       <?php }?>
    408.     </body>
    409.     </html>

    php增删改查表
    1.连接数据库选择数据库 并且判断数据库是否连接成功
    2.设置字符集（编码）为了中文显示不乱码
    3.准备sql语句
    4.向mysql服务器发送sql语句执行
    5.释放结果同时关闭数据库连接

    查询的处理方式和新增 删除 修改的方式不同
    查询的处理：
    获取一个结果，这个函数的功能类似readdir（）；
    相信为结果集合内有一个指针，每调用函数一次则将当前指针指向的内容拿出来
    并且将指针指向下一个值的位置；同时如果获取不到值则返回false（NULL）
    mysqli_fetch_array(结果集[,返回格式])；
    返回格式：MYSQLI_BOTH(默认)/MYSQLI_NUM / MYSQLI_ASSOC

    MYSQLI_BOTH 索引+关联
    MYSQLI_NUM 索引
    MYSQLI_ASSOC 关联

    mysqli_fetch_row(结果集) 获取数据为索引数组
    mysqli_fetch_assoc(结果集) 获取数据为关联数组
    mysqli_fetch_object(结果集) 获取数据为对象格式

    $row=mysqli_fetch_row($res);
    $row=mysqli_fetch_assoc($res);
    $row=mysqli_fetch_object($res);
    var_dump($row);

    获取错误信息：
    mysql_errno($link)； 获取错误代码（编号）
    mysql_error($link)；获取错误文字信息

    mysql版留言板添加功能