Avoiding duplicates

I have UE ver 4 and I am using it to populate a MySQL database from a web form that collects email addresses and names so I can send out newsletters. As implemented out of the box it allows duplicate email addresses, how can I alter it to stop it doing so and send a message to the person filling in the online form that that email address is already in the database?

so you have a form that allows people to enter an email address to sign up for the news letter?


You would need to create a recordset on the page to lookup the email address that is entered in the form, then use the server validations portion of CSS Form builder to validatie that the recordset is empty (email has not already been added).

use number validation.

For the server variable enter "$totalRows_<recordsetName>" where <recordsetName> is the name of the recordset.

when setting up number validation, set the minimum number to -1, and the max to 0

Thanks for the prompt reply.

I did not build the form with CSS form builder, just created it with Dreamweaver in the normal way. As it is an html page I cannot create a recordset on it.

The form posts to a file called regform.php which your programme Universal Email created. What I want to do (and I am sure most of your customers would want to do) is modify the code on this form so that it checks the database for a duplicate email address before dumping it to the database, and if it finds a duplicate does not do the dump and redirects to a page with a message.

Many thanks.

The instructions from my previous reply still hold, you will just need to create the recordset and apply server validations on the php page.

Hello,

I've tried to follow this as well to have validation for no duplicates of the email field with no success.

I keep getting the error:

Fatal error: Call to undefined function getsqlvaluestring() in /home/content/74/6081974/html/reports/Templates/Users_Registration.php on line 13


Not sure why this happening.

Trying to check the form field "userName" on the page doesn't already exist in the database under the field "userName".

I've attached the php code.

Any help is greatly appreciated.

the code at line 53 - 84 needs to be moved to line 1.

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }



  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);



  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;    

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}

?>