troubleshooting Question

How do I Check for duplicate entries in mysql

Avatar of peter-cooper
peter-cooper asked on
PHP
15 Comments1 Solution286 ViewsLast Modified:
Hello
I have a script that inserts items into mysql which works fine. However, what I need to do is check for duplicate entries and if found, issue alert and halt. I have coded some php but cannot seem to incorporate into my existing script.

I would be grateful if someone could help with this. Many thanks.

Exisitng code which works fine

<?php session_start(); ?>

    <?php

    $con = mysql_connect("localhost","root","");
    if(!$con) { die('Could not connect: ' . mysql_error()); }
    mysql_select_db("sample", $con);
    $dept = $_POST['dept'];
    $custref = $_POST['sub'];
		
		
    $query = "SELECT * FROM boxes WHERE department = '".$dept."' AND status = 1 AND custref = '".$custref."'";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result) or die(mysql_error());
    $r = $row['custref'];
		
    $str =  json_encode($r);
    echo trim($str, '"');

?>

New code to be i was thinking of using

<?php session_start();  ?>
    <?php

    $con = mysql_connect("localhost","root","");
    if(!$con) { die('Could not connect: ' . mysql_error()); }
    mysql_select_db("sample", $con);
		
    $custref = $_POST['sub'];
		
    $result = mysql_query("SELECT * FROM boxes WHERE custref = '".$custref."'");
    $found = mysql_num_rows($result);
		
     if ($found > 0)
		{
			
			echo "true";
			
		} else {
			
			echo "false";
			
		}

     ?>

jQuery code

$(function() {
				
$('#srcsubmit').click(function(e) {
e.preventDefault();
				 			 
if ($('#srcBox').val() == '') {

        notif({
        type: "error",
        msg: "<b>ERROR:<br /><br />You must enter a search term</b><p>Click anywhere to close</p>",
        height: 99,
        multiline: true,
        position: "middle,center",
        fade: true,
        timeout: 3000

        });
        return false;
        }
				 
				 
        $( "#submit" ).prop( "disabled", true );
        $( "#submit2" ).prop( "disabled", true );
        $( "#submit3" ).prop( "disabled", true );

        var value = $('#srcBox').val();
        var dept = '<?php echo $_GET['dept']; ?>';
				 
        var qString = 'sub=' + encodeURIComponent(value) + '&dept=' +encodeURIComponent(dept);

        $.post('sub_db_handler.php', qString, processResponse);
         });

   function processResponse(data) {
    
        $('#srcBoxRslt').val(data);

   };
		
});
		
	
</script>
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros