1 Star2 Stars3 Stars4 Stars5 Stars (4 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.

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

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.