Search the Community

Hi There I'm trying to create an upload csv page which detects duplicates and tells me how many are duplicates, but i just cant my head around it, this is my code so far //Upload File if (isset($_POST['submit'])) { if (is_uploaded_file($_FILES['fileName']['tmp_name'])) { echo "<h1>" . "File ". $_FILES['fileName']['name'] ." uploaded successfully." . "</h1>"; //echo "<h2>Displaying contents:</h2>"; //readfile($_FILES['fileName']['tmp_name']); $upload_amount = 0; $duplicates = 0; } //Import uploaded file to Database $handle = fopen($_FILES['fileName']['tmp_name'], "r"); $filename = $_FILES['fileName']['name']; while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $import="INSERT IGNORE into Leads(number,date,used,fileName) values('$data[0]','$data[1]','$used','$filename')"; $query= mysql_query($import); //mysql_query($import) or die(mysql_error()); if ($query){ if (mysql_affected_rows() > 0){ $upload_amount++; } else { $duplicates++; } } else { die (mysql_error()); } } if ($upload_amount > 1){ $todays_date= date ('Y-m-d H:i:s'); $sql_status="INSERT INTO LeadsStatus (filename,imported,user,Date) VALUES ('$filename','$upload_amount','$login_session','$todays_date')"; mysql_query($sql_status) or die (mysql_error()); } fclose($handle); print "Import done </br>"; print $upload_amount." Imported"; echo "</br>"; print $duplicates." Duplicates Not Imported"; print "<a href='Leads.php'> Upload More</a>"; any help is greatly appreciated thank you