PHP - Help With Loop For Paypal Dodirectpayment Api Integration

I have a site with a shopping cart that uses a paypal buy now button.  The button seems to work fine, when I click it everything in my cart on my site shows up how its suppose to in the paypal checkout page.  Then problem is when I try to log into my buyer sandbox account.  It's telling me its the wrong email or password when I know for a fact it is correct.  I know I need to be logged in to the sandbox developer account while using it, but it still wont let me log in.  My site tried to do multiple items using the value _cart for the cmd hidden paypal input and upload.  However when I use another example that only does one item at a time and has preset variables my sandbox paypal accoung logs in fine.  This makes me think there is something wrong with my code.

Here is the code to build my paypal button for my site
Code: [Select]
$cartOutput = "";
$cartTotal = "";
$pp_checkout_btn = '';
$product_id_array = '';
if (!isset($_SESSION["cart_array"]) || count($_SESSION["cart_array"]) < 1) {
    $cartOutput = "<h2 align='center'>Your shopping cart is empty</h2>";
} else {
        // Start PayPal Checkout Button
        $pp_checkout_btn .= '<form action="https://www.paypal.com/cgi-bin/webscr" method="post"  accept-charset="utf-8">
    <input type="hidden" name="cmd" value="_cart">
    <input type="hidden" name="upload" value="1">
    <input type="hidden" name="business" value="pwang@sofpower.com">';
        // Start the For Each loop
        $i = 0;
    foreach ($_SESSION["cart_array"] as $each_item) {
                $item_id = $each_item['item_id'];
                $query = "SELECT * FROM product WHERE id='$item_id' LIMIT 1";
                $result = $db_obj->query($query);
        if($db_obj->error) exit ($db_obj->error);
                //$sql = mysql_query("SELECT * FROM products WHERE id='$item_id' LIMIT 1");
                while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
                        $product_name = $row["product_name"];
                        $price = $row["price"];
                        $details = $row["details"];
                }
                $pricetotal = $price * $each_item['quantity'];
                $cartTotal = $pricetotal + $cartTotal;
                $_SESSION["cart"] = $cartTotal;
                setlocale(LC_MONETARY, "en_US");
        //$pricetotal = money_format("%10.2n", $pricetotal);
                // Dynamic Checkout Btn Assembly
                $x = $i + 1;
                $pp_checkout_btn .= '<input type="hidden" name="item_name_' . $x . '" value="' . $product_name . '">
        <input type="hidden" name="amount_'. $x . '" value="' . $price . '">
        <input type="hidden" name="quantity_' . $x . '" value="' . $each_item['quantity'] . '">  ';
                // Create the product array variable
                $product_id_array .= "$item_id-".$each_item['quantity'].",";
                // Dynamic table row assembly
                $cartOutput .= "<tr>";
                $cartOutput .= '<td><a href="product.php?id=' . $item_id . '">' . $product_name . '</a><br /><img src="inventory_images/' . $item_id . '.jpg" alt="' . $product_name. '" width="40" height="52" border="1" /></td>';
                $cartOutput .= '<td>' . $details . '</td>';
                $cartOutput .= '<td>$' . $price . '</td>';
                $cartOutput .= '<td><form action="cart.php" method="post">
                <input name="quantity" type="text" value="' . $each_item['quantity'] . '" size="1" maxlength="2" />
                <input name="adjustBtn' . $item_id . '" type="submit" value="change" />
                <input name="item_to_adjust" type="hidden" value="' . $item_id . '" />
                </form></td>';
                //$cartOutput .= '<td>' . $each_item['quantity'] . '</td>';
                $cartOutput .= '<td>' . $pricetotal . '</td>';
                 $cartOutput .= '<td><form action="cart.php" method="post"><input name="deleteBtn' . $item_id . '" type="submit" value="X" /><input name="index_to_remove" type="hidden" value="' . $i . '" /></form></td>';
                $cartOutput .= '</tr>';
                $i++;
    }
        setlocale(LC_MONETARY, "en_US");
    //$cartTotal = money_format("%10.2n", $cartTotal);
        $cartTotal = "<div style='font-size:18px; margin-top:12px;' align='right'>Cart Total : ".$cartTotal." USD</div>";

  // Finish the Paypal Checkout Btn
        $pp_checkout_btn .= '

        <input type="hidden" name="return" value="http://webdev.cs.kent.edu/~jfunchio/wp2/HW2/checkout_complete.php">
        <input type="hidden" name="cancel_return" value="http://webdev.cs.kent.edu/~jfunchio/wp2/HW2/paypal_cancel.php">
        <input type="image" src="https://www.paypal.com/images/x-click-butcc.gif" name="submit" alt="Make payments with PayPal - its fast, free and secure!">
        </form>';
}



Here is the example that works

