<?php require_once 'database.php'; try { $pdo = new PDO($DB_DSN, $DB_USER, $DB_PASSWORD); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ); createBdd($pdo); createUserTable($pdo); createImageTable($pdo); } catch (Exception $e) { echo $e->getMessage(); } function createBdd($pdo) { if (isset($pdo)) { $pdo->exec("CREATE DATABASE IF NOT EXISTS 42_camagru;"); $pdo->exec("use 42_camagru;"); } } function createUserTable($pdo) { if (isset($pdo)) { $pdo->exec("CREATE TABLE IF NOT EXISTS users (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, first_name VARCHAR(25), last_name VARCHAR(50), date_naissance DATETIME, email VARCHAR(255) NOT NULL UNIQUE, username VARCHAR(25) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, confirmation_token VARCHAR(60), confirmation_at DATETIME, reset_token VARCHAR(60), reset_at DATETIME);"); } } function createImageTable($pdo) { if (isset($pdo)) { $pdo->exec("CREATE TABLE IF NOT EXISTS images (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,\n\t\t\t\tuser_id INT UNSIGNED NOT NULL, link TEXT NOT NULL,\n\t\t\t\tCONSTRAINT fk_image_user FOREIGN KEY (user_id) REFERENCES users(id))"); }
<?php require_once dirname(__FILE__) . '/../library/Core.php'; $core = new Core(); createBdd($core); function createBdd($core) { $db_host = $core->parameters['db_host']; $db_user = $core->parameters['db_user']; $db_password = $core->parameters['db_password']; $db_name = $core->parameters['db_name']; $conn = mysql_connect($db_host, $db_user, $db_password); if (!$conn) { die('Could not connect: ' . mysql_error() . '\\n'); } echo 'Connected successfully \\n'; $sql = 'CREATE Database ' . $db_name . ''; $retval = mysql_query($sql, $conn); if (!$retval) { die('Could not create database: ' . mysql_error() . '\\n'); } echo "Database test_db created successfully\n"; mysql_close($conn); }