Advertisement
Jure199

Insert data

May 26th, 2016
219
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.09 KB | None | 0 0
  1. <?php
  2.     $servername = "localhost";
  3.     $username = "YUN";
  4.     $password = "xxx";
  5.     $dbname = "TestnaBaza";
  6.    
  7.     // naredi povezavo
  8.     $conn = mysqli_connect($servername, $username, $password, $dbname);
  9.     //preveri povezavo
  10.     if (!$conn){
  11.         die ("Povezava ni uspela" .mysqli_connect_error());
  12.     }
  13.    
  14.     $response = array();
  15.     $res = array();
  16.    
  17.     $json = _json_decode(file_get_contents('php://input'));
  18.    
  19.     if($json!=null){
  20.         //$device = $json("YUN");
  21.         $temperatura = "28"; //$json("26")
  22.         $datum =date('Y-m-d-h-i-s') ; //$json("date")
  23.        
  24.     $sql = "INSERT INTO YunPodatki(temperatura,datum) VALUES(
  25.     '$temperatura', '$datum')";
  26.    
  27.     if(mysqli_query($conn, $sql)){
  28.         $response["code"] = 1;
  29.         $response["message"] = "Uspesno shranjeno";
  30.         echo json_encode($response);
  31.     } else {
  32.         $response["code"] = 2;
  33.         $response["message"] = mysqli_error($conn);
  34.         echo json_encode($response);
  35.     }
  36.    
  37.     }else {
  38.    
  39.         echo "json error";
  40.     }
  41.    
  42.     mysqli_close($conn);
  43.    
  44.     function _json_decode($string){
  45.         if (get_magic_quotes_gpc()){
  46.             $string = stripcslashes($string);
  47.         }
  48.         return json_decode($string.true);
  49.     }
  50.     ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement