Error creating a Mysqli database via PHP on Wampserver

Question

I’m having trouble creating the database, on the net I found little content on, I only find how to build database by phpMyAdmin, but it is via script that I want to create.

I have the following code:

<?php

$mysqli = new mysqli("localhost","root","");

if($mysqli-> connect_error){
    echo "Não foi possível conectar.";
}

$create_db = "CREATE DATABASE 'my_db'";

if($mysqli->query($create_db)){
    echo "conexão bem sucedida";
}
else{
    echo "falha na conexão";
}

?>

Wampserver does not point out syntax errors. I always have the answer "connection failure", which is wrong?

Answer 1

Well, hitting the eye I saw some problems in your query.

1. No need to put the name of the bank in simple quotes.
2. If the database already exists, it will return an error as expected. You need to give a DROP otherwise it will not be possible to create it (don’t do this in production) or add IF NOT EXISTS in your query to avoid an error if the database is already created.

I changed your code by placing complete error messages when running the script.

<?php

// MySQLi usando try catch
mysqli_report(MYSQLI_REPORT_STRICT); 

try 
{
    $mysqli = new mysqli("localhost","root","");

    $mysqli->query("CREATE DATABASE IF NOT EXISTS my_db;");

    echo "Database criada com sucesso!";
} 
catch (Exception $e) 
{
    echo "Alguma coisa de errada aconteceu. Detalhes: " . $e->message;
}

Answer 2

I created this and it worked. If you do the same and it doesn’t work, you have some problem with your installation or Mysql configuration. Just viewing the error provided by Mysql to be sure. But possibly this way not even happen the error. There is possibility of just being a syntax problem, I did not use the apostrophe in the name in the database.

<?php

$mysqli = new mysqli("localhost","root","uma_senha_aqui");

if($mysqli-> connect_error){
    echo "Não foi possível conectar.";
}

$create_db = "CREATE DATABASE IF NOT EXISTS my_db";

if($mysqli->query($create_db)){
    echo "criação ok";
}
else{
    echo "falha na criação:" . $mysqli->error;
}

?>

I put in the Github for future reference.

I had the $mysqli->error to get information to work. When you just have write that failed, you don’t know why it failed and it gets harder to solve any problem.

Answer 3

Just take out the simple quotes that will work normally, your code is coreto, with the exception of these quotes.