上海地下鉄リニア乗り換え・所要時間検索 |
|
上のリストまたは下の地図上で乗車駅・下車駅を選択してください
|
include_once("/home/shanghai/infiles/layer2ad.php"); ?>
「What's New in 上海」交通関連ニュース |
if ($dbcon) {
$rtn = pg_exec("SELECT * FROM news_headline WHERE areash='Y' AND ctgy=50 ORDER BY tdate DESC LIMIT 5");
$n=pg_num_rows($rtn);
if(!$rtn || !$n){ "ERROR! table news_headline";
}else{
for($i=0;$i<$n;$i++){
$row=pg_fetch_array($rtn,$i);
$tdate = explode(" ",$row['tdate']);
$ttime = explode(":",$tdate[1]);
$tdate = explode("-",$tdate[0]);
if(time() > mktime($ttime[0],$ttime[1],0,$tdate[1],$tdate[2],$tdate[0])){
if($row['photo']=="Y"){ $photo = " "; }else{ $photo = ""; }
?>
echo(htmlspecialchars(strip_tags($row['title']))); ?>( echo($tdate[1]); ?>/ echo($tdate[2]); ?> echo($ttime[0]); ?>: echo($ttime[1]); ?>掲載) echo($photo); ?>
}
}
}
}
?>
|

上海交通関連の特集 |
$rtn=@pg_exec("SELECT * FROM feature_headline WHERE ap=1 AND ctgy=50 AND areash='Y' ORDER BY tdate DESC LIMIT 10");
$n=@pg_num_rows($rtn);
for($i=0;$i<$n;$i++){
$row=@pg_fetch_array($rtn,$i);
if($row['purl']){ $url=$row['purl']; }else{ $url="http://www.explore.ne.jp/feature/articles/".$row['id']."_1.html"; }
$tdate=explode(" ",$row['tdate']);
?>
echo $row['title']; ?>( echo str_replace("-","/",$tdate[0]); ?>掲載)
if($i<3 && !$row['purl']){
if(file_exists("/home/shanghai/nicchu.com/feature/articles/images/".$row['id']."_1_1s.jpg")){
echo " ";
}
$rtn2=@pg_exec(sprintf("SELECT honbun FROM feature_honbun WHERE num=%d AND page=1",$row['id']));
echo " ".mb_strimwidth(strip_tags(@pg_result($rtn2,0,0)),0,200,"……")." ";
}
echo "";
}
?>
|
エクスプロア・ブログ掲載の上海交通関連トラックバック |
| include("/home/shanghai/infiles/tb.inc"); ?> |
|
|
|
|
include ("/home/shanghai/travel/oshirase_airport.txt"); ?>
include ("/home/shanghai/nicchu.com/store/sh3dayspass.txt"); ?>
include ("/home/shanghai/nicchu.com/store/sh_map.txt"); ?>
|
|