PHP MySQLi Table Creation

How to Create Table using PHP MySQLi

PHP MySQLi Table Creation

Hi Guys In This Tutorial i will Show you How to Create a Table Using PHP MySQLi.
You are going to create table "test".
What You Will Need:
Database Name: tutorial
Table Name: test
Create a new file table.php in htdocs folder.

Codes for table.php

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

<?php $host = "localhost";//Host Name $username = "root"; //MySQL User name(root is Default) $password = "";  //MySQL Password(If Protected) $db_name="tutorial"; // Creating connection with Server passing host,username and password $conn = new mysqli($host, $username, $password,$db_name); // Checking connection if ($conn->connect_error) {     die("Sorry Failed to Connect: " . $conn->connect_error); }   // sql query to create table "test" $sql = "CREATE TABLE sfsdf(    id int(11) NOT NULL AUTO_INCREMENT,   name varchar(150) NOT NULL,   email varchar(150) NOT NULL,   PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;";   if ($conn->query($sql) === TRUE) {     echo "Your Table test successfully Created"; } else {     echo "Sorry Error creating table: " . $conn->error; }   $conn->close(); ?>

If you Like This article Please Like and Share With Your Friends.
Keep Visiting for More Codes.Thank you.