how to create database in mysql database using form?
these are my form.html and insert.php
I am getting following error, I think I am using wrong way to create database command or passing wrong format of argument in create command.
Please help me !
Thank you !
What I have tried:
************** form.html *******************
Create DataBaseDatabase Name:
********************* insert.php ***********************
$link = mysqli_connect("localhost", "root", "", "demo");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Escape user inputs for security
$database_name = mysqli_real_escape_string($link, $_POST['dbname']);
// attempt create query execution
$sql = "create database ('$database_name')";
if(mysqli_query($link, $sql)){
echo "Database created successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// close connection
mysqli_close($link);
?>
解决方案link = mysqli_connect("localhost", "root", "", "demo");
// Check connection
if(
link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Escape user inputs for security
database_name = mysqli_real_escape_string(