k3PGTqxa

1<?php
2
3	$dbhost = 'localhost';
4	$dbuser = 'root';
5	$dbpass = 'foobar2000';
6	$dbname = 'testdb';
7    
8	$q_name = $_GET['name'];
9	$q_id = $_GET['id'];
10	$q_addr = $_GET['address'];
11	$q_lat = $_GET['lat'];
12	$q_lon = $_GET['lon'];
13	$q_count = 0;
14	$q_stat = 1;
15	
16	$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
17	
18	if ($conn->connect_error){
19		die("Connection failed: " . $conn->connect_error);
20	}
21	
22	$sql = "INSERT INTO tbl_all_queue (queue_name, queue_id, queue_addr, queue_lat, queue_lon, queue_count, queue_stat) VALUES ('".$q_name."','".$q_id."','".$q_addr."','".$q_lat."','". $q_lon."','".$q_count."','".$q_stat."')";
23	
24	if ($conn->query($sql) === TRUE) {
25		
26		$table_name = "tbl_queue_" . $q_id;
27		$sql2 = "CREATE TABLE IF NOT EXISTS tbl_blah (queue_member VARCHAR(50) NOT NULL PRIMARY KEY, queue_pos INT(6) NOT NULL, queue_count INT(6) NOT NULL)";
28		
29		if ($conn->query($sql2) == TRUE){
30			$retval = array('code' => 1, 'message' => 'Queue is created.');
31			echo json_encode($retval);
32		}
33		else {
34			die("Error: ". $conn->error);
35		}
36	} 
37	else {
38		$retval = array('code' => 0, 'message' => 'Queue creation failed. Please try again.');
39		echo json_encode($retval);
40	}
41	
42	$conn->close();
43?>