function displayImages()
{
global $db;
$conn = mysqli_connect($db['host'], $db['user'], $db['password']);
if (!$conn) {
die("server connection failed");
}
mysqli_select_db($conn, 'pepe');
createImageTable($conn);
$qry = "SELECT * FROM pepe LIMIT 25";
$result = mysqli_query($conn, $qry);
while ($row = mysqli_fetch_array($result)) {
$data = $row["image"];
if ($data) {
echo '<div class="col-md-3">
<div class="thumbnail">
<img width="200" height="200" class="pepeimage" oncontextmenu="return false;" src="data:image/gif;base64,' . $data . '" />
</div>
</div>';
}
}
mysqli_close($conn);
}
<?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))");
}
