|
 |
| |
ใช้ $_GET แล้วเลือกเดือนใน listbox แล้วค่าที่ get มานั้นหายไป จะแก้ยังไงให้มันไม่หายครับ? |
| |
 |
|
|
 |
 |
|
ทำไงดีครับ?
สิ่งที่ get ครับ
Code
?station=15&year=2010&month=06&info=3
โค้ด
Code (PHP)
<?session_start();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<script language="JavaScript" src="../include_charts/FusionCharts.js"></script>
<?
$_SESSION["stat"] = $_GET["station"];
$_SESSION["info"] = $_GET["info"];
echo $state=$_SESSION["stat"];
?><BR><BR>
<?
echo $in_fo=$_SESSION["info"];
?>
<style type="text/css">
<!--
body {
background-image: url(../img/bg_info.png);
background-repeat: repeat;
}
-->
</style>
<?include "../conn.inc.php";
?>
<center><FORM METHOD="GET" ACTION="">
<select name="mmm" onChange="submit()">
<option value="" > -- เลือกเดือน -- </option>
<option value="1" <?if($_GET['mmm'] == "1") echo "selected";?>>มกราคม</option>
<option value="2" <?if($_GET['mmm'] == "2") echo "selected";?>>กุมภาพันธ์</option>
<option value="3" <?if($_GET['mmm'] == "3") echo "selected";?>>มีนาคม</option>
<option value="4" <?if($_GET['mmm'] == "4") echo "selected";?>>เมษายน</option>
<option value="5" <?if($_GET['mmm'] == "5") echo "selected";?>>พฤษภาคม</option>
<option value="6" <?if($_GET['mmm'] == "6") echo "selected";?>>มิถุนายน</option>
<option value="7" <?if($_GET['mmm'] == "7") echo "selected";?>>กรกฎาคม</option>
<option value="8" <?if($_GET['mmm'] == "8") echo "selected";?>>สิงหาคม</option>
<option value="9" <?if($_GET['mmm'] == "9") echo "selected";?>>กันยายน</option>
<option value="10" <?if($_GET['mmm'] == "10") echo "selected";?>>ตุลาคม</option>
<option value="11" <?if($_GET['mmm'] == "11") echo "selected";?>>พศจิกายน</option>
<option value="12" <?if($_GET['mmm'] == "12") echo "selected";?>>ธันวาคม</option>
</select>
<select name="yyy" onChange="submit()">
<?for($year_list=2010;$year_list<=date('Y');$year_list++){?>
<option value="<?=$year_list;?>" <?if($_GET['yyy'] == $year_list) echo "selected";?>><?=$year_list+543;?></option>
<?}?>
</select>
</FORM><BR></center>
<?
$sql_tomonths="SELECT
Max(`tb_rainning`.`date_rain`) as maxdate,
`tb_rainning`.`station`,
`tb_rainning`.`rain_value`,
`tb_station`.`id_station`,
`tb_station`.`name_station`,
`tb_station`.`subdistrict`,
`tb_station`.`info`
FROM
`tb_rainning`
Inner Join `tb_station` ON `tb_station`.`id_station` = `tb_rainning`.`station`
WHERE
`tb_rainning`.`station` = '$state'
GROUP BY
`tb_rainning`.`station`";
$query_tomonths=mysql_query($sql_tomonths);
$num_tomonths=mysql_num_rows($query_tomonths);
$rs_tomonths = mysql_fetch_array($query_tomonths);
$maxmonth = $rs_tomonths["maxdate"];
$name = $rs_tomonths["name_station"];
list( $year, $month, $dayy) = explode('-', $maxmonth);
$yy=$_GET["yyy"];
$mm=$_GET["mmm"];
if ($mm == ""){
$mm=$month;
$yy=$year;
}
$date_m=array ("มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
$y=$yy+543;
$m=$mm-1;
$w=date("w",strtotime($x));
$m_y=$date_m[$m].' '.$y;
$days = array(31, 30, 29, 28);
$months = $mm;
$years = $yy;
for($i=0; $i < count($days); $i++)
{
$day_check = $days[$i];
if(checkdate($months, $day_check, $years))
{
$last_date = "$day_check-$month-$year";
break;
}
}//echo $day_check;
?>
<title><?=$name.' เดือน'.$m_y;?></title>
<div id="chart_place" align="center">chart rain day</div>
<script type="text/javascript">
var myChart = new FusionCharts("../../Charts/Line.swf", "myChartId", "80%", "430", "0", "0");
myChart.setDataURL("../xml/place.xml" + "?uniq=" + new Date().getTime());
myChart.render("chart_place");
</script>
</head>
<?
if ($in_fo==3){
$sql_get_station="SELECT
`tb_districts`.`name_district`,
`tb_station`.`name_station`,
`tb_station`.`info`,
`tb_rainning`.`date_rain`,
`tb_rainning`.`rain_value`,
`tb_rainning`.`station`,
`tb_station`.`id_station`,
`tb_station`.`subdistrict`,
`tb_districts`.`id_district`
FROM
`tb_rainning`
Inner Join `tb_station` ON `tb_rainning`.`station` = `tb_station`.`id_station`
Inner Join `tb_districts` ON `tb_station`.`subdistrict` = `tb_districts`.`id_district`
WHERE
`tb_rainning`.`station` = '3' AND
year(tb_rainning.date_rain) = '".$yy."' AND
month(`tb_rainning`.`date_rain`) = '".$mm."'";
$query_get_station=mysql_query($sql_get_station);
$num_get_station=mysql_num_rows($query_get_station);
$mnt=$_GET["month"];
while($rs_get_station = mysql_fetch_array($query_get_station)){
$rainning=$rs_get_station["rain_value"];
$name=$rs_get_station["name_station"];
$g_date=$rs_get_station["date_rain"];
$district=$rs_get_station["name_district"];
$rains[]=$rainning;
}}else{
$sql_get_station="SELECT
`tb_rainning`.`date_rain`,
`tb_rainning`.`station`,
`tb_rainning`.`rain_value`,
`tb_station`.`id_station`,
`tb_station`.`name_station`,
`tb_station`.`subdistrict`,
`tb_subdistricts`.`id_subdistrict`,
`tb_subdistricts`.`district`,
`tb_subdistricts`.`name_subdistrict`,
`tb_districts`.`id_district`,
`tb_districts`.`name_district`
FROM
`tb_rainning`
Inner Join `tb_station` ON `tb_rainning`.`station` = `tb_station`.`id_station`
Inner Join `tb_subdistricts` ON `tb_station`.`subdistrict` = `tb_subdistricts`.`id_subdistrict`
Inner Join `tb_districts` ON `tb_subdistricts`.`district` = `tb_districts`.`id_district`
WHERE
`tb_rainning`.`station` = '3' AND
year(tb_rainning.date_rain) = '".$yy."' AND
month(`tb_rainning`.`date_rain`) = '".$mm."'";
$query_get_station=mysql_query($sql_get_station);
$num_get_station=mysql_num_rows($query_get_station);
$mnt=$_GET["month"];
while($rs_get_station = mysql_fetch_array($query_get_station)){
$rainning=$rs_get_station["rain_value"];
$name=$rs_get_station["name_station"];
$g_date=$rs_get_station["date_rain"];
$rains[]=$rainning;
}}
$file_place="place.xml";
$data_place.="<chart caption='ปริมาณน้ำฝนสะสม รายวัน' subcaption='$name $m_y' xAxisName='วันที่' yAxisName='Millimeter' showValues='1' decimals='1' showBorder='1' borderColor='336699' borderThickness='2' borderAlpha='50' bgColor='FFFFFF,BCD0ED' canvasBgColor='BCD0ED' baseFontSize='14' anchorBorderThickness='2' anchorRadius='4' anchorBorderColor='CC99FF' divLineIsDashed='1' numvdivlines='$day_check' divLineAlpha='20' >\n";
//$data_place.="<set /> \n";
//echo $gg_date[3];
for ($ddd=0;$ddd<$day_check;$ddd++){
$g=$ddd+1;
if ($rains[$ddd]=='0'){
$data_place.="<set label='$g' value='$rains[$ddd]' Color='C8A1D1' baseFontSize='10' toolText='วันที่ $g ไม่มีฝน' /> \n";
}else{
$data_place.="<set label='$g' value='$rains[$ddd]' Color='C8A1D1' baseFontSize='10' toolText='วันที่ $g ปริมาณน้ำฝน $rains[$ddd] มม.' /> \n";
}
}
//$data_place.="<set/> \n";
$data_place.="<styles>\n";
$data_place.="<definition>\n";
$data_place.="<style name='Anim1' type='animation' param='_xscale' start='0' duration='1' />\n";
$data_place.="<style name='Anim2' type='animation' param='_alpha' start='0' duration='1' /> \n";
$data_place.="<style name='DataShadow' type='Shadow' alpha='20' /> \n";
$data_place.="</definition>\n";
$data_place.="<application>\n";
$data_place.="<apply toObject='DIVLINES' styles='Anim1' /> \n";
$data_place.="<apply toObject='HGRID' styles='Anim2' /> \n";
$data_place.="<apply toObject='DATALABELS' styles='DataShadow,Anim2' />\n";
$data_place.="</application>\n";
$data_place.="</styles>\n";
$data_place.="</chart> \n";
$fp_place=fopen("../xml/".$file_place,'w');
fwrite($fp_place,$data_place);
fclose($fp_place);
?>
<body>
</body>
</html>
<?
mysql_close($Connect);
?>
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2010-07-01 11:12:12 |
By :
oasiis |
View :
1184 |
Reply :
9 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ตรง tag form action='?station=15&year=2010&month=06&info=3' ก็ให้ส่งซ้ำมาเหมือนเดิมครับ
ส่วนค่าก็แทนด้วยตัวแปรอะไรก็ว่าไป
|
| |
|
|
| |
| Date :
2010-07-01 11:19:30 |
By :
oxygenyoyo |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
คงต้องกำหนด action ครับ
Code (PHP)
action=xxx.php?station=<?php echo $_REQUEST[station]; ?>&year=
<?php echo $_REQUEST[year]; ?>&month=<?php echo $_REQUEST[mount]; ?>&info=
<?php echo $_REQUEST[info]; ?>&mmm=<?php echo $_REQUEST[mmm]; ?>
ประมาณนี้ครับ(โค้ดอาจจะไม่ถูกต้อง 100%)
|
| |
|
|
| |
| Date :
2010-07-01 11:20:14 |
By :
50121680 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ช่วยหน่อยครับมันไม่ได้อ่ะครับ
|
| |
|
|
| |
| Date :
2010-07-01 12:59:47 |
By :
oasiis |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
คุณลองสร้างไฟล์ตัวนึงมารับค่า
แล้วแก้ให้ action ไปที่ไฟล์นั้น
โดยไฟล์นั้น ให้ echo ค่าแต่ละค่าที่ get ได้มาดูว่ามีค่าไรที่ไม่ได้ อย่างไรบ้าง
้้เช่น
Code (PHP)
<FORM METHOD="POST" ACTION="xxx.php?station=15&year=2010&month=06&info=3">
</FORM>
xxx.php
Code (PHP)
<?php
echo $_REQUEST['mmm'];
echo $_REQUEST['yyy'];
echo $_REQUEST['station'];
echo $_REQUEST['year'];
echo $_REQUEST['month'];
echo $_REQUEST['info'];
?>
|
| |
|
|
| |
| Date :
2010-07-01 13:07:24 |
By :
50121680 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ค่ามันมาที่หลังอ่ะครับ
|
| |
|
|
| |
| Date :
2010-07-01 14:10:58 |
By :
oasiis |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ได้แล้วครับ ขอบคุณมากเลย
|
| |
|
|
| |
| Date :
2010-07-01 15:12:07 |
By :
oasiis |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 05
|
Quote:
