Updating dynamic data in flash (mySQL/PHP)

Actionscript. You need to be using sendAndLoad to send data back to the database.

PHP. You must first find, or select the row from the database...

//get info from database
$select = "SELECT * FROM `tableName` WHERE `id` = '$id'";

$result = mysql_query($select) or die(mysql_error());

//how many rows were found?
$numresults = mysql_num_rows($result);

//if no rows were found do this
if($numresults==0) {

} else {

//else if a row was found, update it
$update = "UPDATE `tableName` SET `name_txt`='$name_txt' WHERE `id` = '$id'";
mysql_query($update) or die(mysql_error());

Sending/Receiving variables through flash/PHP is a relatively simple affair:

1) User writes variables into input fields
2) Send data to PHP script
3) send info like normal to MySQL

The below Actionscript is used to send data from input fields in your flash to PHP. PHP then returns values, in this case the variable called "varName". Obviously you can change this script so that you can just load the php page and then run the script on that to select the MySQL data and send that back to the Flash program(just ignore the initial variables).

If you want to continually send variables back and forth then just setup some functions which are run when user clicks on, e.g. update, select, delete buttons etc!

//Actionscript
 
var variables:URLVariables = new URLVariables();
var conPage:String="http://www.DOMAINNAME.co.uk/contact.php"; //change to your PHP script
var varSend:URLRequest=new URLRequest(conPage);
varSend.method=URLRequestMethod.POST; //Method of sending data
varSend.data=variables; //Name of your variables acontainer
var varLoader:URLLoader=new URLLoader();//Load the URLLoader
varLoader.dataFormat=URLLoaderDataFormat.VARIABLES;
 
//Set all of the variables you want to send to PHP-------------------------------
variables.id=this.contact_id.input_txt.text;//These are obviously textfields
variables.name=this.contact_name.input_txt.text;
variables.details=this.contact_details.input_txt.text;
variables.price=this.contact_price.input_txt.text;
 
variables.sendRequest="parse";
varLoader.addEventListener(Event.COMPLETE, pageLoaded);
varLoader.load(varSend);//Load the PHP page/variables and once its loaded perform the function "pageLoaded"
 
function pageLoaded(e:Event):void {
          var strName:String=e.target.data.varName;//This targets the information received back from the PHP script for a variable called "varName"
          //Do whatever you want with the information you get back from the PHP script.
}
 
 
//PHP---------------------------------(As per Crooksy's comment above)
 
In PHP grab the variables from the flash file (If you had any in the first place):
     $personsname = $_POST['name']; //(Don't forget our method was POST and so this is how PHP will read the variables)
 
//get info from database
$select = "SELECT * FROM `tableName` WHERE `id` = '$id'";
 
$result = mysql_query($select) or die(mysql_error());
 
//how many rows were found?
$numresults = mysql_affected_rows($result);
 
//if no rows were found do this
if($numresults==0) {
 
} else {
 
//else if a row was found, update it
$update = "UPDATE `tableName` SET `name_txt`='$name_txt' WHERE `id` = '$id'";
mysql_query($update) or die(mysql_error());

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:

hello crooksy88 & andoneknight, thank you for the fast response.

I was wondering if you can translate that actionscript to a loadVars format?

---------------------
i load/display all my data from mySQL using loadVars currently with the following code in snippet below.


So can we incorporate my existing code with the 'Update' code?  (loadVars)?

here is a preview of the file and how it loads the data
http://previewsample.com/loaddatacms

myData = new LoadVars();
 
myData.load("http://previewsample.com/loaddatacms/loadcms.php");
myData.ref = this;
 
//Fetch data 
myData.onLoad = function(succes)
{
	if (succes)
	{
		for (var i:Number = 0 ; i < parseInt(this.cant) ; i++)
		{
			this.ref["mc" + i].id.htmlText = "" + this["id" + i] + "";
			this.ref["mc" + i].name_txt.htmlText = "" + this["name_txt" + i] + "";
			this.ref["mc" + i].details_txt.htmlText = "" + this["details_txt" + i] + "";
			this.ref["mc" + i].price_txt.htmlText = "" + this["price_txt" + i] + "";
			
			
			
		}
	}
	else
	{
		trace("Error loading data");
	}
};
stop();

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:

I think there is a little confusion here.
LoadVars is an object that stores vars that are received from a specified url.
LoadVars by itself cannot send data to a php script that then updates a database.

You need to break down the procedure as follows:

1. Gather data in flash and send it to the PHP script (using sendAndLoad();)

2. PHP collects the data and updates a database, then sends data back to Flash.

3. LoadVars collects this data and you do something with it.

This is what a typical sendAndLoad might look like

var sendData:LoadVars = new LoadVars();
var loadData:LoadVars = new LoadVars();
 
//add the vars to the sendData object
sendData.name_Txt = "Peter";
sendData.var_2 = "var2"
 
//send vars to the php script and pass the return data to loadData
sendData.sendAndLoad("http://www.domain.com/script.php", loadData, "POST");
 
//when loadData actually loads the data that is returned, run the whatToDo function
loadData.onLoad = whatToDo;  
}
 
