网页中有两个下拉菜单,从菜单中分别选择选项,按提交按钮,就会产生一个PDF 文档,文档里就是所query得到的数据, 请问这个怎么现实啊?
Form.php <form action=" " method="get" name="form2" >
<input name="township" type="text" class="textbox" size="8">
<input name="rng" type="text" class="textbox" size="8">
<input name="dir" type="text" class="textbox" size="8">
<input name="section" type="text" class="textbox" size="8">
<input type="submit" name="submit" value="Submit">
</form>Query 语句:
Query.php<?php
$map = array ('Township' => 'township', 'Rng1' => 'rng', 'Direction' => 'dir', 'Section' => 'section' );
$where = '';
$and = '';
foreach ( $map as $k =>$v ) { if(!empty($_GET[$v])) { $where .= $and . $k ."= '".$_GET [$v]."'";$and = ' and ';}}
$query =" SELECT Business_Owner,On_Site_Manager,On_Site_Phone,Business_Name,Mailing_Address,Phone_Number,Crop_Type,Crop_Location,Section,Township,Rng1,Direction,Quarter,Acreage,County,Date_Of_Entry,Contact FROM data_query ";
if (!empty($where )) {$query .= ' WHERE ' . $where . ' ORDER BY County, Township, Rng1';}
?>
怎么生成PDF file 呢?完全没有头绪!! 大家帮帮忙吧,先谢了。
Form.php <form action=" " method="get" name="form2" >
<input name="township" type="text" class="textbox" size="8">
<input name="rng" type="text" class="textbox" size="8">
<input name="dir" type="text" class="textbox" size="8">
<input name="section" type="text" class="textbox" size="8">
<input type="submit" name="submit" value="Submit">
</form>Query 语句:
Query.php<?php
$map = array ('Township' => 'township', 'Rng1' => 'rng', 'Direction' => 'dir', 'Section' => 'section' );
$where = '';
$and = '';
foreach ( $map as $k =>$v ) { if(!empty($_GET[$v])) { $where .= $and . $k ."= '".$_GET [$v]."'";$and = ' and ';}}
$query =" SELECT Business_Owner,On_Site_Manager,On_Site_Phone,Business_Name,Mailing_Address,Phone_Number,Crop_Type,Crop_Location,Section,Township,Rng1,Direction,Quarter,Acreage,County,Date_Of_Entry,Contact FROM data_query ";
if (!empty($where )) {$query .= ' WHERE ' . $where . ' ORDER BY County, Township, Rng1';}
?>
怎么生成PDF file 呢?完全没有头绪!! 大家帮帮忙吧,先谢了。
解决方案 »
- easyeclipse for php 总是出现光标消失问题
- php table中怎么实现select中的值保存 与读取?
- 初始化的值能传递吗,如果能,为什么数据库里没有,还是本来就写错了,求高手帮忙?
- PHP查询,结果怎样按时间分组显示?
- 仿照asp.net的Html 控件for php的,欢迎大家试用切磋
- 请教用phpmailer发html格式邮件的外部图片问题
- pear DB 提示Call to undefined function: query()
- 遇到text类型提交后字数超过2000就发不了的问题了,大家教我
- 谁知道比较通用的在线支付接口脚本编程?
- 类型为button的按钮,onclick后这样写为什么错了呢?
- 北京PHPer求职~2年半开发经验
- 我的群! 25229487 春哥PHP开发群
很好很强大
具体可以看API,里面现成的例子学一遍就基本上会了,有个生成表格的例子,官网要翻墙