PDO -> if(table exist)

Question

try {
    $query = $pdo->query("SELECT 1 FROM `classes` LIMIT 1");
} catch (Exception $e) {
    $query = $pdo->prepare("CREATE TABLE `classes`(
    `ID_class` int(11) AUTO_INCREMENT,
    `name` varchar(255),
    PRIMARY KEY(`ID_class`))");

    $query->execute();
}

Hello.

It doesn't catch, if the table doesn't exist.

Take a look https://stackoverflow.com/questions/8829102/check-if-table-exists-without-using-select-from — Nikolai Shevchenko, Jun 05 '18 at 13:16

score 0 · Answer 1 · edited Jun 20 '20 at 09:12

0

This is not going to work because, according to the PHP documentation (php.net):

Return Values

PDO::query() returns a PDOStatement object, or FALSE on failure.

So you either need to test if $pdo->query("SELECT 1 FROM 'classes' LIMIT 1") returns false or an alternative like checking if a table exists without using 'select from' (stackoverflow.com).

edited Jun 20 '20 at 09:12

Community

1
1

answered Jun 05 '18 at 13:31

Justin Pearce

4,994
2
24
37

score 0 · Answer 2 · answered Jun 05 '18 at 14:04

It worked for me with the PDO ATT_ERRMODE set to ERRMODE_EXCEPTION.

$user = 'test';
$pass = 'test';
$opt  = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION];

$db   = new PDO('mysql:host=localhost;dbname=test;charset=utf8' ,
                                    $user ,
                                    $pass ,
                                    $opt
                                    );


try {
    $query = $db->query("SELECT 1 FROM `classes` LIMIT 1");
} catch (Exception $e) {
    $query = $db->prepare("CREATE TABLE `classes`(
    `ID_class` int(11) AUTO_INCREMENT,
    `name` varchar(255),
    PRIMARY KEY(`ID_class`))");

    $query->execute();
}

PDO -> if(table exist)

2 Answers2

Return Values