= - php 求助 ~~ 谢谢

蓝色海丶 2015-06-08 02:29:17 


<select name="rootid" id="rootid" onChange="changelocation(document.form1.rootid.options[document.form1.rootid.selectedIndex].value)"> 

<option value="" selected>- 请选择 -</option> 

<option value="HK Island East">HK Island East</option> 

<option value="2">Yuen Long</option> 

<option value="3">Central and Western</option> 

<option value="4">Kwun Tong</option> 

<option value="5">HK Island South</option> 

<option value="6">Yau Tsim Mong</option> 

<option value="7">Tsuen Wan</option> 

<option value="8">Sham Shui Po</option> 

<option value="9">Wan Chai</option> 

<option value="10">Kowloon City</option> 

<option value="11">Tai Po</option> 

<option value="12">NT North</option> 

<option value="13">Remote Island</option> 

<option value="14">Sai Kung</option> 

<option value="15">Shatin</option> 

<option value="16">Sham Shui Po</option> 

<option value="17">Tseung Kwan O</option> 

<option value="18">Kwai Tsing</option> 

<option value="19">Tuen Mun</option> 



</select></td> 







<?php

$conn=mysql_connect('localhost','root','');

mysql_select_db('project');

if (!$conn)

  {

  die('Could not connect: ' . mysql_error());

  }

mysql_select_db("project",$conn)or die(mysql_error());



mysql_query('set names UTF-8');

var_dump($_POST['rootid']);

$result = mysql_query("SELECT * FROM job where 'rootid'=$rootid");



while($row = mysql_fetch_array($result))

{





echo"<tr>";

echo"<th>" . $row['Job No'] . "</th>";

echo"<th>" . $row['Project Type'] . "</th>";

echo"<th>" . $row['District'] . "</th>";

echo"<th>" . $row['Title'] . "</th>";

echo"<th>" . $row['Google Map label'] . "</th>";



echo"</tr>";

}







 /*var_dump($_POST['rootid']);

var_dump($_POST['areaid']);

*/

mysql_close($conn);

?>

我这样打印不出来 ~~
这个下拉列表当前选择的值我取得后 如何将有关这个值的那一条数据全部打印出来 ，我用post提交 谢谢 ！！！
...全文
270 13 打赏 收藏 转发到动态 举报
写回复
用AI写文章
13 条回复
切换为时间正序
请发表友善的回复…
发表回复
彬莫 2015-06-26
  • 打赏
  • 举报
 回复 
<?php

$con = mysql_connect("localhost","root","");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }



mysql_select_db("project", $con);

mysql_query("set names 'utf8'");

$rootid=$_POST['rootid'];

//$rootid=1;

// echo $rootid;

$sql="SELECT * FROM job where District='$rootid' ";

$result = mysql_query($sql);

// echo $result;





while($row = mysql_fetch_array($result))

{



echo "<table border='1'>";

echo "<tr>";

echo "<th>" . $row['Job No'] . "</th>";

echo "<th>" . $row['Project Type'] . "</th>";

echo "<th>" . $row['District'] . "</th>";

echo "<th>" . $row['Title'] . "</th>";

echo "<th>" . $row['Google Map label'] . "</th>";

echo "</tr>";

echo "</table>";

}



mysql_close($con);

?>
打印正常-.-虽然还是不太清楚你的问题在哪 还有你想用表格显示的话 别忘啦<table>标签
蓝色海丶 2015-06-12
  • 打赏
  • 举报
 回复
引用 11 楼 fdipzone 的回复:
这样还有问题吗？ 

<?php
$conn=mysql_connect('localhost','root','');
mysql_select_db('project');
if (!$conn)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("project",$conn)or die(mysql_error());
  
mysql_query('set names UTF-8');
var_dump($_POST['rootid']);
$rootid = $_POST['rootid'];
$result = mysql_query("SELECT * FROM job where rootid='$rootid'");
  