Code: [Select]
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<meta charset="utf-8"/>
<title>SuperStore.Com</title></head>
<body style="margin: 50px">
<h2>Purchase Our Product Online</h2>
<p><img src="hammer.jpeg" alt="Hammer" style="vertical-align: middle" />
&nbsp;&nbsp;&nbsp;Hammer for $4.49.</p>

<form action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="post" accept-charset="utf-8">
<input type="hidden" name="cmd" value="_xclick" />
<input type="hidden" name="business" value="jfunchio@kent.edu" />
<input type="hidden" name="item_name" value="Hammer" />
<input type="hidden" name="amount" value="4.49" />
<input id="tt" type="hidden" name="return" value="success return URL" />
<input id="ff" type="hidden" name="cancel_return" value="failure return URL" />
<!-- company logo for PayPal page -->
<input type="hidden" name="image_url"
       value="http://www.sofpower.com/images/sofppal.gif" />
<input type="hidden" name="cn" value="Special Instructions (optional)" />
<table style="background-color: #ddffee">
<tr><td>&nbsp;</td></tr>
<tr><td>Customer Full Name</td><td>
<input type="text" name="cnm"  size="30" maxlength="50" /></td></tr>
<tr><td><input type="hidden" name="on0" value="customer email address" />
Customer email</td>
<td><input type="text" name="os0" size="30" maxlength="100" /></td></tr>
<tr><td><input type="hidden" name="on1" value="customer institution" />
Customer institution</td>
<td><input type="text" name="os1" size="30" maxlength="100" /></td></tr>
<tr><td>&nbsp;</td></tr>
</table><br />
<input type="image" src="https://www.paypal.com/images/x-click-butcc.gif"
border="0" name="submit"
alt="Make payments with PayPal - it's fast, free and secure!" />
</form>
<p>When payment has been received, we will
also send a confirmation to you by email.<br />
After ordering, if you need to get in touch with us, please
send email to<br />
<tt>customer-service@superstore.com</tt>.</p>
<pre>

</pre>
</body></html>

Hello Everyone,

I am pretty new to the forums and was curious if i could get some help here. Basically, in a nutshell, i have PayPal integrated into my website. I will use this to collect money from clients. when a client logs into his/her account they see their balance (which is pulled from the database to correspond with the user that's logged-in). Now, everytime a payment is submitted a notify_url is contacted after payment has been verified, that notify_url is the code written below. What I am trying to execute here is when this notify_url is called the current balance is reduced from the amount paid through paypal.

In the second If condition, you will see that the word success is being entered into the paypal.txt file, which is working perfectly fine. Now, you will also see the variable


$update_balance;  


which is suppose to update the original balance with the balance paid through PayPal

BUT IT'S NOT!! WHY?? LOL

Thank You in advance!


<?php
ob_start();

session_start();

include_once ('/home/rdewebde/public_html/includes/paypal.php');

$myPaypal = new Paypal();

$myPaypal->ipnLog = TRUE;
        
include_once "/home/rdewebde/public_html/includes/_config.php";

$username = "".$_SESSION['username']."";

$users_data = mysql_query("SELECT * FROM `members` WHERE `username`='".$username."'");

$user_info = mysql_fetch_array($users_data);

$current_amount = $user_info['balance'];
     
$deduct_amount = $myPaypal->ipnData['payment_gross'];

$new_amount = $current_amount - $deduct_amount;

$update_balance = mysql_query("UPDATE `members` SET `balance` = '$new_amount' WHERE `username` = '".$username."'");

if ($myPaypal->validateIpn()) {

    if ($myPaypal->ipnData['payment_status'] == 'Completed') {

         $update_balance;  

         file_put_contents('/home/rdewebde/public_html/lounge/paypal.txt', 'SUCCESS');

            

    }

else { file_put_contents('/home/rdewebde/public_html/lounge/paypal.txt', "FAILURE\n\n" . $myPaypal->ipnData); }

   }

?> 

I currently have a project undergoing, however i need help integrating two scripts:

Login script & Comment Script

The checking if logged in part is this - Code: [Select]
if(!isset($_SESSION['SESS_MEMBER_ID']) || (trim($_SESSION['SESS_MEMBER_ID']) == '')) {
header("location: access-denied.php");
exit();
}
and i want it so that i can check if the user is logged in the comment script will use there first name from my mysql table of members.

The field name in the table for first name is 'firstname' and my comment section script looks like this

Code: [Select]
echo "<div class=\"commentbody\" id=\"$commentrow[0]\">\n
<p class=\"postedby\">Posted by ";
if($commentrow[3]){
        echo "<a href=\"$commentrow[3]\">$commentrow[2]</a> ";
} else {
echo "$commentrow[2] ";
}
echo "</p> \n
        <p>$commentbb</p>\n\n</div>";
}
echo "</div>";
}
Please someone help me, its driving me crazy.

