PHP代码中的SQL语法错误，即使命令在命令行中运行

Question

I'm trying to make some SQL commands in XAMPP. My query returns following error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS kayttajat ( id INT(10) NOT NULL AUTO_INCREMENT, tunn' at line 2

I can't find the syntax error. And when I run the exact same command by copy-paste in command line, it works. So do I need some different syntax in PHP code? Also if I remove the first command, the error message moves to [...] right syntax to use near 'CREATE TABLE IF NOT EXISTS rivit [...]. If I remove second command the error comes from third command and so on. I really don't understand where the error is.

$query='
CREATE DATABASE IF NOT EXISTS asdgfhj;
CREATE TABLE IF NOT EXISTS kayttajat
(
    id INT(10) NOT NULL AUTO_INCREMENT,
    tunnus1 varchar(32) NOT NULL,
    tunnus2 varchar(32) NOT NULL,
    nimi varchar(32),
    nimi2 varchar(32),
    oikeus INT(10) NOT NULL DEFAULT 1,
    PRIMARY KEY (id)
);
CREATE TABLE IF NOT EXISTS rivit
(
    id INT(10) NOT NULL AUTO_INCREMENT,
    sivu INT(10) NOT NULL,
    kayttaja INT(10) NOT NULL,
    sana varchar(500),
    kommentti varchar(1000),
    aika TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    muutos TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY(id)
);
CREATE TABLE IF NOT EXISTS sivut
(
    id INT(10) NOT NULL AUTO_INCREMENT,
    nimi varchar(32) NOT NULL,
    ohje varchar(2000) NOT NULL,
    salaisuus INT(10) NOT NULL DEFAULT 1,
    PRIMARY KEY(id)
);
';

$mysqli->query($query) or die($mysqli->error);

Answer 1

The query() method is designed to execute a single query not multiple ones.

What you are looking for is multi_query() to execute multiple queries separated by a semicolon.

$query  = "SELECT CURRENT_USER();";
$query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";

/* execute multi query */
if ($mysqli->multi_query($query)) {
    ...
}