Hi,
I have a php page that creats an account from a user submitted form. When a new account is created and you press submit I get an error. Any specific help on what to do would be appreciated!
Rafik
Here is the error I get:
Warning: Cannot add header information - headers already sent by (output started at /home/www/bicyclecoach/profile-submit.php:16) in /home/www/bicyclecoach/profile-submit.php on line 93
Here is the code:
<?php require_once('Connections/connBicycleCoach.php'); ?>
<?php
mysql_select_db($database_connBicycleCoach, $connBicycleCoach);
$query_rsTip = "SELECT COACHES.USERNAME, COACHES.LNAME, COACHES.FNAME, TIPS.TIPID, TIPS.TITLE, TIPS.TIP FROM COACHES INNER JOIN TIPS ON COACHES.USERNAME = TIPS.USERNAME WHERE (((TIPS.HOMEPAGE)='Yes') AND ((TIPS.VISIBLE)='Yes'))";
$rsTip = mysql_query($query_rsTip, $connBicycleCoach) or die(mysql_error());
$row_rsTip = mysql_fetch_assoc($rsTip);
$totalRows_rsTip = mysql_num_rows($rsTip);
mysql_select_db($database_connBicycleCoach, $connBicycleCoach);
$query_rsArticle = "SELECT COACHES.USERNAME, COACHES.LNAME, COACHES.FNAME, ARTICLES.ARTICLEID, ARTICLES.TITLE, ARTICLES.ARTICLE FROM COACHES INNER JOIN ARTICLES ON COACHES.USERNAME = ARTICLES.USERNAME WHERE (((ARTICLES.HOMEPAGE)='Yes') AND ((ARTICLES.VISIBLE)='Yes'))";
$rsArticle = mysql_query($query_rsArticle, $connBicycleCoach) or die(mysql_error());
$row_rsArticle = mysql_fetch_assoc($rsArticle);
$totalRows_rsArticle = mysql_num_rows($rsArticle);
?>
<?php
// *** Redirect if username exists
$FF_flag="MM_insert";
if (isset($$FF_flag)) {
$FF_dupKeyRedirect="login-duplicate.php";
$FF_dupKeyUsernameValue = $HTTP_POST_VARS["USERNAME"];
$FF_dupKeySQL = "SELECT USERNAME FROM COACHES WHERE USERNAME='" . $FF_dupKeyUsernameValue . "'";
mysql_select_db($database_connBicycleCoach, $connBicycleCoach);
$FF_rsKey=mysql_query($FF_dupKeySQL, $connBicycleCoach) or die(mysql_error());
if(mysql_num_rows($FF_rsKey) > 0) {
// the username was found - can not add the requested username
$FF_qsChar = "?";
if (strpos($FF_dupKeyRedirect, "?")) $FF_qsChar = "&";
$FF_dupKeyRedirect = $FF_dupKeyRedirect . $FF_qsChar . "requsername=" . $FF_dupKeyUsernameValue;
header ("Location: $FF_dupKeyRedirect");
exit;
}
mysql_free_result($FF_rsKey);
}
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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;
}
$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}
if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "ACCOUNT")) {
$insertSQL = sprintf("INSERT INTO....blah, blah, blah....) VALUES (%s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['USERNAME'], "text"),
GetSQLValueString($HTTP_POST_VARS['PASSWORD'], "text"),
GetSQLValueString($HTTP_POST_VARS['FNAME'], "text"),
GetSQLValueString($HTTP_POST_VARS['LNAME'], "text"),
GetSQLValueString($HTTP_POST_VARS['ADDRESS1'], "text"),
GetSQLValueString($HTTP_POST_VARS['CITY'], "text"),
GetSQLValueString($HTTP_POST_VARS['STATE'], "text"),
GetSQLValueString($HTTP_POST_VARS['ZIP'], "text"),
GetSQLValueString($HTTP_POST_VARS['REGION'], "text"),
GetSQLValueString($HTTP_POST_VARS['TELEPHONE'], "text"),
GetSQLValueString($HTTP_POST_VARS['EMAIL'], "text"),
GetSQLValueString($HTTP_POST_VARS['LICLEVEL'], "text"),
GetSQLValueString($HTTP_POST_VARS['LICNUMBER'], "text"),
GetSQLValueString($HTTP_POST_VARS['DATEJOINED'], "date"),
GetSQLValueString($HTTP_POST_VARS['FLAG'], "text"),
GetSQLValueString($HTTP_POST_VARS['FLAG'], "text"));
mysql_select_db($database_connBicycleCoach, $connBicycleCoach);
$Result1 = mysql_query($insertSQL, $connBicycleCoach) or die(mysql_error());
$insertGoTo = "index.php";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_connBicycleCoach, $connBicycleCoach);
$query_rsState = "SELECT STATE FROM STATES ORDER BY STATE ASC";
$rsState = mysql_query($query_rsState, $connBicycleCoach) or die(mysql_error());
$row_rsState = mysql_fetch_assoc($rsState);
$totalRows_rsState = mysql_num_rows($rsState);
mysql_select_db($database_connBicycleCoach, $connBicycleCoach);
$query_rsLevel = "SELECT LEVEL FROM LICENSELEVEL ORDER BY LEVEL ASC";
$rsLevel = mysql_query($query_rsLevel, $connBicycleCoach) or die(mysql_error());
$row_rsLevel = mysql_fetch_assoc($rsLevel);
$totalRows_rsLevel = mysql_num_rows($rsLevel);
?>
