Skip navigation
Currently Being Moderated

how to connect sql database with Flash

Nov 1, 2009 6:15 AM

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

 
Replies
  • Currently Being Moderated
    Nov 1, 2009 8:51 AM   in reply to rahimhaji

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 1, 2009 11:04 AM   in reply to clbeech

    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...

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 2, 2009 6:26 AM   in reply to Striker9099

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 2, 2009 6:29 AM   in reply to clbeech

    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

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points