while($row = mysql_fetch_array($result))
{
  
  
echo"<tr>";
echo"<th>" . $row['Job No'] . "</th>";
echo"<th>" . $row['Project Type'] . "</th>";
echo"<th>" . $row['District'] . "</th>";
echo"<th>" . $row['Title'] . "</th>";
echo"<th>" . $row['Google Map label'] . "</th>";
  
echo"</tr>";
}
  
  
  
 /*var_dump($_POST['rootid']);
var_dump($_POST['areaid']);
*/
mysql_close($conn);
?>
有问题呢 打印不出来 = - 我全部的源码加上数据库在7楼 ~ 求帮看 谢谢
傲雪星枫 2015-06-11
  • 打赏
  • 举报
 回复
这样还有问题吗？ 

<?php
$conn=mysql_connect('localhost','root','');
mysql_select_db('project');
if (!$conn)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("project",$conn)or die(mysql_error());
  
mysql_query('set names UTF-8');
var_dump($_POST['rootid']);
$rootid = $_POST['rootid'];
$result = mysql_query("SELECT * FROM job where rootid='$rootid'");
  
while($row = mysql_fetch_array($result))
{
  
  
echo"<tr>";
echo"<th>" . $row['Job No'] . "</th>";
echo"<th>" . $row['Project Type'] . "</th>";
echo"<th>" . $row['District'] . "</th>";
echo"<th>" . $row['Title'] . "</th>";
echo"<th>" . $row['Google Map label'] . "</th>";
  
echo"</tr>";
}
  
  
  
 /*var_dump($_POST['rootid']);
var_dump($_POST['areaid']);
*/
mysql_close($conn);
?>
青鬆下的坚躯 2015-06-11
  • 打赏
  • 举报
 回复
变量$rootid没用定义！ $rootid = $_POST['rootid'];
灬上海爽爷 2015-06-11
  • 打赏
  • 举报
 回复
而<option value="HK Island East">HK Island East</option> 这个是字符串呢？ HK Island East这个是字符串 自然就是字符串了
蓝色海丶 2015-06-11
  • 打赏
  • 举报
 回复
为什么其他value都是数字 而<option value="HK Island East">HK Island East</option> 这个是字符串呢？ 因为之前我打印出来是数字 我想的是根据 District来 打印出只要有这个字符的全部数据 ， 所以我就先改了select的第一个来试试 = - 我实在弄不出来 求助
蓝色海丶 2015-06-11
  • 打赏
  • 举报
 回复 


<form name="form1" method="post" action="post.php"><table border="0" align="center" cellpadding="2" cellspacing="1"> 

<tr> 

<td><div align="right">District：</div></td> 

<script language = "JavaScript"> 

var onecount; 

onecount=0; 

subcat = new Array(); 

//subcat[5] = new Array("abc","1","1"); 

// 5:类别ID abc:名称 1:类别 1:ID 



subcat[0] = new Array("Traffic Engineering","HK Island East","Traffic Engineering"); 



subcat[1] = new Array("Traffic Engineeering - GBP","HK Island East","Traffic Engineeering - GBP"); 



subcat[2] = new Array("TTA","HK Island East","TTA"); 



subcat[3] = new Array("Traffic Engineering","2","Traffic Engineering"); 



subcat[4] = new Array("Traffic Engineeering - GBP","2","Traffic Engineeering - GBP"); 



subcat[5] = new Array("TIA","2","TIA"); 



subcat[6] = new Array("Traffic Engineering","3","Traffic Engineering"); 



subcat[7] = new Array("Traffic Engineeering - GBP","3","Traffic Engineeering - GBP"); 



subcat[8] = new Array("TTA","3","TTA"); 



subcat[9] = new Array("Traffic Engineering","4","Traffic Engineering"); 



subcat[10] = new Array("Traffic Engineeering - GBP","4","Traffic Engineeering - GBP"); 



subcat[11] = new Array("Pedestrian Study","4","Pedestrian Study"); 



subcat[12] = new Array("Traffic Study","4","Traffic Study"); 



subcat[13] = new Array("TTA","4","TTA"); 



subcat[14] = new Array("TIA","4","TIA"); 



subcat[15] = new Array("TIA","HK Island East","TIA");

 

subcat[16] = new Array("TIA","2","TIA");



subcat[17] = new Array("Traffic Study","3","Traffic Study");



subcat[18] = new Array("TIA","3","TIA");



