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