Create mysql database using php | Learning Curve- Perfect Tutorial for the beginers

mysql_query function to create mysql datbase

Syntax
—-

bool mysql_query($sqlqry,$connection);

Sqlqry- its a required field-Query to create database
$connection-connection string opened using mysql_Connect

Example

<?php
$databasehost = 'localhost';
$databasebuser = 'root';
$databasebpass = '';
$connection = mysql_connect($databasebhost, $databasebuser, $databasebpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
$sqlqry = 'CREATE Database mydoubts';
$output = mysql_query( $sqlqry, $conn );
if(! $output )
{
  die('Could not create database: ' . mysql_error());
}
echo "Database mydoubts created successfully\n";
mysql_close($connection);
?>

<?php

$databasehost = 'localhost';

$databasebuser = 'root';

$databasebpass = '';

$connection = mysql_connect($databasebhost, $databasebuser, $databasebpass);

if(! $conn )

{

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

}

echo 'Connected successfully';

$sqlqry = 'CREATE Database mydoubts';

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

if(! $output )

{

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

}

echo "Database mydoubts created successfully\n";

mysql_close($connection);