<?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");
?>