Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //Creates new record as per request
- //Connect to database
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "mvclogin";
- // Create connection
- $conn = new mysqli($servername,$username,$password,$dbname);
- //get date
- date_default_timezone_set('Asia/Manila');
- $d = date('Y-m-d');
- //echo " Date:".$d."<BR>";
- //get time
- $t = date('H:i:s');
- echo "connection"; //for checking
- if(!empty($_GET['temperature']) && !empty($_GET['glucoselevel']) && !empty($_GET['oxygenlevel']) && !empty($_GET['bloodpressure']) && !empty($_GET['heartrate'])&& !empty($_GET['identifier']))
- {
- echo "if"; //for checking
- $temp = $_GET['temperature'];
- $gl = $_GET['glucoselevel'];
- $ol = $_GET['oxygenlevel'];
- $bp = $_GET['bloodpressure'];
- $hr = $_GET['heartrate'];
- $identifier = $_GET['identifier'];
- //insert to data database
- $sql = "INSERT INTO data (temperature, glucoselevel, oxygenlevel, bloodpressure, heartrate, Date, Time, identifier)
- VALUES ('".$temp."', '".$gl."', '".$ol."', '".$bp."', '".$hr."', '".$d."', '".$t."', '".$identifier."')";
- if ($conn->query($sql) === TRUE) {
- echo "OK"; //serial print ok
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error; //serial print error
- }
- mysqli_close($conn);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement