| 回上一頁 |
| 最新消息 |
| 資料查詢系統 |
$link=mysql_connect($DB_SERVER,$DB_USER,$DB_PASS);
mysql_select_db($DB_NAME,$link);
mysql_query("SET NAMES utf8", $link);
//將該筆最新消息的點閱率加1
$serial=$_GET["serial"];
if (!($serial))
{
echo "請選擇資料查詢系統,謝謝您。";
die;
}
$str="update $NEWS_TBL set count=count+1 where serial='$serial'";
mysql_query($str,$link);
$str="select Day,title,content,count,CategoryID,SubjectID,web,PubDay,CountyID,DistrictID from $NEWS_TBL where serial='$serial'";
$list =mysql_query($str,$link);
list($Day,$title,$content,$count,$categoryID,$subjectID,$web,$PubDay,$countyID,$districtID) = mysql_fetch_row($list);
echo "
".$title." 資料內容\n";
$str="select category.Description from category where category.CategoryID='$categoryID'";
$list=mysql_query($str,$link);
list($category) = mysql_fetch_row($list);
$valuea=explode(' ',$districtID);
$valueb=explode(' ',$subjectID);
function place($districtID)
{
require "include/setup.php";
$link=mysql_connect($DB_SERVER,$DB_USER,$DB_PASS);
mysql_select_db($DB_NAME,$link);
mysql_query("SET NAMES utf8", $link);
$str5="select district.Description,district.CountyID from district where district.DistrictID LIKE '%$districtID%'";
$list5=mysql_query($str5,$link);
list($district,$countyID) = mysql_fetch_row($list5);
$str3="select county.Description from county where county.CountyID LIKE '%$countyID%'";
$list3=mysql_query($str3,$link);
list($county) = mysql_fetch_row($list3);
echo "$county";
echo " $district ";
}
function subject($subjectID)
{
require "include/setup.php";
$link=mysql_connect($DB_SERVER,$DB_USER,$DB_PASS);
mysql_select_db($DB_NAME,$link);
mysql_query("SET NAMES utf8", $link);
$str5="select subject.Description from subject where subject.SubjectID LIKE '%$subjectID%'";
$list5=mysql_query($str5,$link);
list($subject) = mysql_fetch_row($list5);
echo "$subject ";
}
$content=nl2br($content);
?>
|
【時間】: |
【類別】: |
【地點】:
|
【主題】:
|
【相關網址】: |
|
【發佈時間】:【人氣指數】: |