subcat[19] = new Array("Traffic Engineering","5","Traffic Engineering");



subcat[20] = new Array("Traffic Engineeering - GBP","5","Traffic Engineeering - GBP");



subcat[21] = new Array("Traffic Study","5","Traffic Study");



subcat[22] = new Array("TTA","5","TTA");



subcat[23] = new Array("TIA","5","TIA");



subcat[24] = new Array("Traffic Engineering","6","Traffic Engineering");



subcat[25] = new Array("Traffic Engineeering - GBP","6","Traffic Engineeering - GBP");



subcat[26] = new Array("Traffic Study","6","Traffic Study");



subcat[27] = new Array("Traffic Engine Lease","6","Traffic Engine Lease");



subcat[28] = new Array("TTA","6","TTA");



subcat[29] = new Array("TIA","6","TIA");



subcat[30] = new Array("Traffic Engineeering - GBP","7","Traffic Engineeering - GBP");



subcat[31] = new Array("Traffic Study","7","Traffic Study");



subcat[32] = new Array("TIA","7","TIA");



subcat[33] = new Array("Traffic Engineering","8","Traffic Engineering");



subcat[34] = new Array("Traffic Engineeering - GBP","8","Traffic Engineeering - GBP");



subcat[35] = new Array("Traffic Study","8","Traffic Study");



subcat[36] = new Array("TIA","8","TIA");



subcat[37] = new Array("Traffic Engineering","9","Traffic Engineering");



subcat[38] = new Array("Traffic Engineeering - GBP","9","Traffic Engineeering - GBP");



subcat[39] = new Array("Traffic Study","9","Traffic Study");



subcat[40] = new Array("TIA","9","TIA");



subcat[41] = new Array("Traffic Engineering","10","Traffic Engineering");



subcat[42] = new Array("Traffic Engineeering - GBP","10","Traffic Engineeering - GBP");



subcat[43] = new Array("Traffic Survey","10","Traffic Survey");



subcat[44] = new Array("TIA","10","TIA");



subcat[45] = new Array("Traffic Engineering","11","Traffic Engineering");



subcat[46] = new Array("Traffic Engineering","12","Traffic Engineering");



subcat[47] = new Array("Traffic Engineeering - GBP","12","Traffic Engineeering - GBP");



subcat[48] = new Array("TIA","12","TIA");



subcat[49] = new Array("Traffic Engineeering - GBP","13","Traffic Engineeering - GBP");



subcat[50] = new Array("Traffic Engineering","14","Traffic Engineering");



subcat[51] = new Array("Traffic Study","14","Traffic Study");



subcat[52] = new Array("TTA","14","TTA");



subcat[53] = new Array("Traffic Engineering","15","Traffic Engineering");



subcat[54] = new Array("Traffic Engineeering - GBP","15","Traffic Engineeering - GBP");



subcat[55] = new Array("Traffic Study","15","Traffic Study");



subcat[56] = new Array("TIA","15","TIA");



subcat[57] = new Array("Traffic Engineering","16","Traffic Engineering");



subcat[58] = new Array("Traffic Engineeering - GBP","16","Traffic Engineeering - GBP");



subcat[59] = new Array("Traffic Study","16","Traffic Study");



subcat[60] = new Array("TIA","16","TIA");



subcat[61] = new Array("Traffic Engineering","17","Traffic Engineering");



subcat[62] = new Array("Traffic Survey","17","Traffic Survey");

subcat[63] = new Array("TTA","17","TTA");



subcat[64] = new Array("TIA","17","TIA");



subcat[65] = new Array("Traffic Engineering","18","Traffic Engineering");



subcat[66] = new Array("Traffic Engineeering - GBP","18","Traffic Engineeering - GBP");



subcat[67] = new Array("Traffic Engine Lease","18","Traffic Engine Lease");

subcat[68] = new Array("Traffic Study","18","Traffic Study");



subcat[69] = new Array("TIA","18","TIA");



subcat[70] = new Array("Traffic Engineering","19","Traffic Engineering");



subcat[71] = new Array("TIA","19","TIA");







onecount=72; 



function changelocation(locationid) 

