♫ HOW TO CREATE DATABASE & TABLE WITH PHP:

Create db with this:



<?php

$dbname="databasename";

//connect to server

$link=mysql_connect("localhost","root","");

if(!$link)

{

die(mysql_error());

}

//create database

$sql="CREATE DATABASE $dbname";

if(mysql_query($sql,$link))

{

echo "database created successfully";

}

else {

echo mysql_error();

}

//select database where we want to create table

mysql_select_db($dbname);

//create table

$tbname="tablename";

$sql="CREATE TABLE $tbname (

username varchar(55) not null,

password varchar(55) not null,

primary key (username)

)";

mysql_query($sql) or die(mysql_error());

mysql_close($link);

?>