<?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);
}
