PHP - Really Basic Php/mysql Question (first Post)

I got a script that receive info from paypal "ipn" when someone is making a payment from my shop. I wanted to edit the script a bit as i am adding a bonus system to it.
After i added

Quote

// Bonus system vars

                    if ($item_name == '301') { $point == "1"; }
                   elseif  ($item_name == '302') { $point == "2"; }
                   elseif  ($item_name == '303') { $point == "3"; }
                   elseif  { $point == "0"; }




And
Quote

                        $bonus1 = "update Bonus set points=points+'$points' where username='$username'";
                        mysql_query("$bonus1");
                        
                        $bonus2 = "update Bonus set points_total=points_total+'$points' where username='$username'";
                        mysql_query("$bonus2");
                        
                        $bonus3 = "update Bonus set $item_name=$item_name+1 where username='$username'";
                        mysql_query("$bonus3");
 


The script wont work. But it does when i remove those things. I think my problem is at the if,elseif i just dont know why.  Do i need to put it in some kind of while loop?


Here is the full php code

Code: [Select]

mysql_connect('xxxxx', 'xxxx', 'xxxxxx');
$notify_email =  "xxxx@xxxx";

// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';

foreach ($_POST as $key => $value) {
        $value = urlencode(stripslashes($value));
        $req .= "&$key=$value";
}

// post back to PayPal system to validate
$header = "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$fp = fsockopen ('www.paypal.com', 80, $errno, $errstr, 30);

// assign posted variables to local variables
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];
$buyer_firstname = $_POST['first_name'];
$buyer_lastname = $_POST['last_name'];
$timestamp = $_POST['payment_date'];
$address_street = $_POST['address_street'];
$address_city = $_POST['address_city'];
$address_state = $_POST['address_state'];
$address_zip = $_POST['address_zip'];
$username = $_POST['custom'];


// Bonus system vars

     if ($item_name == '301') { $point == "1"; }
elseif  ($item_name == '302') { $point == "2"; }
elseif  ($item_name == '303') { $point == "3"; }
elseif  { $point == "0"; }


mysql_select_db('redlite');

if (!$fp) {
        // HTTP ERROR
} else {
        fputs ($fp, $header . $req);
        while (!feof($fp)) {
                $res = fgets ($fp, 1024);
                if (strcmp ($res, "VERIFIED") == 0) {
                        if ($payment_status == 'Completed') {
                                $sql = "insert into tblMail values ('','$txn_id','$payer_email',' $item_name','$timestamp','','','','$payment_amount $payment_currency','$buyer_firstname $buyer_lastname','$address_street  $address_city , $address_state $address_zip','','','$username')";
                                mysql_query("$sql");
                               



$bonus1 = "update Bonus set points=points+'$points' where username='$username'";
mysql_query("$bonus1");

$bonus2 = "update Bonus set points_total=points_total+'$points' where username='$username'";
mysql_query("$bonus2");

$bonus3 = "update Bonus set $item_name=$item_name+1 where username='$username'";
mysql_query("$bonus3");

                                $ttlpay_sql = "update totalpay set total=total+'$payment_amount' where id='1'";
                                mysql_query("$ttlpay_sql");
                                mail($notify_email, "CLVerified", "$res\n $req");
                        } else {
                                mail($notify_email, "CLVerified - But not completed". "$res\n $req");
                        }
                }
                else if (strcmp ($res, "INVALID") == 0) {
                        mail($notify_email, "CLINVALID IPN", "$res\n $req");

                }
        }
        fclose ($fp);
}
?>

Hi there,   I've built a form that should generate an e-mail, but it's not working properly. At first the page wouldn't display at all due to a problem with the EOD tags, that's fixed and I can now see a page, but when I type something in and hit submit, it's just not doing what it's supposed to do. Like I said it's supposed to e-mail me the data and leave the form filled with the data just submitted; it's doing neither. It is however posting the info into the address bar, so something is happening at least.   here's a link to the page:  http://www.remembert...hp/testform.php   here's the code:   <?php if ($_POST['parse_var'] == "testform"){

Hi,

I'm trying to get HTTP post to work on my server but even the most basic script does not work. Can anyone help me?

PHP script:

<?php
echo 'Hello ' . htmlspecialchars($_POST["name"]) . '!';
?>



I try and POST data to the script using:
http://www.czoryk.co.uk/post_test.php?name=Chris

But when I try and do that only ' Hello ! ' is displayed. I'm sure this is just a simple error but I can't figure out what's wrong.

Thanks, Chris

I would like to keep all my classes in a folder placed within the htdocs folder where my php script runs.  Let's say the classes folder is com\jimslounge\classes.  From my script can I instantiate a class like this
$myClass = new com\jimslounge\classes\Jimsclass();  Does it work something like that?  I would hate to have to use include to access classes.

Hi, can you help me please?

I have some code written about 5 yrs ago that is for example like this

echo"<div class=\"select\">";
echo"<br /><br />\n";
echo"</div>\n";
echo"</div>\n";
echo "<p><b>$address</b></p>\n";

Does it make any difference at all if I amended it to

echo"<div class=\"select\"><br /><br /></div></div><p><b>$address</b></p>";

ie coding errors or increase load time?
also when should I use \n"; or ";

Please forgive my ignorance but I am a self taught php writer and have managed to teach myself but just need a little help. Cheers