| Server IP : 172.67.206.42 / Your IP : 104.23.243.51 Web Server : Apache System : Linux server.localhost.com 6.8.0-85-generic #85-Ubuntu SMP PREEMPT_DYNAMIC Thu Sep 18 15:26:59 UTC 2025 x86_64 User : pahana ( 1029) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /home/pahana/public_html/php/ |
Upload File : |
<?php ?><?php ?><?php
// include("connect-mysql.php");
function stringTxtLimit($strng,$wordLimit){
if(strlen($strng)>$wordLimit){
$dotsStr = "...";
}else{
$dotsStr = "";
}
$strngTxt = substr(strip_tags($strng),0,$wordLimit) . $dotsStr;
return $strngTxt;
}
function currDateTimeGmt(){
$user_tz = 5.5;
$user_offset = $user_tz * 3600;
$timestamp = time();
$local_timestamp = $timestamp + $user_offset;
return date("Y-m-d g:i:s A",$local_timestamp);
}
function currDateGmt(){
$dtAry = explode(" ",currDateTimeGmt());
$dtAry2 = explode("-",$dtAry[0]);
return $dtAry2[2].'/'.$dtAry2[1].'/'.$dtAry2[0];
}
function viewDtTm($dt){
$dtTmAry = explode(" ",$dt);
$dtAry = explode("-",$dtTmAry[0]);
return $dtAry[2].'-'.$dtAry[1].'-'.$dtAry[0].' '.$dtTmAry[1].' '.$dtTmAry[2];
}
function sqlDtFormat($dt){
$dtAry = explode("-",$dt);
return $dtAry[2].'-'.$dtAry[1].'-'.$dtAry[0];
}
function viewDateFormat($dt){
$dtAry = explode("-",$dt);
return $dtAry[2].'-'.$dtAry[1].'-'.$dtAry[0];
}
function magazineUrl($id) {
global $conn;
global $siteUrlMain;
$query = mysqli_query($conn,"select urlPage FROM product_mapping_cate where id= '" . $id . "'");
$rows = mysqli_fetch_array($query);
return $siteUrlMain."our-magazine/".$rows['urlPage'];
}
function videoUrl($id) {
global $conn;
global $siteUrlMain;
$query = mysqli_query($conn,"select urlPage FROM videos where id= '" . $id . "'");
$rows = mysqli_fetch_array($query);
return $siteUrlMain."our-video/".$rows['urlPage'];
}
function pageContent($id){
global $conn;
$sql = mysqli_query($conn,"SELECT * FROM pages where id='".$id."'");
$rows = mysqli_fetch_array($sql);
return $rows;
}
function metaTags($id){
global $conn;
$sql = mysqli_query($conn,"SELECT meta_title,meta_keywords,meta_desc FROM meta_tags where id='".$id."'");
$rows = mysqli_fetch_array($sql);
return $rows;
}
function getMetaTags(){
global $conn;
global $siteName;
$basePth = basename($_SERVER['PHP_SELF']);
if($basePth=="about.php"){
$metaAry = metaTags(2);
$siteTitle = $metaAry['meta_title'];
$keywordContent = $metaAry['meta_keywords'];
$descContent = $metaAry['meta_desc'];
}else if($basePth=="newsVideo.php"){
if(isset($_GET['id']) && $_GET['id']!=""){
$sqlMt = mysqli_query($conn,"SELECT title,meta_keywords,meta_desc FROM videos where urlPage='".$_GET['id']."'");
$rowsMt = mysqli_fetch_array($sqlMt);
$siteTitle = $rowsMt['title'];
$keywordContent = $rowsMt['meta_keywords'];
$descContent = $rowsMt['meta_desc'];
}else{
$metaAry = metaTags(4);
$siteTitle = $metaAry['meta_title'];
$keywordContent = $metaAry['meta_keywords'];
$descContent = $metaAry['meta_desc'];
}
}else if($basePth=="contactUs.php"){
$metaAry = metaTags(4);
$siteTitle = $metaAry['meta_title'];
$keywordContent = $metaAry['meta_keywords'];
$descContent = $metaAry['meta_desc'];
}else if($basePth=="videos.php"){
if(isset($_GET['id']) && $_GET['id']!=""){
$sqlMt = mysqli_query($conn,"SELECT title,meta_keywords,meta_desc FROM videos where urlPage='".$_GET['id']."'");
$rowsMt = mysqli_fetch_array($sqlMt);
$siteTitle = $rowsMt['title'];
$keywordContent = $rowsMt['meta_keywords'];
$descContent = $rowsMt['meta_desc'];
}else{
$metaAry = metaTags(5);
$siteTitle = $metaAry['meta_title'];
$keywordContent = $metaAry['meta_keywords'];
$descContent = $metaAry['meta_desc'];
}
}else if($basePth=="talkShows.php"){
$sqlMt = mysqli_query($conn,"SELECT meta_title,meta_keywords,meta_desc FROM talk_shows where id='1'");
$rowsMt = mysqli_fetch_array($sqlMt);
$siteTitle = $rowsMt['meta_title'];
$keywordContent = $rowsMt['meta_keywords'];
$descContent = $rowsMt['meta_desc'];
}else if($basePth=="news.php"){
$sqlMt = mysqli_query($conn,"SELECT meta_title,meta_keywords,meta_desc FROM news where urlPage='".$_GET['id']."'");
$rowsMt = mysqli_fetch_array($sqlMt);
$siteTitle = $rowsMt['meta_title'];
$keywordContent = $rowsMt['meta_keywords'];
$descContent = $rowsMt['meta_desc'];
}else if($basePth=="category.php"){
$sqlMt = mysqli_query($conn,"SELECT meta_title,meta_keywords,meta_desc FROM categories where urlPage='".$_GET['id']."'");
$rowsMt = mysqli_fetch_array($sqlMt);
$siteTitle = $rowsMt['meta_title'];
$keywordContent = $rowsMt['meta_keywords'];
$descContent = $rowsMt['meta_desc'];
}else if($basePth=="infoPage.php"){
$sqlMt = mysqli_query($conn,"SELECT title,meta_keywords,meta_desc FROM info_pages where urlPage='".$_GET['id']."'");
$rowsMt = mysqli_fetch_array($sqlMt);
$siteTitle = $rowsMt['title'];
$keywordContent = $rowsMt['meta_keywords'];
$descContent = $rowsMt['meta_desc'];
}else if($basePth=="newsVideoCategory.php"){
$sqlMt = mysqli_query($conn,"SELECT meta_title,meta_keywords,meta_desc FROM video_categories where urlPage='".$_GET['id']."'");
$rowsMt = mysqli_fetch_array($sqlMt);
$siteTitle = $rowsMt['meta_title'];
$keywordContent = $rowsMt['meta_keywords'];
$descContent = $rowsMt['meta_desc'];
}else if($basePth=="contact.php"){
$metaAry = metaTags(3);
$siteTitle = $metaAry['meta_title'];
$keywordContent = $metaAry['meta_keywords'];
$descContent = $metaAry['meta_desc'];
}else if($basePth=="newsVideos.php"){
$metaAry = metaTags(4);
$siteTitle = $metaAry['meta_title'];
$keywordContent = $metaAry['meta_keywords'];
$descContent = $metaAry['meta_desc'];
}else{
if($basePth=="advertiseWithUs.php"){
$siteTitle = "Advertisement With Us";
}else{
$metaAry = metaTags(1);
$siteTitle = $metaAry['meta_title'];
}
$keywordContent = $metaAry['meta_keywords'];
$descContent = $metaAry['meta_desc'];
}
return '<title>'.$siteTitle.' | '.$siteName.'</title>
<meta name="keywords" content="'.$keywordContent.'" /><meta name="description" content="'.$descContent.'" />';
}
function urlOfPage($tableName,$name,$sno){
global $conn;
global $pageUrlSet;
$pageUrlSet = @str_replace(array(" ","'",'.',',',"?","&",'---','--'),array("-",'','-','-','','and','-','-'),@strtolower(@substr(@trim($name),0,50)));
$sql = mysqli_query($conn,"SELECT urlPage FROM ".$tableName." WHERE urlPage='".$pageUrlSet."'");
$numRow = mysqli_num_rows($sql);
if($numRow>0){
$sno++;
if($sno>2){
$orginalPageUrl = substr($pageUrlSet, 0, -2)."-".$sno;
$pageUrlSet = $orginalPageUrl;
}else{
$pageUrlSet = $pageUrlSet."-".$sno;
}
urlOfPage($tableName,$pageUrlSet,$sno);
}else{
$pageUrlSet = $pageUrlSet;
}
return $pageUrlSet;
}
function checkUpdateUrl($tableName,$fieldName,$newName,$id){
global $conn;
$sql = mysqli_query($conn,"SELECT ".$fieldName." FROM ".$tableName." WHERE id='".$id."'");
$rows = mysqli_fetch_array($sql);
if(ucfirst($rows[$fieldName]) != ucfirst($newName)){
$status = 1;
}else{
$status = 0;
}
return $status;
}
function checkTxtField($stg){
global $conn;
if(!preg_match("/^[a-zA-Z ]*$/",$stg)) { return false; }else{ return true; }
}
function checkPasswordField($stg){
if(!preg_match("/^[a-zA-Z0-9]*$/",$stg)) { return false; }else{ return true; }
}
function checkTextareaField($stg){
if($stg!=""){
if(!preg_match("/[A-Za-z0-9_~\-?.!:,@#\$%\^&\*\(\)]+$/",trim($stg))) { return false; }else{ return true; }
}else{ return false; }
}
function checkPhoneNumber($no){
if(ctype_digit($no) && (strlen($no)==10)) {
return true;
}else{
return false;
}
}
function checkNumber($no){
if(ctype_digit($no)){ return true; }else{ return false; }
}
function checkEmail($e){
$pattern = "^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$";
if (eregi($pattern, $e)){ return true;
}else{ return false; }
}
function tablePaging($pgSql,$per_page,$page){
global $conn;
global $basePth;
/*if($basePth=="musicVideo.php"){
$page_url=((isset($_GET['q']))?'?q='.$_GET['q'].'&':'?');
}else if($basePth=="celebrities.php"){
$page_url=((isset($_GET['q']))?'?q='.$_GET['q'].'&':'?');
}else{*/
$sq = "";
if(isset($_GET['q'])){ $sq='q='.$_GET['q'].'&'; }
$page_url=((isset($_GET['t']) && $_GET['t']!="")?'?t='.$_GET['t'].'&'.$sq:'?');
//}
$query = $pgSql;
$rec = mysqli_fetch_array(mysqli_query($conn,$query));
if(isset($rec['totalCount'])){
$total = $rec['totalCount'];
$adjacents = "2";
$page = ($page == 0 ? 1 : $page);
$start = ($page - 1) * $per_page;
$prev = $page - 1;
$next = $page + 1;
$setLastpage = ceil($total/$per_page);
$lpm1 = $setLastpage - 1;
$setPaginate = "";
if($setLastpage > 1)
{
$setPaginate .= "<ul class='pagination'>";
$setPaginate .= "<li class='setPage'>Page $page of $setLastpage</li>";
if ($setLastpage < 7 + ($adjacents * 2))
{
for ($counter = 1; $counter <= $setLastpage; $counter++)
{
if ($counter == $page)
$setPaginate.= "<li><a class='current_page'>$counter</a></li>";
else
$setPaginate.= "<li><a href='{$page_url}page=$counter'>$counter</a></li>";
}
}
elseif($setLastpage > 5 + ($adjacents * 2))
{
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$setPaginate.= "<li><a class='current_page'>$counter</a></li>";
else
$setPaginate.= "<li><a href='{$page_url}page=$counter'>$counter</a></li>";
}
$setPaginate.= "<li class='dot'>...</li>";
$setPaginate.= "<li><a href='{$page_url}page=$lpm1'>$lpm1</a></li>";
$setPaginate.= "<li><a href='{$page_url}page=$setLastpage'>$setLastpage</a></li>";
}
elseif($setLastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$setPaginate.= "<li><a href='{$page_url}page=1'>1</a></li>";
$setPaginate.= "<li><a href='{$page_url}page=2'>2</a></li>";
$setPaginate.= "<li class='dot'>...</li>";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$setPaginate.= "<li><a class='current_page'>$counter</a></li>";
else
$setPaginate.= "<li><a href='{$page_url}page=$counter'>$counter</a></li>";
}
$setPaginate.= "<li class='dot'>..</li>";
$setPaginate.= "<li><a href='{$page_url}page=$lpm1'>$lpm1</a></li>";
$setPaginate.= "<li><a href='{$page_url}page=$setLastpage'>$setLastpage</a></li>";
}
else
{
$setPaginate.= "<li><a href='{$page_url}page=1'>1</a></li>";
$setPaginate.= "<li><a href='{$page_url}page=2'>2</a></li>";
$setPaginate.= "<li class='dot'>..</li>";
for ($counter = $setLastpage - (2 + ($adjacents * 2)); $counter <= $setLastpage; $counter++)
{
if ($counter == $page)
$setPaginate.= "<li><a class='current_page'>$counter</a></li>";
else
$setPaginate.= "<li><a href='{$page_url}page=$counter'>$counter</a></li>";
}
}
}
if ($page < $counter - 1){
$setPaginate.= "<li><a href='{$page_url}page=$next'>Next</a></li>";
$setPaginate.= "<li><a href='{$page_url}page=$setLastpage'>Last</a></li>";
}else{
$setPaginate.= "<li><a class='current_page'>Next</a></li>";
$setPaginate.= "<li><a class='current_page'>Last</a></li>";
}
$setPaginate.= "</ul>\n";
}
return $setPaginate;
}
}
function advertmentSingle($postnID){
global $conn;
global $siteUrlMain;
$sql = mysqli_query($conn,"SELECT a.title,a.advImg,a.advURL,ap.advSize FROM advertisements as a,advertisement_position as ap WHERE ap.id=a.advPositionID AND a.advStatus='1' AND a.advPositionID='".$postnID."' ORDER BY RAND() LIMIT 1 ");
$numRow = mysqli_num_rows($sql);
if($numRow>0){
$rows = mysqli_fetch_array($sql);
return '<a href="'.$rows['advURL'].'"><img class="img-responsive" src="'.$siteUrlMain.'imgPath?src='.$siteUrlMain.'img/'.$rows['advImg'].'&'.$rows['advSize'].'&zc=2" alt="'.$rows['title'].'"></a>';
}else{
return false;
}
}
function mappingTotalArea($id){
global $conn;
$sql = mysqli_query($conn,"SELECT count(id) as t FROM product_mapping_coords WHERE pmID='".$id."'");
$rows = mysqli_fetch_array($sql);
return $rows['t'];
}
function mappingImgTotal($id){
global $conn;
$sql = mysqli_query($conn,"SELECT count(id) as t FROM product_mapping WHERE pmcID='".$id."'");
$rows = mysqli_fetch_array($sql);
return $rows['t'];
}
function mappingCateTotal($id){
global $conn;
$sql = mysqli_query($conn,"SELECT count(id) as t FROM product_mapping_cate WHERE cID='".$id."'");
$rows = mysqli_fetch_array($sql);
return $rows['t'];
}
function productMappingCateName($id){
global $conn;
$sql = mysqli_query($conn,"SELECT cateName FROM product_mapping_cate where id='".$id."'");
$rows = mysqli_fetch_array($sql);
return $rows['cateName'];
}
function mappingImgSortNo($id){
global $conn;
$sql = mysqli_query($conn,"SELECT sortOrder FROM product_mapping WHERE pmcID='".$id."' ORDER BY id DESC LIMIT 1");
$rows = mysqli_fetch_array($sql);
return ($rows['sortOrder']+1);
}
function monthName($id){
$month = array("January","February","March","April","May","June","July","August","September","October","November","December");
return $month[$id];
}
function issueTypeNm($id){
global $conn;
$sql = mysqli_query($conn,"SELECT issueType FROM issue_type where id='".$id."'");
$rows = mysqli_fetch_array($sql);
return $rows['issueType'];
}
?>