if ($payment_status = Completed)
if you do this your if statement is invalid
You should do
if ($payment_status == Completed)
I mean you should use double '=' inorder to say 'equals'.
Jim Hankins [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Here is a portion of a work in progress, I tested by sending the script
with
a payment status of incomplete yet it still executed other portions of the
code. Should it not have jumped out. Or is my nested if invalid for some
reason?
if ($payment_status = Completed)
{
echo 1st if is passedbr;
// check that txn_id has not been previously processed
$db_conn = mysql_connect(localhost:/var/lib/mysql/mysql.sock, apache,
xxx);
mysql_select_db(telnetlabs, $db_conn);
$query = select pp_txn_id from orders
.where pp_txn_id ='.$txn_id.' ;
$result = mysql_query($query, $db_conn);
echo This is the result of 1st querybr;
echo $result;
echo br;
$num_results = mysql_num_rows($result);
echo $num_results;
if ($num_results)
{
}
else {
echo 2nd if is passedbr;
$query = select cust_email from customers
.where cust_email = '$payer_mail' ;
$result = mysql_query($query, $db_conn);
$num_results = mysql_num_rows($result);
if ($num_results)
{
}
else
{
echo 3rd if is passedbr;
$item_name=addslashes($item_name);
$receiver_email=addslashes($receiver_email);
$item_number=addslashes($item_number);
$invoice=addslashes($invoice);
$payment_status=addslashes($payment_status);
$payment_gross=addslashes($payment_gross);
$txn_id=addslashes($txn_id);
$payer_email=addslashes($payer_email);
$payer_status=addslashes($payer_status);
$first_name=addslashes($first_name);
$last_name=addslashes($last_name);
$address_status=addslashes($address_status);
$address_street=addslashes($address_street);
$address_city=addslashes($address_city);
$address_state=addslashes($address_state);
$address_country=addslashes($address_country);
echo $first_name;
echo $last_name;
echo $address_street;
echo $address_city;
echo $address_state;
echo $address_status;
echo $address_zip;
echo $payer_status;
echo $item_name;
echo $receiver_email;
echo $item_number;
echo $invoice;
echo $payment_status;
echo $address_country;
//$query = insert into customers values ('null', '.$first_name.',
'.$last_name.', '.$address_street.', '.$address_city.' ,
'.$address_state.', '.$address_status.', '.$payer_email.' ,
'.$payer_status.', '.$payer_email.' , '.$txn_id.', '1');
// check that receiver_email is an email address in your PayPal account
// check that payer_email doesn't already exist in customer database
// if exist, increment customer.balanace by 1
// if not exist, create user and increment balance by 1
// then send schedule email with userid and password
// process payment
// first stab does none of the processes above, just emails the customer
and
us for testing
mail ([EMAIL PROTECTED], order info, trim($mailcontent), From:
[EMAIL PROTECTED], [EMAIL PROTECTED]);
mail ($payer_email, Your Order, $custconfirmation, From:
[EMAIL PROTECTED], [EMAIL PROTECTED]);
}
}
}
?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php