<?php
//$con = mysqli_connect('localhost','root','','globus');

$host_name = "localhost";
$host_user = "root";
$host_pass = "";
$host_db = "";
$connect = mysql_connect($host_name,$host_user,$host_pass)or die("Could not connect: ".mysql_error());
$con = mysql_select_db($host_db);

if(isset($_POST['file'])){
$new_file_name=$_POST['file'];

 $new_file_name = str_replace('&','and',$new_file_name);

		 $new_file_name = str_replace('#','',$new_file_name);

		 $new_file_name = str_replace('+','',$new_file_name);
                  $new_file_name = str_replace("'", '', $new_file_name);
				   $new_file_name = str_replace(' ','',$new_file_name);
			$userfile_name_3730=$new_file_name;	   
				   
				   $Query_pay_date = mysql_query("SELECT image_name from    tbl_localjobs_img where image_name='$new_file_name'");
$name_pay_date=mysql_fetch_array($Query_pay_date);
$n_pay_date=mysql_num_rows($Query_pay_date);
if($n_pay_date>0)
{


$query_12_3 = mysql_query("SELECT max(id) as nd_1 FROM tbl_localjobs_img  ");

$fetch_12_3 = mysql_fetch_array($query_12_3);
$mysql_insert_id=$fetch_12_3['nd_1']+1;


 $new_file_name=($mysql_insert_id.$new_file_name);
 
 
	  }
	  
	  if($n_pay_date>0)

	  {
	  
	  
	 $Query_delete = mysql_query("DELETE from  tbl_local_img where old_name='$userfile_name_3730'  ");


	  }


    $file = '../local/' . $new_file_name;
    if(file_exists($file)){
        unlink($file);
    }
}
?>