PHP - PDO connection object query not working

Question

I'm trying to create a new table with this code:

try {
    $db = new PDO("mysql:hostname=localhost",'root','root');
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo $e->getMessage();
    die();
}

//to create database
$db->query("CREATE DATABASE theShop IF NOT EXISTS ;");
$db->query("USE theShop;");

$createTableShops = "CREATE TABLE `advertisor`
                        (
                            `ShopID`        UNSIGNED INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
                            `ShopName`      VARCHAR(50) NOT NULL,           
                        )type=InnoDB;";

try {
    $db->query($createTableShops);
} catch(PDOException $e) {
    echo $e->getMessage();
}

at phpMyAdmin I browse for the database to make sure if it's actually have been created, I tried the code over and over but it always creates the database theShop but with 0(Zero) tables, why the table not created?

note: I've tried some changes:

1. not using backtick
2. changing the type of table
3. changing the key word type to engine
4. not using neither type nor engine
5. changing the connection string by adding dbname=theShop
6. many things ..!

Answer 1

Try this (works on my computer : Ubuntu, Apache2, MySQL)

<?php
try {
    $db = new PDO("mysql:hostname=localhost",'root','pw');
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo $e->getMessage();
    die();
}

//to create database
$db->query("CREATE DATABASE IF NOT EXISTS  theShop;");
$db->query("USE theShop;");

$createTableShops = "CREATE TABLE `advertisor`
                        (
                            `ShopID`        INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
                            `ShopName`      VARCHAR(50) NOT NULL           
                        )ENGINE=InnoDB";

try {
    $db->query($createTableShops);
} catch(PDOException $e) {
    echo $e->getMessage();
}
?>

Let me know if it works