dbConnect("168.168.168.12","dls","0AkPZvKRLZ3Uy4jA","dls");
/**** Mysqli require one extra step, parameter binding ****/
$sdb->parameter_types="i";
/* =============================================
validation if posted
============================================= */
$gTitle="";$gContent="";$gCTime="";$gKind="";
$typeWord=array(1=>"新聞",2=>"政策",3=>"公司動態");
//if ($_SERVER["REQUEST_METHOD"] == "GET") {
$sdb->fetch_mode="ASSOC";
$sdb->order_by_column="create_time desc";
$sdb->single_row=true;
if(!isset($_GET['id'])){
$qry="";
}else{
$qry=array('id'=>intval($_GET['id']));
}
$rec=$sdb->dbSelect("t_news","",$qry);
// echo $sdb->query;
// var_dump($sdb->error_info);
// var_dump($sdb->message_info);
// var_dump($rec);
//var_dump($_GET);
// echo $gContent;
if($rec && count($rec)>0){
$gTitle=$rec['title'];
$gContent=$rec['content'];
$gCTime=$rec['create_time'];
$gKind=$typeWord[$rec['kind']];
$gPicFile=$rec['pic_file'];
}
// select all news
$sdb->single_row=false;
$sdb->order_by_column="create_time desc";
$sdb->limit_val="0,30";
$newsList=$sdb->dbSelect("t_news");
//}
//die();
?>
Latest News | <?=$gTitle ?>
""){ ?>
