脚本宝典收集整理的这篇文章主要介绍了php – 显示从下拉列表中恢复的数据,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
这是我的3下拉列表
require "config.PHP"; //Database connection $resource_selections = MysqL_query("SELECT DISTINCT selection_id From selections ORDER BY selection_id ASC"); $selections = array(); while($row = MysqL_fetch_row($resource_selections)){ $selections[] = $row[0]; } $resource_fixtures = MysqL_query("SELECT DISTINCT fixture_id From selections ORDER BY selection_id ASC"); $fixtures = array(); while($row = MysqL_fetch_row($resource_fixtures)){ $fixtures[] = $row[0]; } $resource_names = MysqL_query("SELECT DISTINCT name FROM selections ORDER BY selection_id ASC"); $names = array(); while($row = MysqL_fetch_row($resource_names)){ $names[] = $row[0]; } if(count($selections) <= 0 || count($fixtures) <= 0 || count($names) <= 0){ echo 'No results have been found.'; } else { // Display form echo '<form name="form" method="post" action="selection.PHP">'; //SelectionID dropdown: echo "<select name='selection_id' id='selections' >"; foreach($selections as $selection) echo "<option id='$selection'>$selection</option>"; echo '</select>'; //FixtureiD dropdown echo "<select name='fixture_id' id='fixtures' >"; foreach($fixtures as $fixture) echo "<option id='$fixture'>$fixture</option>"; echo '</select>'; //Name dropdown echo "<select name='name' id='names' >"; foreach($names as $name) echo "<option id='$name'>$name</option>"; echo '</select>'; echo "<input tyPE='submIT' name='submit' value='Submit' />"; echo '</form>'; } ?>
<script type="text/javascript"> function mergeval(val,flag) { if(flag==1) document.getElementById('mvalue1').innerHTML = val ; else if(flag==2) document.getElementById('mvalue2').innerHTML = val; else if(flag==3) document.getElementById('mvalue3').innerHTML = val; } </script> <?PHP session_start(); $_SESSION['values']=!empty($_SESSION['values']) ? $_SESSION['values']:array(); if(!empty($_REQUEST['selection_id'])&&!empty($_REQUEST['fixture_id'])&&!empty($_REQUEST['name'])) { $_SESSION['values'][] = array('id'=>$_REQUEST['selection_id'],'fid'=>$_REQUEST['fixture_id'],'name'=>$_REQUEST['name']); } $dispval ="<table>"; foreach(@$_SESSION['values'] as $key=>$val) { $dispval .="<tr><td>".$val['id']." ".$val['fid']." ".$val['name']."</td></tr>"; } $dispval .="</table>"; echo $dispval; ?> <?PHP require "config.PHP"; //Database connection $resource_selections = MysqL_query("SELECT DISTINCT selection_id FROM selections ORDER BY selection_id ASC"); $selections = array(); while($row = MysqL_fetch_row($resource_selections)){ $selections[] = $row[0]; } $resource_fixtures = MysqL_query("SELECT DISTINCT fixture_id FROM selections ORDER BY selection_id ASC"); $fixtures = array(); while($row = MysqL_fetch_row($resource_fixtures)){ $fixtures[] = $row[0]; } $resource_names = MysqL_query("SELECT DISTINCT name FROM selections ORDER BY selection_id ASC"); $names = array(); while($row = MysqL_fetch_row($resource_names)){ $names[] = $row[0]; } if(count($selections) <= 0 || count($fixtures) <= 0 || count($names) <= 0){ echo 'No results have been found.'; } else { // Display form echo '<form name="form" method="post" action="selection.PHP">'; //SelectionID dropdown: echo "<select name='selection_id' id='selections' onchange='javascript:mergeval(this.value,1)'>"; foreach($selections as $selection) echo "<option id='$selection'>$selection</option>"; echo '</select>'; //FixtureID dropdown echo "<select name='fixture_id' id='fixtures' onchange='javascript:mergeval(this.value,2)' >"; foreach($fixtures as $fixture) echo "<option id='$fixture'>$fixture</option>"; echo '</select>'; //Name dropdown echo "<select name='name' id='names' onchange='javascript:mergeval(this.value,3)'>"; foreach($names as $name) echo "<option id='$name'>$name</option>"; echo '</select>'; echo "<input type='submit' name='submit' value='Submit' />"; echo '</form>'; } ?> <table> <tr><td > <span id="mvalue1"></span> <span id="mvalue2"></span> <span id="mvalue3"></span></td></tr> </table>
以上是脚本宝典为你收集整理的php – 显示从下拉列表中恢复的数据全部内容,希望文章能够帮你解决php – 显示从下拉列表中恢复的数据所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。