I am facing a challenge which deadline is May 15.
Goal is to build in Flash a search engine able to retrieve in a MySQL DB a student amongst the students present in my School over a period of five years. I have also exported the DB in XML which results in a 350K File, just to say that I am not stuck with MySQL and that I can contemplate an XML driven solution.
The DB is filled with almost 700 Entries in a Table which Fields are: ID, lastName, firstName, promo (French equivalent of “class of”), joining (year the student join the promo-“class of”), street, city, postalCode (“ZIP” code), country, phone, email, webSite, notes.
In my FLA, I have already created the two mandatory Input Fields [ ‘sLastName’, variable ‘nom’ (which means Last Name in French) and ‘sFirstName’, variable ‘prenom’ (which means First Name in French). Two Input Fields are necessary to differentiate brothers having the same Last Name…
I have also created the Dynamic Fields to receive the pertinent informations found in the DB. These Fields have the very same Names as the DB Fields. Variable names for their content are not yet assigned (are they necessary?).
I know how to load the XML, but no more* :-(((
I also must say that I’ll prefer a MySQL solution, I think it offers more security for the confidential data and it is more robust…
In FlashMX ActionScript, what I don’t know (and understand despite the numerous search I made in many tutorials) is how to ask the DB for the two Input Fields content and if they are found in the DB how to pass them (with ALL the above mentioned associated Fields content) to the SWF and display them in the appropriate Dynamic Fields).
You can see the UI at <http://www.germaris.com/aet_login/list/aet_list.swf>.
The bottom search button is here to perform a search by “class of” (field ‘Promo’ can only receive numerals YYYY).
I thank you in advance for any provided help (code code code !!!).
Kindest regards and have very nice Day!
