PHP - Prevent Duplicate Insert On Array.

I am having a big problem in MySQL and a part in my PHP coding as well.

I created a registration form, where the user will have to fill his names, email address, choose a username and so on. I do not want duplicate email address and username in my database, thus, if a user choose either an email address or a username which has already taken, he will be notified.

To prevent this duplication, I have set both the email address and username fields as UNIQUE KEY in MySQL.

My problems a

Even by setting both the username and email address fields as UNIQUE KEY, it is not working as I can register using the same email address or username. How to solve this?

I have coded also to prevent this problem of duplicate so that the user will be notified to choose another email or username, but I am having a warning.

My PHP codes:
Code: [Select]
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if (isset($_POST['fname']) && isset($_POST['lname'])&& isset($_POST['emailr']) && isset($_POST['user']) && isset($_POST['pass'])) {
//Assignng variables        
$firstname = mysql_real_escape_string($_POST['fname']);
$lastname = mysql_real_escape_string($_POST['lname']);    
$email = mysql_real_escape_string($_POST['emailr']);
$uname = mysql_real_escape_string($_POST['user']);
$pwd = mysql_real_escape_string($_POST['pass']);
$pmd= md5($pwd);
//Database
$connect = mysql_connect('localhost', 'root', '') or die ('Connection Failed');
mysql_select_db('registration', $connect) or die ('Connection Failed');

//Registration codes

if (empty($firstname) || empty($lastname) || empty($email) || empty($uname) || empty($pmd)) {
echo '<p class="error">All fields are required to fill!</p>';
return false;
} elseif (strlen($firstname) && (strlen($lastname) < '2')) {
echo '<p class="error">Invalid first name or last name!</p>';
return false;
} elseif (filter_var($firstname, FILTER_VALIDATE_INT) || (filter_var($lastname, FILTER_VALIDATE_INT))) {
echo '<p class="error">First name or last name cannot be integers!</p>';
return false;
} elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
echo '<p class="error">Email address not valid!</p>';
return false;    
} elseif (strlen($uname) && (strlen($pmd) < '6' )) {
echo '<p class="error">Username or password must be minimum 6 characters!</p>';
return false;
} else {
$query = "INSERT INTO login (id, firstname, lastname, emailaddress, username, password) VALUES('', '$firstname', '$lastname', '$email', '$uname', '$pmd')";
mysql_query($query, $connect);    
if (mysql_num_rows(mysql_query("SELECT * FROM login WHERE emailaddress = '$email' username = '$uname'"))) {
echo '<p class="fail">This email or username is already taken!</p>';
}
}
}
}
?>
The warning message I am getting:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\miniimagehosting\register.php on line 44

Here is video and there is shown how specific this problem is
http://faksx.sytes.net/help/

Solutions Witch doesn't fit in for this time is meta refresh,header(),exit(),die() .

Hi...

Before I have no problem in using On Duplicate Key, but now i have because of using time function.

Before I only have insert query:

Code: [Select]
$result = mysql_query("INSERT INTO regular_sum_hours(EMP_NO, Hours) SELECT EMP_NO, sec_to_time(SUM(time_to_sec(Rendered))) FROM regular_dtr_total GROUP BY EMP_NO") or die(mysql_error());   

And now I think that I need to add a syntax for Update, so i revise my code:
Code: [Select]
$result = mysql_query("INSERT INTO regular_sum_hours(EMP_NO, Hours) SELECT EMP_NO, sec_to_time(SUM(time_to_sec(Rendered))) FROM regular_dtr_total GROUP BY EMP_NO ON DUPLICATE KEY EMP_NO = EMP_NO, Hours = sec_to_time(SUM(time_to_sec(Rendered)))") or die(mysql_error());

and I got a problem in this part:

 Hours = sec_to_time(SUM(time_to_sec(Rendered)))")


Thank you

Hello,

i've got this code, to insert some form data into my db, it checks for a value if it exists already, it won't insert, now i want to add another value to check, but i don't know how.

This is my code:

Code: [Select]
<?php
if(isset($_POST['submit'])){
   if (strlen($_POST['code']) == 12 && substr($_POST['code'],0,6) == '610147'){
      $code = $_POST['code'];
      $select_query = mysql_query("SELECT * FROM jupiter WHERE code = '$code'");
      if(mysql_num_rows($select_query) == 0){
         $remote_addr = $_SERVER['REMOTE_ADDR'];
         $secret = $_POST['euro'];
         mysql_query("INSERT INTO jupiter(code,euro,ip,date,used) VALUES('$code','$secret','$remote_addr',CURDATE(),'n')");
 
      }
  Print "<font color='green'>OK</font>"; 
} else { 
    
Print "<font color='red'>Error</font>"; 
}
   
}?>
This checks if "code" already exists, now i want to also have it check for "ip"

Can someone help me out here please.

Thanks !

Hello,

i am inserting some form data into my mysql db, i happen to get some duplicates so i want to check first if the entry exists already before i insert.

my current code:

Code: [Select]
<?php

if(isset($_POST['submit']))  { ?>
<?php 
if (strlen($_POST['code']) == 19 && substr($_POST['code'],0,7) == '5541258')  { 
     mysql_query("INSERT INTO table(code,secret,ip,date) VALUES('$_POST[code]','$_POST[secret]','$_SERVER[REMOTE_ADDR]',CURDATE())");
Print "<font color='green'>The code will be checked now</font>"; 
} else { 
    
Print "<font color='red'>The code is invalid</font>"; 
}
?><?php } ?>
I would like to use the value 'code' to check if the entry exists, that one is unique for each entry. How would i do that ?

Thanks !