Actionscript PHP and MySql Problem

[Zarwadi]

Hi, I have been creating a simple flash site and I need to use PHP and MySql, which I have never done. And I really need help.
I've created a database but I can't get my action script to send my variable to my PHP code. I think my Mysql data base has been set up wrong, but because I have never done this before I don't know what I am doing wrong.
Please can some help me. I have not slept for 3 days
If anyone can help me i will be eternally greatful.

This is how for I've got

 
function sendmail() {
var dbVar = new LoadVars();
db_path = "localhost/shop.php";
for (var i = 0; i<_root.mycart.length; i++) {
dbVar.itemdent = "ID: "+_root.mycart.getItemAt(i).id;
dbVar.ItemSize = "Size: "+_root.mycart.getItemAt(i).size;
dbVar.ItemProduct = "Product: "+_root.mycart.getItemAt(i).product;
dbVar.ItemQut = "Quantity: "+_root.mycart.getItemAt(i).qut;
dbVar.ItemPrice = "Price: "+_root.mycart.getItemAt(i).price;
}
dbVar.sendAndLoad(db_path, dbVar, "POST");
trace(dbVar);
}
_root.billing_mov.send_bt.onRelease = function() {
sendmail();
};
 

<?php
// Make a MySQL Connection
require("db.php");
//creating a var
$var_itemdent = $_POST['itemdent'];
$var_itemQut = $_POST['itemQut'];
$var_itemProduct = $_POST['itemProduct'];
$var_itemSize = $_POST['itemSize'];
$var_itemPrice = $_POST['itemPrice'];
 
/* Strip any escape characters etc */
$var_itemdent = stripslashes($var_itemdent);
$var_itemQut = stripslashes($var_itemQut);
$var_itemProduct = stripslashes($var_itemProduct);
$var_itemSize = stripslashes($var_itemSize);
$var_itemPrice = stripslashes($var_itemPrice);
 
// Insert a row of information into the table "customer orders"
$q1 = "INSERT INTO customer orders (id, qut, products, size, price)
VALUES ('$var_itemdent', '$var_itemQut', '$var_itemProduct', '$var_itemSize', '$var_itemPrice')";
echo $q1;
mysql_close($con);
?>
 

[endline]

this may be a silly question, but did you set up an appropriate table in the SQL db?
i had my fun using the command prompt exercises while reading the sql manual, and then I discovered phpMyAdmin. its available on most hosts and greatly helps in setting up sql dbs.

usually, php and my sql will give errors (in great detail lol) any errors we should know about that might help someone trying to help you?

[Zarwadi]

Hi thanks for getting back to me,
I have found out that my flash code is not send the LoadVar to the PHP, I don't understand I have been coding in action script for over 7 years and I know how to send a Var but this time I'm stumped. When I trace the Loadvar every thing looks right.

Any help would be greatfuly received
Zarwadi

Actionscript code:
_root.billing_m ov.send_bt.onRe lease = function() {
db_path = "localhost/admin1/shop.php";
var dbVar = new LoadVars();
for (var i = 0; i<_root.mycart. length; i++) {
dbVar.itemdent = _root.mycart.ge tItemAt(i).id;
dbVar.ItemSize = _root.mycart.ge tItemAt(i).size ;
dbVar.ItemProdu ct = _root.mycart.ge tItemAt(i).prod uct;
dbVar.ItemQut = _root.mycart.ge tItemAt(i).qut;
dbVar.ItemPrice = _root.mycart.ge tItemAt(i).pric e;
}
dbVar.onLoad = function(succes s:Boolean) {
if (success) {
trace("Your info has been sent");
trace(dbVar);
} else {
trace("Error connecting to server.");
}
};
send_Result.sen dAndLoad(db_pat h, dbVar, "POST");
};
Trace output
07003%5F2=&onLo ad=%5Btype%20Fu nction%5D&ItemP rice= 26%2E00&ItemQut =1&ItemProduct= Gaucho%20pants& ItemSize= 14&itemdent=070 03%5F2

[Zarwadi]

[Hi I think i've found the problem, but I do not under stand it, do you know what this means

Re: [jQuery] Bug Report - Component returned failure code: 0x80070057 (NS_ERROR_ILLEG AL_VALUE), it has some thing to do with my PHP

kind regards
zarwadi