PHP不会发布到数据库 [英] PHP won't post to database
问题描述
大家好，
我真的是新手，在webmonkey上找到了一个脚本。基本上我只想要
做的就是在我的数据库中添加记录。在我的数据库中，我有一个名为
research_main的表，其中已经创建了字段。
我试图提供一个脚本为我工作。它不是。它看起来像
虽然它有效，但我没有发布数据。我做错了什么？
如果你想让我在任何地方发表声明来检查一下，请告诉
我知道你要我把它放在哪里因为我真的没用这个。
你能告诉我这个剧本有什么问题。
:-(我在努力诚实
< html>
< body>
<？php
如果（$ submit）{
//流程表格
$ db = mysql_connect（" ; localhost"，" uname"，" password"）;
mysql_select_db（" dbtouse"，$ db）;
$ sql =" INSERT INTO research_main
（date_inv，info，medium_name，place_name，date_death，v erified_event，closed_event
）VALUES
（ ''$ date_inv''，''$ info''，''$ medium_name''，''$ place_name''，''$ date_death''，''$ verified_e
vent'' ，''closed_event''）" ;;
$ result = mysql_query（$ sql）;
echo"谢谢！输入信息。\ n" ;;
}否则{
//显示表格
？>
< form method =" post" action ="<？php echo $ PHP_SELF？>">
< p>事件日期：
<输入名称= QUOT; date_inv"类型= QUOT;文本" id =" date_inv">
< br>
需要研究的信息：
< textarea name = "信息" COLS = QUOT; 75"行= QUOT; 5英寸id =" info">< / textarea>
< br>
媒介或研究人员姓名::
< input name =" medium_name"类型= QUOT;文本" ID = QUOT; medium_name" maxlength =" 30"
< br>
地名：：
< input name =" ; PLACE_NAME"类型= QUOT;文本" ID = QUOT; PLACE_NAME" maxlength =" 50"
< br>
调查日期：
< input name =" date_death"类型= QUOT;文本" id =" date_death">
< br>
已验证事件：
< input name =" verified_event"类型= QUOT;无线电" value =" radiobutton">
是
< input name =" verified_event"类型= QUOT;无线电"值= QUOT;单选按钮"已检查>
否< br>
活动结束：
< input name =" closed_event"类型= QUOT;无线电" value =" radiobutton"
是
< input name =" closed_event"类型= QUOT;无线电"值= QUOT;单选按钮"已检查>
否< br>
< input type ="提交"命名= [提交" value ="输入信息"
< / p>
< / form>
<？php
} //结束如果
？>
< / body>
< / html>
Hi Guys,
I really am a novice and found a script on webmonkey. Basically all I want
to do is to add records to my database. In my database I have a table called
research_main with the fields already created.
I have tried to bodge a script to work for me. it doesn''t. It looks as
though it works but I get no data posted. What have I done wrong?
If you want me to put a statement in anywhere to check something please let
me know where you want me to put it as I really am useless with this.
can you tell me what is wrong with this script.
:-( I am trying honest
<html>
<body>
<?php
if ($submit) {
// process form
$db = mysql_connect("localhost", "uname", "password");
mysql_select_db("dbtouse",$db);
$sql = "INSERT INTO research_main
(date_inv,info,medium_name,place_name,date_death,v erified_event,closed_event
) VALUES
(''$date_inv'',''$info'',''$medium_name'',''$place_name'', ''$date_death'',''$verified_e
vent'',''$closed_event'')";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
} else{
// display form
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<p>Date Of Event:
<input name="date_inv" type="Text" id="date_inv">
<br>
Information to be researched:
<textarea name="info" cols="75" rows="5" id="info"></textarea>
<br>
Medium or Researchers name: :
<input name="medium_name" type="Text" id="medium_name" maxlength="30">
<br>
Place Name: :
<input name="place_name" type="Text" id="place_name" maxlength="50">
<br>
Date of Investigation:
<input name="date_death" type="text" id="date_death">
<br>
Verified Event:
<input name="verified_event" type="radio" value="radiobutton">
Yes
<input name="verified_event" type="radio" value="radiobutton" checked>
No<br>
Event Closed:
<input name="closed_event" type="radio" value="radiobutton">
Yes
<input name="closed_event" type="radio" value="radiobutton" checked>
No<br>
<input type="Submit" name="submit" value="Enter information">
</p>
</form>
<?php
} // end if
?>
</body>
</html>
推荐答案
submit）{
//流程表格
submit) {
// process form
db = mysql_connect（" localhost"，" uname"，" password"）;
mysql_select_db（" dbtouse"，
db = mysql_connect("localhost", "uname", "password");
mysql_select_db("dbtouse",
db）;
db);
这篇关于PHP不会发布到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
