Oldalak

Wednesday, October 19, 2016

How to create DB in MySQL with PhP







 <?php

$db_username="root"; /*Username in localhost is ROOT*/
$db_password="";  /*DataBasa Password*/
$db_hoster="localhost"; /*Just in the LocalHost */



   $conn = mysql_connect($db_hoster, $db_username, $db_password);
   if(! $conn )
   {
     die('DataBasa error: ' . mysql_error());
   }
 
 
 
   // Create database
   $databasa_name="MyFirstDB";
 
    $sql = "CREATE DATABASE $databasa_name";
    if (mysql_query($sql, $conn)) {
    echo "Database created successfully";
    } else {
    echo "Error creating database: " . mysqli_error($conn);
    }

 
 
    mysql_close($conn);


?>




No comments:

Post a Comment