Thursday, 18 April 2013

Create New Table using Mysql And PHP ???


Create table for admin registration having fields

id
username
password
fullname
emailid
mobileno

<?php

// Create connection
$con=mysqli_connect(@"localhost","root","","Database1") or die("Unable to connect to the database of Mysql name :  Database1");

//CREATE NEW TABLE
$sql="CREATE TABLE tbladmin(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
username VARCHAR(30),
password VARCHAR(30),
fullname VARCHAR(50),
emailid VARCHAR(50),
mobileno INT
)";

// Execute query
if (mysqli_query($con,$sql))
  {
  echo "Table tbladmin created successfully";
  }
else
  {
  echo "Error creating table: " . mysqli_error();
  }
?> 

No comments:

Post a Comment