pass_sub40.php 0000644 0000772 0000772 00000035210 10573757000 016735 0 ustar fastrackparents fastrackparents
require($_SERVER['DOCUMENT_ROOT'] . '/database_config.php');
session_start();
session_register("LoginValid_session");
session_register("GoodLoginURL_session");
session_register("BadLoginURL_session");
session_register("Username_session");
session_register("ParentsName_session");
session_register("ChildName_session");
session_register("EnrollMonthYear_session");
session_register("academyid_session");
session_register("Country_session");
session_register("City_session");
session_register("StateProvince_session");
session_register("ID_session");
session_register("ref_email_session");
session_register("passwd_session");
function dQuote($s) {
return str_replace("'","''",$s);
}
$Status="Suspend";
$DateEntered=strftime("%m/%d/%Y %H:%M:%S %p");
if ($HTTP_GET_VARS["st"]=="exists")
{
$stComment="The email address you submitted is already in our database. Please choose another.";
}
$ParentsName_session=$HTTP_POST_VARS["textfield"];
$ChildName_session=$HTTP_POST_VARS["textfield2"];
$EnrollMonthYear_session=$HTTP_POST_VARS["textfield3"];
$academyid_session=$HTTP_POST_VARS["textfield4"];
$Country_session=$HTTP_POST_VARS["textfield5"];
$City_session=$HTTP_POST_VARS["textfield6"];
$StateProvince_session=$HTTP_POST_VARS["textfield7"];
if ($HTTP_POST_VARS["textfield4"]!="")
{
// $RS is of type "ADODB.Recordset"
$academyid=$HTTP_POST_VARS["textfield4"];
$theSQL="select academyid from academyid where academyid ='".$academyid."'";
//Response.Write "executing sql query"
$RS = mysql_query($theSQL);
if (($RS==0))
{
header("Location: "."pass_sub.php?st=exists");
}
}
//Response.Write "execute sql query for insertion"
$SQLQuery="Select Max(ID) as HighestID from users";
$rsResults_query=mysql_query($SQLQuery);
$rsResults=mysql_fetch_array($rsResults_query);
$userId=intval($rsResults["HighestID"])+1;
$ID_session=$userId;
$SQLQuery="INSERT INTO users (ID,ParentsName, ChildName, EnrollMonthYear, academyid, DateEntered, Country, City, StateProvince, Status) ".
"VALUES(".$userId.", ".
"'".dquote(${"textfield"})."', '".
dquote($HTTP_POST_VARS["textfield2"])."', '".
dquote($HTTP_POST_VARS["textfield3"])."', '".
dquote($HTTP_POST_VARS["textfield4"])."', '".
$DateEntered."', '".
dquote($HTTP_POST_VARS["textfield5"])."', '".
dquote($HTTP_POST_VARS["textfield6"])."', '".
dquote($HTTP_POST_VARS["textfield7"])."', '".$Status."')";
//Response.Write "sql query is " & SQLQuery
mysql_query($SQLQuery);
?>
Submission Form Step 2
|
|
Step 2: Fill in
a valid email address as your
Username
for the FasTrack Parents' Site.
|
echo $stComment; ?>
|
Username
Your
username must be a VALID email address. If you do not have an
email account, simply go to your favorite search engine and
do a search for "Free Email". Find a service that
fits your needs and follow their steps to setup your own email
account.
Select
A Email Provider:
|
|
|
|
|
|
|
|
|
|
|
|
|