PHP - SPLessons

PHP Create Table

Chapter 33

SPLessons 5 Steps, 3 Clicks
5 Steps - 3 Clicks

PHP Create Table

PHP Create Table

shape Description

PHP Create Table requires following:

MySQL Create Table

shape Table

Initially, create a table with name “users2”, with five columns: “id”,”Username”, “Password”,”First”, “Last”.

CREATE TABLE users2 (
ID INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
Username varchar(20),
Password varchar(20),
First varchar(20),
Last varchar(20)
)

shape Examples

(MySQLi Object-oriented)

<!DOCTYPE html>
<html>
	<body>
		 <?php
			$HostName = "localhost"; 
			$UserName = "root"; 
			$Password = "password"; 
			$dbname="accounts"; 
					 
			// Create connection 
			$connection = new mysqli($HostName, $UserName, $Password, $dbname); 
					 
			// Check connection 
			if ($connection->connect_error) 
			{
				die("Connection failed: " . $connection->connect_error);
			} 
		 
			// sql to create table
			$sql = "CREATE TABLE users2 (
				ID INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
				Username varchar(20),
				Password varchar(20),
				First varchar(20),
				Last varchar(20)
				)";
		 
			if ($connection->query($sql) === TRUE) 
			{
				echo "Table users2 created successfully";
			} 
			else
			{
				echo "Error creating table: " . $connection->error;
			}
			$connection->close();

		?>
	</body>
</html>

The output in the phpmyadmin looks like below.

Example : (MySQLi Procedural)

<!DOCTYPE html>
<html>
	<body>
		 <?php 
			$HostName = "localhost"; 
			$UserName = "root"; 
			$Password = "password"; 
			$dbname="accounts"; 
			
			// Create connection 
			$connection = mysqli_connect($HostName, $UserName, $Password, $dbname); 
			
			// Check connection 
			if (!$connection) 
			{ 
			        die("Connection failed: " . mysqli_connect_error()); 
			} 
            // sql to create table
            $sql = "CREATE TABLE users2 (
				ID INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
				Username varchar(20),
				Password varchar(20),
				First varchar(20),
				Last varchar(20)
					)";

			if (mysqli_query($connection, $sql)) 
			{ 
				echo "Table Student created successfully"; 
			} 
			else 
			{ 
				echo "Error creating table: " . mysqli_error($connection);
			} 
			mysqli_close($connection); 
		?>
	</body>
</html>

Summary

shape Description

  • SQL commands are used to create table.
  • Table can be created with the command CREATE TABLE