1#@!#!123s

: / home / realadss / kavyaeventz.in / admin / ajax /
Filename : product-update.php
back
<?php
    
    include"../connection.php";
    
    $id = $_POST['id'];
    $category = $_POST['category'];
    $meta1 = $_POST['meta1'];
    $meta2 = $_POST['meta2'];
    $meta3 = $_POST['meta3'];
    $meta4 = $_POST['meta4'];
    $video1 = $_POST['video1'];
    $video2 = $_POST['video2'];
    $script = $_POST['script'];
    $pixcel = $_POST['pixcel'];
    
    $escaped_html_line = $conn->real_escape_string($pixcel);
    // echo $escaped_html_line;    
    // print_r($escaped_html_line);
    // die();
    $altb = $_POST['altb'];
    $alte = $_POST['alte'];
    $altg = $_POST['altg'];
    $bannerimage = $_FILES['banner'];
    $bannerimageold = $_POST['bannerold'];
    $temper = $bannerimage['tmp_name'];   
    
    $pname = $_POST['pname'];
        $replaceArray0 = array(
             '"' => "&#34;",
            "'" => "&#39;",
           
        );
        
        $modifiedText0 = str_replace(array_keys($replaceArray0), array_values($replaceArray0), $pname);
    
    
    $editordata1 = $_POST['editordata1'];            
        $replaceArray1 = array(
             '"' => "&#34;",
            "'" => "&#39;",
           
        );
        
        $modifiedText1 = str_replace(array_keys($replaceArray1), array_values($replaceArray1), $editordata1);
        // print_r($modifiedText1);
        // die();
    
   
    // $editordata3 = $_POST['editordata3'];            
    //     $replaceArray3 = array(
    //          '"' => "&#34;",
    //         "'" => "&#39;",
           
    //     );
        
    //     $modifiedText3 = str_replace(array_keys($replaceArray3), array_values($replaceArray3), $editordata3);
     
     
    $date = date("Y-m-d h-i-sa");
    $upload_location = "../images/new/";
    
    $countformFile1 = count($_FILES['formFile1']['name']);
    $files_arr1 = array();
    
    
    $countformFile2 = count($_FILES['formFile2']['name']);
    $files_arr2 = array();
    
    // echo $countformFile1;
    // echo $countformFile2;
    // die();
    
    for($index = 0; $index < $countformFile1; $index++){

    	if(isset($_FILES['formFile1']['name'][$index]) && $_FILES['formFile1']['name'][$index] != ''){
            $images = "images".$index;
        	$filename = $images.$date.$index.$_FILES['formFile1']['name'][$index];
        	$path = $upload_location.$filename;
                
            if(move_uploaded_file($_FILES['formFile1']['tmp_name'][$index],$path)){
        		$files_arr1[] = $filename;
        // 		echo 'jftrt';
        	}
        }	
    }
    for($index = 0; $index < $countformFile2; $index++){

    	if(isset($_FILES['formFile2']['name'][$index]) && $_FILES['formFile2']['name'][$index] != ''){
            $images = "images".$index;
        	$filename = $images.$date.$index.$_FILES['formFile2']['name'][$index];
        	$path = $upload_location.$filename;
                
            if(move_uploaded_file($_FILES['formFile2']['tmp_name'][$index],$path)){
        		$files_arr2[] = $filename;
        	}
        }	
    }
    
    $names_str1 = implode(', ', $files_arr1);
	$names_str2 = implode(', ', $files_arr2);
	
	move_uploaded_file($temper, '../images/new/'.$bannerimageold); 
    
    
    if($countformFile1 == 0 and $countformFile2 == 0){
        $sql = "UPDATE `products` SET `catagory`='$category',`pname`='$pname',`video1`='$video1',`video2`='$video2',`script`='$script',`pixcel`='$escaped_html_line',`banner`='$bannerimageold', `meta1`='$meta1', `meta2`='$meta2', `meta3`='$meta3', `meta4`='$meta4',`description`='$modifiedText1',
        `altb`='$altb', `alte`='$alte', `altg`='$altg' WHERE id = '$id'";
    
        // echo $sql;
    }else if($countformFile1 == 0){
        $sql = "UPDATE `products` SET `catagory`='$category',`pname`='$pname',`video1`='$video1',`video2`='$video2',`script`='$script',`pixcel`='$escaped_html_line',`banner`='$bannerimageold', `meta1`='$meta1', `meta2`='$meta2', `meta3`='$meta3', `meta4`='$meta4',`description`='$modifiedText1',
        `detail_image`='$names_str2', `altb`='$altb', `alte`='$alte', `altg`='$altg' WHERE id = '$id'";
        // echo $sql;
    }else if($countformFile2 == 0){
        $sql = "UPDATE `products` SET `catagory`='$category',`pname`='$pname',`video1`='$video1',`video2`='$video2',`script`='$script',`pixcel`='$escaped_html_line',`banner`='$bannerimageold', `meta1`='$meta1', `meta2`='$meta2', `meta3`='$meta3', `meta4`='$meta4',`description`='$modifiedText1',
        `thumbnail_image`='$names_str1', `altb`='$altb', `alte`='$alte', `altg`='$altg' WHERE id = '$id'";
        // echo $sql;
        
    }    
    
    
    // die();
    $query = mysqli_query($conn, $sql);

    if($query){
        echo 1;
    }else{
        echo 2;
    }    

?>