<?php
@session_start();
// $con = mysqli_connect("localhost", "root", "", "blog-admin-panel");
$con = mysqli_connect("localhost", "aaryhspitl_data11012023", "baroxNPSK", "aaryhspitl_data11012023");
// $con = mysqli_connect("localhost", "hiqat_bhtjanki", "aN1#OiL@9z", "hiqat_nfneurolinguistics");

function check_input($con, $data) {
  $data = trim($data);
  $data = stripslashes($data);
  $data = htmlspecialchars($data);
  $data = addslashes($data);
  $data = mysqli_real_escape_string($con, $data);
  return $data;
}

function check_textinput($con, $data) {
  $data = trim($data);
  $data = htmlspecialchars($data);
  $data = mysqli_real_escape_string($con, $data);
  return $data;
}

function random_generator($length) {
    $chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789!@#$";
    $password = substr( str_shuffle( $chars ), 0, $length );
    return $password;
}

function getRealIpAddr(){
  if (!empty($_SERVER['HTTP_CLIENT_IP']))
  //check ip from share internet
  {
    $ip=$_SERVER['HTTP_CLIENT_IP'];
  }
  elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
  //to check ip is pass from proxy
  {
    $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
  }
  else
  {
    $ip=$_SERVER['REMOTE_ADDR'];
  }
  return $ip;
}

function getCurrentURL()
{
    $currentURL = (@$_SERVER["HTTPS"] == "on") ? "https://" : "http://";
    $currentURL .= $_SERVER["SERVER_NAME"];
 
    if($_SERVER["SERVER_PORT"] != "80" && $_SERVER["SERVER_PORT"] != "443")
    {
        $currentURL .= ":".$_SERVER["SERVER_PORT"];
    } 
 
    $currentURL .= $_SERVER["REQUEST_URI"];
    return $currentURL;
}

$crtUrl=getCurrentURL();


$blogImg="blog-img";
$newsImg="news-img";

$albumImg="album-img";
$galleryImg="gallery-img";
$uploads="uploads";
$eventImg="event-img";

$navlImg="img/image-not-available.png";

function maincategory($con){
  $main_result=array();
  
  $fetch_categories=mysqli_query($con,"SELECT * FROM `spc_category` WHERE  `status`='1'")or die(mysqli_error($con));
  while($catresult=mysqli_fetch_array($fetch_categories)){
   $main_result[]=$catresult;
  }   
  return $main_result;
}
function medCategory($con){
  $main_result=array();
  
  $fetch_med=mysqli_query($con,"SELECT * FROM `med-category` WHERE  `status`='1'")or die(mysqli_error($con));
  while($medResult=mysqli_fetch_array($fetch_med)){
   $main_result[]=$medResult;
  }   
  return $main_result;
}
/*function maincategory($con){
$fetch_categories=mysqli_query($con,"SELECT `category_id`,`category`,`category_slug` FROM `ahq_category` WHERE `status`='1' ORDER BY `category_id` DESC ")or die(mysqli_error($con));

while($result=mysqli_fetch_array($fetch_categories)){
	$main_result[]=array("category_id" => $result['category_id'],
                                      "category" => $result['category'],
                                      "category_slug" => $result['category_slug'],
                                      );
}
return $main_result;
}*/

/*function subcategory($con,$parentcategory){
$fetch_subcategories=mysqli_query($con,"SELECT `subcategory_id`,`subcategory`,`subcategory_slug` FROM `ahq_subcategory` WHERE `category_id`='".$parentcategory."' AND `status`='1' ORDER BY `subcategory_id` DESC ")or die(mysqli_error($con));

while($subcatresult=mysqli_fetch_array($fetch_subcategories)){
	$sub_result[]=array("subcategory_id" => $subcatresult['subcategory_id'],
                                      "subcategory" => $subcatresult['subcategory'],
                                      "subcategory_slug" => $subcatresult['subcategory_slug'],
                                      );
}
return $sub_result;
}*/


/*function clientreview($con){
   $fetchCreviews=mysqli_query($con,"SELECT * FROM `ahq_review` WHERE `status`='1' ORDER BY `review_id` DESC ")or die(mysqli_error($con));
   while($cr_result=mysqli_fetch_array($fetchCreviews)){
      $crmain_result[]=array("review_id" => $cr_result['review_id'],
         "client_name" => $cr_result['client_name'],
         "country" => $cr_result['country'],
         "review_date" => $cr_result['review_date'],
         "rating" => $cr_result['rating'],
         "image" => $cr_result['image'],
         "image_alt" => $cr_result['image_alt'],
         "image_title" => $cr_result['image_title'],
         "company_name" => $cr_result['company_name'],
         "designation" => $cr_result['designation'],
         "description" => $cr_result['description'],
      );
   }
   return $crmain_result;
}*/


date_default_timezone_set("Asia/Kolkata");

$tdate=date("Y-m-d");
?>