html表单php连接mysql数据库_如何使用HTML表单和PHP创建mysql数据库

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 DataBase

Database 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(