$host="localhost"; //ชื่อโฮสโดยปกติจะเป็น localhost
$user="vteeraco_v"; //ชื่อผู้ใช้ฐานข้อมูล
$pass="4655839"; //รหัสผ่านฐานข้อมูล
$dbname="vteeraco_v"; // ชื่อฐานข้อมูล
$conn=@mysql_connect($host,$user,$pass)or die("Cannot select DB");
$db=mysql_select_db($dbname)or die("Cannot select DB");
mysql_query("SET NAMES utf8");
?>
//ตกแต่ง
$sqlDecoration = "SELECT * FROM decoration";
$resultDecoration = mysql_query($sqlDecoration) or die(mysql_error());
$rowDecoration = mysql_fetch_array($resultDecoration);
//ข้อมูลร้าน
$sqlSetting = "SELECT * FROM setting";
$resultSetting = mysql_query($sqlSetting) or die(mysql_error());
$rowSetting = mysql_fetch_array($resultSetting);
//ส่วนเสริม
$sqlPlus = "SELECT * FROM plus";
$resultPlus = mysql_query($sqlPlus) or die(mysql_error());
$rowPlus = mysql_fetch_array($resultPlus);
//หน้า
$sqlPage = "SELECT * FROM page WHERE display='แสดง' ORDER BY sort asc";
$resultPage = mysql_query($sqlPage) or die(mysql_error());
$numPage = mysql_num_rows($resultPage);
//สไลด์โชว์
$sqlSlideshow = "SELECT * FROM slideshow ORDER BY last_update DESC";
$resultSlideshow = mysql_query($sqlSlideshow) or die(mysql_error());
$numSlideshow = mysql_num_rows($resultSlideshow);
//สินค้า
$sqlAll = "SELECT * FROM product";
$resultAll = mysql_query($sqlAll) or die(mysql_error());
$numAll = mysql_num_rows($resultAll);
//หมวดสินค้า
$sqlCategory = "SELECT big_category.id AS id, big_category.name AS name, COUNT(product.id) AS num_product FROM big_category LEFT JOIN product ON big_category.id=product.category_id WHERE big_category.id!=0 GROUP BY big_category.id ORDER BY big_category." . $rowSetting['sort_category'];
$resultCategory = mysql_query($sqlCategory) or die(mysql_error());
$numCategory = mysql_num_rows($resultCategory);
function rewrite_url($url="url"){
$url=strtolower(str_replace(" ","_",$url));
$url=strtolower(preg_replace('~[^a-z0-9ก-๙\.\-\_]~iu','',$url));
return $url;
}
?>
if ($title == 'index') {
?>
|
} else if ($title == 'product') {
$sql = "SELECT * FROM product WHERE id=$_GET[id]";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);?>
|
} else if ($title == 'cat') {
$sql = "SELECT * FROM category WHERE id=$_GET[id]";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);?>
|
} else if ($title == 'catbig') {
$sql = "SELECT * FROM big_category WHERE id=$_GET[id]";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);?>
|
} else if ($title == 'payment') {
$sql = "SELECT * FROM page WHERE id=6";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);?>
|
} else if ($title == 'promotion') {
$sql = "SELECT * FROM page WHERE id=4";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);?>
|
} else if ($title == 'about') {
$sql = "SELECT * FROM page WHERE id=1";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);?>
|
} else if ($title == 'howto') {
$sql = "SELECT * FROM page WHERE id=5";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);?>
|
} else if ($title == 'forum') {
$sql = "SELECT * FROM page WHERE id=8";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);?>
|
} else if ($title == 'forumdetail') {
$sql = "SELECT * FROM page WHERE id=8";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);
$sqlPost = "SELECT * FROM webboard_post WHERE id=$_GET[id]";
$resultPost = mysql_query($sqlPost) or die(mysql_error());
$rowPost = mysql_fetch_array($resultPost);?>
- |
} else if ($title == 'contact') {
$sql = "SELECT * FROM page WHERE id=9";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);?>
|
} else if ($title == 'articledetail') {
$sql = "SELECT * FROM page WHERE id=7";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);
$sqlPost = "SELECT * FROM article WHERE id=$_GET[id]";
$resultPost = mysql_query($sqlPost) or die(mysql_error());
$rowPost = mysql_fetch_array($resultPost);?>
- |
} else if ($title == 'article') {
$sql = "SELECT * FROM page WHERE id=7";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);?>
|
} else if ($title == 'page') {
$sql = "SELECT * FROM page WHERE id=$_GET[id]";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);?>
|
} else if ($title == 'cus') {?>
จัดการข้อมูลส่วนตัว |
} else if ($title == 'cus_pass') {?>
จัดการรหัสผ่าน |
} else if ($title == 'cus_address') {?>
จัดการที่อยู่สำหรับจัดส่งสินค้า |
} else if ($title == 'cus_wishlist') {?>
รายการสินค้าที่ชอบ |
} else if ($title == 'cus_order') {?>
รายการสั่งซื้อ |
} else if ($title == 'shipping') {?>
ขั้นตอนการสั่งซื้อสินค้า |
} else if ($title == 'order') {?>
เสร็จสิ้นขั้นตอนการสั่งซื้อสินค้า |
} else { ?>
|
} ?>
include("config/sql.inc.php");
?>
for ($i = 1; $i <= $numPage; $i++) {
$rowPage = mysql_fetch_array($resultPage);
?>
}
?>
if (!isset($_SESSION['member'])) { ?>
} ?>
include('template/cat_widget.php');
include('template/fb_widget.php');
?>
//widget
$sqlwidget = "SELECT * FROM widget where align = 'ตรงกลางหน้าแรก' order by sort";
$resultwidget = mysql_query($sqlwidget) or die(mysql_error());
$numwidget = mysql_num_rows($resultwidget);
for ($k = 1;
$k <= $numwidget;
$k++) {
$rowwidget = mysql_fetch_array($resultwidget);
if ($rowwidget['display'] == 'เปิด') {
?>
if ($rowwidget['id'] == '3') {
?>