Any more info needed just ask many thanks in advance!!

Okay, I run a website; I wrote it from scratch, it's own database. With this website, I also run a news section (Run by wordpress), a wiki (Run by MediaWiki), A chat system (X7Chat), and a Live Help system (Mibew Messenger). I am looking to integrate all four of these systems to run off the same login as my main website. I would like it so that when the user logs in to the main site, it automatically logs in and sets the cookies for the other 4 systems. I also want it so when a user registers, it automatically registers them on the other 4 systems.

I have achieved this with the chat system. I duplicated the Cookies and I have it so that if a user logs in to the main site, it sets the cookies for the chat, and when a user registers, or changes their password or email, it updates it on the chat table.

But, I am finding it quite more difficult for the Wiki, Wordpress, and the Live Help system. The cookies were easy to duplicate for the chat system, and inserting the rows was fairly simple for the chat system, but it is quite a bit more complicated with the other systems. I am hoping someone here has done this before and could help me out on this one, because I am clueless.

Thanks in advance for all that help.

Okay so i have a flash game website. I want it so that i can list all the games in a category onto one page.
So, php selects the items with the category with mysql(for example 'a for arcade' http://url.com/select.php?cat=a) and then lists every game's name and a link to the url (by grabbing the id of the game and providing a link (http://url.com/play.php?id=1)


This is the code i have so far..

<?php
$con = mysqli_connect('localhost', 'root', 'root', 'games')or die(mysqli_error($con));

if(isset($_GET['cat'])){
     $query_var = $_GET['type']; // force it to be an integer

 $query=" SELECT * FROM games WHERE category = '$query_var'";

     $result = mysqli_query($con, $query)or die(mysqli_error($con));
     }
}

?>
<html>
<head>
<title>
Test
</title>
</head>
<body>
?
</body>
</html>

Hi There,

I was wondering if there is a way, or in deed if there is an off the shelf calendar that would be able to interact with an SQL database?

I want to be able to display a week's worth of dates (Mon - Fri) - and show what is on each day, for different people, say 4. If possible, I would like it to read start and end dates from the DB, and if that entry is over 3 days, display it on 3 calendar days.

Has anyone heard of anything like this, or is it easy to code up?

Thanks in advance
Matt

Hello
I have not been able to find my answer anywhere else, so now i post it he

Code: [Select]
<html>
  <body>
    <p></p>
  </body>
</html>

<?php
  $var = 'Some text here!'
?>

My questions is now: How do i get the text in the PHP variable into the HTML paragraph text?   
The code is on the same page 

Thanks in advance 
Jones

Hey All, 

I am using a Curl script to call item details from an API and then updating mysql with the results. But the API is limited to 100 requests per 60 seconds. So I am currently just using:

$page = $_GET["page"];
$next_page = ++$page;
echo "<meta http-equiv='refresh' content='60;url=?page=".$next_page."'>";

This runs until the results from the API runs out, then resets the page number to 1 and loops through again. 

My question is, will this would the same with a CRON job?

 

 

I have set up u chat page on my site and would like to know how to make it use the logged in members user name from my database rather than assigning them a guest name, i think i have found the code that needs editing but i have no idea what needs to be done.

I think the editing needs to be done in this code somewhere but i could be wrong, Please help.

Code: [Select]
<?php

require_once dirname(__FILE__)."/src/phpfreechat.class.php";
$params = array();
$params["title"] = "Quick chat";
$params["nick"] = "guest".rand(1,1000);  // setup the intitial nickname
$params['firstisadmin'] = true;
//$params["isadmin"] = true; // makes everybody admin: do not use it on production servers ;)
$params["serverid"] = md5(__FILE__); // calculate a unique id for this chat
$params["debug"] = false;
$chat = new phpFreeChat( $params );

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
 <head>
  <meta http-equiv="content-type" content="text/html; charset=utf-8" />
  <title>phpFreeChat- Sources Index</title>
  <link rel="stylesheet" title="classic" type="text/css" href="style/generic.css" />
  <link rel="stylesheet" title="classic" type="text/css" href="style/header.css" />
  <link rel="stylesheet" title="classic" type="text/css" href="style/footer.css" />
  <link rel="stylesheet" title="classic" type="text/css" href="style/menu.css" />
  <link rel="stylesheet" title="classic" type="text/css" href="style/content.css" /> 
 </head>
 <body>

<div class="header">
      <img alt="phpFreeChat" src="style/logo.gif" class="logo2" />
</div>

