<?php #connect.php connect to the mysql server define('DB_HOST','localhost'); define('DB_PORT', '3306'); define('DB_NAME', 'cookbook'); define('DB_USERNAME', 'root'); define('DB_PASSWORD', ''); try{ $dns = 'mysql:host='.DB_HOST.';port='.DB_PORT.';dbname=' . DB_NAME; $pdo = new PDO($dns , DB_USERNAME, DB_PASSWORD); $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_ASSOC); $pdo->exec('set session sql_mode = traditional'); $pdo->exec('set session innodb_strict_mode = on'); $stmt = $pdo->prepare('select * from firstNmae'); $stmt->execute(); $resute = $stmt->fetchAll(); echo'<pre>'; print_r($resute); echo '</pre>'; } catch(PDOException $e){ die(htmlspecialchars($e->getMessage())); } And when tryprint_r(PDO::getAvailableDrivers()); it returns this result Array ( [0] => sqlite )
