index.php

我的比赛作品 第22届全国青少年科技创新大赛3等奨 备注: 同时使用VC及Delphi开发

<?php
chdir('../');
require "global.php";

if ($_GET['cur_station'])
{
	setCookie('cur_station',$_GET['cur_station']);
	$_COOKIE['cur_station'] = $_GET['cur_station'];
}

$loadlist = "";
if ($_COOKIE['cur_station'])
{
	$query = mysql_query("SELECT roid FROM bus_route WHERE station = '$_COOKIE[cur_station]' GROUP BY roid");
	while ($rt = mysql_fetch_array($query))
	{
		if ($loadlist) $loadlist.=",";
		$loadlist.=$rt['roid'];
	}
}

$title = ' - ROAD';

$roadList = array();
$query = mysql_query("SELECT * FROM bus_road".($loadlist ? " WHERE roid IN ($loadlist)":""));
while ($rt = mysql_fetch_array($query))
{
	$roadList[] = $rt;
}

$areaList = array();
$query = mysql_query("SELECT area FROM bus_station GROUP BY area ORDER BY area");
while ($rt = mysql_fetch_array($query,MYSQL_ASSOC))
{
	$areaList[] = $rt['area'];
}

$areaArray = array();
$query = mysql_query("SELECT * FROM bus_station ORDER BY area");
while ($rt = mysql_fetch_array($query,MYSQL_ASSOC))
{
	$areaArray[$rt['area']][] = $rt;
}

$busRoute = array();
$query = mysql_query("SELECT b.*,s.* FROM bus_route b LEFT JOIN bus_station s USING(station) ORDER BY b.direction,b.sort,b.rid");
while ($rt = mysql_fetch_array($query))
{
	$busRoute[$rt['roid']][] = $rt;
}

include template('web_index');
?>