使用php / html表单从数据库获取值 [英] Getting Values from database with php/html form

问题描述

我希望这是发布此内容的正确位置....


我正在使用表单从数据库中提取信息。我正在尝试使用数组，但我只返回一条记录，它在我的表单上的两行中都是重复的。


代码是：


[PHP]<？php $ sql =" select * from admin其中Week =''1 英寸;

$ result = mysql_query（$ sql）;

$ num = mysql_numrows（$ result）;

$ i = 0;

while（$ i< $ num）

{$ pass [GameID] = mysql_result（$ result，$ i，" GameID"）;

$ pass [Week] = mysql_result（$ result，$ i，" Week"）;

$ pass [Favorite] = mysql_result（$ result，$ i，" Favorite"）;

$ pass [Underdog] = mysql_result（$ result，$ i，" Underdog"）;

$ pass [Spread] = mysql_result（$ result，$ i，" ; Spread"）;

$ pass [FavScore] = mysql_result（$ result，$ i，" FavScore"）;

$ pass [UndScore] = mysql_result（$结果，$ i，UndScore）;

$ pass [Time] = mysql_result（$ result，$ i，" Time"）;

$ i ++;

} mysql_close（）;

？> [/ PHP]


[HTML]

< form action =" admininsert.php" method =" POST">


< Select size =" 1"名称= QUOT;周" >< option value =" None" < ;? if（$ pass [$ Week] ==" None"）{echo" selected" ;; }>>周< /选项>

<选项<？ if（$ pass [Week] ==" 01"）{echo" selected" ;; }>> 01< / option>

< option<？ if（$ pass [Week] ==" 02"）{echo" selected" ;; }>> 02< / option>


<？php echo" $ pass [GameID]" ;; ？>


< select size =" 1" name =" Favorite []">< option value =" None"<？ if（$ pass [Favorite] ==" None"）{echo" selected" ;; }>>收藏< /选项>

<选项<？ if（$ pass [Favorite] ==" Atlanta"）{echo" selected" ;; }>>亚特兰大< /选项><选项<？ if（$ pass [Favorite] ==" Arizona"）{echo" selected" ;; }>>亚利桑那州< /选项>


< select size =" 1" name =" Underdog []">< option value =" None"<？ if（$ pass [Underdog] ==" None"）{echo" selected" ;; }>>失败者< /选项>

<选项<？ if（$ pass [Underdog] ==" Atlanta"）{echo" selected" ;; }>>亚特兰大< /选项>

<选项<？ if（$ pass [Underdog] ==" Arizona"）{echo" selected" ;; }>> Arizona< / option>


< input type =" Number"命名= QUOT;消息传播[]"大小= QUOT; 5英寸MAXLENGTH = QUOT; 4英寸值= QUOT;< ;? if（$ pass [Spread]！=""）{echo" $ pass [Spread]" ;; }？>" >


< input type =" Number"名称= QUOT; FavScore []"大小= QUOT; 5英寸MAXLENGTH = QUOT; 4英寸值= QUOT;< ;? if（$ pass [FavScore]！=""）{echo" $ pass [FavScore]" ;; }？>" >


< input type =" Number"名称= QUOT; UndScore []"大小= QUOT; 5英寸MAXLENGTH = QUOT; 4英寸值= QUOT;< ;? if（$ pass [UndScore]！=""）{echo" $ pass [UndScore]" ;; }？>" >


< input type =" Number"名称= QUOT;时间[] QUOT;大小= QUOT; 5英寸MAXLENGTH = QUOT; 8英寸值= QUOT;< ;? if（$ pass [Time]！=""）{echo" $ pass [Time]" ;; }？>" >

[/ HTML]


，html代码的第二部分重复...


我是在正确的轨道上，我错过了什么让它拉到每一行？


任何帮助都会很棒，


Patsman77

I hope this is the right spot to post this....

I am working on a form to pull the information from the database. I am trying to use arrays, but I only get one record to come back and it is duplicated in both rows on my form.

the code is:

[PHP]<?php $sql="select *from admin Where Week=''1''";
$result=mysql_query($sql);
$num=mysql_numrows($result);
$i=0;
while ($i < $num)
{$pass[GameID]=mysql_result($result,$i,"GameID");
$pass[Week]=mysql_result($result,$i,"Week");
$pass[Favorite]=mysql_result($result,$i,"Favorite");
$pass[Underdog]=mysql_result($result,$i,"Underdog");
$pass[Spread]=mysql_result($result,$i,"Spread");
$pass[FavScore]=mysql_result($result,$i,"FavScore");
$pass[UndScore]=mysql_result($result,$i,"UndScore");
$pass[Time]=mysql_result($result,$i,"Time");
$i++;
}mysql_close();
?>[/PHP]

[HTML]
<form action="admininsert.php" method="POST">

<Select size="1" name="Week" ><option value="None" <? if($pass[$Week]== "None"){ echo "selected"; } ?>>Week</option>
<option <? if($pass[Week]== "01" ) { echo "selected"; } ?>>01</option>
<option <? if($pass[Week]== "02" ) { echo "selected"; } ?>>02</option>

<li>
<?php echo"$pass[GameID]"; ?>

<select size="1" name="Favorite[]"><option value="None"<? if($pass[Favorite]== "None"){ echo "selected"; } ?>>Favorite</option>
<option <? if($pass[Favorite]== "Atlanta"){ echo "selected"; } ?>>Atlanta</option><option <? if($pass[Favorite]== "Arizona"){ echo "selected"; } ?>>Arizona</option>

<select size="1" name="Underdog[]"><option value="None"<? if($pass[Underdog]== "None"){ echo "selected"; } ?>>Underdog</option>
<option <? if($pass[Underdog]== "Atlanta"){ echo "selected"; } ?>>Atlanta</option>
<option <? if($pass[Underdog]== "Arizona"){ echo "selected"; } ?>>Arizona</option>

<input type="Number" name="Spread[]" size="5" MAXLENGTH="4" value="<? if($pass[Spread]!=""){ echo "$pass[Spread]"; } ?>" >

<input type="Number" name="FavScore[]" size="5" MAXLENGTH="4" value="<? if($pass[FavScore]!=""){ echo "$pass[FavScore]"; } ?>" >

<input type="Number" name="UndScore[]" size="5" MAXLENGTH="4" value="<? if($pass[UndScore]!=""){ echo "$pass[UndScore]"; } ?>" >

<input type="Number" name="Time[]" size="5" MAXLENGTH="8" value="<? if($pass[Time]!=""){ echo "$pass[Time]"; } ?>" >
[/HTML]

with the second part of the html code duplicated...

am i on right track, what am i missing to get it to pull each row?

Any help would be great,

Patsman77

推荐答案

sql =" select * from admin其中Week =''1''" ;;

sql="select *from admin Where Week=''1''";

result = mysql_query（

result=mysql_query(

sql）;

sql);

这篇关于使用php / html表单从数据库获取值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！