Contact Us : +91 7200 00 5928

FileToBeUploaded = $InFile; $FullFileName = trim($InFile["name"]); $length = strlen($FullFileName); $pos = strrpos($FullFileName, "."); if ($pos === false) return false; if ($length - $pos < 3 || $pos < 1) return false; $this->ValidExtension = $InputValidExt; $this->FileName = substr($FullFileName, 0, $pos); $this->File_Extension = strtolower(substr($FullFileName, $pos + 1, $length - $pos - 1)); $this->File_Path = $InputFilePath; $this->Prefix = $Prefix; if ($InputFileName != NULL && $InputFileName != "") $this->FileName = $InputFileName; return true; } function AssignFileName($InputFileName) { $this->FileName = $InputFileName; } function AssignFilePath($InputFilePath) { $this->File_Path = $InputFilePath; } function AssignFilePrefix($Prefix) { $this->Prefix = $Prefix; } function isNotEmptyFile() { $err = ""; if (!isset($this->FileToBeUploaded)) { $err .= "Empty file"; return false; } elseif ( !is_uploaded_file( $this->FileToBeUploaded['tmp_name'] ) ) { $err .= "Empty file"; return false; } return true; } function Check_Size() { if ( $this->FileToBeUploaded["size"] > MAX_FILE_SIZE) return false; else return true; } function Check_Valid_Ext() { if ( $this->ValidExtension == "*" ) return true; $ExtArray = array_filter(explode(",", $this->ValidExtension)); //print_r($ExtArray); if ( in_array($this->File_Extension, $ExtArray) ) return true; else return false; } function Upload() { if ( move_uploaded_file( $this->FileToBeUploaded["tmp_name"], $this->Prefix . $this->File_Path . "/". $this->FileName . "." . $this->File_Extension) ) return $this->File_Path . ($this->File_Path!=''?"/":''). $this->FileName . "." . $this->File_Extension; else return ""; } function AssignAndCheck($argvs=array()){ $argvs=is_array($argvs)?$argvs:array(); extract($argvs); $FileNotErrorBool = FALSE; if( $FileRef["error"] == 0 && $FileRef["size"] > 0 ){ $File_Error = ""; $File_Error .= $this->Check_Val(); $this->AssignFile($FileRef, $Extension, $Path, $PathPrefix, $FileName); if( $this->Check_Size() ){ if ( !$this->Check_Valid_Ext() ){ $File_Error .= "InValid File Extension." . ( isset($this->File_Extension) && $this->File_Extension != "" ? "Enter ".$Extension ." format file" : "") .""; } if ( $this->isNotEmptyFile() && $File_Error == ""){ return array('Type'=>2); } else{ $FileNameError = $File_Error; } } else{ $FileNameError = "Your are not able to upload more than " . MAX_FILE_SIZE_IN_MB . " "; } return array('Type'=>1, 'ErrorNo'=>2, 'Error'=>$FileNameError); } else return array('Type'=>1, 'ErrorNo'=>1, 'Error'=>'Upload File'); } } ?> dbconn,$Sql); return mysqli_insert_id() ; } function updateSql($Sql){ $data = new DatabaseConnection(); mysqli_query($data->dbconn,$Sql); return mysqli_affected_rows() ; } function deleteSql($Sql){ $data = new DatabaseConnection(); mysqli_query($data->dbconn,$Sql); return mysqli_affected_rows() ; } function sExecuteSql($Sql){ $data = new DatabaseConnection(); $Resource = mysqli_query($data->dbconn,$Sql); $Row = @mysqli_fetch_object($Resource) ; @mysqli_free_result($Resource); return $Row ; } function mExecuteSql($Sql){ $data = new DatabaseConnection(); $Resource = mysqli_query($data->dbconn,$Sql); while($Row = @mysqli_fetch_object($Resource)) {$Rs[] = $Row;} @mysqli_free_result($Resource); return $Rs ; } function getNumRows($Sql) { $data = new DatabaseConnection(); $Resource = mysqli_query($data->dbconn,$Sql); $rowCount= mysqli_num_rows($Resource); @mysqli_free_result($Resource); return $rowCount; } function mSelectHash($Sql){ $data = new DatabaseConnection(); $Resource = mysqli_query($data->dbconn,$Sql); return db::rowsToHash($Resource); } function sSelectHash($Sql){ $data = new DatabaseConnection(); $Resource = mysqli_query($data->dbconn,$Sql); return db::rowToHash($Resource); } function rowsToHash($result) { if (mysqli_num_rows($result)==0) return false; $ret = array(); $j=0; while($thisrow=mysqli_fetch_row($result)) { $i = 0; while ($i < mysqli_num_fields($result)) { $meta = mysqli_fetch_field($result, $i); $ret[$j][$meta->name] = $thisrow[$i]; $i++; } $j++; } return $ret; } function rowToHash($result) { global $logger; if (mysqli_num_rows($result)==0) { return false; } $i = 0; $ret = mysqli_fetch_row($result); while ($i < mysqli_num_fields($result)) { $meta = mysqli_fetch_field($result, $i); $ret[$meta->name] = $ret[$i]; $i++; } return $ret; } function SelectFilter($table,$fields="*",$where="",$order_by="",$order="ASC",$limit=1000,$offset=0) { $data = new DatabaseConnection(); $sql = "SELECT " . $fields . " FROM " . $table; if ($where != "") { $sql = $sql + " WHERE " . $where; } if ($order_by != "") { $sql = $sql + " ORDER BY " . $order_by . " " . $order; } $sql = $sql + " LIMIT " . $limit; if ($offset != "") { $sql = $sql + " OFFSET " . $offset; } $result = mysqli_query($data->dbconn,$sql) or die(mysqli_error()); return $result; } } ?>array('MAX(`Position`)')))); $Position = $HierDtl[0]->Position + 1; $argvs['Position'] = $Position;*/ $qryBuildArr = array() ; foreach($argvs as $K=>$V) { if(!empty($V) && $K!='TableName' && $K!='showSQL') $qryBuildArr[] = "`".$K."`='".$V."'" ; } $qryBuilt = implode(', ', $qryBuildArr); $SQL = 'INSERT INTO `'.constant($TableName).'` SET ' . $qryBuilt . ' ' ; if($showSQL=='YES'){ echo $SQL; } $Id = dB::insertSql($SQL); return $Id; } function selectRecords($sval="") { if(unserialize($sval)) $argvs = unserialize($sval); elseif(is_array($sval)) $argvs = $sval; $argvs=is_array($argvs)?$argvs:array(); extract($argvs); //pagination $retCountOnly = $COUNT == 1 ; $start = (int)$start ; $limit = (int)$limit ; $paging = '' ; if($limit>0) { $paging = 'LIMIT ' . $start . ', ' . $limit ; } //pagination if(isset($Where)) { //print_r($Where); if(empty($Condition)) $Condition = "AND"; $qryBuildArr = array(); foreach($Where as $K=>$V) { if(strstr($V,':::')) { $v1 = explode(':::',$V); /** * $qryBuildArr[] = $K." ".$v1[0]." '".$v1[1]."'"; * single quote removed for the value part. * For Date condition. */ $qryBuildArr[] = $K." ".$v1[0]." ".$v1[1].""; } else { $qryBuildArr[] = $K."='".$V."'"; } } $qryBuilt = 'WHERE ' . implode(" $Condition ", $qryBuildArr); } if($subqry!='') $qryBuilt.=$subqry; if(isset($Group)) { $qryBuilt.= ' GROUP BY '.$Group; } if(isset($Orderby)) { if(empty($Sort)) $Sort = "DESC"; $qryBuilt.= ' ORDER BY '.$Orderby.' '.$Sort; } if(isset($Fields)) { $fieldsel = ""; foreach($Fields as $K=>$V) { if($K>0) $fieldsel .= ","; $fieldsel .= $V; } } else $fieldsel = "*"; $fieldsSel = $retCountOnly ? 'COUNT(*) AS \'TOTAL\'' : $fieldsel ; $SQL = " SELECT $fieldsSel FROM `".constant($TableName)."` ".$qryBuilt; if($showSQL=='YES'){ echo $SQL; } if($retCountOnly) { $row = dB::sExecuteSql($SQL); return $row->TOTAL ; } else { $SQL = $SQL . ' '. $paging ; return dB::mExecuteSql($SQL); } } function updateRecord($sval="") { if(unserialize($sval)) $argvs = unserialize($sval); elseif(is_array($sval)) $argvs = $sval; $argvs=is_array($argvs)?$argvs:array(); extract($argvs); $qryBuildArr = array() ; foreach($Values as $K=>$V) { //if(!empty($V) && $K!='TableName') //sat - empty values not updating if($K!='TableName') $qryBuildArr[] = "`".$K."`='".$V."'" ; } $qryBuilt = implode(', ', $qryBuildArr); if(isset($Where)) { if(empty($Condition)) $Condition = "AND"; $qryBuildArr = array(); foreach($Where as $K=>$V) { if(strstr($V,':::')) { $v1 = explode(':::',$V); /** * $qryBuildArr[] = $K." ".$v1[0]." '".$v1[1]."'"; * single quote removed for the value part. * For Date condition. */ $qryBuildArr[] = $K." ".$v1[0]." ".$v1[1].""; } else { $qryBuildArr[] = $K."='".$V."'"; } } $qryBuiltWhere = ' WHERE ' . implode(" $Condition ", $qryBuildArr); } else { $qryBuiltWhere=" Where `Id` = '$Id'"; } $SQL = " UPDATE `".constant($TableName)."` SET " . $qryBuilt .$qryBuiltWhere; if($showSQL=='YES'){ echo $SQL; } if(dB::updateSql($SQL)){ return true; } } function deleteRecord_old($argvs = array()) { $argvs=is_array($argvs)?$argvs:array(); extract($argvs); if($Id>0) { $SQL = " DELETE FROM `".constant($TableName)."` WHERE `Id` = '".$Id."' " ; if($showSQL=='YES'){ echo $SQL; } if(dB::deleteSql($SQL)){ return true; } } } function deleteProjectThreadRecord($argvs = array()) { $argvs=is_array($argvs)?$argvs:array(); extract($argvs); if($MId>0) { $SQL = " DELETE FROM `".constant($TableName)."` WHERE `MId` = '".$MId."' " ; if($showSQL=='YES'){ echo $SQL; } if(dB::deleteSql($SQL)){ return true; } } } function deleteRecord($argvs = array()) { $argvs=is_array($argvs)?$argvs:array(); extract($argvs); // if($Id>0) // { if(isset($Where)) { if(empty($Condition)) $Condition = "AND"; $qryBuildArr = array(); foreach($Where as $K=>$V) { if(strstr($V,':::')) { $v1 = explode(':::',$V); /** * $qryBuildArr[] = $K." ".$v1[0]." '".$v1[1]."'"; * single quote removed for the value part. * For Date condition. */ $qryBuildArr[] = $K." ".$v1[0]." ".$v1[1].""; } else { $qryBuildArr[] = $K."='".$V."'"; } } $qryBuiltWhere = ' WHERE ' . implode(" $Condition ", $qryBuildArr); } else { $qryBuiltWhere=" Where `Id` = '$Id'"; } $SQL = " DELETE FROM `".constant($TableName)."` ".$qryBuiltWhere; ; if($showSQL=='YES'){ echo $SQL; } if(dB::deleteSql($SQL)){ return true; } //} } } ?>id!='') $sub_qry[] .= " id=".$this->id; if($this->link_type!='') $sub_qry[] .= "`link_type`='".$this->link_type."'"; if($this->link!='') $sub_qry[] .= "`link`='".$this->link."'"; if($this->fields=='') $this->fields='*'; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".iDosT_SocIalLinKS." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getSocialLinkAllDtls() { $query = "SELECT * FROM ".iDosT_SocIalLinKS; return dB::mExecuteSql($query); } function getSocialLinkList() { echo $query = "select COUNT(*) AS \"Total\", ( CASE link_type WHEN \"FB\" THEN id END ) AS \"Facebook\", ( CASE link_type WHEN \"YT\" THEN id END ) AS \"YouTube\" FROM ".iDosT_SocIalLinKS; return dB::sExecuteSql($query); } // Contact Functions function insertContact($contact_name, $company_name, $ie_code, $mobile_no, $email_id, $address) { $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".iDosT_ContAct."` (`contact_name`, `company_name`, `ie_code`, `mobile_no`, `email_id`, `address`, `added_date`) VALUES ('$contact_name', '$company_name', '$ie_code', '$mobile_no', '$email_id', '$address', '$date_time')"; return $insertId=dB::insertSql($query); } function updateContact($contact_name, $company_name, $ie_code, $mobile_no, $email_id, $address, $id) { $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".iDosT_ContAct." SET contact_name='$contact_name', company_name='$company_name', ie_code='$ie_code', mobile_no='$mobile_no', email_id='$email_id', address='$address', updated_date='$date_time' WHERE id='$id'"; return dB::updateSql($query); } function deleteContact($id) { $query="DELETE FROM ".iDosT_ContAct." WHERE id = '".$id."'"; return db::deleteSql($query); } function getAllContactDtls() { if($this->id!='') $sub_qry[] .= " id=".$this->id; if($this->contact_name!='') $sub_qry[] .= "`ie_code`='".$this->ie_code."'"; if($this->company_name!='') $sub_qry[] .= "`email_id`='".$this->email_id."'"; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".iDosT_ContAct." ".$subqry.$sort_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getContactAllDtls() { $query = "SELECT * FROM ".iDosT_ContAct; return dB::mExecuteSql($query); } // Categories Functions function insertCategory($category, $hosting, $order_num, $category_status) { $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".IDHOST_CateGories."` (`category`, `host_name`, `order_num`, `category_status`,`added_date`) VALUES ('$category', '$hosting', '$order_num', '$category_status', '$date_time')"; return $insertIdIndex=dB::insertSql($query); } function updateCategory($category, $hosting, $order_num, $category_status, $id) { $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".IDHOST_CateGories." SET category='$category', host_name= '$hosting', order_num='$order_num', category_status='$category_status', updated_date='$date_time' WHERE id='$id'"; return dB::updateSql($query); } function updateCategoryByField($field, $fieldvalue, $id){ $query=" UPDATE ". IDHOST_CateGories ." SET ".$field." = '".$fieldvalue."' WHERE `id`='".$id."'"; return dB::updateSql($query); } function deleteCategory($id) { $query="DELETE FROM ".IDHOST_CateGories." WHERE id = '".$id."'"; return db::deleteSql($query); } function getAllCategoryDtls() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->not_id!='') $sub_qry[] = " id!='".$this->not_id."'"; if($this->category!='') $sub_qry[] .= "`category`='".$this->category."'"; if($this->category_status!='') $sub_qry[] .= "`category_status`='".$this->category_status."'"; if($this->order_num!='') $sub_qry[] .= "`order_num`='".$this->order_num."'"; if($this->host!='') $sub_qry[] .= "`host_name`='".$this->host."'"; if($this->fields=='') $this->fields='*'; if($this->hosts!='') $host= " WHERE ". $this->host; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".IDHOST_CateGories." ".$hosts.$subqry.$sort_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getCategoryAllDtls() { $query = "SELECT * FROM ".IDHOST_CateGories; return dB::mExecuteSql($query); } function getCategoryList() { $query = "SELECT category FROM ".IDHOST_CateGories." WHERE category_status='A' ORDER BY order_num ASC"; $result = dB::mExecuteSql($query); $catArr=array(); if(count($result)>0) { foreach($result as $kk=>$vv) { $catArr[] = $vv->category; } } $catList = implode(", ", $catArr); return $catList; } //Content Functions function updateContent($description, $id) { $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".iDHOST_Content." SET text='$description', date='$date_time' WHERE id='$id'"; return dB::updateSql($query); } function updateContentByField($field, $fieldvalue, $id){ $query=" UPDATE ". iDHOST_Content." SET ".$field." = '".$fieldvalue."' WHERE `id`='".$id."'"; return dB::updateSql($query); } function deleteContent($id) { $query="DELETE FROM ".iDHOST_Content." WHERE id = '".$id."'"; return db::deleteSql($query); } function getAllContent() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->text!='') $sub_qry[] .= "`text`='".$this->text."'"; if($this->fields=='') $this->fields='*'; if($this->hosts!='') $host= " WHERE ". $this->host; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".iDHOST_Content." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getContentAllDtls() { $query = "SELECT * FROM ".iDHOST_Content; return dB::mExecuteSql($query); } // Products Functions function insertProduct($category_id, $subcategory, $url, $rate, $date, $description, $product_status) { $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".iDHOST_ProDucTs."` (`category_id`, `subcategory`, `url`, `rate`, `date_format`, `description`, `product_status`, `added_date`) VALUES ('$category_id', '$subcategory', '$url', '$rate', '$date', '$description', '$product_status', '$date_time')"; return $insertIdIndex=dB::insertSql($query); } function updateProduct ($category_id, $subcategory, $url, $rate, $date, $description, $product_status, $id) { $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".iDHOST_ProDucTs." SET category_id='$category_id', subcategory='$subcategory', url='$url', rate ='$rate', date_format= '$date', description='$description', product_status='$product_status', updated_date='$date_time' WHERE id='$id'"; return dB::updateSql($query); } function updateProductByField($field, $fieldvalue, $id){ $query=" UPDATE ". iDHOST_ProDucTs ." SET ".$field." = '".$fieldvalue."' WHERE `id`='".$id."'"; return dB::updateSql($query); } function deleteProduct($id) { $query="DELETE FROM ".iDHOST_ProDucTs." WHERE id = '".$id."'"; return db::deleteSql($query); } function getAllProductDtls() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->category_id!='') $sub_qry[] .= "`category_id`='".$this->category_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->rate!='') $sub_qry[] .= "`rate`='".$this->rate."'"; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->product_status!='') $sub_qry[] .= "`product_status`='".$this->product_status."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".iDHOST_ProDucTs." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getAllProductDtlss() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->category_id!='') $sub_qry[] .= "`category_id`='".$this->category_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->rate!='') $sub_qry[] .= "`rate`='".$this->rate."'"; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->product_status!='') $sub_qry[] .= "`product_status`='".$this->product_status."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->range!='') $this->range="MIN(rate)"; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->range." from ".iDHOST_ProDucTs; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getProductAllDtls() { $query = "SELECT * FROM ".iDHOST_ProDucTs; return dB::mExecuteSql($query); } function getProductMaxProductId() { $query = "SELECT max(id) as LastId FROM ".iDHOST_ProDucTs; return dB::sExecuteSql($query); } function getProductmin() { $query = "SELECT min(rate) as LastId FROM ".iDHOST_ProDucTs; return dB::sExecuteSql($query); } // Plan Title Functions function insertTitle($title, $order_num, $plan_status) { $dB = new dB(); $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".MPN_TITLE."` (`title`, `order_num`, `plan_status`, `added_date`) VALUES ('$title', '$order_num', '$plan_status', '$date_time')"; return $insertIdIndex= $dB->insertSql($query); } function updateTitle($title, $order_num, $plan_status, $id) { $dB = new dB(); $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".MPN_TITLE." SET title='$title', order_num='$order_num', plan_status='$plan_status', updated_date='$date_time' WHERE id='$id'"; return $dB->updateSql($query); } function updateTitleByField($field, $fieldvalue, $id){ $dB = new dB(); $query=" UPDATE ". MPN_TITLE ." SET ".$field." = '".$fieldvalue."' WHERE `id`='".$id."'"; return $dB->updateSql($query); } function deleteTitle($id) { $dB = new dB(); $query="DELETE FROM ".MPN_TITLE." WHERE id = '".$id."'"; return $dB->deleteSql($query); } function getAllTitleDtls() { $dB = new dB(); if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->not_id!='') $sub_qry[] = " id!='".$this->not_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->plan_status!='') $sub_qry[] .= "`plan_status`='".$this->plan_status."'"; if($this->order_num!='') $sub_qry[] .= "`order_num`='".$this->order_num."'"; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".MPN_TITLE." ".$subqry.$sort_qry; if($this->id=='') return $dB->mExecuteSql($query); else return $dB->sExecuteSql($query); } function getTitleAllDtls() { $dB = new dB(); $query = "SELECT * FROM ".MPN_TITLE; return $dB->mExecuteSql($query); } function getTitleList() { $dB = new dB(); $query = "SELECT title FROM ".MPN_TITLE." WHERE plan_status='A' ORDER BY order_num ASC"; $result = $dB->mExecuteSql($query); $titleArr=array(); if(count($result)>0) { foreach($result as $kk=>$vv) { $titleArr[] = $vv->title; } } $catList = implode(", ", $titleArr); return $catList; } // Plan Detail Functions function insertPlanDetail($category_name, $plan_title, $image, $url_link, $status) { $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".IDHOST_PLANDETAIL."` (`category_name`, `plan_title`, `image`, `url_link`, `status`, `added_date`) VALUES ('$category_name', '$plan_title', '$image', '$url_link', '$status', '$date_time')"; return $insertIdIndex=dB::insertSql($query); } function updatePlanDetail ($category_name, $plan_title, $image, $url_link, $status, $id) { $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".IDHOST_PLANDETAIL." SET category_name='$category_name', plan_title='$plan_title', image ='$image', url_link='$url_link', status='$status', updated_date='$date_time' WHERE id='$id'"; return dB::updateSql($query); } function deletePlanDetail($id) { $query="DELETE FROM ".IDHOST_PLANDETAIL." WHERE id = '".$id."'"; return db::deleteSql($query); } function getAllPlanDetailDtls() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->category_name!='') $sub_qry[] .= "`category_name`='".$this->category_name."'"; if($this->plan_title!='') $sub_qry[] .= "`plan_title`='".$this->plan_title."'"; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->url_link!='') $sub_qry[] .= "`url_link`='".$this->url_link."'"; if($this->status!='') $sub_qry[] .= "`status`='".$this->status."'"; if($this->status!='') $sub_qry[] .= "`status`='".$this->status."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".IDHOST_PLANDETAIL." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getPlanDetailAllDtls() { $query = "SELECT * FROM ".IDHOST_PLANDETAIL; return dB::mExecuteSql($query); } // Domain Functions function insertDomain($domain, $frate, $crate) { $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".iDosT_RateDoMAin."` (`domain_name`, `actual_prices`, `current_prices`) VALUES ('$domain', '$frate', '$crate')"; return $insertIdIndex=dB::insertSql($query); } function updateDomain($domain, $frate, $crate, $id) { $query = "UPDATE ".iDosT_RateDoMAin." SET domain_name='$domain', actual_prices='$frate', current_prices ='$crate' WHERE id='$id'"; return dB::updateSql($query); } function updateDomainByField($field, $fieldvalue, $id){ $query=" UPDATE ". iDosT_RateDoMAin." SET ".$field." = '".$fieldvalue."' WHERE `id`='".$id."'"; return dB::updateSql($query); } function getAllDomainDtls() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->domain!='') $sub_qry[] .= "`domain_name`='".$this->domain."'"; if($this->actual!='') $sub_qry[] .= "`actual_prices`='".$this->actual."'"; if($this->current!='') $sub_qry[] .= "`current_prices`='".$this->current."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".iDosT_RateDoMAin." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function deleteDomain($id) { $query="DELETE FROM ".iDosT_RateDoMAin." WHERE id = '".$id."'"; return db::deleteSql($query); } function getDomainAllDtls() { $query = "SELECT * FROM ".iDosT_RateDoMAin; return dB::mExecuteSql($query); } function getDomainMaxProductId() { $query = "SELECT max(id) as LastId FROM ".iDosT_RateDoMAin; return dB::sExecuteSql($query); } function getDomainmin() { $query = "SELECT min(rate) as LastId FROM ".iDosT_RateDoMAin; return dB::sExecuteSql($query); } // promo code function insertPromo($category_id, $title, $code, $links, $description, $dates) { $query = "INSERT INTO `".iDHOST_PrmO."` (`category_id`, `title`, `code`, `links`, `description`, `expriy`) VALUES ('$category_id', '$title', '$code', '$links', '$description', '$dates')"; return $insertIdIndex=dB::insertSql($query); } function updatePromo($category_id, $title, $code, $links, $description, $dates, $id) { $query = "UPDATE ".iDHOST_PrmO." SET category_id='$category_id', title='$title', code='$code', links='$links', description ='$description ', expriy='$dates' WHERE pro_id='$id'"; return dB::updateSql($query); } function updatePromoByField($field, $fieldvalue, $id){ $query=" UPDATE ".iDHOST_PrmO." SET ".$field." = '".$fieldvalue."' WHERE `pro_id`='".$id."'"; return dB::updateSql($query); } function deletePromo($id) { $query="DELETE FROM ".iDHOST_PrmO." WHERE pro_id = '".$id."'"; return db::deleteSql($query); } function getAllPromoDlts() { if($this->id!='') $sub_qry[] = "pro_id=".$this->id; if($this->category_id!='') $sub_qry[] .= "`category_id`='".$this->category_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->code!='') $sub_qry[] .= "`code`='".$this->code."'"; if($this->links!='') $sub_qry[] .= "`link`='".$this->links."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->expiry!='') $sub_qry[] .= "`expiry`='".$this->expiry."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".iDHOST_PrmO." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getPromoAllDtls() { $query = "SELECT * FROM ".iDHOST_PrmO; return dB::mExecuteSql($query); } function getPromoMaxProductId() { $query = "SELECT max(id) as LastId FROM ".iDHOST_PrmO; return dB::sExecuteSql($query); } function getPromomin() { $query = "SELECT min(rate) as LastId FROM ".iDHOST_PrmO; return dB::sExecuteSql($query); } // Mail Functions function insertMail($category_id, $subcategory, $url, $rate, $date, $description, $product_status) { $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".iDHOST_Mail."` (`category_id`, `subcategory`, `url`, `rate`, `date_format`, `description`, `product_status`, `added_date`) VALUES ('$category_id', '$subcategory', '$url', '$rate', '$date', '$description', '$product_status', '$date_time')"; return $insertIdIndex=dB::insertSql($query); } function updateMail ($category_id, $subcategory, $url, $rate, $date, $description, $product_status, $id) { $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".iDHOST_Mail." SET category_id='$category_id', subcategory='$subcategory', url='$url', rate ='$rate', date_format= '$date', description='$description', product_status='$product_status', updated_date='$date_time' WHERE id='$id'"; return dB::updateSql($query); } function updateMailByField($field, $fieldvalue, $id){ $query=" UPDATE ". iDHOST_Mail ." SET ".$field." = '".$fieldvalue."' WHERE `id`='".$id."'"; return dB::updateSql($query); } function deleteMail($id) { $query="DELETE FROM ".iDHOST_Mail." WHERE id = '".$id."'"; return db::deleteSql($query); } function getAllMailDtls() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->category_id!='') $sub_qry[] .= "`category_id`='".$this->category_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->rate!='') $sub_qry[] .= "`rate`='".$this->rate."'"; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->product_status!='') $sub_qry[] .= "`product_status`='".$this->product_status."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".iDHOST_Mail." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getAllMailDtlss() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->category_id!='') $sub_qry[] .= "`category_id`='".$this->category_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->rate!='') $sub_qry[] .= "`rate`='".$this->rate."'"; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->product_status!='') $sub_qry[] .= "`product_status`='".$this->product_status."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->range!='') $this->range="MIN(rate)"; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->range." from ".iDHOST_Mail; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getMailAllDtls() { $query = "SELECT * FROM ".iDHOST_Mail; return dB::mExecuteSql($query); } function getMailMaxProductId() { $query = "SELECT max(id) as LastId FROM ".iDHOST_Mail; return dB::sExecuteSql($query); } function getMailmin() { $query = "SELECT min(rate) as LastId FROM ".iDHOST_Mail; return dB::sExecuteSql($query); } // SMS Functions function insertSms($category_id, $subcategory, $url, $rate, $date, $description, $product_status) { $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".iDHOST_Sms."` (`category_id`, `subcategory`, `url`, `rate`, `date_format`, `description`, `product_status`, `added_date`) VALUES ('$category_id', '$subcategory', '$url', '$rate', '$date', '$description', '$product_status', '$date_time')"; return $insertIdIndex=dB::insertSql($query); } function updateSms ($category_id, $subcategory, $url, $rate, $date, $description, $product_status, $id) { $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".iDHOST_Sms." SET category_id='$category_id', subcategory='$subcategory', url='$url', rate ='$rate', date_format= '$date', description='$description', product_status='$product_status', updated_date='$date_time' WHERE id='$id'"; return dB::updateSql($query); } function updateSmsByField($field, $fieldvalue, $id){ $query=" UPDATE ". iDHOST_Sms ." SET ".$field." = '".$fieldvalue."' WHERE `id`='".$id."'"; return dB::updateSql($query); } function deleteSms($id) { $query="DELETE FROM ".iDHOST_Sms." WHERE id = '".$id."'"; return db::deleteSql($query); } function getAllSmsDtls() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->category_id!='') $sub_qry[] .= "`category_id`='".$this->category_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->rate!='') $sub_qry[] .= "`rate`='".$this->rate."'"; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->product_status!='') $sub_qry[] .= "`product_status`='".$this->product_status."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".iDHOST_Sms." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getAllSmsDtlss() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->category_id!='') $sub_qry[] .= "`category_id`='".$this->category_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->rate!='') $sub_qry[] .= "`rate`='".$this->rate."'"; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->product_status!='') $sub_qry[] .= "`product_status`='".$this->product_status."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->range!='') $this->range="MIN(rate)"; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->range." from ".iDHOST_Sms; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getSmsAllDtls() { $query = "SELECT * FROM ".iDHOST_Sms; return dB::mExecuteSql($query); } function getSmsMaxProductId() { $query = "SELECT max(id) as LastId FROM ".iDHOST_Sms; return dB::sExecuteSql($query); } function getSmsmin() { $query = "SELECT min(rate) as LastId FROM ".iDHOST_Sms; return dB::sExecuteSql($query); } // Promotional SMS Functions function insertProSms($category_id, $subcategory, $url, $rate, $date, $description, $product_status) { $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".iDHOST_ProSms."` (`category_id`, `subcategory`, `url`, `rate`, `date_format`, `description`, `product_status`, `added_date`) VALUES ('$category_id', '$subcategory', '$url', '$rate', '$date', '$description', '$product_status', '$date_time')"; return $insertIdIndex=dB::insertSql($query); } function updateProSms ($category_id, $subcategory, $url, $rate, $date, $description, $product_status, $id) { $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".iDHOST_ProSms." SET category_id='$category_id', subcategory='$subcategory', url='$url', rate ='$rate', date_format= '$date', description='$description', product_status='$product_status', updated_date='$date_time' WHERE id='$id'"; return dB::updateSql($query); } function updateProSmsByField($field, $fieldvalue, $id){ $query=" UPDATE ". iDHOST_ProSms ." SET ".$field." = '".$fieldvalue."' WHERE `id`='".$id."'"; return dB::updateSql($query); } function deleteProSms($id) { $query="DELETE FROM ".iDHOST_ProSms." WHERE id = '".$id."'"; return db::deleteSql($query); } function getAllProSmsDtls() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->category_id!='') $sub_qry[] .= "`category_id`='".$this->category_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->rate!='') $sub_qry[] .= "`rate`='".$this->rate."'"; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->product_status!='') $sub_qry[] .= "`product_status`='".$this->product_status."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".iDHOST_ProSms." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getAllProSmsDtlss() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->category_id!='') $sub_qry[] .= "`category_id`='".$this->category_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->rate!='') $sub_qry[] .= "`rate`='".$this->rate."'"; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->product_status!='') $sub_qry[] .= "`product_status`='".$this->product_status."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->range!='') $this->range="MIN(rate)"; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->range." from ".iDHOST_ProSms; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getProSmsAllDtls() { $query = "SELECT * FROM ".iDHOST_ProSms; return dB::mExecuteSql($query); } function getProSmsMaxProductId() { $query = "SELECT max(id) as LastId FROM ".iDHOST_ProSms; return dB::sExecuteSql($query); } function getProSmsmin() { $query = "SELECT min(rate) as LastId FROM ".iDHOST_ProSms; return dB::sExecuteSql($query); } // OTP/API SMS Functions function insertOtpSms($category_id, $subcategory, $url, $rate, $date, $description, $product_status) { $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".iDHOST_OtpSms."` (`category_id`, `subcategory`, `url`, `rate`, `date_format`, `description`, `product_status`, `added_date`) VALUES ('$category_id', '$subcategory', '$url', '$rate', '$date', '$description', '$product_status', '$date_time')"; return $insertIdIndex=dB::insertSql($query); } function updateOtpSms ($category_id, $subcategory, $url, $rate, $date, $description, $product_status, $id) { $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".iDHOST_OtpSms." SET category_id='$category_id', subcategory='$subcategory', url='$url', rate ='$rate', date_format= '$date', description='$description', product_status='$product_status', updated_date='$date_time' WHERE id='$id'"; return dB::updateSql($query); } function updateOtpSmsByField($field, $fieldvalue, $id){ $query=" UPDATE ". iDHOST_OtpSms ." SET ".$field." = '".$fieldvalue."' WHERE `id`='".$id."'"; return dB::updateSql($query); } function deleteOtpSms($id) { $query="DELETE FROM ".iDHOST_OtpSms." WHERE id = '".$id."'"; return db::deleteSql($query); } function getAllOtpSmsDtls() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->category_id!='') $sub_qry[] .= "`category_id`='".$this->category_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->rate!='') $sub_qry[] .= "`rate`='".$this->rate."'"; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->product_status!='') $sub_qry[] .= "`product_status`='".$this->product_status."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".iDHOST_OtpSms." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getAllOtpSmsDtlss() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->category_id!='') $sub_qry[] .= "`category_id`='".$this->category_id."'"; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->rate!='') $sub_qry[] .= "`rate`='".$this->rate."'"; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->product_status!='') $sub_qry[] .= "`product_status`='".$this->product_status."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->range!='') $this->range="MIN(rate)"; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->range." from ".iDHOST_OtpSms; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getOtpSmsAllDtls() { $query = "SELECT * FROM ".iDHOST_OtpSms; return dB::mExecuteSql($query); } function getOtpSmsMaxProductId() { $query = "SELECT max(id) as LastId FROM ".iDHOST_OtpSms; return dB::sExecuteSql($query); } function getOtpSmsmin() { $query = "SELECT min(rate) as LastId FROM ".iDHOST_OtpSms; return dB::sExecuteSql($query); } // Top Bar Functions function insertTopBar($top_bar_value) { $dB = new dB(); $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".MPN_TOP_BAR."` (`top_bar_value`, `added_date`) VALUES ('$top_bar_value', '$date_time')"; return $insertId= $dB->insertSql($query); } function updateTopBar($top_bar_value, $id) { $dB = new dB(); $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".MPN_TOP_BAR." SET top_bar_value='$top_bar_value', updated_date='$date_time' WHERE id='$id'"; return $dB->updateSql($query); } function updateTopBarByField($field, $fieldvalue, $id){ $dB = new dB(); $date_time = date("Y-m-d H:i:s"); $query=" UPDATE ". MPN_TOP_BAR ." SET ".$field." = '".$fieldvalue."', updated_date='$date_time' WHERE `id`='".$id."'"; return $dB->updateSql($query); } function deleteTopBar($id) { $dB = new dB(); $query="DELETE FROM ".MPN_TOP_BAR." WHERE id = '".$id."'"; return $dB->deleteSql($query); } function getAllTopBarDtls() { $dB = new dB(); if($this->id!='') $sub_qry[] .= " id=".$this->id; if($this->top_bar_value!='') $sub_qry[] .= "`top_bar_value`='".$this->top_bar_value."'"; if($this->fields=='') $this->fields='*'; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".MPN_TOP_BAR." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return $dB->mExecuteSql($query); else return $dB->sExecuteSql($query); } function getTopBarAllDtls() { $dB = new dB(); $query = "SELECT * FROM ".MPN_TOP_BAR; return $dB->mExecuteSql($query); } // Slider Functions function insertSlider($image, $slider_status) { $dB = new dB(); $query = "INSERT INTO `".MPN_LANDING_SLIDER."` (`image`, `slider_status`) VALUES ('$image', '$slider_status')"; return $insertId=$dB->insertSql($query); } function updateSlider($image, $slider_status, $id) { $dB = new dB(); $query = "UPDATE ".MPN_LANDING_SLIDER." SET image='$image', slider_status='$slider_status' WHERE id='$id'"; return $dB->updateSql($query); } function updateSliderById($field, $field_value, $id) { $dB = new dB(); $query = "UPDATE ".MPN_LANDING_SLIDER." SET $field='$field_value' WHERE id='$id'"; return $dB->updateSql($query); } function deleteSlider($id) { $dB = new dB(); $query="DELETE FROM ".MPN_LANDING_SLIDER." WHERE id = '".$id."'"; return $dB->deleteSql($query); } function getAllSliderDtls() { $dB = new dB(); if($this->id!='') $sub_qry[] .= " id=".$this->id; if($this->image!='') $sub_qry[] .= "`image`='".$this->image."'"; if($this->slider_status!='') $sub_qry[] .= "`slider_status`='".$this->slider_status."'"; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".MPN_LANDING_SLIDER." ".$subqry.$sort_qry; if($this->id=='') return $dB->mExecuteSql($query); else return $dB->sExecuteSql($query); } function getSliderAllDtls() { $dB = new dB(); $query = "SELECT * FROM ".MPN_LANDING_SLIDER; return $dB->mExecuteSql($query); } function getProductMaxSliderId() { $dB = new dB(); $query = "SELECT max(id) as LastId FROM ".MPN_LANDING_SLIDER; return $dB->sExecuteSql($query); } // testmonials functions function insertTest($title, $description) { $date_time = date("Y-m-d H:i:s"); $query = "INSERT INTO `".MPN_TESTMONIALS."` (`title`, `description`, `time`) VALUES ('$title', '$description', '$date_time')"; return $insertIdIndex=dB::insertSql($query); } function updateTest($title, $description, $id) { $date_time = date("Y-m-d H:i:s"); $query = "UPDATE ".MPN_TESTMONIALS." SET title='$title', description='$description', time='$date_time' WHERE id='$id'"; return dB::updateSql($query); } function updateTestByField($field, $fieldvalue, $id){ $date_time = date("Y-m-d H:i:s"); $query=" UPDATE ". MPN_TESTMONIALS ." SET ".$field." = '".$fieldvalue."', updated_date='$date_time' WHERE `id`='".$id."'"; return dB::updateSql($query); } function deleteTest($id) { $query="DELETE FROM ".MPN_TESTMONIALS." WHERE id = '".$id."'"; return db::deleteSql($query); } function getAllTestDtls() { if($this->id!='') $sub_qry[] = " id=".$this->id; if($this->title!='') $sub_qry[] .= "`title`='".$this->title."'"; if($this->description!='') $sub_qry[] .= "`description`='".$this->description."'"; if($this->limits!='') $limit_qry = ' limit '.$this->limits; if($this->fields=='') $this->fields='*'; if($this->sortby!='') $sort_qry = " order by ".$this->orderby.' '.$this->sortby; if(count($sub_qry)>0) $subqry = " where ".implode(' and ',$sub_qry); $query = "select ".$this->fields." from ".MPN_TESTMONIALS." ".$subqry.$sort_qry.$limit_qry; if($this->id=='') return dB::mExecuteSql($query); else return dB::sExecuteSql($query); } function getTestAllDtls() { $query = "SELECT * FROM ".MPN_TESTMONIALS; return dB::mExecuteSql($query); } function getTestMaxKeywordId() { $query = "SELECT max(id) as LastId FROM ".MPN_TESTMONIALS; return dB::sExecuteSql($query); } } ?> Web Design Company India, Web Development Services, Cheapest SEO Services in India, Web Solutions Coimbatore, Web Hosting, Email Hosting Coimbatore, Tamilnadu, India

Portfolio