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
2010-09-22 06:27:14
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
2010-09-22 06:36:14
isn't zend framework better for very big and large projects? This looks a bit to simple to be using zend framework
krike
2010-09-22 10:51:15
Zend Framework is very good for large projects.
Alexander.Plutov
2010-09-22 10:56:42
A:
Basic steps are:
- Create a form to receive user preferences
- Post form to php script
- In the php script query the database using the user's preference (which can be found in
$_POST
) - Iterate over the results you got back from the database and
echo
them back to the user - Use Google and php.net to find out how to implement the steps above
captaintokyo
2010-09-22 06:37:39
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
2010-09-22 10:43:14