1#@!#!123s

: / home / shubmkcj / designpitara.com / admin / franchise /
Filename : execute.php
back
<?php
	include("../include/config.php");
	include("../include/sessionhandle.php");


##########################################################################################
// service-last-level
##########################################################################################


if ( array_key_exists( "add-new-franchise", $_REQUEST ) ) {
    //    echo "sli";
//    die;
 

    $meta_title = mysqli_real_escape_string( $conn, $_POST['meta_title'] );
    $keyword = mysqli_real_escape_string( $conn, $_POST['keyword'] );
    $description = mysqli_real_escape_string( $conn, $_POST['description'] );
    $txtfranchiseIds = mysqli_real_escape_string( $conn, $_POST['txtfranchiseIds'] );

    // if ( !empty( $custo_url ) ) {
    //     $url = create_slug( $custo_url );
    // } else {
    //     $url = create_slug( $services_name );
    // }

    $aa_faqq = str_replace("'","\'",$_POST['faqQuest']); 
    $faqQuest = implode('--',$aa_faqq);
      
    $aa_faqa = str_replace("'","\'",$_POST['faqAns']);
    $faqAns = implode('--',$aa_faqa);
    
    // if ( isset( $_FILES['image_a']['name'] ) ) {
    //     $fileName1 = $_FILES["image_a"]["name"];
    //     $fileTmpLoc1 = $_FILES["image_a"]["tmp_name"];
    //     $fileType1 = $_FILES["image_a"]["type"];
    //     $fileSize1 = $_FILES["image_a"]["size"];
    //     $fileErrorMsg1 = $_FILES["image_a"]["error"];
    //     $kaboom1 = explode( ".", $fileName1 );
    //     $fileExt1 = end( $kaboom1 );
        
    //     $newFileName = time().".".$fileExt1;
    //     $moveResult1 = move_uploaded_file( $fileTmpLoc1, "upload/$newFileName" );
    // }
    // if(empty($_FILES['image_a']['name'])) 
    // { 
    //     $newFileName = ""; 
    // }
 $query="UPDATE `franchise` SET `meta_title` = '$meta_title', `meta_keywords`='$keyword', `meta_description`='$description', `faqQuestion`='$faqQuest', `faqAnswer`='$faqAns'  WHERE `franchise`.`id` = '$txtfranchiseIds'";
 //  echo $query; die;
    if ( mysqli_query( $conn, $query ) ) {
        header( "location:". $admin_baseurl . 'franchise/' );
    } else {
        echo "qu faild to update data";
    }
    mysqli_close( $conn );

}
###################################################################################


###################################################################################
//franchise inquiry page
###################################################################################
// status active  data
if(array_key_exists("status_active_franchise_inquiry",$_REQUEST)){
   
        $net_id = $_GET['id'];
        
        	 $query="UPDATE `franchise_enquiry` SET `status` = 'active' WHERE `franchise_enquiry`.`id` = '$net_id'";

			if (mysqli_query($conn, $query)) {
				header("location:". $admin_baseurl . 'franchise/franchise-inquiry.php');
			} 
            
			else {
				include('include/error-modal.php');
			}
			mysqli_close($conn);
    
}

##########################################################################################
// status deactive data
if(array_key_exists("status_deactive_franchise_inquiry",$_REQUEST)){
    
  $net_id = $_GET['id'];
        
        	 $query="UPDATE `franchise_enquiry` SET `status` = 'deactive' WHERE `franchise_enquiry`.`id` = '$net_id'";
		
            
			if (mysqli_query($conn, $query)) {
				header("location:". $admin_baseurl . 'franchise/franchise-inquiry.php');
			} 
            
			else {
				include('include/error-modal.php');
			}
			mysqli_close($conn);
    
}


##################################################################################################

//For detete data
if(array_key_exists("delete_franchise_inquiry",$_REQUEST)){
    
    $t_id = $_GET['id'];
    
//  echo $t_id; die;
    
        
    $query="DELETE FROM `franchise_enquiry` WHERE `franchise_enquiry`.`id` = '$t_id'";
			
			if (mysqli_query($conn, $query)) {
				header("location:". $admin_baseurl . 'franchise/franchise-inquiry.php');
			} 
            
			else {
				include('include/error-modal.php');
			}
			mysqli_close($conn);
}


###################################################################################
//Vender inquiry page
###################################################################################
// status active  data
if(array_key_exists("status_active_Vendor_Enrollment",$_REQUEST)){
   
        $net_id = $_GET['id'];
        
        	 $query="UPDATE `vendor_enrollment_enquiry` SET `status` = 'active' WHERE `vendor_enrollment_enquiry`.`id` = '$net_id'";

			if (mysqli_query($conn, $query)) {
				header("location:". $admin_baseurl . 'franchise/vendor-enrollment-inquiry.php');
			} 
            
			else {
				include('include/error-modal.php');
			}
			mysqli_close($conn);
    
}

##########################################################################################
// status deactive data
if(array_key_exists("status_deactive_Vendor_Enrollment",$_REQUEST)){
    
  $net_id = $_GET['id'];
        
        	 $query="UPDATE `vendor_enrollment_enquiry` SET `status` = 'deactive' WHERE `vendor_enrollment_enquiry`.`id` = '$net_id'";
		
            
			if (mysqli_query($conn, $query)) {
				header("location:". $admin_baseurl . 'franchise/vendor-enrollment-inquiry.php');
			} 
            
			else {
				include('include/error-modal.php');
			}
			mysqli_close($conn);
    
}


##################################################################################################

//For detete data
if(array_key_exists("delete_Vendor_Enrollment_inquiry",$_REQUEST)){
    
    $t_id = $_GET['id'];
    
//  echo $t_id; die;
    
        
    $query="DELETE FROM `vendor_enrollment_enquiry` WHERE `vendor_enrollment_enquiry`.`id` = '$t_id'";
			
			if (mysqli_query($conn, $query)) {
				header("location:". $admin_baseurl . 'franchise/vendor-enrollment-inquiry.php');
			} 
            
			else {
				include('include/error-modal.php');
			}
			mysqli_close($conn);
}

?>