STUCK in Storing data from flash then php into mySQL

the0nly1

hi all,

i current working on a project. i wanted to store data entered by the user in the swf to be store into mySQL

here is my flash code

submitButton.onPress = function () {
mySend = new LoadVars();
mySend.client = Client.text;
mySend.send('http://localhost/somephpfile.php','POST');
}

here is my php code

<?php
mysql_connect("localhost","root") or die(mysql_error());
mysql_select_db("brimelow_store:") or die(mysql_error());
//$client = mysql_real_escape_string ($_POST["client"]);
$client = $_POST["client"];
$query = " INSERT INTO products (product) VALUES ('$client') ";
$result = mysql_query($query);
?>

and i keep receiving an error message :
Notice: Undefined index: client in C:\wamp\www\somephpfile.php on line 18

plz help!!! thank!

sneakyimp

Firstly, please use the code formatting tags around your code so they get highlighted. It makes them easier to read.

I'm guessing that you are getting that error when you visit http://localhost/somephpfile.php in your browser. That would be true because you haven't POSTed any data to the page.

I also noticed that you don't check for errors when you query in your PHP.

Why have you commented out the line with [man]mysql_real_escape_string[/man]? You definitely should be doing that.

You also don't check to see if your [man]mysql_connect[/man] command worked. If that fails, your query is never going to work because you failed to connect. You aren't supplying a password so this is quite likely.

the0nly1

sry to trouble you.

Erm... i did enter some words in the swf file and press submit button. that will i will receive Notice: Undefined index: client in C:\wamp\www\somephpfile.php on line 18.

i never put passwords in the mysql_connect("localhost","root") is becuz i was doing a beta. i wanna to try out 1st, is there a way to store data from SWF to MYSQL.

mysql_real_escape_string, this is i copy from a fren. he asked me to try using this. LOL

sneakyimp

So how do you know that you received this error?
Notice: Undefined index: client in C:\wamp\www\somephpfile.php on line 18

If you had a SWF open and you clicked submitButton, I don't think the SWF would report that error from PHP.

the0nly1

Notice: Undefined index: client in C:\wamp\www\somephpfile.php on line 18

i receive this error on the browser! when i wanted to see if my database update anot? i recieve this message.

sneakyimp

The error is because you loaded the page in your browser without POSTing any data. This should happen when you access your script via flash. The behavior should be different because flash is POSTING