hi, I have a form that processes customers credit cards to a processing company. once the transaction is successful, it prints to screen the information, etc. about the transaction.
In order to update my database now showing their subscription is no longer expired, I have added a form on the print screen…
then on the continue.php page (I did this just to see if $billEmail could post…
$billEmail = $HTTP_POST_VARS["bill_email"];
also on continue.php I added a form with $billEmail echo to see if it was there. it does post my email address when I go to continue.php from the transaction page. Below is the form on continue.php
then, on continue25.php I have
$conn = db_connect();
return 'Could not connect to database server - please try later.';
$billEmail = isSet( $_GET['bill_email'] ) ? $_GET['bill_email'] : '';
if( $billEmail == '' )
die( 'You have not set id or it is blank. Cannot continue.' );
echo "DEBUG: bill_email = $billEmail.
$expired_sql = "UPDATE customer_tbl SET expired='0' WHERE bill_email='$billEmail'";
echo "DEBUG: expired_sql = $expired_sql.
mysql_query( $expired_sql )
or die( mysql_error() );
$check_sql = "SELECT * FROM customer_tbl WHERE bill_email='$billEmail' AND expired='0'";
echo "DEBUG: check_sql = $check_sql.
$result = mysql_query( $check_sql );
$num = mysql_num_rows( $result );
if( $num == 0 )
My results on connection25.php ends up
“You have not set id or it is blank. Cannot continue.”
I am not sure where I am going wrong.