2020年5月8日

    1. <?php
    2. $post=$_POST;
    3. var_dump($post);
    5. include './functions.php';
    6. $sql=sprintf("INSERT INTO comment VALUES(DEFAULT,'%s','%s','%s'),$post['comment'],$post['name'],$post['email']");
    7. $res= execute($sql);
    8. if($res){
    9. echo"成功";
    10. }else{
    11. echo"失败"
    12. }
    15. function query($sql);
    16. $link=mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败')；
    17. mysqli_set_charset($link,'UTF8');
    18. if($res≡false){
    19. echo mysqli_errno($link),"<br>";
    20. echo mysqli_error($link),"<br";
    21. exit('sql语句执行失败')；  
    22. }
    23. $data=[];
    24. while($row=mysqli_fetch_assoc($res)){
    25. $data[]=$row;
    26. }
    28. mysqli_free_result($res);
    29.  mysqli_close($link)；
    31. return $data;
    32. }
    33. function execute($sql){
    34. $link = mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败'); 
    35. mysqli_set_charset($link,'UTF8');
    36. $res=mysqli_query($link,$sql);
    37.   $aff=mysqli_affected_rows($link);
    38.   mysqli_close($$link);
    40.   if($res && $aff > 0){
    41.   return true;
    42.   }else{
    43.   return false;
    44.   }
    45. }
    48. include '/.demo.php';
    49. $sql="SELECT *FROM comment ORDER BY id DESC";
    50. $data = query($sql);
    52. ?>
    55. <!DOCTYPE html>
    56. <html>
    57. <head>
    58.   <meta charset="utf-8">
    59.   <title>内容</title>
    60.     <styl>
    62.     </style>
    63.   </head>
    64. <body>
    65.   <h1>留言板</h1>
    66.   <p>
    67.   <a herf="./add.php">添加留言</a>
    68.   </p>
    69.   <?php forseach($data as $key→$liuyan){ ?>
    70.   <div class="cb">
    71.     <p><? php echo $liuyan['content']?></p>
    72.   <div class="ca">
    73.     <b><? php echo $liuyan['name']?></b><span><?php echo $liuyan['email']?></span></div>
    74.     <div class="c-act">
    75.     <a herf="">编辑</a>
    76.      <a herf="">删除</a>
    77.     </div>
    78.   </div>
    79.  <?php } ?>
    80.   </body>
    81. </html>
    84. <?php
    85. include './functions.php';
    86. $sql="SELECT *FROM comment ORDER BY id DESC";
    87. $data=query($sql);
    89. ?>
    90. <!DOCTYPE html>
    91. <html>
    92. <head>
    93.   <meta charset="utf-8">
    94.   <title>内容</title>
    95.     <styl>
    96.     .cb{
    97.     border:1px solid red;
    98.     }
    99.     </style>
    100.   </head>
    101. <body>
    102. <h1>留言板</h1>
    103. <p><a herf="./add.php">添加留言</a></p>
    104.    <?php forseach($data as $key→$liuyan){ ?>
    105.   <div class="cb">
    106.     <p><? php echo $liuyan['content']?></p>
    107.   <div class="ca">
    108.     <b><? php echo $liuyan['name']?></b><span><?php echo $liuyan['email']?></span></div>
    109.      <div class="c-act">
    110.     <a herf="./edit.php?id=<?php echo $liuyan['id']?>">编辑</a>
    111.      <a herf="./del.php?id=<?php echo $liuyan['id']?>">删除</a>
    112.     </div>
    113.   </div>
    114.   <?php } ?>
    115.   </body>
    116.   </html>
    117. <?php
    118. $id=$_GET['id'];
    119. var_dump($id);
    120. $sql="DELETE FROM comment WHERE id={$id}";
    121. include './functions.php';
    122. $res=execute($sql);
    123. if($res){
    124. echo"成功"；
    125. }esle{
    126. echo"失败“;
    127. }
    130. <?php
    131. var_dump($_POST);
    132. $id=$_POST['id'];
    133. $content=$_POST['comment'];
    134. $sql=sprintf("UPDATE comment SET content='%s' WHERE id =%s",$content,$id);
    135. include './functions.php';
    136. $res=execute($sql);
    137. if($res){
    138. echo"成功";
    139. }else{
    140. echo"失败";
    141. }
    145. <?php
    146. $post=$_POST;
    147. var_dump($post);
    149. include './functions.php';
    150. $sql=sprintf("INSERT INTO comment VALUES(DEFAULT,'%s','%s','%s'),$post['comment'],$post['name'],$post['email']");
    151. $res= execute($sql);
    152. if($res){
    153. echo"成功";
    154. }else{
    155. echo"失败"
    156. }
    159. function query($sql);
    160. $link=mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败')；
    161. mysqli_set_charset($link,'UTF8');
    162. if($res≡false){
    163. echo mysqli_errno($link),"<br>";
    164. echo mysqli_error($link),"<br";
    165. exit('sql语句执行失败')；  
    166. }
    167. $data=[];
    168. while($row=mysqli_fetch_assoc($res)){
    169. $data[]=$row;
    170. }
    172. mysqli_free_result($res);
    173.  mysqli_close($link)；
    175. return $data;
    176. }
    177. function execute($sql){
    178. $link = mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败'); 
    179. mysqli_set_charset($link,'UTF8');
    180. $res=mysqli_query($link,$sql);
    181.   $aff=mysqli_affected_rows($link);
    182.   mysqli_close($$link);
    184.   if($res && $aff > 0){
    185.   return true;
    186.   }else{
    187.   return false;
    188.   }
    189. }
    192. include '/.demo.php';
    193. $sql="SELECT *FROM comment ORDER BY id DESC";
    194. $data = query($sql);
    196. ?>
    199. <!DOCTYPE html>
    200. <html>
    201. <head>
    202.   <meta charset="utf-8">
    203.   <title>内容</title>
    204.     <styl>
    206.     </style>
    207.   </head>
    208. <body>
    209.   <h1>留言板</h1>
    210.   <p>
    211.   <a herf="./add.php">添加留言</a>
    212.   </p>
    213.   <?php forseach($data as $key→$liuyan){ ?>
    214.   <div class="cb">
    215.     <p><? php echo $liuyan['content']?></p>
    216.   <div class="ca">
    217.     <b><? php echo $liuyan['name']?></b><span><?php echo $liuyan['email']?></span></div>
    218.     <div class="c-act">
    219.     <a herf="">编辑</a>
    220.      <a herf="">删除</a>
    221.     </div>
    222.   </div>
    223.  <?php } ?>
    224.   </body>
    225. </html>
    228. <?php
    229. include './functions.php';
    230. $sql="SELECT *FROM comment ORDER BY id DESC";
    231. $data=query($sql);
    233. ?>
    234. <!DOCTYPE html>
    235. <html>
    236. <head>
    237.   <meta charset="utf-8">
    238.   <title>内容</title>
    239.     <styl>
    240.     .cb{
    241.     border:1px solid red;
    242.     }
    243.     </style>
    244.   </head>
    245. <body>
    246. <h1>留言板</h1>
    247. <p><a herf="./add.php">添加留言</a></p>
    248.    <?php forseach($data as $key→$liuyan){ ?>
    249.   <div class="cb">
    250.     <p><? php echo $liuyan['content']?></p>
    251.   <div class="ca">
    252.     <b><? php echo $liuyan['name']?></b><span><?php echo $liuyan['email']?></span></div>
    253.      <div class="c-act">
    254.     <a herf="./edit.php?id=<?php echo $liuyan['id']?>">编辑</a>
    255.      <a herf="./del.php?id=<?php echo $liuyan['id']?>">删除</a>
    256.     </div>
    257.   </div>
    258.   <?php } ?>
    259.   </body>
    260.   </html>
    261. <?php
    262. $id=$_GET['id'];
    263. var_dump($id);
    264. $sql="DELETE FROM comment WHERE id={$id}";
    265. include './functions.php';
    266. $res=execute($sql);
    267. if($res){
    268. echo"成功"；
    269. }esle{
    270. echo"失败“;
    271. }
    274. <?php
    275. var_dump($_POST);
    276. $id=$_POST['id'];
    277. $content=$_POST['comment'];
    278. $sql=sprintf("UPDATE comment SET content='%s' WHERE id =%s",$content,$id);
    279. include './functions.php';
    280. $res=execute($sql);
    281. if($res){
    282. echo"成功";
    283. }else{
    284. echo"失败";
    285. }
    288. <?php
    289. $post=$_POST;
    290. var_dump($post);
    292. include './functions.php';
    293. $sql=sprintf("INSERT INTO comment VALUES(DEFAULT,'%s','%s','%s'),$post['comment'],$post['name'],$post['email']");
    294. $res= execute($sql);
    295. if($res){
    296. echo"成功";
    297. }else{
    298. echo"失败"
    299. }
    302. function query($sql);
    303. $link=mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败')；
    304. mysqli_set_charset($link,'UTF8');
    305. if($res≡false){
    306. echo mysqli_errno($link),"<br>";
    307. echo mysqli_error($link),"<br";
    308. exit('sql语句执行失败')；  
    309. }
    310. $data=[];
    311. while($row=mysqli_fetch_assoc($res)){
    312. $data[]=$row;
    313. }
    315. mysqli_free_result($res);
    316.  mysqli_close($link)；
    318. return $data;
    319. }
    320. function execute($sql){
    321. $link = mysqli_connect('127.0.0.1','root','root','liuyan')or exit('连接数据库失败'); 
    322. mysqli_set_charset($link,'UTF8');
    323. $res=mysqli_query($link,$sql);
    324.   $aff=mysqli_affected_rows($link);
    325.   mysqli_close($$link);
    327.   if($res && $aff > 0){
    328.   return true;
    329.   }else{
    330.   return false;
    331.   }
    332. }
    335. include '/.demo.php';
    336. $sql="SELECT *FROM comment ORDER BY id DESC";
    337. $data = query($sql);
    339. ?>
    342. <!DOCTYPE html>
    343. <html>
    344. <head>
    345.   <meta charset="utf-8">
    346.   <title>内容</title>
    347.     <styl>
    349.     </style>
    350.   </head>
    351. <body>
    352.   <h1>留言板</h1>
    353.   <p>
    354.   <a herf="./add.php">添加留言</a>
    355.   </p>
    356.   <?php forseach($data as $key→$liuyan){ ?>
    357.   <div class="cb">
    358.     <p><? php echo $liuyan['content']?></p>
    359.   <div class="ca">
    360.     <b><? php echo $liuyan['name']?></b><span><?php echo $liuyan['email']?></span></div>
    361.     <div class="c-act">
    362.     <a herf="">编辑</a>
    363.      <a herf="">删除</a>
    364.     </div>
    365.   </div>
    366.  <?php } ?>
    367.   </body>
    368. </html>
    371. <?php
    372. include './functions.php';
    373. $sql="SELECT *FROM comment ORDER BY id DESC";
    374. $data=query($sql);
    376. ?>
    377. <!DOCTYPE html>
    378. <html>
    379. <head>
    380.   <meta charset="utf-8">
    381.   <title>内容</title>
    382.     <styl>
    383.     .cb{
    384.     border:1px solid red;
    385.     }
    386.     </style>
    387.   </head>
    388. <body>
    389. <h1>留言板</h1>
    390. <p><a herf="./add.php">添加留言</a></p>
    391.    <?php forseach($data as $key→$liuyan){ ?>
    392.   <div class="cb">
    393.     <p><? php echo $liuyan['content']?></p>
    394.   <div class="ca">
    395.     <b><? php echo $liuyan['name']?></b><span><?php echo $liuyan['email']?></span></div>
    396.      <div class="c-act">
    397.     <a herf="./edit.php?id=<?php echo $liuyan['id']?>">编辑</a>
    398.      <a herf="./del.php?id=<?php echo $liuyan['id']?>">删除</a>
    399.     </div>
    400.   </div>
    401.   <?php } ?>
    402.   </body>
    403.   </html>
    404. <?php
    405. $id=$_GET['id'];
    406. var_dump($id);
    407. $sql="DELETE FROM comment WHERE id={$id}";
    408. include './functions.php';
    409. $res=execute($sql);
    410. if($res){
    411. echo"成功"；
    412. }esle{
    413. echo"失败“;
    414. }
    417. <?php
    418. var_dump($_POST);
    419. $id=$_POST['id'];
    420. $content=$_POST['comment'];
    421. $sql=sprintf("UPDATE comment SET content='%s' WHERE id =%s",$content,$id);
    422. include './functions.php';
    423. $res=execute($sql);
    424. if($res){
    425. echo"成功";
    426. }else{
    427. echo"失败";
    428. }