getAll($sqlstr); //about $sqlstr = "select * from ".Table_Homepage." where id='A' and lang='".$lang."' ORDER BY serno desc"; $ABanner = $g_db->getAll($sqlstr); //focus $sqlstr = "select * from ".Table_Homepage." where id='B' and lang='".$lang."' ORDER BY serno asc limit 0,3"; $BBanner = $g_db->getAll($sqlstr); //focus_word $sqlstr = "select tidesc from ".Table_Homepage." where id='B' and lang='".$lang."' ORDER BY serno desc limit 0,1"; $WBanner = $g_db->getOne($sqlstr); //部落格 $sqlstr = "select * from ".Table_Blogs." where show_index='Y' and lang='".$lang."' and post_date <= '".date("Y-m-d")."' ORDER BY post_date desc limit 0,6 "; $Blogs = $g_db->getAll($sqlstr); for ($i=0; $i< sizeof($Blogs); $i++) { $mno =$Blogs[$i]["author"]; $sqlstr = "select * from admin WHERE serno='{$mno}'" ; $blogauthor = $g_db->getRow($sqlstr); $Blogs[$i]["author"] = $blogauthor['name']; $Blogs[$i]["img"] = $blogauthor['head_img']; $Blogs[$i]["office"] = $blogauthor['head_office']; } //作品 $sqlstr = "select * from ".Table_work." where lang='".$lang."' and show_index='Y' and showup='Y' order by RAND() limit 0,6"; $Work = $g_db->getAll($sqlstr); for ($i=0; $i< sizeof($Work); $i++) { $mno = $Work[$i]["item"]; $sqlstr = "select * from work_class WHERE serno='{$mno}'" ; $nclass = $g_db->getRow($sqlstr); $Work[$i]["wname"] = $nclass['wname']; } //最新消息 $sqlstr = "Select * FROM `".Table_News."` where show_index='Y' and lang='".$lang."' order by post_date desc LIMIT 0,6"; $News = $g_db->getAll( $sqlstr ); for ($i=0; $i< sizeof($News); $i++) { $mno = $News[$i]["type"]; $sqlstr = "select * from newsclass WHERE serno='{$mno}'" ; $nclass = $g_db->getRow($sqlstr); $News[$i]["type"] = $nclass['serno']; $News[$i]["wname"] = $nclass['ncname']; $News[$i]["csst"] = $nclass['csst']; } //聯絡資料 $sqlstr = "Select * FROM `".Table_WebInfo."` where showup='Y' and lang='".$lang."' and type='contact' and page='index' order by list asc"; $Contacts = $g_db->getAll( $sqlstr ); ?>

\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
".$val['maintit']."
\n"; echo "
".$val['tidesc']."
\n"; echo "
\n"; echo "
".$val['btn_name']."
\n"; echo "
\n"; echo "
\n"; echo "

\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
".$val['maintit']."
\n"; echo "
".$val['tidesc']."
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "

作品案例

\n"; echo "\n"; echo "".$val['wname']."\n"; echo ""; echo "\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
".$val['pname']."
\n"; echo "
".$val['feature']."
\n"; echo "
\n"; echo "

最新作品與個案個案深度討論

寶銳部落格

\n"; echo "\n"; echo "
\n"; echo "
"; echo "
\n"; echo "
\n"; echo "\n"; echo "
".$val['tname']."
\n"; echo "
".$val['pre_text']."
\n"; echo "
"; echo "
$\"".$val['author']."\"$
"; echo "
"; echo "
".$val['author']."
"; echo "
".$val['office']."
"; echo "
"; echo "
".date("Y-m-d",strtotime($val['post_date']))."
".$val['clicks']." 點閱
"; echo "