{ 

document.form1.areaid.options[0]=new Option("-请选择-",""); 

document.form1.areaid.length = 1; 



var locationid=locationid; 

var i; 

for (i=0;i < onecount; i++) 

{ 

if (subcat[i][1] == locationid) 

{ 

document.form1.areaid.options[document.form1.areaid.length] = new Option(subcat[i][0], subcat[i][2]); 

} 

} 



} 

</script> 

<td><select name="rootid" id="rootid" onChange="changelocation(document.form1.rootid.options[document.form1.rootid.selectedIndex].value)"> 

<option value="" selected>- 请选择 -</option> 

<option value="HK Island East">HK Island East</option> 

<option value="2">Yuen Long</option> 

<option value="3">Central and Western</option> 

<option value="4">Kwun Tong</option> 

<option value="5">HK Island South</option> 

<option value="6">Yau Tsim Mong</option> 

<option value="7">Tsuen Wan</option> 

<option value="8">Sham Shui Po</option> 

<option value="9">Wan Chai</option> 

<option value="10">Kowloon City</option> 

<option value="11">Tai Po</option> 

<option value="12">NT North</option> 

<option value="13">Remote Island</option> 

<option value="14">Sai Kung</option> 

<option value="15">Shatin</option> 

<option value="16">Sham Shui Po</option> 

<option value="17">Tseung Kwan O</option> 

<option value="18">Kwai Tsing</option> 

<option value="19">Tuen Mun</option> 



</select></td> 

<td> 



Type ：</td> 

<td><select name="areaid" id="areaid"> 

<option value="" selected>-- 请选择 --</option> 

</select></td> 

</tr> 

<tr> 

<td colspan="4"><div align="right"></div> 

<div align="right"> 

<input type="submit" name="Submit" value="提交"> 

</div></td> 

</tr> 

</table> 

</form></td>

	  </tr>

	</table>

    

    








<?php

$conn=mysql_connect('localhost','root','');



if (!$conn)

  {

  die('Could not connect: ' . mysql_error());

  }

mysql_select_db("project",$conn)or die(mysql_error());



mysql_query('set names UTF-8');

$rootid=$_POST['rootid'];

$result = mysql_query("SELECT * FROM job where District=$rootid ");



while($row = mysql_fetch_array($result))

{





echo"<tr>";

echo"<th>" . $row['Job No'] . "</th>";

echo"<th>" . $row['Project Type'] . "</th>";

echo"<th>" . $row['District'] . "</th>";

echo"<th>" . $row['Title'] . "</th>";

echo"<th>" . $row['Google Map label'] . "</th>";



echo"</tr>";

}







 /*var_dump($_POST['rootid']);

var_dump($_POST['areaid']);

*/

mysql_close($conn);

?>


数据表



= - 求助
傲雪星枫 2015-06-09
  • 打赏
  • 举报
 回复
为什么其他value都是数字
而<option value="HK Island East">HK Island East</option> 这个是字符串呢？

你的程序不完整，改成这样就可以提交了
html


<meta http-equiv="content-type" content="text/html;charset=utf-8">

<form name="form1" id="form1" method="post" action="server.php">

<select name="rootid" id="rootid" onChange="changelocation()"> 

<option value="" selected>- 请选择 -</option> 

<option value="HK Island East">HK Island East</option> 

<option value="2">Yuen Long</option> 

<option value="3">Central and Western</option> 

<option value="4">Kwun Tong</option> 

<option value="5">HK Island South</option> 

<option value="6">Yau Tsim Mong</option> 

<option value="7">Tsuen Wan</option> 

<option value="8">Sham Shui Po</option> 

<option value="9">Wan Chai</option> 

<option value="10">Kowloon City</option> 

<option value="11">Tai Po</option> 

<option value="12">NT North</option> 

<option value="13">Remote Island</option> 

<option value="14">Sai Kung</option> 

<option value="15">Shatin</option> 

<option value="16">Sham Shui Po</option> 

<option value="17">Tseung Kwan O</option> 

<option value="18">Kwai Tsing</option> 

<option value="19">Tuen Mun</option> 

</select>

<script type="text/javascript">

function changelocation(){

    document.getElementById('form1').submit();

}

</script>


server.php


<?php

$conn=mysql_connect('localhost','root','');

