Statements

7724

Hi,

I'm trying to add some data to a MYSQL table UNLESS it sees a duplicate entry for what is entered in the textbox and submit is hit. However it just submits the data anyway despite it being a duplicate. Can anyone advise:


<?php 

// Start the connection to the database 

    include('***********');
    $can_i_connect = db_connect(); // by db_connect function is in my include file 
    if(!$can_i_connect) 
    { 
        echo "Could not connect to database"; 
    } 

// End the connection to the database    

// ** If Submit is hit do your stuff ** 
if (isset($_POST['Submit'])) { 

$the_region = $_POST['the_region']; 

// ** Check for Required Fields with IF statements ** 
   if (empty($the_region)){ 
   echo "You forgot to enter the area"; 
   } 

// ** Check for Duplicate entries with IF statements ** 

$sql = "SELECT COUNT(*) FROM prop_areas WHERE the_region=$the_region"; 
$sql_result = mysql_query($sql); 

if ($sql_result) { 
    echo "No Chance -  duplicate entry"; 

// ** If all of the statements are true then ** 
    } else { 

$query = "INSERT INTO prop_areas (the_region) VALUES 
    ('$the_region')"; 
    $query = mysql_query($query)or die('Query failed: ' . mysql_error()); 
    $area_id_id=mysql_insert_id(); 
    echo "success"; 

// ** And finally run the query to add data to the database ** 
     $link = mysql_connect; 
     mysql_select_db($db); 
     $result = mysql_query($query) or die('Query failed: ' . mysql_error()); 
     mysql_close();   

} 
} 
?> 
<html> 
<head> 
<title>Add Area</title> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 
</head> 

<body bgcolor="#FFFFFF"> 
<form action="".php" method="post" name="frmAdd"> 
<p>Area: <input type="text" name="the_region" size="40" /><br />     

         <input type="submit" name="Submit" value="Submit"> 
    <input type="reset" name="Reset" value="Reset">   

</p></form>

bogu

Use ajax to check if there are any duplicates texts in your DB, if u don't want to submit ...

I use this method on register pages to check if the desired username is not already taken ...

7724

Thanks, but don't know ajax. Was hoping someone could spot the above?

Thanks

Chris

NogDog

// ** Check for Duplicate entries with IF statements **

$sql = "SELECT COUNT(*) FROM prop_areas WHERE the_region=$the_region";
// NOGDOG: make sure query works:
$sql_result = mysql_query($sql) or die("Query failed: $sql - ".mysql_error());
list($count) = mysql_fetch_assoc($sql_result);
if ($count) {
    echo "No Chance -  duplicate entry";

// ** If all of the statements are true then **
    } else {

NogDog

PS: My preferred method is to define the column as UNIQUE in your table definition, then look for a MySQL error 1062 if it's a duplicate entry:

$sql = "INSERT INTO ...........";
$result = mysql_query($sql);
if(!$result)
{
  if(mysql_errno() == 1062)
  {
    // output error message here for duplicate value
  }
  else
  {
    die("Query failed: $sql - " . mysql_error());
  }
}

This way you only have to do one query instead of two.

konrad

[MISTAKE] :o