MySQL and AJAX, works in one but not the other

Question

I am using AJAX to make a "load call" to a PHP script that contains information to be added to a database, the script is as such:

<?php

$create_tables = "
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
`name` varchar(255) NOT NULL UNIQUE,
`password` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `user_details`
(
`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
`email_address` varchar(255) NOT NULL UNIQUE,
`address1` varchar(500) NULL,
`address2` varchar(500) NULL,  
`address3` varchar(500) NULL,
`postcode` VARCHAR(10) NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 CHARSET=latin1;

INSERT IGNORE INTO `user` (`id`, `name`, `password`) VALUES (1, 'admin', '704b037a97fa9b25522b7c014c300f8a');
INSERT IGNORE INTO `user_details` (`id`, `email_address`) VALUES (1, 'sam.swift@fifteendigital.co.uk');
";

function cre($query)
{
    $link = new mysqli();
    $link->real_connect("localhost", "root", "", "overr");
    return $link->query($query) ? "true" : "false";
}

print cre($create_tables);

?>

And the AJAX is called as thus:

function _ajax( u, t )
{
    $.ajax( {
        url: u,
        type: "GET",
        success: function ( r )
        {
            $( "#test" ).html( r );
            console.log( r );
            return r;
        },
        beforeSend: function ()
        {
            $( t ).html( "Loading" );
        }
    } );
}

$( document ).ready( function ()
{
    _ajax( "aj/tables.php", "#null" );
} );

And when I call the query in phpmyadmin, it works perfect, but when I call it through the AJAX from the load page, the console gets logged "false", how can I make it so that the script executes and returns true, even when there is nothing in the database at all I am still getting "false" returned through to the client.

The purpose of this is to set up the environment before anything is done to ensure that everything is in place and working correctly, this system will change in the future, but for now I just need to get it working

You cannot execute multiple statements in single query. – Inurosen Sep 14 '15 at 14:35 — Inurosen, Sep 14 '15 at 14:35
Separate your queries and execute one by one ! – Fky Sep 14 '15 at 14:37 — Fky, Sep 14 '15 at 14:37

score 4 · Accepted Answer · edited Sep 14 '15 at 14:39

4

Use mysqli::multi_query() not mysqli::query():

http://php.net/manual/en/mysqli.multi-query.php

edited Sep 14 '15 at 14:39

Kev

118,037
53
300
385

answered Sep 14 '15 at 14:38

markdwhite

2,360
19
24

Perfect, as soon as I can, going down as correct! – Can O' Spam Sep 14 '15 at 14:39

score 0 · Answer 2 · answered Sep 14 '15 at 14:39

0

Try,

Separating every query or use multiquery feature.
Avoid using INSERT IGNORE as you will not be able to receive errors. Try INSERT...ON DUPLICATE instead.

answered Sep 14 '15 at 14:39

jqheart

767
1
5
15

MySQL and AJAX, works in one but not the other

2 Answers2