当我在表单中按提交时出现错误。 [英] I'm getting an error when I press the submit in my form.
本文介绍了当我在表单中按提交时出现错误。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在表单中按提交时出错。
I'm getting an error when I press the submit in my form.
<?php
// 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"><br><br>
<input type="text" name="name" required placeholder="name"><br><br>
<input type="text" name="vin" required placeholder="vin" ><br><br>
<input type="submit" name="insert" value="Add Data To Database">
</form>
</body>
</html>
我尝试了什么:
当我在表单中按提交时出现错误。
What I have tried:
I'm getting an error when I press the submit in my form.
<?php
// 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"><br><br>
<input type="text" name="name" required placeholder="name"><br><br>
<input type="text" name="vin" required placeholder="vin" ><br><br>
<input type="submit" name="insert" value="Add Data To Database">
</form>
</body>
</html>
推荐答案
_POST [' insert']))
{
_POST['insert'])) {
hostname = 本地主机跨度>;
hostname = "localhost";
用户名 = 科尔曼跨度>;
username = "coleman";
这篇关于当我在表单中按提交时出现错误。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文