function whatToDo(success:Boolean) { 
if (success) {
 
trace("LOADDATA RECEIVED: "+loadData);
	
} else {
trace("ERROR");
}
}
}

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:

hello,
sorry your code threw me off with all of the URLRequest and URLLoader variables.
----------------------------------
Using your actionscript. i have 4 compiler errors.....
here is the .fla ,, if you wish, to view what the heck is going on.. ;))
http://previewsample.com/loadupdate/loadupdate.fla

----------------
also , in the PHP there was an error when i tested in the browser,, it reads the following:
Parse error:  syntax error, unexpected $end in /homepages/34/d229401770/htdocs/111Privet/LoadUpdate/update.php on line 32


view here.  (PHP code is in snippet below)
http://previewsample.com/loadupdate/update.php
------------------------------------------------------------------------------

is there any way we can go with the simplfied version of actionscript  that you posted in your last message? (you lost me on all the URLrequest's and URLloader things.. )   <<<<< sorry if i come across as a doofas.. i am just learning all of this. ;)))

<?php
$connect = mysql_connect("db1603.perfora.net", "dbo254844067", "Q77hasTT");
mysql_select_db("db254844067", $connect);
 
 
 
//PHP---------------------------------(As per Crooksy's comment above)
 
//In PHP grab the variables from the flash file (If you had any in the first place):
     $name_txt = $_POST['name_txt']; //(Don't forget our method was POST and so this is how PHP will read the variables)
 	$details_txt = $_POST['details_txt'];
 	$price_txt = $_POST['price_txt'];
 
 
//get info from database
$select = "SELECT * FROM loadtest WHERE `id` = '$id'";
 
$result = mysql_query($select) or die(mysql_error());
 
//how many rows were found?
$numresults = mysql_affected_rows($result);
 
//if no rows were found do this
if($numresults==0) {
 
} else {
 
//else if a row was found, update it
$update = "UPDATE loadtest SET `price_txt`='$price _txt' WHERE `id` = '$id'";
mysql_query($update) or die(mysql_error());
 
?>

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:

FYI andoneknight's code is AS3.

In your PHP file you are looking for $id but you have not specified a variable named $id.

@crooksy88..

thanks for pointing that out.. i though i stated that i was using AS2 at the beginning..

soo. then we can use your version: (attached below on snippet..)
but i still get a compiler error for "unexpected '}' on line 14"

i tried to remove it and then it gives me 3 other compiler errors.  how can that be fixed?

-----------------------------------
on the PHP, i have added the variable $id,,, but it still has that error.
http://previewsample.com/loadupdate/update.php

------------------------------
so we have one flash compiler error and one error on the PHP.      is there some kind of program to fix these? or is it just trouble shooting? but i have no idea hot to fix it..i've tried removing that 'unexpected }' but then it gave me more compiler errors.

var sendData:LoadVars = new LoadVars();
var loadData:LoadVars = new LoadVars();
 
//add the vars to the sendData object
sendData.name_xt = "name_txt";
sendData.details_txt = "details_txt"
sendData.price_txt = "price_txt"
 
//send vars to the php script and pass the return data to loadData
sendData.sendAndLoad("http://www.previewsample.com/loadupdate/update.php", loadData, "POST");
 
//when loadData actually loads the data that is returned, run the whatToDo function
loadData.onLoad = whatToDo;  
}
 
function whatToDo(success:Boolean) { 
if (success) {
 
trace("LOADDATA RECEIVED: "+loadData);
        
} else {
trace("ERROR");
}
}
}

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:

do i need to add the id variable in the actionscript to?    or is that just for referencing the record we are targeting?

Flash:

When you have issues with curly braces it's a good idea to comment them so you can see which is doing what.

var sendData:LoadVars = new LoadVars();
var loadData:LoadVars = new LoadVars();
 
//add the vars to the sendData object
sendData.name_xt = "name_txt";
sendData.details_txt = "details_txt"
sendData.price_txt = "price_txt"
 
//send vars to the php script and pass the return data to loadData
sendData.sendAndLoad("http://www.previewsample.com/loadupdate/update.php", loadData, "POST");
 
