Create Database

create_db.php

<?php
require_once 'db_info.inc';

$db = new mysqli( $servername, $username, $password );
if ( $db->connect_error ) die( 'Connection Error: ' . $db->connect_error );

$result = $db->query( "CREATE DATABASE IF NOT EXISTS $database" );
if ( $db->error ) die( 'Query Error: ' . $db->error );
else echo 'Database creation successful.';

create_table.php

<?php
require_once 'db_connect.inc';

$result = $db->query( '' );
if ( $db->error ) die( 'Query Error: ' . $db->error );
else echo 'Table creation successful.';

db_connect.inc

<?php
require_once 'db_info.inc';

$db = new mysqli( $servername, $username, $password, $database );
if ( $db->connect_error ) die( 'Connection Error: ' . $db->connect_error );

db_info.inc

<?php
$servername = 'localhost';
$username = 'root';
$password = '';
$database = '';

• Move this to miscellaneous.php.
• Improve readability by adding curly brackets.