Webmaster Forum / Flash / Data Integration / April 2007

If this is a question of the server script. Could be syntax errors, database
authentication errors, SQL errors, logic errors, web server scripting
configuration issues. For example is it templete or template in your code. Is
it quantity with lower case q or Quantity with uppercase q.

The best way to debug the server script is to create a simple HTML form and
pass the needed variables to it. Then you should have the PHP set so all errors
are returned. Now you can see if you have PHP errors, SQL errors and so on. You
can add special echo statements for debugging.

ONe item I did notice is that the echo statement assumes the PHP script is
providing data to an HTML form. If you add echo statements for debugging, be
sure to remove when returning to using Flash with the script.

The PHP should only echo data in URL var format
&var1=value&var2=valu$var3=value and so on without anything else.

This also means you can have no whitespace before and after the PHP tags.
So the echo "<br/>" needs to go.

$index = 0;
while($row = mysql_fetch_array($result))
{
$index++;
echo "&id" .  $index  .  "=" . $row['Id'];
echo "&templete" .  $index  .  "=" . $row['templete'];
echo "&price" .  $index  .  "=" . $row['price'];
echo "&option1'" .  $index  .  "=" . $row['option1''];
echo "&option2'" .  $index  .  "=" . $row['option2''];
}

Looks good. Just you want to attach the sending variables to the send LoadVars
object. See attached code.
For the time being you may want to simply send one hard coded variable and use
a copy of the PHP script that returns that value to work out the client server
issues. Then once that is done you can work on the details at both ends.

var send_lv:LoadVars = new LoadVars();
var result_lv:LoadVars = new LoadVars();
result_lv.onLoad = function(success:Boolean)
{
trace(success);
};
button1.onRelease = function () {
send_lv.ID=myPayPalItem.ID;
send_lv.maxQuantity = button1.maxQuantity;
//send_lv.name = "templete";
send_lv.name = button1.name;
send_lv.option1Name = button1.option1Name;
send_lv.option1Value = button1.option1Value;
send_lv.price = button1.price;
send_lv.sendAndLoad("http://www.guyswebdesigns.com/PHPfolder/testpage.php?",
result_lv, "POST");

}

//=======================================
Testing the client server

var send_lv:LoadVars = new LoadVars();
var result_lv:LoadVars = new LoadVars();
result_lv.onLoad = function(success:Boolean)
{
      trace("result_lv.onLoad - success:"+ success);
      trace ("result_lv.name:"+result_lv.name);
};
button1.onRelease = function () {
send_lv.name = "Joe";

send_lv.sendAndLoad("http://www.guyswebdesigns.com/PHPfolder/testpage.php?",
result_lv, "POST");

}

-----------------------------------------
<?php
 echo "&name=" . $_REQUEST['name'];
?>

These are as you say components developed by a company:

"The ANYRD PayPal Cart Components are a set of simple to use flash components
that make it very easy to add self-contained shopping cart capabilites to your
flash movie for use with the PayPal payment service."

Their web site claims they have all the documentation in the Flash help once
you install them. However they have docshttp://anyrd.anyrd.com/docs/ppcc/.

They do not have a user forum to ask questions I noticed but do have an email
address that does not look like it wants inquiries but you could try.