Create A Database and Table At The Same Time With PHP

Create a database and a table at the same time with php in mysql. All you will need is the connection information to your database. This is what you will need.

Preliminary Information Needed

Connection to the host. For most of you this will be localhost.
Mysql username.
Mysql password.

Applies To

PHP5 +
Mysql

You can use phpmyadmin for visual confirmation. However the use of phpmyadmin is not required for this tutorial.

Scripts for PHP lesson.

Create a file and call it createdatabase.php or download it here. Enter the following code in if you are not downloading it.

<?php
include_once('db.php');
// Create connection
$con= new mysqli($localhost, $dbusername, $dbpass);
// Check connection
if ($con->connect_error) {
die("Connection failed: " . $con->connect_error);
}

// Create database
$sql = "CREATE DATABASE $dbname";
if ($con->query($sql) === TRUE) {
echo "Database created successfully";
} else {
echo "Error creating database: " . $con->error;
}

$con = mysqli_connect("$localhost","$dbusername","$dbpass","$dbname");

// sql to create table
$sql = "CREATE TABLE users(
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(250) NOT NULL,
email VARCHAR(250) NOT NULL,
password VARCHAR(250) NOT NULL,
reg_date TIMESTAMP
)";
if ($con->query($sql) === TRUE) {
echo "Table users created successfully";
} else {
echo "Error creating table: " . $con->error;
}
$con->close();
?>

Create another file and call it db.php. Enter the following code into it. Be sure to change it to your password.

<?php
$localhost='localhost';
$dbusername='root';
$dbpass='yourpassword';
$dbname='members';
?>

Final Steps for Database and Table creation in PHP

Load the createdatabase.php in your browser. If all of your connection information is correct it will create a table called "members" in you database. In the members table you will now have the following.

id
username
password
reg_date