如何将一个简单的表单连接到我在蓝色主机中设置的mysql表。 [英] How do I connect a simple form to a mysql table I have set up in blue host.
问题描述
寻找一个简单的解决方案，将表单数据填充到bluehost中设置的mysql数据库表中。
谢谢。
我尝试过：
//将数据插入mysql的php代码输入文本中的数据库
if（isset（$ _ POST ['insert']））
{
$ hostname =localhost;
$ username =coleman;
$ password =Kkkholiday @ 33;
$ databaseName =test;
//获取输入文字和数字的值
$ id = $ _POST ['id'];
$ name = $ _POST ['name'];
$ vin = $ _POST ['vin'];
//使用mysqli连接到mysql数据库
$ connect = mysqli_connect（$ localhost，$ coleman，$ Kkkholiday @ 33，$ test）;
//要插入数据的mysql查询
$ b $我NSERT INTO`test`（`id`，`name`，`vin`）VALUES（[id]，[name]，[vin]）
$结果= mysqli_query（$ connect，$ query）;
//检查mysql查询是否成功
if （$结果）
{
echo'Data Inserted';
}
else {
echo'Data not Inserted';
}
mysqli_free_result（$ result）;
mysqli_close（$ connect）;
}
？>
<！DOCTYPE html>
< html>
< head>
< title> PHP INSERT DATA< / title>
< meta charset =UTF-8>
< meta name =viewportcontent =width = device-width，initial-scale = 1.0>
< / head>
< body>
< form action =php_insert_data_in_mysql_database.phpmethod =post>
< input type =textname =idrequired placeholder =id>
< input type =textname =namerequired placeholder =name>
< input type = textname =vinrequired placeholder =vin>
< input type =submitname =insert value =向数据库添加数据>
< / form>
< / body>
< / html>
Looking for a simple solution for populating form data into mysql database table set up in bluehost.
Thanks.
What I have tried:
// php code to Insert data into mysql database from input text
if(isset($_POST['insert']))
{
$hostname = "localhost";
$username = "coleman";
$password = "Kkkholiday@33";
$databaseName = "test";
// get values form input text and number
$id = $_POST['id'];
$name = $_POST['name'];
$vin = $_POST['vin'];
// connect to mysql database using mysqli
$connect = mysqli_connect($localhost, $coleman, $Kkkholiday@33, $test);
// mysql query to insert data
INSERT INTO `test`(`id`, `name`, `vin`) VALUES ([id],[name],[vin])
$result = mysqli_query($connect,$query);
// check if mysql query successful
if($result)
{
echo 'Data Inserted';
}
else{
echo 'Data Not Inserted';
}
mysqli_free_result($result);
mysqli_close($connect);
}
?>
<!DOCTYPE html>
<html>
<head>
<title> PHP INSERT DATA </title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<form action="php_insert_data_in_mysql_database.php" method="post">
<input type="text" name="id" required placeholder="id">
<input type="text" name="name" required placeholder="name">
<input type="text" name="vin" required placeholder="vin" >
<input type="submit" name="insert" value="Add Data To Database">
</form>
</body>
</html>
推荐答案
_ POST ['insert']））
{
_POST['insert']))
{
hostname =localhost;
hostname = "localhost";
username =coleman;
username = "coleman";
这篇关于如何将一个简单的表单连接到我在蓝色主机中设置的mysql表。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
