tutorials for mysql/phpLearning Curve- Perfect Tutorial for the beginers | Learning Curve- Perfect Tutorial for the beginers

Creating database table using php

use sql query to create tables in the particulardatabase using mysql_query() function See the below example

<?php
$databasehost = 'localhost';
$databaseuser = 'root';
$databasepassword = '';
$connection = mysql_connect($databasehost, $databaseuser, $databasepassword);
if(! $connection )
{
  die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
$sqlqry = 'CREATE TABLE mydoubts_data( '.
       'id INT NOT NULL AUTO_INCREMENT, '.
       'name VARCHAR(20) NOT NULL, '.
        'primary key (id ))';

mysql_select_db('mydoubts');
$output = mysql_query( $sqlqry, $connection);
if(! $output)
{
  die('Could not create table: ' . mysql_error());
}
echo "Table employee created successfully\n";
mysql_close($connection);
?>

<?php

$databasehost = 'localhost';

$databaseuser = 'root';

$databasepassword = '';

$connection = mysql_connect($databasehost, $databaseuser, $databasepassword);

if(! $connection )

{

die('Could not connect: ' . mysql_error());

}

echo 'Connected successfully';

$sqlqry = 'CREATE TABLE mydoubts_data( '.

'id INT NOT NULL AUTO_INCREMENT, '.

'name VARCHAR(20) NOT NULL, '.

'primary key (id ))';

mysql_select_db('mydoubts');

$output = mysql_query( $sqlqry, $connection);

if(! $output)

{

die('Could not create table: ' . mysql_error());

}

echo "Table employee created successfully\n";

mysql_close($connection);

or you can use the phpmyadmin to create table in the particular database.