//when loadData actually loads the data that is returned, run the whatToDo function
loadData.onLoad = whatToDo;  
 
function whatToDo(success:Boolean) { 
if (success) {
trace("LOADDATA RECEIVED: "+loadData);      
} //close if
 
else {
trace("ERROR");
 
}//close else
}// close function
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:

PHP

Try 'reading through' your PHP to follow what it is trying to do...

<?php
//connect to database
$connect = mysql_connect("db1603.perfora.net", "dbo254844067", "Q77hasTT");
mysql_select_db("db254844067", $connect);
 
//get variables from the flash post
$name_txt = $_POST['name_txt'];
$details_txt = $_POST['details_txt'];
$price_txt = $_POST['price_txt'];
 
 
//get info from database
//select all from the table loadtest where column 'id' equals the variable $'id'
$select = "SELECT * FROM loadtest WHERE `id` = '$id'";

//(NOTE The problem here is that php hasn't been told about a variable named $id yet)

//This query should reflect the variables you have and the table columns you have
// e.g. $select = "SELECT * FROM loadtest WHERE `name_txt` = '$name_txt";
//This assumes you have a column in your table called name_txt
 
$result = mysql_query($select) or die(mysql_error());
 
//how many rows were found?
//NOTE. Just pointing out this is different to my code above
$numresults = mysql_affected_rows($result);
 
