Re: [請益] 表單處理問題

看板PHP作者rm031023 (土撥鼠)時間14年前 (2012/01/09 18:45)推噓0(0推 0噓 26→)

留言26則, 5人參與討論串5/5 (看更多)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "" rel="nofollow">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="" rel="nofollow">http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=big5" /> <title>無標題文件</title> </head> <body> <form id="form1" name="form1" method="post" action="search2-3-2"> <br> piletype <select name="piletype"> <option value=""></option> <option value="Drilled Shaft">Drilled Shaft</option> <option value="Driven pile">Driven pile</option> </select> <br> <br> soiltype <select name="soiltype" > <option value=""></option> <option value="Drained">Drained</option> <option value="Undrained">Undrained</option> </select> </select> <br> <br> LoadingType<select name="LoadingType" > <option value=""></option> <option value="Compression">Compression</option> <option value="Uplift">Uplift</option> </select> <br> <br> capacity method<p> <p> <select name="select" > <option value=""></option> <option value="L1">L1</option> <option value="0.2%B">0.2%B</option> <option value="0.25%B">0.25%B</option> <option value="0.3%B">0.3%B</option> <option value="0.4%B">0.4%B</option> <option value="0.5in">0.5in</option> <option value="L2">L2</option> <option value="4%B">4%B</option> <option value="STC">STC</option> <option value="Fuller and Hoy">Fuller and Hoy</option> <option value="Terzaghi and Peck">Terzaghi and Peck</option> <option value="DeBeer">DeBeer</option> <option value="van der Veen">van der Veen</option> <option value="Chin">Chin</option> </select> <p> capacity< <input name="input" type="text" size="10" /> kN<p> <br> <br> <input type="submit" value="送出" /> </label> </form> <?php $host="localhost"; $user="root"; $pass="0000"; $database="drilled shaft database"; $select=$_POST["select"]; $input=$_POST["input"]; $piletype=$_POST["piletype"]; $LoadingType=$_POST["LoadingType"]; $soiltype=$_POST["soiltype"]; if($piletype!="" || $LoadingType!="" || $soiltype!="" || $input="" || $select="" ) { $link=mysql_connect($host,$user,$pass); if($link!=False) { $qstring="Select* From shaft Inner Join site ON site.idSite = shaft.site_idSite Inner Join soil ON site.idSite = soil.site_idSite Inner Join soil_has_shaft ON soil.idSoil = soil_has_shaft.soil_idSoil AND shaft.idShaft = soil_has_shaft.shaft_idShaft Inner Join desparameter ON shaft.idShaft = desparameter.shaft_idShaft Inner Join capacity ON capacity.shaft_idShaft = shaft.idShaft where shaft.`piletype`='$piletype' AND shaft.`LoadingType`='$LoadingType' AND soil.`soiltype`='$soiltype' AND capacity.`$select` < '$input' ORDER BY shaft.`Depth, D (m)` ASC "; $result=mysql_db_query($database,$qstring,$link); $rows=mysql_num_rows($result); if($rows>=0) { for($x=0;$x<=$rows-1;$x++) { $arrdata[$x]=mysql_fetch_field($result); } } echo"查詢結果:<br>"; echo"<table border=1>"; echo"<tr><td>Depth, D (m)</td>"; echo"<td>Dia, B (m)</td>"; echo"<td>Friction Angle-TC</td>"; echo"<td>Su(CIUC) (kN/m<sup>2</sup>)</td>"; echo"<td>alpha(CIUC)</td>"; echo"<td>Measured Beta</td>"; echo"<td>k/ko</td>"; echo"<td>$select (kN)</td></tr>"; while($arrdata[$x]=mysql_fetch_array($result)){ echo"<tr><td><div align=right>".$arrdata[$x]['Depth, D (m)']."</div></td>"; echo"<td><div align=right>".$arrdata[$x]['Dia, B (m)']."</div></td>"; echo"<td><div align=right>".$arrdata[$x]['Friction Angle-TC']."</div></td>"; echo"<td><div align=right>".$arrdata[$x]['Su(CIUC)']."</div></td>"; echo"<td><div align=right>".$arrdata[$x]['alpha(CIUC)']."</div></td>"; echo"<td><div align=right>".$arrdata[$x]['Measured Beta']."</div></td>"; echo"<td><div align=right>".$arrdata[$x]['k/ko']."</div></td>"; echo"<td><div align=right>".$arrdata[$x]['$select']."</div></td></tr>"; } echo"</table>"; } } 其他欄位值都抓得到結果，就只有capacity的抓不到 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 140.135.120.167

→

kerash

01/09 20:55, , 1^F

01/09 20:55, 1^F

→

kerash

01/09 20:55, , 2^F

01/09 20:55, 2^F

→

kerash

01/09 20:57, , 3^F

01/09 20:57, 3^F

→

MOONRAKER

01/09 22:57, , 4^F

01/09 22:57, 4^F

→