How can we create a database using PHP and MySQL?

Marc0 · Mar 11, 2013

Hi All

I am

How can we create a database using PHP and MySQL?

Only expert ...

Thanks

HostPace · Jun 28, 2016

If you're having a cPanel. You can easily create a Database in PHP using MySQL/phpMyAdmin from the panel.

harrygreen90 · Jun 28, 2016

HostPace said:
If you're having a cPanel. You can easily create a Database in PHP using MySQL/phpMyAdmin from the panel.

Maybe the OP asked about how create a database using PHP and MySQL, not create a database in cPanel

Mark Levin said:
Hi All

I am How can we create a database using PHP and MySQL?

Only expert ...

Thanks

I do a research and here's codes you can use to create a database using php.

Code:

<?php
   $dbhost = 'localhost:3036';
   $dbuser = 'root';
   $dbpass = 'rootpassword';
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);
   
   if(! $conn ) {
      die('Could not connect: ' . mysql_error());
   }
   
   echo 'Connected successfully';
   
   $sql = 'CREATE Database test_db';
   $retval = mysql_query( $sql, $conn );
   
   if(! $retval ) {
      die('Could not create database: ' . mysql_error());
   }
   
   echo "Database test_db created successfully\n";
   mysql_close($conn);
?>

Hope it helps!

machinedock · Aug 19, 2016

mysql is outdated and not recomment to create database, you can use PDO or mysqli instead of mysql.
The codes for mysqli is

PHP:

<?php
$link=mysqli_connect("localhost","Username","password","dbname");
if(!$link)
{
     die('Could not connect: ' . mysqli_error($link));
}
else
{
if(myqli_query($link,"CREATE DATABASE database_name"))
{
echo "Success";
}
mysqli_close($link);
}

?>

How can we create a database using PHP and MySQL?

Marc0

Well-known member

HostPace

Active member

harrygreen90

Active member

machinedock

New member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud