如何使用HTML表单和PHP创建mysql数据库 [英] How to create mysql database using HTML form and PHP
问题描述
如何使用表单在mysql数据库中创建数据库?
这些是我的form.html和insert.php
我收到以下错误,我想我正在使用在create命令中创建数据库命令或传递错误格式的参数的错误方法。
请帮助我!
谢谢!>
我尝试过:
********* ***** form.html *******************
<!DOCTYPE html>
< ; html lang =en>
< head>
< meta charset =UTF-8>
< ; title>创建数据库< / title>
< / head>
< body>
< form action =insert。 phpmethod =post>
< label for =dbname>数据库名称:< / label>
< input type =textname =dbnameid =dbname>
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 *******************
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Create DataBase</title>
</head>
<body>
<form action="insert.php" method="post">
<label for="dbname">Database Name:</label>
<input type="text" name="dbname" id="dbname">
推荐答案
link = mysqli_connect(localhost,root,,demo);
//检查连接
if(
link = mysqli_connect("localhost", "root", "", "demo");
// Check connection
if(
link === false){
die(ERROR:无法连接。。mysqli_connect_error());
}
//逃脱用户安全性输入
link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Escape user inputs for security
database_name = mysqli_real_escape_string(
database_name = mysqli_real_escape_string(
这篇关于如何使用HTML表单和PHP创建mysql数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!