session_start();?> include($_SERVER['DOCUMENT_ROOT']."/includes/configs.php");?>
include("head.php");?>
$sql_banner = "select * from banner_lr where positions = '1' order by list_no DESC";
$result_banner = mysql_query($sql_banner) or die ("Can not excute SQL_banner");
while($data_banner = mysql_fetch_array($result_banner)){
echo "
$sql_banner2 = "select * from banner_lr2 where positions = '1' order by list_no DESC";
$result_banner2 = mysql_query($sql_banner2) or die ("Can not excute SQL_banner");
while($data_banner2 = mysql_fetch_array($result_banner2)){
echo "";
}
?>
echo "Tee Intact Golf Lab Blog ";
$sql_blog = "select * from blog order by postdate DESC limit 20";
$result_blog = mysql_query($sql_blog) or die ("Can not excute SQL_blog");
while($data_blog = mysql_fetch_array($result_blog)){
$sql_custo = "select real_name as custo_fname,email_address as custo_email,avatar as image_path from smf_members where id_member = '$data_blog[postby]' ";
$result_custo = mysql_query($sql_custo) or die ("Can not excute SQL_custo");
$data_custo = mysql_fetch_array($result_custo);
$sql_cate = "select cate_id,catename_en from blog_category where cate_id = '$data_blog[cate_id]'";
$result_cate = mysql_query($sql_cate) or die ("Can not excute SQL_cate");
$data_cate = mysql_fetch_array($result_cate);
$sql_countcomment= "select count(*) as countcomment from blog_comment where blog_id = '$data_blog[bid]'";
$result_countcomment = mysql_query($sql_countcomment) or die ("Can not excute SQL_countcomment");
$data_countcomment = mysql_fetch_array($result_countcomment);
$sql_view= "select count(*) as countview from blog_view where id_blog = '$data_blog[bid]'";
$result_view = mysql_query($sql_view) or die ("Can not excute SQL_view");
$data_view = mysql_fetch_array($result_view);
echo "";
echo " ";
echo "
($data_countcomment[countcomment]) Comment"; } else { echo " No Comment"; } echo "| Read More (View $data_view[countview])"; ?> Share echo " "; echo "";
echo "Posted By: $data_custo[custo_fname] ";
}
?>
echo "![]()
$sql_cateb = "select * from b_category where b_id = '1'";
$result_cateb = mysql_query($sql_cateb) or die ("Can not excute SQL_subcategory");
$data_cb = mysql_fetch_array($result_cateb);
echo $data_cb[bname];
?>
$sql_cateb = "select * from b_category where b_id <> '1'";
$result_cateb = mysql_query($sql_cateb) or die ("Can not excute SQL_subcategory");
while($data_cb = mysql_fetch_array($result_cateb)){
?>
echo $data_cb[bname];
?>
$sql_subcategory = "select * from hotgolf_lr where b_cate_id = '$data_cb[b_id]' and positions = '1' order by list_no";
$result01 = mysql_query($sql_subcategory) or die ("Can not excute SQL_subcategory");
while($data01 = mysql_fetch_array($result01)){
echo "
}?>
Golf VDO
Blog Categories
About This Blog
Tee Intact Golf Lab มีความรู้และความเชี่ยวชาญในด้านไม้กอล์ฟ สามารถช่วยท่านวิเคราะห์, เลือก, ปรับแต่ง และปรับเปลี่ยนไม้กอล์ฟให้เหมาะสมกับวงสวิงเฉพาะของนักกอล์ฟแต่ละท่าน โดยใช้เครื่องVector Launch Monitor, Swing Radar และกล้องวีดีโอเป็นเครื่องมือ ช่วยในการวิเคราะห์. ![]() //*** By Weerachai Nukitram ThaiCreate.Com ***// //*** Connect MySQL ***// //*** Select วันที่ในตาราง Counter ว่าปัจจุบันเก็บของวันที่เท่าไหร่ ***// //*** ถ้าเป็นของเมื่อวานให้ทำการ Update Counter ไปยังตาราง daily และลบข้อมูล เพื่อเก็บของวันปัจจุบัน ***// $strSQL = " SELECT DATE FROM counter LIMIT 0,1"; $objQuery = mysql_query($strSQL); $objResult = mysql_fetch_array($objQuery); if($objResult["DATE"] != date("Y-m-d")) { //*** บันทึกข้อมูลของเมื่อวานไปยังตาราง daily ***// $strSQL = " INSERT INTO daily (DATE,NUM) SELECT '".date('Y-m-d',strtotime("-1 day"))."',COUNT(*) AS intYesterday FROM counter WHERE 1 AND DATE = '".date('Y-m-d',strtotime("-1 day"))."'"; mysql_query($strSQL); //*** ลบข้อมูลของเมื่อวานในตาราง counter ***// $strSQL = " DELETE FROM counter WHERE DATE != '".date("Y-m-d")."' "; mysql_query($strSQL); } //*** Insert Counter ปัจจุบัน ***// $strSQL = " INSERT INTO counter (DATE,IP) VALUES ('".date("Y-m-d")."','".$_SERVER["REMOTE_ADDR"]."') "; mysql_query($strSQL); //******************** Get Counter ************************// // Today // $strSQL = " SELECT COUNT(DATE) AS CounterToday FROM counter WHERE DATE = '".date("Y-m-d")."' "; $objQuery = mysql_query($strSQL); $objResult = mysql_fetch_array($objQuery); $strToday = $objResult["CounterToday"]; // Yesterday // $strSQL = " SELECT NUM FROM daily WHERE DATE = '".date('Y-m-d',strtotime("-1 day"))."' "; $objQuery = mysql_query($strSQL); $objResult = mysql_fetch_array($objQuery); $strYesterday = $objResult["NUM"]; // This Month // $strSQL = " SELECT SUM(NUM) AS CountMonth FROM daily WHERE DATE_FORMAT(DATE,'%Y-%m') = '".date('Y-m')."' "; $objQuery = mysql_query($strSQL); $objResult = mysql_fetch_array($objQuery); $strThisMonth = $objResult["CountMonth"]; // Last Month // $strSQL = " SELECT SUM(NUM) AS CountMonth FROM daily WHERE DATE_FORMAT(DATE,'%Y-%m') = '".date('Y-m',strtotime("-1 month"))."' "; $objQuery = mysql_query($strSQL); $objResult = mysql_fetch_array($objQuery); $strLastMonth = $objResult["CountMonth"]; // This Year // $strSQL = " SELECT SUM(NUM) AS CountYear FROM daily WHERE DATE_FORMAT(DATE,'%Y') = '".date('Y')."' "; $objQuery = mysql_query($strSQL); $objResult = mysql_fetch_array($objQuery); $strThisYear = $objResult["CountYear"]; // Last Year // $strSQL = " SELECT SUM(NUM) AS CountYear FROM daily WHERE DATE_FORMAT(DATE,'%Y') = '".date('Y',strtotime("-1 year"))."' "; $objQuery = mysql_query($strSQL); $objResult = mysql_fetch_array($objQuery); $strLastYear = $objResult["CountYear"]; //*** Close MySQL ***// ?>
| ||||||||||||||||||||||