<?php
$conn = mysqli_connect($db['host'], $db['user'], $db['pass']);
if ($conn) {
initialize_db($conn, $db['db']);
$is_db = mysqli_select_db($conn, $db['db']);
initialize_tables($conn);
}
function initialize_db($conn, $name)
{
mysqli_query($conn, "CREATE DATABASE IF NOT EXISTS {$name}");
}
function initialize_tables($conn)
{
mysqli_query($conn, "CREATE TABLE IF NOT EXISTS comments(\n id INT PRIMARY KEY AUTO_INCREMENT,\n content TEXT\n )");
mysqli_query($conn, "CREATE TABLE IF NOT EXISTS com(\n from_id INT,\n from_type VARCHAR(20),\n to_id INT,\n to_type VARCHAR(20),\n rel_type VARCHAR(20) DEFAULT 'have'\n )");
}
$model = array();
$model_files = array_filter(scandir(MODEL_DIR), function ($i) {
return !in_array($i, array('.', '..', 'model.php'));
});
foreach ($model_files as $model_file) {
require_once $model_file;
}
unset($conn);
<?php
$db = array('host' => 'localhost', 'name' => 'root', 'pass' => '', 'db_name' => 'slabel_gallery');
$conn = mysqli_connect($db['host'], $db['name'], $db['pass']);
// echo '<pre>';
// var_dump($conn);
initialize_db($conn, $db);
initialize_tables($conn);
function initialize_db($conn, $db)
{
mysqli_query($conn, "CREATE DATABASE IF NOT EXISTS {$db['db_name']}");
mysqli_select_db($conn, $db['db_name']);
}
function initialize_tables($conn)
{
mysqli_query($conn, "CREATE TABLE IF NOT EXISTS images(\n id INT AUTO_INCREMENT PRIMARY KEY,\n title VARCHAR(50),\n path VARCHAR(200),\n description TEXT,\n category_id INT\n )");
mysqli_query($conn, "CREATE TABLE IF NOT EXISTS categories(\n id INT AUTO_INCREMENT PRIMARY KEY,\n category VARCHAR(50)\n )");
mysqli_query($conn, "CREATE TABLE IF NOT EXISTS hashtags(\n id INT AUTO_INCREMENT PRIMARY KEY,\n tag VARCHAR(50)\n )");
mysqli_query($conn, "CREATE TABLE IF NOT EXISTS i_d(\n image_id INT,\n tag_id INT\n )");
}
// $image= $_FILES['image'];
// echo $image['tmp_name'];
// echo '<br>';
function save_image($image)
{
$tmp_name = tempnam('public', 'img');
copy($image['tmp_name'], $tmp_name);
// echo $tmp_name;
// echo '<br>';
return $tmp_name;
}
