Advertisement
anta40

query1.php

Jun 9th, 2016
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.79 KB | None | 0 0
  1. <?php
  2.  
  3.     $dbhost = 'localhost';
  4.     $dbuser = 'root';
  5.     $dbpass = 'dbadmin';
  6.     $dbname = 'wait4me';
  7.    
  8.     $q_id = $_GET['queue'];
  9.     $q_email = $_GET['email'];
  10.     $q_pos = 0;
  11.    
  12.     $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
  13.    
  14.     if ($conn->connect_error){
  15.         die("Connection failed: " . $conn->connect_error);
  16.     }
  17.    
  18.     $tbl_name = "$tbl_queue_" . $q_id;
  19.     $sql = "INSERT INTO ".$tbl_name." (queue_member, queue_pos) VALUES ('"$q_name."','".$q_pos."')";
  20.    
  21.     if ($conn->query($sql) === TRUE) {
  22.         $retval = array('code' => 1, 'message' => 'User have been subscrived to queue');
  23.     }
  24.     else {
  25.         $retval = array('code' => 0, 'message' => 'User cannot subscribe to queue. Please try again.');
  26.         echo("anjir ini query sampah ----> ".$sql);
  27.     }
  28.    
  29.     echo json_encode($retval);
  30.     $conn->close();
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement