更新紀錄

1. 查看目前資料表 dywphp 有有兩筆紀錄。

   [root@kvm3 html]# curl -s http://kvm3/selectrecord.php | sed 's/<br> */\n/g'
   Dywphp ID: 1
   Title: PHP
   Author: David
   Submission Date: 2023-04-13
   --------------------------------
   Dywphp ID: 2
   Title: Mariadb
   Author: dywang
   Submission Date: 2023-04-20
   --------------------------------
   

2. 撰寫 upodaterecord.php，更新 tblphp 資料表的紀錄。

   [root@kvm3 html]# vim updaterecord.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 = "update tblphp set title='python' where id=2";
   $retval = mysqli_query( $conn, $sql )
   	or die('Error: '.mysqli_error($conn).PHP_EOL);
   echo "Data Updated successfully\n";
   mysqli_close($conn); 
   ?>
   

3. curl 連上網址 http://kvm3/updaterecord.php，管線處理將 html 換行標籤 <br> 改成 shell 的換行符號 \n，回應 'Data Updated successfully'。

   [root@kvm3 html]# curl -s http://kvm3/updaterecord.php | sed 's/<br> */\n/g'
   Data Updated successfully
   

4. curl 連上網址 http://kvm3/selectrecord.php，管線處理將 html 換行標籤 <br> 改成 shell 的換行符號 \n，回應 id=2 的紀錄，其 title 已變更為 python。

   [root@kvm3 html]# curl -s http://kvm3/selectrecord.php | sed 's/<br> */\n/g'
   Dywphp ID: 1
   Title: PHP
   Author: David
   Submission Date: 2023-04-13
   --------------------------------
   Dywphp ID: 2
   Title: python
   Author: dywang
   Submission Date: 2023-04-20
   --------------------------------
   Fetched data successfully