Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

PHP MySQL Create Database


Since PHP 4.3, mysql_create_db() function is deprecated. Now it is recommended to use one of the 2 alternatives.

  • mysqli_query()
  • PDO::__query()

PHP MySQLi Create Database Example

Example

  1. <?php
  2. $host = ‘localhost:3306’;
  3. $user = ;
  4. $pass = ;
  5. $conn = mysqli_connect($host$user$pass);
  6. if(! $conn )
  7. {
  8.   die(‘Could not connect: ‘ . mysqli_connect_error());
  9. }
  10. echo ‘Connected successfully<br/>’;
  11. $sql = ‘CREATE Database mydb’;
  12. if(mysqli_query( $conn,$sql)){
  13.   echo “Database mydb created successfully.”;
  14. }else{
  15. echo “Sorry, database creation failed “.mysqli_error($conn);
  16. }
  17. mysqli_close($conn);
  18. ?>

Output:

Connected successfully
Database mydb created successfully.

Comments

comments