Re: FLASH: Writing to the Database

[Sergio Santos]

I there, i'm doing database writes with php and mysql, but the theory should

be the same.


I use loadvaribles in my movies to execute the php scripts, basicly when I

want to get data from the database, my php file outputs variables like:

...(sql query)... ;

echo "id=".urlencode($var);

echo "&name=".urlencode($var2);

etc...

This means i get those loaded variables in the specified level/target of the

movie.


Now when an insert/update/delete is needed, I use load variables in the

same.You may use a  "tracking variable" to return the result of the database

action (true or false for example).

The movie must POST the necessary variables so that the php script may do

the action correctly without any errors. If you have several levels on your

movie or are calling it from another clip, you must first be sure that the

movie that calls the script has the necessary variables to POST. Flash

debugger is quite helpfull on this.


And don't forget, asp/php scripts are only executed when called from the web

server, previewing in flash won't work.

All of the above should be the same switching php for asp.

I can provide you with some code, if you need contact me.


Sergio

----- Original Message -----

From: "Vinh Thai" <

flashrookiehotmail [dot] com

>

To: <

flasherchinwag [dot] com

>

Sent: Thursday, September 14, 2000 4:42 PM

Subject: FLASH: Writing to the Database



> hi everyone,

>

> here the situation.  i'm using flash as my front end, asp in the middle,

and

> an access database.  i'm able to read and pull images from access through

> asp, but i can't seem to write to it.  if someone could either give me an

> example or point me to the rigth direction; a book or site, anything.

>

> thanks in advance.

> -vgt-




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

NudeGuru.com is proud to sponsor the Flasher list

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

        IT'S  THE  ART  OF  MONEY,  HONEY!

 Tips and Advice from some of the most popular Flash

 artists + industry power-brokers on how to hold onto

 your rights, negotiate contracts and get full value

 for your work.http://www.nudeguru.com from Franke James

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com