[root@kvm3 ~]# vim /var/www/html/deleterecord.php [root@kvm3 ~]# cat /var/www/html/deleterecord.php <?php $dbhost = 'localhost:3306'; $dbuser = 'root'; $dbpass = '123qwe'; $conn = mysqli_connect($dbhost, $dbuser, $dbpass) or die(mysqli_connect_error().PHP_EOL); mysqli_select_db( $conn, 'dywphp' ) or die('Error: '.mysqli_error($conn).PHP_EOL); $sql = "delete from tblphp where id=1"; $retval = mysqli_query( $conn, $sql ) or die('Error: '.mysqli_error($conn).PHP_EOL); echo "Data Deleted successfully\n"; mysqli_close($conn); ?>
[root@kvm3 ~]# grep '^\$sql' /var/www/html/selectrecord.php $sql = "select id, title, author,submission_date from tblphp";
http://kvm3.deyu.wang/selectrecord.php
,管線處理將 html 換行標籤 <br>
改成 shell 的換行符號 \n
,網頁上列出資料表 tblphp
所有紀錄。
[root@kvm3 ~]# curl -s http://kvm3.deyu.wang/selectrecord.php | sed 's/<br> */\n/g' Dywphp ID :1 Title: python Author: David Submission Date : 0000-00-00 -------------------------------- Dywphp ID :2 Title: python Author: dywang Submission Date : 2020-01-29 -------------------------------- Fetched data successfully
http://kvm3.deyu.wang/deleterecord.php
,管線處理將 html 換行標籤 <br>
改成 shell 的換行符號 \n
,網頁回應 'Data Deleted successfully'。
[root@kvm3 ~]# curl -s http://kvm3.deyu.wang/deleterecord.php | sed 's/<br> */\n/g' Data Deleted successfully
http://kvm3.deyu.wang/selectrecord.php
,管線處理將 html 換行標籤 <br>
改成 shell 的換行符號 \n
,網頁上列出資料表 tblphp
所有紀錄,id=1 的紀錄已不存在。
[root@kvm3 ~]# curl -s http://kvm3.deyu.wang/selectrecord.php | sed 's/<br> */\n/g' Dywphp ID :2 Title: python Author: dywang Submission Date : 2020-01-29 -------------------------------- Fetched data successfully