<?php

    $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpass = 'foobar2000';
    $dbname = 'testdb';

    $q_name = $_GET['name'];
    $q_id = $_GET['id'];
    $q_addr = $_GET['address'];
    $q_lat = $_GET['lat'];
    $q_lon = $_GET['lon'];
    $q_count = 0;
    $q_stat = 1;

    $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

    if ($conn->connect_error){
        die("Connection failed: " . $conn->connect_error);
    }

    $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."')";

    if ($conn->query($sql) === TRUE) {

        $table_name = "tbl_queue_" . $q_id;
        $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)";

        if ($conn->query($sql2) == TRUE){
            $retval = array('code' => 1, 'message' => 'Queue is created.');
            echo json_encode($retval);
        }
        else {
            die("Error: ". $conn->error);
        }
    }
    else {
        $retval = array('code' => 0, 'message' => 'Queue creation failed. Please try again.');
        echo json_encode($retval);
    }

    $conn->close();
?>