<div class="menu">
      <ul>
        <li class="sub title">General</li>
        <li>
          <ul class="sub">
            <li class="item">
              <a href="demo/">Demos</a>
            </li>
            <?php if (file_exists(dirname(__FILE__)."/checkmd5.php")) { ?>
            <li>
              <a href="checkmd5.php">Check md5</a>
            </li>
            <?php } ?>
            <!--
            <li class="item">
              <a href="admin/">Administration</a>
            </li>
            -->
          </ul>
        </li>
        <li class="sub title">Documentation</li>
        <li>
          <ul>
            <li class="item">
              <a href="http://www.phpfreechat.net/overview">Overview</a>
            </li>
            <li class="item">
              <a href="http://www.phpfreechat.net/quickstart">Quickstart</a>
            </li>
            <li class="item">
              <a href="http://www.phpfreechat.net/parameters">Parameters list</a>
            </li>
            <li class="item">
              <a href="http://www.phpfreechat.net/faq">FAQ</a>
            </li>
            <li class="item">
              <a href="http://www.phpfreechat.net/advanced-configuration">Advanced configuration</a>
            </li>
            <li class="item">
              <a href="http://www.phpfreechat.net/customize">Customize</a>
            </li>
          </ul>
        </li>
      </ul>
      <p class="partner">
        <a href="http://www.phpfreechat.net"><img alt="phpfreechat.net" src="style/logo_88x31.gif" /></a><br/>
      </p>
</div>

<div class="content">
  <?php $chat->printChat(); ?>
  <?php if (isset($params["isadmin"]) && $params["isadmin"]) { ?>
    <p style="color:red;font-weight:bold;">Warning: because of "isadmin" parameter, everybody is admin. Please modify this script before using it on production servers !</p>
  <?php } ?>
</div>

<div class="footer">
  <span class="partners">phpFreeChat partners:</span>
  <a href="http://www.jeu-gratuit.net">jeux gratuits</a> |
  <a href="http://jeux-flash.jeu-gratuit.net">jeux flash</a> |
  <a href="http://www.pronofun.com">pronofun</a> |
  <a href="http://areno.jeu-gratuit.net">areno</a> |
  <a href="http://www.micropolia.com">micropolia</a> |
  <a href="http://www.zeitoun.net">zeitoun</a> |
  <a href="http://federation.jeu-gratuit.net">federation</a>
</div>
   
</body></html>

I'm having some trouble getting some kind of validation built into a form on my site.  I'm using multiple scripts in a form including a lightwindow, as well as some other scripting I found to allow me to submit my form inside the lightwindow.  I'm dying to get some kind of validation code added to the script to stop all of the spam emails, but I'm not able to do it, as I don't truly know PHP.  I tried using a recaptcha, following the instructions carefully, but I think my problem there was that I don't have a simple

Code: [Select]
<input type="submit" />
instead, I have:

Code: [Select]
<a href="thanks.php" style="text-decoration: none" params="lightwindow_form=Catering,lightwindow_width=632,lightwindow_height=1600" class="lightwindow_action" rel="submitForm"><button tabindex="21">Submit</button></a>
Could anyone take a look and give me some pointers?

mikeandzachsbbq DOT com/Catering/   -  click on the link that says Click Here to use our Do-It Yourself

mikeandzachsbbq DOT com/Catering/form.php - form w/out the lightwindow

Thanks in advance

Hi   I am working as a PHP developer in my organization. They asked me to integrate several couriers in of our client's website. As i have only 1 year of experience and i am new to this.   Can any one help me by sending me the courier integration scripts in PHP for   1. Blue Dart 2. Delhivery 3. FEDEX 4. ARAMEX 5. GATI   Kindly help me.

Hello Friends,

I am developing a website with frontend as php and backend MySQL. And i am about to integrate the Skipjack payment gateway. But due to lack of sufficient materials and knowledge about this gateway. I am having the problems in integrating this. So all i got is the encrypted FormBuilder html form code which displays a order button only. When it is clicked the form of skipjack loads. But those form fields are already present in the website. So all i need is to pass the form field value plus other values from my website to the skipjack website and to redirect back to my website when the payment is done. Is there any way to do so?

Thanks in advance.
STRANGESOUL

i get


Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\AtomicPool\s.php on line 93

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\AtomicPool\s.php on line 95

when i use this code:

  <?php
$dbhost  = 'xxxx';
$dbname  = 'xxxx';
$dbuser  = 'xxx';
$dbpass  = 'xxxxxx';

$connect = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());

if (isset($_GET['cat'])){
  $cat = $_GET['cat'];
  $get_cat = mysql_query("SELECT * FROM categories WHERE Short Name = '$cat'");
  $get_cat_rows = mysql_num_rows($get_cat);             --This is Row 93
  if ($get_cat_rows=1){
    while ($fetch = mysql_fetch_assoc($get_cat)){          --This is Row 95
        $categoryyyy = $fetch['Name'];






$categ = "".$categoryyyy." Games"; 
        

    }
  }
   

}
else
     echo "Looks like someone has been playing with the URL bar...";

 ?>