1#@!#!123s

file_get_contents 1#@!#!123s
: / home3 / wwwcraftenterpri / www / admin /
Filename : config.php
back
<?php
    $servername = "localhost";
    $username = "wwwcraft_enterpr" ;
    $password = "GGyT-IFvjIHM";
    $database_name = "wwwcraft_ craftenterprises";
    

    $conn = new mysqli($servername,$username,$password,$database_name);
    $target_dir_logo = "images/product_logo/";
    $target_dir_product_images = "images/product_images/";
    $target_banner_image = "images/product_banner/";
    $target_pdf_dir  = "pdf/";
    $target_brand_logo = 'images/client_logo/';


    function remove_unwanted_files($conn,$dir,$colname,$table_name){
        $result_array=  array();
    
        if(is_dir($dir)){
            if($handle = opendir($dir)){
                while(($file = readdir($handle)) !==FALSE){
                    $result_array[] = $file;
                }
                closedir($handle);
            }
        }

        foreach($result_array as $value){
            $select_query = "SELECT COUNT($colname) FROM $table_name WHERE $colname = '$value'";
            $query_resut = $conn->query($select_query);
            $result_count = $query_resut->fetch_row();
            if($result_count[0] == 0 ){
                if(is_file($dir.$value)){
                    unlink($dir.$value);
                }
                
            }
    
        }
    }

    remove_unwanted_files($conn,$target_dir_logo,'Brand_Logo','Brands');
    remove_unwanted_files($conn,$target_banner_image,'Brand_Banner','Brands');
    remove_unwanted_files($conn,$target_pdf_dir,'Pdf_name','Brands');
    remove_unwanted_files($conn,$target_brand_logo,'logo','clientele');
?>