<?php
     /* Bind parameters. Types: s = string, i = integer, d = double,  b = blob */
     $host = "p:192.168.0.11"; //請填入可以存取的主機IP，p:表示使用連接池(Pooled Connection)
     $user = "root";           //請填入帳號
     $pass = "thePassword";    //請填入密碼
     $dbnm = "theDatabase";    //請填入資料庫名稱
     $conn = new mysqli($host, $user, $pass, $dbnm);
     $sn = 1;
     $sql1 = "SELECT * FROM `users` WHERE sn = ?";  //請依需求改寫
     $stmt = $conn->prepare($sql1);
     $stmt->bind_param('i',$sn);
     $stmt->execute();
     $stmt->bind_result($sn,$name,$mail,$home,$message); //請依需求改寫
     while($stmt->fetch())
     {
         //請依需求改寫
         echo $sn." , ".$name." , ".$mail." , ".$home." , ".$message;
     }
     $stat->close();
     $conn->close();
  ?>
  

<?php
     /* Bind parameters. Types: s = string, i = integer, d = double,  b = blob */
     $host = "p:192.168.0.11"; //請填入可以存取的主機IP，p:表示使用連接池(Pooled Connection)
     $user = "root";           //請填入帳號
     $pass = "thePassword";    //請填入密碼
     $dbnm = "theDatabase";    //請填入資料庫名稱
     $H = 0;
     $C = 0;
     $F = 0;
     if (isset($_GET["H"]) && !empty($_GET["H"]) && is_numeric($_GET["H"])) $H = $_GET["H"];
     if (isset($_GET["C"]) && !empty($_GET["C"]) && is_numeric($_GET["C"])) $C = $_GET["C"];
     if (isset($_GET["F"]) && !empty($_GET["F"]) && is_numeric($_GET["F"])) $F = $_GET["F"];
     $conn = new mysqli($host, $user, $pass, $dbnm);
     $sql1 = "insert into pointStatus(locationPoint, H, C, F) values(0, ?, ?, ?)"; //請依需求改寫
     $stat = $conn->prepare($sql1);
     $stat->bind_param("ddd",$H, $C, $F); //請依需求改寫
     $stat->execute();
     $stat->close();
     $conn->close();
?>