I am very new to using databases and Flash. I have Flash CS3 so I can use any
version of AS. Below are my goals for the project.
-Front end that will allow me to enter in a Name and Kind.
-Submit the information to a database.
-Browse all entries in the database.
-Delete entries in the database if needed.
This is for my local Relay for Life. We need a better way to make a database
of our luminaria sales. The data entered would be something like.
Name = John Doe
Kind = Memory
Name is just the name of the person and Kind will be either Memory or Honor.
I have no idea how to go about this. If this ends up working like I want it
to, I could see this being used by many Relay for Life events throughout the
country. I will create a tutorial on how to use the program and I will also
include any credits for people that submit to the completion of this project.
Please understand that I will make NO money from this project. I am just
trying to create something to help streamline the efforts of Relay for Life
volunteers.
Thank you.
The Feldkircher - 28 Feb 2008 12:41 GMT
Hi
You will need to get very friendly with PHP and MySQL, both of these are
required for what you want to acheive.
Google for 'Flash + PHP + MySQL', read as much as you can get familiar with
what they do and how they interact.
Welcome to the world of Flash, your life will never be the same again.
mysteNights - 29 Feb 2008 12:19 GMT
Feldkircher, say is the flash + PHP an alternative to using flash remoting for interaction with the sql db?
The Feldkircher - 03 Mar 2008 12:05 GMT
Hi
Flash Remoting I believe is the proprietary method of Macromedia/Adobe, can be
a steep learning curve so I am told. You can use AMFPHP as an alternative, or
the LoadVars function of Flash.
There are many ways to connect all this together its just down to personal
choice really.
Hope it helps
MYSCREENNAMEISUNAVAILABLE - 03 Mar 2008 17:54 GMT
First, the Feldkircher is one top-notch guy on this forum in my book.
The BEST recommendation which someone posted to me was to buy the two books by
David Powers, Foundation PHP5 for Flash, and PHP Solutions: Dynamic Web Design
Made Easy. However, IT ISN'T EASY.
Not only do these books tell how to set up your offline server but they give
examples which aren't necessarily straight forward because you could have
different mysql and php versions on your web hosting server.
As you can see by my many posts, I purchased a flash sql component from
Netdrims (now flexcubed) which with Feldkircher's help I got working offline
but NEVER got to work on my server. There tech support is far and very far
between - let's say that they have no phone number and email you every 2-3
weeks basically leaving you if they can't help you.
Although books and advice help, the situations are unique to your own
webhosting environment --> mine doesn't offer mysqli (mysql improved) which
many of the examples in Powers' books rely on.
I'm using David Power's books now to do it by writing my own php files and
actually got the php file to query my database and display the results of one
column. But it doesn't work with his next step, creating a cache file.
Also google your issues and other flash forums will show up.
dzedward - 03 Mar 2008 19:16 GMT
http://www.flashgods.org/forums/viewtopic.php?f=20&t=98 on this subject.
However, it is for AS3, but you say you are willing to use either AS2 or AS3.
This will query the database with a variable it posts, then echo the response
back via XML. Enjoy.
mwg646 - 03 Mar 2008 19:22 GMT
Thanks for all of the responses.
I think that I have it figured out now.