mysql_select_db('project');

if (!$conn)

  {

  die('Could not connect: ' . mysql_error());

  }

mysql_select_db("project",$conn)or die(mysql_error());

 

mysql_query('set names UTF-8');

var_dump($_POST['rootid']);

$rootid = $_POST['rootid'];

$result = mysql_query("SELECT * FROM job where rootid='$rootid'");

 

while($row = mysql_fetch_array($result))

{

 

 

echo"<tr>";

echo"<th>" . $row['Job No'] . "</th>";

echo"<th>" . $row['Project Type'] . "</th>";

echo"<th>" . $row['District'] . "</th>";

echo"<th>" . $row['Title'] . "</th>";

echo"<th>" . $row['Google Map label'] . "</th>";

 

echo"</tr>";

}

 

 

 

 /*var_dump($_POST['rootid']);

var_dump($_POST['areaid']);

*/

mysql_close($conn);

?>
一起混吧 2015-06-09
  • 打赏
  • 举报
 回复
代码也不全，changelocation()函数是如何写的？ 你的form提交成功了吗？ print_r($_POST); 贴出结果看看。
小菜鸟czh 2015-06-09
  • 打赏
  • 举报
 回复
$result = mysql_query("SELECT * FROM job where 'rootid'=$rootid");你这里的$rootid没有定义啊，你可以打印sql语句看看 是不是正确的
蓝色海丶 2015-06-09
  • 打赏
  • 举报
 回复
引用 1 楼 xuzuning 的回复:
'rootid' 包裹 rootid 的是单引号吗？ 那不变成了字符串了吗？一个字符串怎么和一个大于 0 的数相等呢？ 既然不会出现歧义，为何要转义呢？何况转义符还写错了。是 ` 不是 ' 是 Esc 键下面，1 键左边，Tab 键上面的那个
= - 我不会弄 求教
蓝色海丶 2015-06-08
  • 打赏
  • 举报
 回复
= - 我改了也打印不出来呢, 求教
xuzuning 2015-06-08
  • 打赏
  • 举报
 回复
'rootid' 包裹 rootid 的是单引号吗？ 那不变成了字符串了吗？一个字符串怎么和一个大于 0 的数相等呢？ 既然不会出现歧义，为何要转义呢？何况转义符还写错了。是 ` 不是 ' 是 Esc 键下面，1 键左边，Tab 键上面的那个
VB6.0封装EXCEL2010功能区菜单
大家好，2009年9月份... <button id="a1" 加解密组里第一个按钮a1，不能同名，如果有同名，则一个也不会显示，呵呵，这个使用我纠结了3个多小时，在论坛上求助过，在群里也求助过，呵呵，后面读到山菊花老师的一篇贴...
高性能高并发服务器架构大全
谢谢，村里面的兄弟们！ 183  方案探讨,关于工程中数据库的问题. 184  web软件设计时考虑你的性能解决方案 190  大型Java Web系统服务器选型问题探讨 193  高并发高流量网站架构 210 1.1 互联网的发展...
一个简单的java爬虫产品
　这个产品，做到现在，我遇到了这么几个情况，有和大家分享的，也有向大家请教，求助的。 　1.关于对应关系数据的保存方式 　在创建索引的时候，需要将网页的URL和网页的内容传到相应的方法中，当然URL和内容是要...
vs 2017 建立 php,程序在VS 2017中输出的结果为什么是这样的？求助大神！谢谢！...
求助大神！谢谢！菜鸟100学C发布于2018-09-29 08:06，1405 次点击#include int fun(int lim, int aa[]){int i, j = 0, k = 0;for (i = 2; i < lim; i++){for (j = 2; j < i; j++){if (i%j == ...
Linux系统C编程资料
1)Linux程序设计入门--基础...在这篇文章当中,我们将 会学到以下内容: 源程序编译 Makefile的编写 程序库的链接 程序的调试 头文件和系统求助 ----------------------------------------------------------------------
基础编程

21,886

社区成员

140,364

社区内容

发帖
与我相关
我的任务
社区描述
从PHP安装配置，PHP入门，PHP基础到PHP应用
社区管理员
  • 基础编程社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章