Advertisement
laurens-wuyts

db_create.php

May 12th, 2015
4,955
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.17 KB | None | 0 0
  1. <?php
  2. // array for JSON response
  3. $response = array();
  4.  
  5. // check for required fields
  6. if (isset($_POST['Name']) && isset($_POST['part_nr'])) {
  7.  
  8.     $Name = $_POST['Name'];
  9.     $part_nr = $_POST['part_nr'];
  10.  
  11.     // include db connect class
  12.     require_once __DIR__ . '/db_connect.php';
  13.  
  14.     // connecting to db
  15.     $db = new DB_CONNECT();
  16.  
  17.     // mysql inserting a new row
  18.     $result = mysql_query("INSERT INTO Parts(Name, part_nr) VALUES('$Name', '$part_nr')");
  19.  
  20.     // check if row inserted or not
  21.     if ($result) {
  22.         // successfully inserted into database
  23.         $response["success"] = 1;
  24.         $response["message"] = "Part successfully inserted.";
  25.  
  26.         // echoing JSON response
  27.         echo json_encode($response);
  28.     } else {
  29.         // failed to insert row
  30.         $response["success"] = 0;
  31.         $response["message"] = "Oops! An error occurred.";
  32.  
  33.         // echoing JSON response
  34.         echo json_encode($response);
  35.     }
  36. } else {
  37.     // required field is missing
  38.     $response["success"] = 0;
  39.     $response["message"] = "Required field(s) is missing";
  40.  
  41.     // echoing JSON response
  42.     echo json_encode($response);
  43. }
  44. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement