views:

76

answers:

3

I'm designed a web application in PHP which conects to a database in MySQL, this application will generate reports according to the fields that a user choose from diferents tables, there is a way to do this, preference by code. (and software tool is acceptable too)

A: 

I work with Zend Framework. In controller I am creating a form. Form values sending to model. Model function returns inserted id or an error. In controller I am checking this result and echoing it. It works not only in Zend.

Alexander.Plutov
I am not sure to understand you, but you did an insert, but I will do only select, don't sure if with select will be functionaltoo
alfjos89
isn't zend framework better for very big and large projects? This looks a bit to simple to be using zend framework
krike
Zend Framework is very good for large projects.
Alexander.Plutov
A: 

Basic steps are:

  1. Create a form to receive user preferences
  2. Post form to php script
  3. In the php script query the database using the user's preference (which can be found in $_POST)
  4. Iterate over the results you got back from the database and echo them back to the user
  5. Use Google and php.net to find out how to implement the steps above
captaintokyo
A: 

I don't know what exactly you need but if you want get form value use js. If you want use js use jquery ... you can get selected value with jquery by name or id ... just have a look on jquery

example:

$("#input_id").val()

and use it to generate your report... add onclick or onchange to show report dinamically

If you want make it after submit.. I think it is quiet easy...

jatt