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

We offer a wide range of web design concepts so that Your web site will exude an aura of professionalism

Web Development

We develop web sites that use state-of-the-art technology, are easy to maintain and effectively

Corporate Identities

We offer business card design, logo creation, and letterheads as well as envelop design services.

Online Marketing

Our internet marketing services includes search engine optimization, search engine submission

Software Application

We offer software's for various needs such as Super markets, Dairy firms, Dry clearners, Sabzi mandis, Restaurants. etc.,

We offer Web Design, Web Development, Graphic Design, SEO, Internet Marketing,Domain Registration,Web Hosting,Email Hosting, Payment Gateway Solutions Services

Our amazing Products & services and others listed below

WEBSITES
Starts from Rs. 3500

Website is face of your business on the Internet.

More >>
SEO
Starts from Rs. 3000

SEO is the process of manipulating the visibility of a website in search engines.

More >>
DIGITAL MARKETING
Starts from Rs. 4500

It is the marketing of products or services using digital technologies.

More >>
G SUITE
Starts from Rs. 2500

G Suite adds enterprise features such as custom email addresses at a domain (@yourcompany.com)

More >>
OPEN-XCHANGE
Rs.680/USER ID/Year

Open-Xchange is a web-based communication, collaboration and office productivity software

More >>
LOGO DESIGNING
Rs.2500 (3 Choices)

Logo design is the process of designing a graphic symbol.

More >>
E Brochure
Starts from Rs. 1000

This format has the added benefit of unlimited distribution and cost savings.

More >>
Visiting Cards / Business Cards
Starts from Rs.500/Per 1000 cards

Its are cards bearing business information about a company or individual.

More >>
Letter Heads
Starts from Rs. 2000

That heading usually consists of a name and an address, and a logo or corporate design.

More >>
Trade Mark Registration
Rs. 9000 (Valid for 10 Years.)

A trademark identifies the brand owner of a particular product or service.

More >>
Ingenious Guru

Ingeniousguru.co is a technology-driven way of redefining Learning and Teaching simpler & easier.

More >>
Call Repo

Call repo is report tracking Software to handle daily inquiries for marketing, sales etc.

More >>

Web Designing

We offer a wide range of web design concepts so that your web site will exude an aura of professionalism and competitiveness in today’s business arena. It is the design of the site that gives first impression about you, and says a lot about your company and the services offered.

Web Development

Web Development: We develop web sites that use state-of-the-art technology, are easy to maintain and effectively present your organization to the web audience. Advanced Information Technologies made it crucial for a company to have its presence in cyberspace.

Online Marketing

Without a powerful marketing campaign a site gets lost in cyberspace. Our internet marketing services lude search engine optimization, search engine submission, and site maintenance.

Corporate Identity

We offer business card design, logo creation, and letterheads as well as envelop design services. We need not say much on this, as Yagna started as a company offering the basic services for its clients for a scratch start of a business it knows the rule, people apply to business cards and logos, letterheads and envelop designs because they add certain charm, appeal and allure.

Our Products


TESTIMONIALS