{
try {
$statement = DB::getInstance()->prepare($queryString);
if ($params && is_array($params)) {
foreach ($params as $key => $param) {
$statement->bindValue($key, $param);
}
}
$statement->execute();
} catch (PDOException $e) {
die('Error sqlExecute : ' . $e->getMessage() . '<br/>');
}
}
include DATA_PATH . 'db-schema.sql.php';
Db::$dbHost = empty($_POST['dbURI']) ? 'localhost' : $_POST['dbURI'];
Db::$dbPort = empty($_POST['dbPort']) ? '3306' : $_POST['dbPort'];
Db::$dbUser = empty($_POST['dbUser']) ? 'root' : $_POST['dbUser'];
Db::$dbPwd = empty($_POST['dbPwd']) ? '' : $_POST['dbPwd'];
Db::$dbName = empty($_POST['dbName']) ? 'cocktails' : $_POST['dbName'];
Db::$tablePrefix = $_POST['tablePrefix'];
$sql = getSqlSchema(Db::$dbName, Db::$tablePrefix);
if (isset($_POST['createDatabase']) && $_POST['createDatabase'] == true) {
// create the database if needed.
try {
$dbh = new PDO('mysql:host=' . Db::$dbHost . ';port=' . Db::$dbPort, Db::$dbUser, Db::$dbPwd);
$dbh->exec($sql['base']['create']) or die('Erreur lors de la création de la base<br />' . print_r($dbh->errorInfo(), true));
} catch (PDOException $e) {
die("DB ERROR: " . $e->getMessage());
}
}
if (isset($_POST['dropTables']) && $_POST['dropTables'] == true) {