//if no rows were found do this
if($numresults==0) {
 
} else {
 
//else if a row was found, update it
//NOTE again you are using the $id variable here which hasn't been defined.

$update = "UPDATE loadtest SET `price_txt`='$price _txt' WHERE `id` = '$id'";
mysql_query($update) or die(mysql_error());
 
?>

thank you for that information crooksy88..

the flash is compiling with no errors..
-------------------------------------------------------
so what you were explaining about the id variable,  I have added this line below:

//get variables from the flash post
$id = $_POST['id'];   // I ADDED THIS LINE... IS THIS WHAT YOU MEAN?
$name_txt = $_POST['name_txt'];
$details_txt = $_POST['details_txt'];
$price_txt = $_POST['price_txt'];
-----------------------------------------------------------------------------------------------


however, the PHP is still giving the error message when i test in browser:
HTTP://previewsample.com/loadupdate/update.php

--------------------------------------------------------------------------------
error message is still the same:

almost a step closer to 'updating text in flash' !!!!

what the heck could be wrong with the PHP? i'm going to google that error message .. please let me know if you know what that error is.

<?php
//connect to database
$connect = mysql_connect("db1603.perfora.net", "dbo254844067", "Q77hasTT");
mysql_select_db("db254844067", $connect);
 
//get variables from the flash post
$id = $_POST['id'];
$name_txt = $_POST['name_txt'];
$details_txt = $_POST['details_txt'];
$price_txt = $_POST['price_txt'];
 
 
//get info from database
//select all from the table loadtest where column 'id' equals the variable $'id'
$select = "SELECT * FROM loadtest WHERE `id` = '$id'";
 
//(NOTE The problem here is that php hasn't been told about a variable named $id yet)
 
//This query should reflect the variables you have and the table columns you have
// e.g. $select = "SELECT * FROM loadtest WHERE `name_txt` = '$name_txt";
//This assumes you have a column in your table called name_txt
 
$result = mysql_query($select) or die(mysql_error());
 
//how many rows were found?
//NOTE. Just pointing out this is different to my code above
$numresults = mysql_affected_rows($result);
 
//if no rows were found do this
if($numresults==0) {
 
} else {
 
//else if a row was found, update it
//NOTE again you are using the $id variable here which hasn't been defined.
 
$update = "UPDATE loadtest SET `price_txt`='$price _txt' WHERE `id` = '$id'";
mysql_query($update) or die(mysql_error());
 
?>

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:

$id = $_POST['id'];

So now you have this line in your PHP file, what is it doing?

yes that line $id =$_POST['id']; is getting variables from the flash..  correct?
--------------------------------------------
i have fixed the PHP... it was missing a curly bracket at the end..

--------------
but nothing is loading into flash...so obviously then there is nothing to edit... (there is data in mySQL

are you sending id with a value from flash?
e.g. in flash

//add the vars to the sendData object
sendData.id = 2;
sendData.name_xt = "name_txt";
sendData.details_txt = "details_txt"
sendData.price_txt = "price_txt"

--
And in your database table, do you have a column named 'id'?
Is there a record with the id value the same as what you are searching for?
Put your tablename in quotation marks.
$select = "SELECT * FROM `loadtest` WHERE `id` = '$id'";

yes in my table, the column is named 'id'        and that is the primary , auto increment index.
----------------------------------
i added this line in AS:
sendData.id = 2;                   ...but it did nothing. still blank when i load the .fla
=======================================

Should we have :>>>

loadData.id = 2;
loadData.name_xt = "name_txt";
loadData.details_txt = "details_txt"
loadData.price_txt = "price_txt"

?????\
=======================
since we have both at the beginning of the actionscript: >>>
var sendData:LoadVars = new LoadVars();
var loadData:LoadVars = new LoadVars();

=====================================
also, i added single quotes on the table name but it gave an error message when tested in browser..,, referring to the quotes inserted...so i removed them.

on the flash side.... what all should i have on the stage?

can you take a look inside the .fla to see if something might be wrong there please?

http://previewsample.com/loadupdate/loadupdate.fla

Give me the details of a database table row and I'll amend your fla so that it works.

ie. I need the table row names and the contents of one of the rows.

Hang on what are you trying to do here?

send data to php so that it updates a database or get data from a database and display it in Flash?

Currently as I stated from the beginning, all i have is the part where my data loads into flash , and each entry from the database is loaded into its own movie clip.  It is displayed in flash this way..  
-----(here is a working preview of how the data loads)
http://previewsample.com/loaddatacms

===============================
What I am trying to do is edit/update one of the entries that you see.  Obviously there are multiple entries in the data base, so we would need to pick one of those entries and then be able to update it.

For learning purposes, i was just trying to keep it simple and follow what you are trying to do.

But the main objective is to be able to update data.  so if you have a simple way to do it that is different from the way I load the data in, then that will work ;)
==============================================

but i think that once i can see it actually working , and the code that makes it work, i can take it and integrate it with my above file.

hope that makes sense. ?
--------------------------------------------------------

I attached screenshots of the table and the contents..
and here is the username/password/table info if you can get in someway with this?

$connect = mysql_connect("db1603.perfora.net", "dbo254844067", "Q77hasTT");
mysql_select_db("db254844067", $connect);

OK, within your fla file you were attempting to send the variables to php as soon as the swf was run. This meant that it was sending blank data as you didn't have time to fill the text fields in.

So you need a form to fill in, then when you hit the submit button, it send the data to php.

save the attached fla and delete the .txt from the end of the name.

hi!,

ok i uploaded your .fla.......... and from what i understand so far, i must enter the # of the id.. so for example... if i want to edit the 2nd entry in that table... i must enter '2' in the "input ID number' field you created..and then enter the data that i want to replace the old data with?  correct?

i tried that but it is not updating.. i went into the mySQL database and checked.  was there something else i have to do?


i have the lastest PHP uploaded also.
=============
if it is easier please access my FTP

host: previewsample.com
user; u47663653-22
pass: password

<?php
//connect to database
$connect = mysql_connect("db1603.perfora.net", "dbo254844067", "Q77hasTT");
mysql_select_db("db254844067", $connect);
 
//get variables from the flash post
$id = $_POST['id'];
$name_txt = $_POST['name_txt'];
$details_txt = $_POST['details_txt'];
$price_txt = $_POST['price_txt'];
 
 
//get info from database
//select all from the table loadtest where column 'id' equals the variable $'id'
$select = "SELECT * FROM loadtest WHERE `id` = '$id'";
 
//(NOTE The problem here is that php hasn't been told about a variable named $id yet)
 
//This query should reflect the variables you have and the table columns you have
// e.g. $select = "SELECT * FROM loadtest WHERE `name_txt` = '$name_txt";
//This assumes you have a column in your table called name_txt
 
$result = mysql_query($select) or die(mysql_error());
 
//how many rows were found?
//NOTE. Just pointing out this is different to my code above
$numresults = mysql_affected_rows($result);
 
//if no rows were found do this
if($numresults==0) {
 
} else {
 
//else if a row was found, update it
//NOTE again you are using the $id variable here which hasn't been defined.
 
$update = "UPDATE 'loadtest' SET `price_txt`='$price _txt' WHERE `id` = '$id'";
mysql_query($update) or die(mysql_error());
}
if($result) echo "writing=Ok&";
   else echo "writing=Error";
?>

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:

http://previewsample.com/loadupdate

Yes you are correct. Unfortunately I don't have time to sort this out for you.

In the first instance what you need to do is make sure your PHP file is working and is writing to the database. i.e. cut flash out of the equasion.

So you need to create a simple html form that you can fill in and post to your php script. Once you have that working and your database is being written to, we can then look at introducing Flash.

I have built a form in flash that inserts a new entry into mySQL.. it works fine .. please view and try inserting a new record..

http://previewsample.com/loadupdate
http://previewsample.com/loadupdate/loadupdate.fla
----------------------------------------------------------
I have tried many possibilities and also checked the code 10x.  It is still not updating.

Here is the current PHP below.

we are very close.. i can feel it.. ;))))

