1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 5.00 out of 5)

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.

Tip: Click on images to make them larger. If you find anything wrong on this page or need further assistance please comment below or contact me. 🙂

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.

Subscribe To My YouTube Channel:
// 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(
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;

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


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
Create A Database and Table At The Same Time With PHP was last modified: June 8th, 2017 by Maximus Mccullough

Please like, share and subscribe.

Advanced Programming Made Easy

I hope you enjoyed the article. If I was able to help you please consider a tip for the content.

One Time Tip

more tips

Reoccuring Tips


Cool People Share:
Create A Database and Table At The Same Time With PHP

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.