How to do multiple sql query in single execution

Question

im using this php code to concat two querys:

$qry = "Create Table $this->tablename (".
                "id_user BIGINT NOT NULL AUTO_INCREMENT ,".
                "name VARCHAR( 128 ) NOT NULL ,".
                "lastname VARCHAR( 128 ) NOT NULL ,".
                "email VARCHAR( 128 ) NOT NULL ,".
                "password VARCHAR( 32 ) NOT NULL ,".
                "confirmcode VARCHAR(32) ,".
                "ident_number VARCHAR( 128 ) NOT NULL ,".
                "professional_area VARCHAR( 128 ) NOT NULL ,".
                "last_update_cv DATETIME NOT NULL ,".
                "last_login DATETIME NOT NULL ,".
                "PRIMARY KEY ( id_user )".
                ");";
$qry = $qry . "CREATE TABLE ". table_cv . 
" (id_cv BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY , 
id_user BIGINT NOT NULL, 
phone_number VARCHAR(35) NOT NULL, 
profile_text VARCHAR(500) NOT NULL);";

Any time i send the query i get a syntax error.
What is the correct way to do two queries in single execution?

John Giotta · Accepted Answer · 2011-09-07 14:49:31Z

1

If you are using PHP 5 you can use multi_query

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

answered Sep 7, 2011 at 14:49

John Giotta

17.1k7 gold badges55 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marc B · Accepted Answer · 2011-09-07 14:50:14Z

Use a HEREDOC:

$sql = <<<EOL
Create Table {$this->tablename} (
    id_user BIGINT NOT NULL AUTO_INCREMENT,
    name VARCHAR( 128 ) NOT NULL ,
    lastname VARCHAR( 128 ) NOT NULL ,
    email VARCHAR( 128 ) NOT NULL ,
    password VARCHAR( 32 ) NOT NULL ,
    confirmcode VARCHAR(32) ,
    ident_number VARCHAR( 128 ) NOT NULL ,
    professional_area VARCHAR( 128 ) NOT NULL ,
    last_update_cv DATETIME NOT NULL ,
    last_login DATETIME NOT NULL ,
    PRIMARY KEY ( id_user )
);
EOL;

They make it very easy to generate multi-line strings. However, note that MySQL's PHP driver does NOT allow multiple queries to be issued in a single query call as a security restriction (it eliminates a large class of SQL injection attacks).

You'll have to issue two separate queries.

smp7d · Accepted Answer · 2011-09-07 14:51:28Z

0

are you using multi_query? http://php.net/manual/en/mysqli.multi-query.php

answered Sep 7, 2011 at 14:51

smp7d

5,0422 gold badges28 silver badges49 bronze badges

Collectives™ on Stack Overflow

How to do multiple sql query in single execution

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related