$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");
?>
if (!isset($_SESSION['member'])) { ?>
} ?>
include('template/cat_widget.php');
include('template/fb_widget.php');
?>
ยินดีต้อนรับเข้าสู่
เราได้รับข้อมูลการสมัครสมาชิกเรียบร้อยแล้ว ท่านสามารถเข้าใช้งานระบบโดยการกรอก Email และ รหัสผ่าน
ที่เมนูของเว็ปไซต์
} else { ?>
} ?>