Same Page Error Message

lukeawade · September 9, 2008

I have a registration page that if all the required fields are filled out then it submits the information to a database and sends them an email. If one of the reqiured fields arent filled out it shows an error message on the same page.

WHAT I'M TRYING to add is a check to see if that email is already in the database or doesnt exist then it shows an error on the same page. WHAT I HAVE WORKING is it checking to see if it exists in the database but it takes you to a blank page with the error message. Please help. My code is below.

<?php require_once('../Connections/connRegistration.php'); ?>

<?php

// Load the common classes

require_once('../includes/common/KT_common.php');

// Load the tNG classes

require_once('../includes/tng/tNG.inc.php');

// Make a transaction dispatcher instance

$tNGs = new tNG_dispatcher("../");

// Make a transaction dispatcher instance

$tNGs = new tNG_dispatcher("");

// Make unified connection variable

$conn_connRegistration = new KT_connection($connRegistration, $database_connRegistration);

// Start trigger

$formValidation = new tNG_FormValidation();

$formValidation->addField("first_name", true, "text", "", "", "", "");

$formValidation->addField("last_name", true, "text", "", "", "", "");

$formValidation->addField("company", true, "text", "", "", "", "");

$formValidation->addField("address1", true, "text", "", "", "", "");

$formValidation->addField("city", true, "text", "", "", "", "");

$formValidation->addField("state", true, "text", "", "", "", "");

$formValidation->addField("zip", true, "text", "zip_generic", "", "", "");

$formValidation->addField("phone", true, "text", "phone", "", "", "");

$formValidation->addField("cell_phone", false, "text", "phone", "", "", "");

$formValidation->addField("fax", false, "text", "phone", "", "", "");

$formValidation->addField("email", true, "text", "email", "", "", "");

$formValidation->addField("distribution_method", true, "distribution_method", "", "", "", "");

$tNGs->prepareValidation($formValidation);

// End trigger

//start Trigger_SendEmail trigger

//remove this line if you want to edit the code by hand

