.
.
PHP 5.2.1/Mysql 5.0
.
.
One PHP page (and a dummy page).
Page 1:
It provides a "Enter SQL" textfield, and a button "QUERY" next to it.
This textfield accepts an SQL Select statement from the user.
Below this textfield is the "Count" textfield,, and next to it a "GO" button.
Enter sql _____ --QUERY
Count _______ --GO
When "QUERY" is clicked, the number of records retrieved displays in the Count field.
Underneath this 4-item section is the List Section, where the records fetched (resultset) are listed.
Allow the maximum size of listed records to be modified.
When the user is satisfied with his resultset,
he can hit "GO" - a button which becomes activated with a count > 0.
Hitting GO updates 2 parameters and passes these to Page 2.
Page 2 merely redisplays the 2 parameters (the count and resultset) it had received from Page 1.
If the QUERY button yields an error, the error will appear on the screen, in the List Section.
This also prevents the GO button from becoming activate.
Note 1. All testing will be done on Webmster's local box.
Note 2. All code, besides PHP and HTML, such as Javascript & CSS, must be externally included.
Note 3. Only SELECT statements are valid queries.
Note 4. The maximum list size is also an externally referenced file.
Note 5. The GO button remains inactive unless a proper resultset is retrieved.
----------------------