将表单内容插入MySQL [英] Inserting Contents of a form into MySQL
问题描述
当我填写表格并提交时,表示已成功提交,但是当我查看我的MySQL数据库时,没有添加记录。我做错了什么。
这是我的插入PHP代码:
<?
$ name = $ _ POST [' name'];
$ time = date(' l jS \哪一个:我:A');
$ email = $ _ POST [' email'];
$ location = $ _ POST [' location'];
$ sex = $ _ POST [' sex'];
mysql_connect( quollcraft.net, quollcr1_forum, PASSWORD)或 die(mysql_error());
mysql_select_db( quollcr1_hub)或 die(mysql_error());
mysql_query( INSERT INTO`data` VALUES('$ Username','$ name','$电子邮件','$ location','$ sex'。'$ time'));
打印 您的信息已成功添加到数据库中。;
?>
这是我的表格:
< pre lang =xml> < 表格 action = process.php 方法 = 发布 >
关于:< 输入 type = text 姓名 = 名称 > < br >
位置:< input 类型 = text 名称 = < span class =code-keyword> email > < br >
兴趣:< 输入 type = text name = 位置 > < br >
性别:< input type = text name < span class =code-attribute> = sex > < br >
< 输入 类型 = 提交 value = 提交 >
< ; / form >
name =
_POST [' 名称跨度>];
time = date(' l jS \of FY h:i:s A');
When i fill out my form and submit it it says submitted successfully however when i look in my MySQL database there is not record added. What have i done wrong.
This is my inserting php code:
<?
$name=$_POST['name'];
$time = date('l jS \of F Y h:i:s A');
$email=$_POST['email'];
$location=$_POST['location'];
$sex=$_POST['sex'];
mysql_connect("quollcraft.net", "quollcr1_forum", "PASSWORD") or die(mysql_error());
mysql_select_db("quollcr1_hub") or die(mysql_error());
mysql_query("INSERT INTO `data` VALUES ('$Username', '$name', '$email', '$location', '$sex'. '$time')");
Print "Your information has been successfully added to the database.";
?>
This is my form:
<form action="process.php" method="post">
About: <input type="text" name="name"><br>
Location: <input type="text" name = "email"><br>
Interests: <input type="text" name = "location"><br>
Gender: <input type="text" name = "sex"><br>
<input type="submit" value="Submit">
</form>
name=
_POST['name'];
time = date('l jS \of F Y h:i:s A');
这篇关于将表单内容插入MySQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!