File: /home/pengthai/domains/pengthaicurry.com/public_html/admin/include/function.php
<?php
function msg($status,$txt,$notAjax=null)
{
if(empty($notAjax)){
return '{"stat":'.$status.',"txt":"'.$txt.'"}';
}
else
{
echo'<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />';
if ($status ==1){
echo "<script language='javascript'>alert('บันทึกลงฐานข้อมูลเรียบร้อยแล้วค่ะ');</script>";
echo "<meta http-equiv=\"refresh\" content=\"0;URL=$txt \" />";
}
else
{
echo "<script language='javascript'>alert('$txt');
javascript:history.back();</script>";
}
}
}
function displaydate($x)
{
$date_m = array("มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
$time_array=explode(" ",$x);
$date = $time_array[0];
$time = $time_array[1];
$date_array=explode("-",$date);
$y = $date_array[0]+543;
$m = $date_array[1]-1;
$d = $date_array[2];
$m=$date_m[$m];
$displaydate= "$d $m $y";
return $displaydate;
}
function displaydate2($x)
{
$date_m = array("ม.ก.","ก.พ.","ม.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.");
$time_array=explode(" ",$x);
$date = $time_array[0];
$time = $time_array[1];
$date_array=explode("-",$date);
$y = $date_array[0]+543;
$m = $date_array[1]-1;
$d = $date_array[2];
$y = substr($y, -2);
$m=$date_m[$m];
$displaydate= "$d $m $y";
return $displaydate;
}
function displaydate_en($x)
{
$date_m = array("January","February","March","April","May","June","July","August","September","October","November","December");
$time_array=explode(" ",$x);
$date = $time_array[0];
$time = $time_array[1];
$date_array=explode("-",$date);
$y = $date_array[0];
$m = $date_array[1]-1;
$d = $date_array[2];
$m=$date_m[$m];
$displaydate= "$d $m $y";
return $displaydate;
}
function displaydate_enshort($x)
{
$date_m = array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
$time_array=explode(" ",$x);
$date = $time_array[0];
$time = $time_array[1];
$date_array=explode("-",$date);
$y = $date_array[0];
$m = $date_array[1]-1;
$d = $date_array[2];
$m=$date_m[$m];
$displaydate= "$d $m $y";
return $displaydate;
}
function displaytime($x)
{
$time_array=explode(" ",$x);
$date = $time_array[0];
$time = $time_array[1];
$date_m = array("มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
$date_array=explode("-",$date);
$y = $date_array[0]+543;
$m = $date_array[1]-1;
$d = $date_array[2];
$m=$date_m[$m];
$displaytime= $d." ".$m." ".$y."<br>";
$displaytime.= "$time";
return $displaytime;
}
function display_month($x)
{
$time_array=explode(" ",$x);
$date = $time_array[0];
$time = $time_array[1];
$date_m = array("มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
$date_array=explode("-",$date);
$y = $date_array[0]+543;
$m = $date_array[1]-1;
$d = $date_array[2];
$m=$date_m[$m];
$displaymonth= "<h1>".$d."</h1>".$m;
// $displaytime.= "$time";
return $displaymonth;
}
function checkemail($checkemail)
{
if(ereg("^[^@ ]+@([a-zA-Z0-9\-]+\.)+([a-zA-Z0-9\-]{2}
|net|com|gov|mil|org|edu|int|co.th)$",$checkemail))
{
return true;
}
else
{
return false;
}
}
function statuspd($statid){
include ("../include/connect.php");
mysql_queryx("SET NAMES UTF8");
//อ่านสถานะจากฐานข้อมูล
$sqlst = "SELECT * FROM tb_pdstatus ORDER BY id_ps";
$resultst = mysql_db_query($dbname,$sqlst);
$sel_catemain = "<option value='0'>-----ไม่ระบุ -----</option>";
while($rst=mysql_fetch_arrayx($resultst))
{
$id_ps = sprintf("%d", $rst[id_ps]);
$name_ps = $rst[name_ps];
if( $statid== $id_ps )
$sel_catemain .= "<option value='$id_ps' selected='selected' >";
else
$sel_catemain .= "<option style='background-color:#ffffff' value='$id_ps'>";
$sel_catemain .= $name_ps;
$sel_catemain .= "</option>";
}
return $sel_catemain;
}
function resize($images , $new_images , $width ,$ext)
{
$re_value= false;
$size=GetimageSize($images);
$height=round($width*$size[1]/$size[0]);
//$images_orig = ImageCreateFromJPEG($images);
$valid_exts = array("jpg","jpeg","gif","png");
// ตรวจสอบนามสกุล
if(in_array($ext,$valid_exts))
{
if($ext == "jpg" || $ext == "jpeg")
{
$images_orig =ImageCreateFromJPEG($images);
}
else if($ext == "gif")
{
$images_orig = ImageCreateFromGIF($images);
}
else if($ext == "png")
{
$images_orig = ImageCreateFromPNG($images);
}
$photoX = ImagesX($images_orig);
$photoY = ImagesY($images_orig);
$images_fin = ImageCreateTrueColor($width, $height);
imageSaveAlpha($images_fin, true);
ImageAlphaBlending($images_fin, false);
$transparentColor = imagecolorallocatealpha($images_fin, 255, 255, 255, 127);
imagefill($images_fin, 0, 0, $transparentColor);
ImageCopyResampled($images_fin, $images_orig, 0, 0, 0, 0, $width+1, $height+1, $photoX, $photoY);
//ImagePNG($images_fin,$new_images);
if($ext == "jpg" || $ext == "jpeg")
{
ImageJPEG($images_fin,$new_images);
}
else if($ext == "gif")
{
imagegif($images_fin,$new_images);
}
else if($ext == "png")
{
imagepng($images_fin,$new_images);
}
ImageDestroy($images_orig);
ImageDestroy($images_fin);
$re_value = true;
}
return $re_value;
}
function fb_thaidate($timestamp){
$diff = time() - $timestamp;
$periods = array("วินาที", "นาที", "ชั่วโมง");
$words="ที่แล้ว";
if($diff<60){
$i=0;
$diff=($diff==1)?"":$diff;
$text = "$diff $periods[$i]$words";
}elseif($diff<3600){
$i=1;
$diff=round($diff/60);
$diff=($diff==3 || $diff==4)?"":$diff;
$text = "$diff $periods[$i]$words";
}elseif($diff<86400){
$i=2;
$diff=round($diff/3600);
$diff=($diff != 1)?$diff:"" . $diff ;
$text = "$diff $periods[$i]$words";
}elseif($diff<172800){
$diff=round($diff/86400);
$text = "$diff วันที่แล้ว เมื่อเวลา " .date("g:i a",$timestamp);
}else{
$thMonth = array("มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฏาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
$date = date("j", $timestamp);
$month = $thMonth[date("m", $timestamp)-1];
$y = date("Y", $timestamp)+543;
$t1 = "$date $month $y";
$t2 = "$date $month $y";
if($timestamp<strtotime(date("Y-01-01 00:00:00"))){
$text = $t1 ;
}else{
$text = $t2 ;
}
}
return $text;
//return $diff;
}
function showShipping($id,$mode){
global $dbname;
//อ่านสถานะจากฐานข้อมูล
$sqlst = "SELECT * FROM tb_shipping WHERE id_ship='$id' and type_ship ='$mode' ";
$resultst = mysql_queryx($sqlst);
if($rst=mysql_fetch_arrayx($resultst))
{
$id_ship = sprintf("%d", $rst[id_ship]);
$type_ship = $rst[type_ship];
$type_ship = $rst[type_ship];
$value_ship = $rst[value_ship];
$ship_arr = explode("||",$value_ship);
}
switch ($mode){
case 2 :
$shipprice_arr = explode(",",$ship_arr[0]);
$msg = "<ul><li><span>ราคา </span> <span><input type='text' class='price' value='$shipprice_arr[1]' /></span> <span>บาท </span></li></ul>";
break;
case 3 :
$shipprice_arr = explode(",",$ship_arr[0]);
$shipprice_arr2 = explode(",",$ship_arr[1]);
$msg = " <ul>
<li><span>ค่าส่งสินค้าชิ้นแรก </span> <span><input type='text' class='price' value='$shipprice_arr[1]' /></span> <span>บาท </span></li>
<li><span>ค่าส่งสินค้าชิ้นถัดไป </span> <span><input type='text' class='price' value='$shipprice_arr2[1]' /> </span> <span>บาท/ชิ้น </span></li>
</ul>";
break;
case 4 :
$count_array = count($ship_arr);
$count=0;
while($ship_arr[$count] != ''){
if($count !=0){
$shipprice_arr1 = explode(",",$ship_arr[$count-1]);
$strnum = $shipprice_arr1[0]+1;
}
$shipprice_arr = explode(",",$ship_arr[$count]);
if($count==0){
$msg .= "<ul>
<li><span>ถ้าสินค้ามีจำนวนไม่เกิน <input type='text' class='number' value='$shipprice_arr[0]' /> ชิ้น คิดค่าส่ง
<input class='price' type='text' value='$shipprice_arr[1]' /> บาท </span> <input type='button' class='icon add add_condition'/> </li>";
}
else if (($count_array-2) == $count)
{
$msg .= " <li class='last'>
<span class='text-last'>ถ้าสินค้ามีจำนวนเกิน $strnum ชิ้น คิดค่าส่ง </span>
<span><input type='text' class='price' value='$shipprice_arr[1]' /> บาท </span></li>
</ul>";
}
else
{
$msg .= "<li> <span class='text-last' > ถ้าสินค้ามีจำนวนเกิน $strnum ชิ้น แต่ไม่เกิน </span> <input type='text' class='number' value='$shipprice_arr[0]' />
ชิ้น คิดค่าส่ง <span> <input class='price' type='text' value='$shipprice_arr[1]' /> บาท </span> <input type='button' class='icon remove'/></li>";
}
$count++;
}
if ($count_array == 0){
$msg = "<ul>
<li><span>ถ้าสินค้ามีจำนวนไม่เกิน <input type='text' class='number' value='1' /> ชิ้น คิดค่าส่ง
<input class='price' type='text' value='0' /> บาท </span> <input type='button' class='icon add add_condition'/> </li>";
$msg .= " <li class='last'>
<span class='text-last'>ถ้าสินค้ามีจำนวนเกิน 2 ชิ้น คิดค่าส่ง </span>
<span><input type='text' value='0' class='price' value='0' /> บาท </span></li>
</ul>";
}
break;
case 5 :
$count_array = count($ship_arr);
$count=0;
while($ship_arr[$count] != ''){
if($count !=0){
$shipprice_arr1 = explode(",",$ship_arr[$count-1]);
$strnum = $shipprice_arr1[0]+1;
}
$shipprice_arr = explode(",",$ship_arr[$count]);
if($count==0){
$msg .= "<ul>
<li><span>ถ้าสินค้ามีราคาไม่เกิน <input type='text' class='number' value='$shipprice_arr[0]' /> บาท คิดค่าส่ง
<input class='price' type='text' value='$shipprice_arr[1]' /> บาท </span> <input type='button' class='icon add add_condition'/> </li>";
}
else if (($count_array-2) == $count)
{
$msg .= " <li class='last'>
<span class='text-last'>ถ้าสินค้ามีราคาเกิน $strnum บาท คิดค่าส่ง </span>
<span><input type='text' class='price' value='$shipprice_arr[1]' /> บาท </span></li>
</ul>";
}
else
{
$msg .= "<li> <span class='text-last' > ถ้าสินค้ามีจำนวนเกิน $strnum บาท แต่ไม่เกิน </span>
<input type='text' class='number' value='$shipprice_arr[0]' /> บาท คิดค่าส่ง <span>
<input class='price' type='text' value='$shipprice_arr[1]' /> บาท </span> <input type='button' class='icon remove'/></li>";
}
$count++;
}
if ($count_array == 0){
$msg = "<ul>
<li><span>ถ้าสินค้ามีราคาไม่เกิน <input type='text' class='number' value='1' /> บาท คิดค่าส่ง
<input class='price' type='text' value='0' /> บาท </span> <input type='button' class='icon add add_condition'/> </li>";
$msg .= " <li class='last'>
<span class='text-last'>ถ้าสินค้ามีราคาเกิน 2 บาท คิดค่าส่ง </span>
<span><input type='text' value='0' class='price' value='0' /> บาท </span></li>
</ul>";
}
break;
}
return $msg;
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
function ShowCountry($country,$city){
//อ่านหมวดหมู่หลัก จากฐานข้อมูล
global $dbname;
if (empty($country) || empty($city)) {
$showcountry = "";
} else {
$sql = "SELECT * FROM tb_country WHERE cate_id='$city' ORDER BY cate_sort";
$result = mysql_queryx($sql);
while($r=mysql_fetch_arrayx($result))
{
$cateid = sprintf("%d", $r[cate_id]);
$catename = $r[cate_name];
$showcity = $catename;
}
$sql = "SELECT * FROM tb_country WHERE cate_id='$country' ORDER BY cate_sort";
$result = mysql_queryx($sql);
while($r=mysql_fetch_arrayx($result))
{
$cateid = sprintf("%d", $r[cate_id]);
$catename = $r[cate_name];
$showcountry = $catename;
}
$showcountry = $showcity .", ".$showcountry ;
}
return $showcountry ;
}
function ShowState($state){
//อ่านหมวดหมู่หลัก จากฐานข้อมูล
global $dbname;
if (empty($state)) {
$showstate = "";
} else {
$sql = "SELECT * FROM tb_state WHERE cate_id='$state' ";
$result = mysql_queryx($sql);
while($r=mysql_fetch_arrayx($result))
{
$cateid = sprintf("%d", $r[cate_id]);
$catename = $r[cate_name];
$showstate = $catename;
}
}
return $showstate ;
}
function ShowEmployer($employer){
//อ่านหมวดหมู่หลัก จากฐานข้อมูล
global $dbname;
if (empty($employer)) {
$showemployer = "";
} else {
$sql = "SELECT * FROM tb_employer WHERE cate_id='$employer' ";
$result = mysql_queryx($sql);
while($r=mysql_fetch_arrayx($result))
{
$cateid = sprintf("%d", $r[cate_id]);
$catename = $r[cate_name];
$showemployer = $catename;
}
}
return $showemployer ;
}
function ShowPosition($position){
//อ่านหมวดหมู่หลัก จากฐานข้อมูล
global $dbname;
if (empty($position)) {
$showposition = "";
} else {
$sql = "SELECT * FROM tb_position WHERE cate_id='$position' ";
$result = mysql_queryx($sql);
while($r=mysql_fetch_arrayx($result))
{
$cateid = sprintf("%d", $r[cate_id]);
$catename = $r[cate_name];
$showposition = $catename;
}
}
return $showposition ;
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
function Callcateprod($showcate=null){
//อ่านหมวดหมู่หลัก จากฐานข้อมูล
global $dbname;
$sql = "SELECT * FROM tb_category WHERE show_cate=1 ORDER BY num_cate";
$result = mysql_queryx($sql);
$sel_catemain = "<option value='0'>----- แสดงทุกหมวดหมู่ -----</option>";
while($r=mysql_fetch_arrayx($result))
{
$cateid = sprintf("%d", $r[id_cate]);
$catename = $r[name_cate];
if( $showcate == $cateid )
$sel_catemain .= "<option value='$cateid' selected='selected'>";
else
$sel_catemain .= "<option value='$cateid'>";
$sel_catemain .= $catename;
$sel_catemain .= "</option>";
}
return $sel_catemain;
}
function CallStatus($value=null,$addAll=null){
//อ่านสถานะ จากฐานข้อมูล
global $dbname;
$sql = "SELECT * FROM tb_product_status ";
$result = mysql_queryx($sql);
if( $value=='0')
$selected = "selected='selected'";
$sel_catemain = "$addAll<option value='0' $selected>ไม่มีสถานะ</option>";
while($r=mysql_fetch_arrayx($result))
{
$stat_id = sprintf("%d", $r[stat_id]);
$stat_name = $r[stat_name];
if( $value == $stat_id )
$sel_catemain .= "<option value='$stat_id' selected='selected'>";
else
$sel_catemain .= "<option value='$stat_id'>";
$sel_catemain .= $stat_name;
$sel_catemain .= "</option>";
}
return $sel_catemain;
}
function statusbox($statid=null){
//อ่านสถานะจากฐานข้อมูล
$sqlst = "SELECT * FROM tb_status ORDER BY id_st";
$resultst = mysql_queryx($sqlst);
$sel_catemain = "<option value='0'>----- แสดงทุกสถานะ -----</option>";
while($rst=mysql_fetch_arrayx($resultst))
{
$id_st = sprintf("%d", $rst[id_st]);
$name_st = $rst[name_st];
if( $statid== $id_st )
$sel_catemain .= "<option value='$id_st' selected='selected' >";
else
$sel_catemain .= "<option style='background-color:#ffffff' value='$id_st'>";
$sel_catemain .= $name_st;
$sel_catemain .= "</option>";
}
return $sel_catemain;
}
function ShowStatus($value=null){
//อ่านสถานะ จากฐานข้อมูล
global $dbname;
$sql = "SELECT * FROM tb_product_status WHERE stat_id = '$value' ";
$result = mysql_queryx($sql);
while($r=mysql_fetch_arrayx($result))
{
$stat_id = sprintf("%d", $r['stat_id']);
$stat_name = $r['stat_name'];
}
return $stat_name;
}
function getYouTubeIdFromURL($url)
{
$url_string = parse_url($url, PHP_URL_QUERY);
parse_str($url_string, $args);
return isset($args['v']) ? $args['v'] : false;
}
?>