Advertisement
cjoyales

GETDEMO.PHP

Feb 4th, 2019
163
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.45 KB | None | 0 0
  1. <?php
  2.  
  3. //Creates new record as per request
  4.     //Connect to database
  5.     $servername = "localhost";
  6.     $username = "root";
  7.     $password = "";
  8.     $dbname = "mvclogin";
  9.  
  10.     // Create connection
  11.     $conn = new mysqli($servername,$username,$password,$dbname);
  12. //get date
  13.     date_default_timezone_set('Asia/Manila');
  14.     $d = date('Y-m-d');
  15.     //echo " Date:".$d."<BR>";
  16. //get time
  17.     $t = date('H:i:s');
  18.  
  19.     echo "connection"; //for checking
  20.  
  21.     if(!empty($_GET['temperature']) && !empty($_GET['glucoselevel']) && !empty($_GET['oxygenlevel']) && !empty($_GET['bloodpressure']) && !empty($_GET['heartrate'])&& !empty($_GET['identifier']))
  22.     {
  23.        echo "if"; //for checking
  24.         $temp = $_GET['temperature'];
  25.         $gl = $_GET['glucoselevel'];
  26.         $ol = $_GET['oxygenlevel'];
  27.         $bp = $_GET['bloodpressure'];
  28.         $hr = $_GET['heartrate'];
  29.         $identifier = $_GET['identifier'];
  30.         //insert to data database
  31.         $sql = "INSERT INTO data (temperature, glucoselevel, oxygenlevel, bloodpressure, heartrate, Date, Time, identifier)
  32.        
  33.         VALUES ('".$temp."', '".$gl."', '".$ol."', '".$bp."', '".$hr."', '".$d."', '".$t."', '".$identifier."')";
  34.            
  35.                
  36.           if ($conn->query($sql) === TRUE) {
  37.             echo "OK"; //serial print ok
  38.         } else {
  39.             echo "Error: " . $sql . "<br>" . $conn->error; //serial print error
  40.         }  
  41.            
  42.         mysqli_close($conn);
  43.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement