= - php 求助 ~~ 谢谢

2015-06-08 02:29:17 326 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

PHP导出图表 ~~ phpspreadsheet 利用phpspreadsheet导出Excel图表 PHP所需要的的扩展就不再说了,需要的可以看看PHPExcel导出测试环境：PHP 7.1 这里介绍***折线图、饼状图、柱状图***,更多的可以参考扩展里的测试案例。以下代码只支持单个sheet的图表导出，多个图表导出以后再写吧。引用代码 use PhpOffice\PhpSpreadsheet\Writer\Xlsx; use PhpO... 阅读详情



<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提交谢谢！！！

...全文

PHP导出图表 ~~ PHPExcel 利用PHPExcel和PhpSpreadsheet导出Excel图表PHPExcel导出Excel图表示例代码： PHPExcel导出Excel图表这里主要介绍饼状图。示例代码： use PHPExcel; //折线图 public function chart1() { $objPHPExcel=new PHPExcel();//实例化PHPExcel类，... 阅读详情

蓝色海丶

基础编程 21,889 成员 140,329 内容

+ 关注 + 加入社区

切换为时间正序

彬莫 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 键上面的那个

= - php 求助 ~~ 谢谢

相关推荐