Posts: 626
|
I have a page which I use to save client info into my db. What I can't understand is if I use META to redirect it works but if I use javascript (inside PHP) it doesn't.
here is the version that doesn't work:
Code:
<?php
$conn = mysql_connect('localhost', 'root', 'PW') or die(mysql_error());
mysql_select_db("Clientbase") or die(mysql_error());
extract($_POST);
// put all string variable and varchar's in single quotes
$ClientNum = $ClientNumber;
$ID == NULL ? $ID = "NULL" : $ID = $ID;
$ClientNumber == NULL ? $ClientNumber = "NULL" : $ClientNumber = "'$ClientNumber'";
$AccountNumber == NULL ? $AccountNumber = "NULL" : $AccountNumber = "'$AccountNumber'";
$CompanyName == NULL ? $CompanyName = "NULL" : $CompanyName = "'$CompanyName'";
$PolicyType == NULL ? $PolicyType = "NULL" : $PolicyType = "'$PolicyType'";
$PolicyStatus == NULL ? $PolicyStatus = "NULL" : $PolicyStatus = "'$PolicyStatus'";
$FaceAmount == NULL ? $FaceAmount = "NULL" : $FaceAmount = "'$FaceAmount'";
$PmtAmount == NULL ? $PmtAmount = "NULL" : $PmtAmount = "'$PmtAmount'";
$PmtFreq == NULL ? $PmtFreq = "NULL" : $PmtFreq = "'$PmtFreq'";
$HealthStatus == NULL ? $HealthStatus = "NULL" : $HealthStatus = "'$HealthStatus'";
$CTRAmt == NULL ? $CTRAmt = "NULL" : $CTRAmt = "'$CTRAmt'";
$GIOAmt == NULL ? $GIOAmt = "NULL" : $GIOAmt = "'$GIOAmt'";
$SpousalAmt == NULL ? $SpousalAmt = "NULL" : $SpousalAmt = "'$SpousalAmt'";
$CIAmt == NULL ? $CIAmt = "NULL" : $CIAmt = "'$CIAmt'";
$DateSold = "'"."$YearSold-$MonthSold-$DaySold"."'";
$IssueDate = "'"."$IssueYear-$IssueMonth-$IssueDay"."'";
$RenewalDate = "'"."$RenewalYear-$RenewalMonth-$RenewalDay"."'";
// find out if the checkboxes from the preceeding form were check or left blank and format
// to mysql format.
if (!array_key_exists('WP', $_POST)) { $WP = 0;} else {$WP = 1; }
if (!array_key_exists('ROP', $_POST)) { $ROP = 0;} else {$ROP = 1;}
if (!array_key_exists('ROPS', $_POST)) {$ROPS = 0; } else {$ROPS = 1;}
if (!array_key_exists('CTR', $_POST)) { $CTR = 0; } else { $CTR = 1;}
if (!array_key_exists('GIO',$_POST)) { $GIO = 0; } else {$GIO = 1;}
if (!array_key_exists('Spousal', $_POST)) { $Spousal = 0; } else {$Spousal = 1;}
if (!array_key_exists('CI', $_POST)) { $CI = 0; } else {$CI = 1;}
if (!array_key_exists('Editing', $_POST)) {$Editing = "NO"; $ID = "NULL";} else {$Editing = "YES";}
// working on sql statement - need to exclude all NULL values (columns too).
if ($Editing == "YES") {
$sql = "REPLACE INTO insurance (ID, ClientNumber, DateSold, AccountNumber, CompanyName, PolicyType, PolicyStatus, FaceAmount, PmtAmount, PmtFreq, IssueDate, RenewalDate, WP, ROP, ROPS, CTR, CTRAmt, GIO, GIOAmt, CI, CIAmt, Spousal, SpousalAmt, HealthStatus)
VALUES ($ID, $ClientNumber, $DateSold, $AccountNumber, $CompanyName, $PolicyType, $PolicyStatus, $FaceAmount, $PmtAmount, $PmtFreq, $IssueDate, $RenewalDate, $WP, $ROP, $ROPS, $CTR, $CTRAmt, $GIO, $GIOAmt, $CI, $CIAmt, $Spousal, $SpousalAmt, $HealthStatus)";
} else {
$sql = "INSERT INTO insurance (ID, ClientNumber, DateSold, AccountNumber, CompanyName, PolicyType, PolicyStatus, FaceAmount, PmtAmount, PmtFreq, IssueDate, RenewalDate, WP, ROP, ROPS, CTR, CTRAmt, GIO, GIOAmt, CI, CIAmt, Spousal, SpousalAmt, HealthStatus)
VALUES ($ID, $ClientNumber, $DateSold, $AccountNumber, $CompanyName, $PolicyType, $PolicyStatus, $FaceAmount, $PmtAmount, $PmtFreq, $IssueDate, $RenewalDate, $WP, $ROP, $ROPS, $CTR, $CTRAmt, $GIO, $GIOAmt, $CI, $CIAmt, $Spousal, $SpousalAmt, $HealthStatus)";
}
mysql_query($sql) or die(mysql_error());
mysql_close($conn);
echo <<<SAVEINS
<script type="text/javascript" language="javascript">
document.write('<form name="SaveIt" action="$Referrer" method="POST">');
document.write('<input type="hidden" name="ClientNumber" value="$ClientNum">');
document.write('</form>');
SaveIt.submit();
</script>
SAVEINS;
?>
Here is the version that does:
Code:
<?php
$conn = mysql_connect('localhost', 'root', 'PW') or die(mysql_error());
mysql_select_db("Clientbase") or die(mysql_error());
extract($_POST);
// put all string variable and varchar's in single quotes
$ClientNum = $ClientNumber;
$ID == NULL ? $ID = "NULL" : $ID = $ID;
$ClientNumber == NULL ? $ClientNumber = "NULL" : $ClientNumber = "'$ClientNumber'";
$AccountNumber == NULL ? $AccountNumber = "NULL" : $AccountNumber = "'$AccountNumber'";
$CompanyName == NULL ? $CompanyName = "NULL" : $CompanyName = "'$CompanyName'";
$PolicyType == NULL ? $PolicyType = "NULL" : $PolicyType = "'$PolicyType'";
$PolicyStatus == NULL ? $PolicyStatus = "NULL" : $PolicyStatus = "'$PolicyStatus'";
$FaceAmount == NULL ? $FaceAmount = "NULL" : $FaceAmount = "'$FaceAmount'";
$PmtAmount == NULL ? $PmtAmount = "NULL" : $PmtAmount = "'$PmtAmount'";
$PmtFreq == NULL ? $PmtFreq = "NULL" : $PmtFreq = "'$PmtFreq'";
$HealthStatus == NULL ? $HealthStatus = "NULL" : $HealthStatus = "'$HealthStatus'";
$CTRAmt == NULL ? $CTRAmt = "NULL" : $CTRAmt = "'$CTRAmt'";
$GIOAmt == NULL ? $GIOAmt = "NULL" : $GIOAmt = "'$GIOAmt'";
$SpousalAmt == NULL ? $SpousalAmt = "NULL" : $SpousalAmt = "'$SpousalAmt'";
$CIAmt == NULL ? $CIAmt = "NULL" : $CIAmt = "'$CIAmt'";
$DateSold = "'"."$YearSold-$MonthSold-$DaySold"."'";
$IssueDate = "'"."$IssueYear-$IssueMonth-$IssueDay"."'";
$RenewalDate = "'"."$RenewalYear-$RenewalMonth-$RenewalDay"."'";
// find out if the checkboxes from the preceeding form were check or left blank and format
// to mysql format.
if (!array_key_exists('WP', $_POST)) { $WP = 0;} else {$WP = 1; }
if (!array_key_exists('ROP', $_POST)) { $ROP = 0;} else {$ROP = 1;}
if (!array_key_exists('ROPS', $_POST)) {$ROPS = 0; } else {$ROPS = 1;}
if (!array_key_exists('CTR', $_POST)) { $CTR = 0; } else { $CTR = 1;}
if (!array_key_exists('GIO',$_POST)) { $GIO = 0; } else {$GIO = 1;}
if (!array_key_exists('Spousal', $_POST)) { $Spousal = 0; } else {$Spousal = 1;}
if (!array_key_exists('CI', $_POST)) { $CI = 0; } else {$CI = 1;}
if (!array_key_exists('Editing', $_POST)) {$Editing = "NO"; $ID = "NULL";} else {$Editing = "YES";}
// working on sql statement - need to exclude all NULL values (columns too).
if ($Editing == "YES") {
$sql = "REPLACE INTO insurance (ID, ClientNumber, DateSold, AccountNumber, CompanyName, PolicyType, PolicyStatus, FaceAmount, PmtAmount, PmtFreq, IssueDate, RenewalDate, WP, ROP, ROPS, CTR, CTRAmt, GIO, GIOAmt, CI, CIAmt, Spousal, SpousalAmt, HealthStatus)
VALUES ($ID, $ClientNumber, $DateSold, $AccountNumber, $CompanyName, $PolicyType, $PolicyStatus, $FaceAmount, $PmtAmount, $PmtFreq, $IssueDate, $RenewalDate, $WP, $ROP, $ROPS, $CTR, $CTRAmt, $GIO, $GIOAmt, $CI, $CIAmt, $Spousal, $SpousalAmt, $HealthStatus)";
} else {
$sql = "INSERT INTO insurance (ID, ClientNumber, DateSold, AccountNumber, CompanyName, PolicyType, PolicyStatus, FaceAmount, PmtAmount, PmtFreq, IssueDate, RenewalDate, WP, ROP, ROPS, CTR, CTRAmt, GIO, GIOAmt, CI, CIAmt, Spousal, SpousalAmt, HealthStatus)
VALUES ($ID, $ClientNumber, $DateSold, $AccountNumber, $CompanyName, $PolicyType, $PolicyStatus, $FaceAmount, $PmtAmount, $PmtFreq, $IssueDate, $RenewalDate, $WP, $ROP, $ROPS, $CTR, $CTRAmt, $GIO, $GIOAmt, $CI, $CIAmt, $Spousal, $SpousalAmt, $HealthStatus)";
}
mysql_query($sql) or die(mysql_error());
mysql_close($conn);
echo "<META HTTP-EQUIV=Refresh CONTENT=\"0; URL=./\">";
?>
What's wierd: the javascript redirect works in all other pages EXCEPT those which I am saving data to the DB. If I do it in the saving page it just keeps looping creating a new RECORD for EACH variable.
Can anyone help here?
This is the error message I get:
Code:
Notice: Undefined variable: ID in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 9
Notice: Undefined variable: AccountNumber in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 11
Notice: Undefined variable: CompanyName in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 12
Notice: Undefined variable: PolicyType in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 13
Notice: Undefined variable: PolicyStatus in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 14
Notice: Undefined variable: FaceAmount in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 15
Notice: Undefined variable: PmtAmount in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 16
Notice: Undefined variable: PmtFreq in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 17
Notice: Undefined variable: HealthStatus in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 18
Notice: Undefined variable: CTRAmt in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 19
Notice: Undefined variable: GIOAmt in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 20
Notice: Undefined variable: SpousalAmt in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 21
Notice: Undefined variable: CIAmt in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 22
Notice: Undefined variable: YearSold in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 25
Notice: Undefined variable: MonthSold in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 25
Notice: Undefined variable: DaySold in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 25
Notice: Undefined variable: IssueYear in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 26
Notice: Undefined variable: IssueMonth in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 26
Notice: Undefined variable: IssueDay in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 26
Notice: Undefined variable: RenewalYear in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 27
Notice: Undefined variable: RenewalMonth in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 27
Notice: Undefined variable: RenewalDay in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 27
Notice: Undefined variable: Referrer in C:\Documents and Settings\Administrator\My Documents\My Webs\moneytime.ca\database\saveinsurance.php on line 54
|