function Trigger_SendEmail(&$tNG) {

$emailObj = new tNG_Email($tNG);

$emailObj->setFrom("[email protected]");

$emailObj->setTo("{email}");

$emailObj->setCC("");

$emailObj->setBCC("[email protected]");

$emailObj->setSubject("Project Registration");

//WriteContent method

$emailObj->setContent("{first_name}, <br><br>

Thank you for registering.

The Project Information Management Team <br><br><br><br>

(Preferred Delivery Method: {distribution_method})

");

$emailObj->setEncoding("ISO-8859-1");

$emailObj->setFormat("HTML/Text");

$emailObj->setImportance("Normal");

return $emailObj->Execute();

}

//end Trigger_SendEmail trigger

if (!function_exists("GetSQLValueString")) {

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

{

$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;

}

$colname_rsMail = "-1";

if (isset($_POST['email'])) {

$colname_rsMail = $_POST['email'];

}

mysql_select_db($database_connRegistration, $connRegistration);

$query_rsMail = sprintf("SELECT first_name, email FROM dashboard_registration WHERE email = %s", GetSQLValueString($colname_rsMail, "text"));

$rsMail = mysql_query($query_rsMail, $connRegistration) or die(mysql_error());

$row_rsMail = mysql_fetch_assoc($rsMail);

$totalRows_rsMail = mysql_num_rows($rsMail);

// checks if the email is registered

if (!get_magic_quotes_gpc()) {

$_POST['email'] = addslashes($_POST['email']);

}

$usercheck = $_POST['email'];

$check = mysql_query("SELECT email FROM dashboard_registration WHERE email = '$usercheck'") or die(mysql_error());

$check2 = mysql_num_rows($check);

//if the name exists it gives an error

if ($check2 != 0) {

die('Sorry, the email '.$_POST['email'].' has already registered.');

}

// Make an insert transaction instance

$ins_dashboard_registration = new tNG_insert($conn_connRegistration);

$tNGs->addTransaction($ins_dashboard_registration);

// Register triggers

$ins_dashboard_registration->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");

$ins_dashboard_registration->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);

$ins_dashboard_registration->registerTrigger("END", "Trigger_Default_Redirect", 99, "thankyou.html");

$ins_dashboard_registration->registerTrigger("AFTER", "Trigger_SendEmail", 98);

// Add columns

$ins_dashboard_registration->setTable("dashboard_registration");

$ins_dashboard_registration->addColumn("first_name", "STRING_TYPE", "POST", "first_name");

$ins_dashboard_registration->addColumn("last_name", "STRING_TYPE", "POST", "last_name");

$ins_dashboard_registration->addColumn("company", "STRING_TYPE", "POST", "company");

$ins_dashboard_registration->addColumn("address1", "STRING_TYPE", "POST", "address1");

$ins_dashboard_registration->addColumn("address2", "STRING_TYPE", "POST", "address2");

$ins_dashboard_registration->addColumn("city", "STRING_TYPE", "POST", "city");

$ins_dashboard_registration->addColumn("state", "STRING_TYPE", "POST", "state");

$ins_dashboard_registration->addColumn("zip", "STRING_TYPE", "POST", "zip");

$ins_dashboard_registration->addColumn("phone", "STRING_TYPE", "POST", "phone");

$ins_dashboard_registration->addColumn("cell_phone", "STRING_TYPE", "POST", "cell_phone");

$ins_dashboard_registration->addColumn("fax", "STRING_TYPE", "POST", "fax");

$ins_dashboard_registration->addColumn("email", "STRING_TYPE", "POST", "email");

$ins_dashboard_registration->addColumn("registration_date", "DATE_TYPE", "POST", "registration_date");

$ins_dashboard_registration->addColumn("ip", "STRING_TYPE", "POST", "ip");

$ins_dashboard_registration->setPrimaryKey("reg_id", "NUMERIC_TYPE");

$ins_dashboard_registration->addColumn("distribution_method", "STRING_TYPE", "POST", "distribution_method");

$ins_dashboard_registration->addColumn("proj_id", "INT_TYPE", "POST", "proj_id");

// Execute all the registered transactions

$tNGs->executeTransactions();

// Get the transaction recordset

$rsdashboard_registration = $tNGs->getRecordset("dashboard_registration");

$row_rsdashboard_registration = mysql_fetch_assoc($rsdashboard_registration);

$totalRows_rsdashboard_registration = mysql_num_rows($rsdashboard_registration);

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Project Dashboard Registration</title>

<?php echo $tNGs->displayValidationRules();?>

<!--

.style1 {font-size: 9px}

.style2 { font-family: Arial, Helvetica, sans-serif;

font-size: 16px;

color: #333333;

}

.norepeatbg {

background:url(images/table_bottom.gif);

background-repeat: no-repeat;

background-position:bottom;

}

.style22 {

font-family: Arial, Helvetica, sans-serif;

font-size: 10px;

font-weight:bold;

color: #FF0000;

}

.style3 { font-family: Arial, Helvetica, sans-serif;

font-size: 36px;

font-weight: bold;

color: #333333;

}

.style4 {font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: #666666; }

.style24 {color: #FF9900}

.style25 {color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 18px;}

.style26 {

font-size: 12px;

font-style: italic;

color: #666666;

}

-->

</style>

</head>

<body>

<tr>

</tr>

<tr>

</tr>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td><div align="center" class="style3">Download<br />

</div></td>

</tr>

<tr>

</div></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<td class="style4"><div align="justify">Please fill out the form below to download the software installer. provides you access to the very latest project information, including:</div></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td class="style4"><div align="justify">If you have any questions, please feel free to contact the technical support department.</div></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

<tr>

<tr>

</tr>

<tr>

<td colspan="2" valign="top" class="style2"><strong>Contact Information:</strong></td>

</tr>

<tr>

</tr>

<tr>

<div align="left">First Name:</div>

</label></td>

<?php echo $tNGs->displayFieldError("dashboard_registration", "first_name"); ?></div></td>

</tr>

<tr>

</label></td>

<?php echo $tNGs->displayFieldError("dashboard_registration", "last_name"); ?></div></td>

</tr>

<tr>

<div align="left">Company:</div>

</label></td>

<?php echo $tNGs->displayFieldError("dashboard_registration", "company"); ?></div></td>

</tr>

<tr>

<div align="left">Address:</div>

</label></td>

<?php echo $tNGs->displayFieldError("dashboard_registration", "address1"); ?></div></td>

</tr>

<tr>

<div align="left">Bldg/Suite:</div>

</label></td>

<?php echo $tNGs->displayFieldError("dashboard_registration", "address2"); ?></div></td>

</tr>

<tr>

</label></td>

<?php echo $tNGs->displayFieldError("dashboard_registration", "city"); ?></div></td>

</tr>

<tr>

<td valign="top" class="style2" ><div align="left">State:</div></td>

</select>

<?php echo $tNGs->displayFieldError("dashboard_registration", "state"); ?></div></td>

</tr>

<tr>

</label></td>

<?php echo $tNGs->displayFieldError("dashboard_registration", "zip"); ?></div></td>

</tr>

<tr>

<div align="left">Office Phone:</div>

</label></td>

<?php echo $tNGs->displayFieldError("dashboard_registration", "phone"); ?></div></td>

</tr>

<tr>

<td valign="top" class="style2" ><div align="left">Mobile Phone:</div></td>

<?php echo $tNGs->displayFieldError("dashboard_registration", "cell_phone"); ?></div></td>

</tr>

<tr>

</label></td>

<?php echo $tNGs->displayFieldError("dashboard_registration", "fax"); ?></div></td>

</tr>

<tr>

</label></td>

<?php echo $tNGs->displayFieldError("dashboard_registration", "email"); ?>

</div></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<td><div align="justify"><span class="style26">Please choose a delivery method below. Installation CD's will be shipped ground the day your registration is received.</span></div></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<td valign="top" class="style2" ><div align="left">Delivery<br />

Method:</div></td>

<option value="CD">Install CD</option>

<option value="Download">Electronic Download</option>

</select>

<?php echo $tNGs->displayFieldError("dashboard_registration", "distribution_method"); ?></div></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<td><div align="justify"><span class="style26">Estimated Download Times:</span></div></td>

</tr>

<tr>

<p align="left">T1/Business Class: 20 minutes<br />

Cable/DSL: 50 minutes<br />

Dialup: 15 hours<br />

</p>

</blockquote></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

</div></td>

</tr>

<tr>

</tr>

</table>

</div>

</form>

</td>

</tr>

</table> </td>

</tr>

<tr>

<tr>

<td class="style1">Powered by: </td>

</tr>

<tr>

</tr>

</table></td>

</tr>

</table>

</body>

</html>

<?php

mysql_free_result($rsMail);

?>

Sign In

Same Page Error Message

Recommended Posts

lukeawade

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information