Advertisement
Guest User

Miso

a guest
Feb 8th, 2016
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.10 KB | None | 0 0
  1. <?php
  2.  
  3.     $znacka = $_POST['znacka1'];
  4.     $model = $_POST['model1'];
  5.     $spz = $_POST['spz1'];
  6.    
  7.     $con = mysqli_connect('localhost:3306', 'root', '', 'KnihaJazd');
  8.     $response = [];
  9.    
  10.         // Check for valid input
  11.     if($znacka && $model && $spz){
  12.         // Execute query to insert
  13.         if(mysqli_query($con, "INSERT INTO vp (znacka, model, spz) VALUES ('{$znacka}', '{$model}', '{$spz}');")){
  14.             $response['success']['msg'] = 'Data were successfully added';
  15.             $response['success']['data'] = [
  16.                 'znacka' => $znacka,
  17.                 'model' => $model,
  18.                 'spz1' => $spz
  19.             ];
  20.         }else{
  21.             $response['error']['sql'] = 'Sql error: '. mysqli_error($con);
  22.         }
  23.     }else{
  24.         if(!$znacka) $response['error']['znacka'] = "znacka were not provided!";
  25.         if(!$model) $response['error']['model'] =  "model were not provided!";
  26.         if(!$spz) $response['error']['spz'] =  "spz were not provided!";
  27.     }
  28.  
  29.     // Close connection
  30.     mysqli_close($con);
  31.     echo json_encode($response);
  32.  
  33. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement