roaddown.php

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

<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<?php
set_time_limit(0);
$link = mysql_connect("localhost",'root','');
mysql_select_db('bus');

$q = mysql_query("SELECT * FROM bus_road");
while ($qqq1=mysql_fetch_array($q))
{
echo "Start Road: ".$qqq1['road']."<BR><br>\n";
$content = "";
$line = $qqq1['road'];
//$roid = mysql_result(mysql_query("SELECT roid FROM bus_road WHERE road='$line'"),0);
$roid=$qqq1['roid'];
$fp = fopen("http://www.transmac.com.mo/query_busroute.php?action=query_by_busno&busIndex=$line","rb");
//$fp = fopen("busroad.htm","rb");
if ($fp)
{
	while (!feof($fp))
	{
		$content.=fread($fp,1024);
	}
	fclose($fp);
	
	$st = strpos($content,"<tr><td colspan='4'><font color='red'>");
	$fen = strpos($content,"<tr><td colspan='4'>&nbsp;</td></tr>");
	$nen = strpos($content,"</table>",$st);
	
	if ($fen === false)
	{
		$goDirection = substr($content,$st,$nen-$st);
		$go = explode('<tr',$goDirection);
		queryInsert($go,0);
	}else{
		$goDirection = substr($content,$st,$fen-$st);
		$backDirection = substr($content,$fen,$nen-$fen);
		$go = explode('<tr',$goDirection);
		queryInsert($go,0);
		
		$go = explode('<tr',$backDirection);
		queryInsert($go,1);
	}
	
	echo "<BR><BR><BR>\n\n\n";
}
}
function queryTDData($td_data)
{
	$pos = strpos($td_data,"<font color='#666666' size='2'>");
	$add = 31;
	if ($pos === false){
		$pos = strpos($td_data,"<font color='black' size='2'>");
		$add = 29;
	}
	if ($pos === false) return;
	$str = substr($td_data,$pos+$add,strpos($td_data,"</font>")-$pos-$add);
	$str = str_replace("<img src='images/sci.gif' width='16' height='16' align='absmiddle' valign='bottom' border='0' >","乙水",$str);
	return $str;
}
function queryInsert($go,$direction)
{
	global $roid;
	echo "Process Direction: $direction<br><br>";
	foreach ($go as $mkey => $data)
	{
		if ($mkey > 0) $data = "<tr ".ltrim($data);
		$td = explode('<td',$data);
		$area = "";
		foreach ($td as $key => $td_data)
		{
			if ($key > 0) $td_data = "<td".$td_data;
			if (strpos($td_data,"<td align='center'> <font color='#666666' size='2'><font size='2'><b>")!==false) break;
			if (strpos($td_data,"<td align='center'> <font color='black' size='2'><font size='2'><b>")!==false) break;
			if (strpos($td_data,"<td colspan='4'><font color='red'>")===false)
			{
				if ($key == 1)
				{
					$area = queryTDData($td_data);
				}
				if ($key == 2)
				{
					$station = queryTDData($td_data);
					$rt = mysql_fetch_array(mysql_query("SELECT station FROM bus_station WHERE area='".addslashes($area)."' AND name='".addslashes($station)."'"),MYSQL_ASSOC);
					if (!$rt)
					{
						mysql_query("INSERT INTO bus_station (area,name) VALUES ('".addslashes($area)."','".addslashes($station)."')");
						echo "INSERT STATION ".$area."  ->  $station <BR>\n";
						$rt['station'] = mysql_insert_id();
					}
					
					$count = mysql_result(mysql_query("SELECT COUNT(*) FROM bus_route WHERE roid='$roid' AND station='$rt[station]' AND direction='$direction'"),0);
					if ($count == 0)
					{
						mysql_query("INSERT INTO bus_route (roid,station,direction) VALUES ('$roid','$rt[station]',$direction)");
						echo "INSERT BUS ROAD ROUTE   ->  $station <BR>\n";
					}
				}
			}
		}
	}
}
?>