how to connect sql database with Flash

[rahimhaji]

Dear Friends,

Iam working on a quessinarie (assesment) for elearning software. i want to connect sql database with flash and save my records in back end like add, delete, modification of student result and details.

Kindly help me to connect the sql database. or dot net server. I know how to connect PHP and mysql. But my client dont want php. only sql database and do the add, del, modificaiton.

Thanks in advance,

Syed Abdul Rahim

[clbeech]

this cannot be done - you must run a server-side script to access a server DB - php is a common option, along with Java, JavaScript, ASP, ColdFusion, etc.  you will need to educate your client on the fact that a client-side script cannot do this for security reasons.

[Striker9099]

clbeech, do you know how to do that with ASP.NET? I think the actionscript 3.0 that should take care of this stuff is by using the URLLoader and URLVariables classes... but from there, I have no idea what to do...

[clbeech]

unfortunately no, i do not know ASP well enough to give any code advice, other than the basic concept:  make a request on a server-side script (such as ASP) via URLLoader - the script receives variable values (if required), runs the DB queries you wish to invoke, and 'returns' the results - pick them up in the URLVariables class via the event handler in Flash and assign them to local properties if needed, etc.

there are quite a few threads that you could find more specific information on the ASP side, here and elsewhere around the net.

[Striker9099]

Yeh that's almost the same procedure you would follow to do this stuff with PHP. Unfortunately, everybody uses AS3 with PHP rather than ASP.NET but anyway, I'll try to find some code snippets that might help. Thanks

[rahimhaji]

hi friend,

thks for ur response. pls help me to connect asp.net and save datas.....

thanks and Regards,

Syed Adbul Rahim