I need a VERY simple Java-script, PHP, CSS and MySQL script that does the following
PHP script Retrieves data from three different tables with two fields in each (id and description). There are three values in each of the 2 fields and with PHP we retrieve them and allocate them to individual arrays with an id value and description value.
Table_ petType = “0, Dog” , “1, Cat” , “2, Rabbit” : Array = “petType”
Table_ petColor = “0, Black” , “1, White” , “2, Grey” : Array = “petColor”
Table_ petSize = “0, Big” , “1, Medium” , “, Small” : Array = “petSize”
Next on the same PHP page with a little JS (& CSS for formatting) we display each field of data in three dropdown boxes (on the same page) with the first selection displaying the Array name and the results underneath Ex:
- Choose + “petType” (visible in box on page load, but not an option! Also can be an extra variable or field “0” of database if easier)
The page will have one submit button which ONLY when one from all the three drop downs have been chosen, the script then goes to the next page (but same window) and shows the variable names plus a numeric id value using echo in PHP. If one name is forgotten then an alert window should inform user that they have forgot to make a choice.
All functions between dbase and script must be in PHP. All shall be compacted into one zip file and you don't have to worry about setting up database for me or anything just the script and comments where necessary. Also I don't want any copies from another website with restricted rights to the script, or have to remark the authors name or JS libraries from 3rd parties. This has to be your own script or a good rewrite of another.