adi1991 Posted June 24, 2015 Share Posted June 24, 2015 I have craated one web form to upload csv sheet to mysql database, the primary key is "sample name" in database, i am trying to avoid duplication of "samplename" before uploading to database. my question is , Is it possible to do so? <html> <body> <form action="dform.php" method="post" enctype="multipart/form-data"> <input name="csv" type="file" id="csv" accept=".xls"/> <br /> <br /> <input type="submit" name="Submit" value="UPDATE" /> </form> </body> </html> above i saved as "dform.html" <?php if (!$_POST) { ?> <?php } else { $connect = new mysqli("localhost", "root", "", "ProcessTrackingSystem"); if ($_FILES[csv][size] > 0) { //get the csv file $file = $_FILES[csv][tmp_name]; $handle = fopen($file, "r"); $i = 0; while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if ($i > 0) { $import = ("INSERT INTO ProcessTrackingSystem.ProcessDetails VALUES('" . implode("','", $data) . "');"); $connect->query($import); } $i++; } fclose($handle); echo "THANKS FOR UPLOADING"."<br>"."<br>"; echo "Hit Back Button to UPLOAD MORE Data Sheets"; } } ?> above code i saved as "dform.php". any doughts and clarifications regarding above asked question are welcome. Quote Link to comment https://forums.phpfreaks.com/topic/296993-avoiding-duplicate-entry-in-mysql-database/ Share on other sites More sharing options...
Ch0cu3r Posted June 24, 2015 Share Posted June 24, 2015 Yes, you can set the samplename field to be unique ALTER TABLE ProcessDetails ADD UNIQUE(samplename) Now when you go to insert a duplicate value into the samplename field an error will be triggered and the insert query will fail, if you do want to the error to be triggered then change your INSERT query to INSERT IGNORE or if you want the insert query to update the existing data for that row, then use INSERT ON DUPLICATE KEY UPDATE query Quote Link to comment https://forums.phpfreaks.com/topic/296993-avoiding-duplicate-entry-in-mysql-database/#findComment-1514774 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.