how to create mysql database from sql query

Question

I need to create a database from MySQL query. I have used the following, but it is not working.

$sql2 = "CREATE DATABASE DATABAE_NAME";
$query2=mysqli_query($connect_dude,$sql2);

This query is not creating any database. Probably,I have to use database username and password, but I'm not quite sure how to apply or use database username, password and host in this case.

You are neither verifying whether mysqli_query() succeeds nor retrieving the error message if any. — Álvaro González
– Álvaro González, Commented Sep 25, 2014 at 16:46
@ÁlvaroG.Vicario I verified that and it's giving me failure msg — Salim Khan
– Salim Khan, Commented Sep 25, 2014 at 16:47
Make sure you're connected and that you have permissions to create a database. Check your PHPmyadmin's settings. — Funk Forty Niner
– Funk Forty Niner, Commented Sep 25, 2014 at 16:49
I'm connected for sure.But i don't know how to check the permission to create database.any clue? — Salim Khan
– Salim Khan, Commented Sep 25, 2014 at 16:51

Jay Blanchard · Accepted Answer · 2014-09-25 17:54:46Z

1

Here is a sample php code about connecting DB Hope this will help.

<?php

//mysqli query for connecting database  
//mysqli_connect('host','username','password')
$connection=mysqli_connect('localhost','root','');
if($connection)
{
    //saving query for creating database in a variable 
    $query="CREATE DATABASE student";

    //creating Database
    $newdb=mysqli_query($connection,$query);

    //testing whether database created or not 

    if($newdb)
    {
        //setting database name to connect for database operation
        $setDbName="student";

        //query for connecting database
        $connectionTesing=mysqli_select_db($connection,$setDbName);

        if($connectionTesing)
        {
            echo "Connected!";
        }
    }
}

?>

edited Sep 25, 2014 at 17:54

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

answered Sep 25, 2014 at 17:53

Md Rashedul Hoque Bhuiyan

10.7k5 gold badges33 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Salim Khan Over a year ago

I already fixed the problem.But I'm talking your one as the solution.Thanks

Collectives™ on Stack Overflow

how to create mysql database from sql query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related