<?php
//connect to database
$connect = mysql_connect("db1603.perfora.net", "dbo254844067", "Q77hasTT");
mysql_select_db("db254844067", $connect);
 
//get variables from the flash post
$id = $_POST['id'];
$name_txt = $_POST['name_txt'];
$details_txt = $_POST['details_txt'];
$price_txt = $_POST['price_txt'];
 
 
//get info from database
//select all from the table loadtest where column 'id' equals the variable $'id'
$select = "SELECT * FROM loadtest WHERE `id` = '$id'";
 
//(NOTE The problem here is that php hasn't been told about a variable named $id yet)
 
//This query should reflect the variables you have and the table columns you have
// e.g. $select = "SELECT * FROM loadtest WHERE `name_txt` = '$name_txt";
//This assumes you have a column in your table called name_txt
 
$result = mysql_query($select) or die(mysql_error());
 
//how many rows were found?
//NOTE. Just pointing out this is different to my code above
$numresults = mysql_affected_rows($result);
 
//if no rows were found do this
if($numresults==0) {
 
} else {
 
//else if a row was found, update it
//NOTE again you are using the $id variable here which hasn't been defined.
 
$update = "UPDATE loadtest SET `name_txt`='$name_txt', `details_txt`='$details _txt', `price_txt`='$price _txt' WHERE `id` = '$id'";
//$update = "UPDATE loadtest set name_txt = '$name_txt', details_txt = '$details_txt', price_txt = '$price_txt' where id = '$id'";
 
mysql_query($update) or die(mysql_error());
}
if($result) echo "writing=Ok&";
   else echo "writing=Error";
?>

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:

Just came back to this - Apologies I didn't see that you mentioned you are using AS2 - I must have ignored that bit ^.^

Unfortunately I can't help, just thought I'd apologise :-)

@andoneknight..   its something i need to learn ;)))

thank you for your thoughts anyways.

So I just had a quick look anyway ^.^

(I don't know if this is outdated code - downloaded the above loadupdate.fla.txt)

You use:
sendData.id = _root.panel_mc.id.text; ----------> The text field for ID is called id_txt do you mean sendData.id = _root.panel_mc.id_txt.text; ?

I checked your PHP... looks fine.

@andoneknight... yes thank you for looking... i had fixed that after i reviewed also.. so all instance names for ID are 'id'  .. but that didnt fix the problem yet.. ;))

OK I've uploaded a testing form for you and amended your update.php script.

But I can't access the mySQL admin to see if the database has been updated so you will have to do that and report back. Record 2 should now be set to have the word 'test'.

http://previewsample.com/LoadUpdate/indexform.html

good morning crooksy88.. i have checked the table and it has not updated.. instead it filled the field with '0'

i attached a picture.
==========================
i dont know if you have seen it or not. but 6 posts before this one please see my comments and the updated file.  I have made a flash form that inserts new records and also you can see the data that is there...

please find the link above (6 posts before this one, and the messages from 'andoneknight')

------------------------------
i have also tried your form and it does not update the data, it just replaces it with a '0' in the 'name_txt' field.

I've just used your form to add a record. Has it been inserted?

yes it has been inserted. you can view all the data by clicking on but 'VIEW DATA' button directly below the form where you inserted the new record.

http://previewsample.com/loadupdate

also here is the source

http://previewsample.com/loadupdate/loadupdate.fla

Your form is working now.

2 issues that I changed.

1. You had two forms both with the same instance name 'panel_mc'
2. Your URL to update.php was incorrect.You had /loadupdate/ when it should have been /LoadUpdate/

The fla is on your FTP server... loadupdate2.fla.

PS. remember to change your database and ftp login settings as you have posted them on this question.
You might want to request this question be deleted.

which form are you referring to that is working?  because the 'insert new record' form was working already...  but i just tried updating a record again with your 'update' form but it still did not update. ??

also, the .fla you uploaded on the server was no good.. i tried to open it and it said ''unexpected file format''

;((

It is working, you just need to set the form to do something once the response has been received.
I've set it up now to jump to frame 2 so you can see the results.

I've just updated record 16.

I've re-uploaded the fla as CS3

AWESOMEEEEEEEEEE :))))))

you are the best!

that is wondeful . thank you very much . good fortune will come your way for helping me.
worth a million

and i assume that this works the same way for deleting a record.. i would just need to change the PHP to DELETE instead of UPDATE?