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