Skip to main content
Inspiring
November 1, 2009
Question

how to connect sql database with Flash

  • November 1, 2009
  • 1 reply
  • 4650 views

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

This topic has been closed for replies.

1 reply

clbeech
Inspiring
November 1, 2009

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.

Inspiring
November 1, 2009

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
Inspiring
November 2, 2009

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.