multiple search on one page
Posted: Thu Jul 29, 2010 5:44 pm
hi,
I have been asked by my boss to create an internal site for easy viewing of database data. i am in very early development stage but have a working page. the way i have started this is to have one page that calls it's self but passing different parameters via querystring, post from a form and menus (there will be be 10 - 15 main menu options each with different submenus with such things as view data from today, last week, last month etc the idea being to generate a dynamic SQL statement each time. this works with one table but not sure how it would work with more, i don't fancy having 50+ SQL statements each one getting called via a link. has anyone done this before or have any good ideas on how to do this better? like i said i am using $_GET and $_POST. i have a meeting in a few weeks about this as no one has decided how to store the data yet ie new table per department or store all data in one table with one field denoting the dept obviously this will impact on how i code the page.
Many thanks for any help i receive
I have been asked by my boss to create an internal site for easy viewing of database data. i am in very early development stage but have a working page. the way i have started this is to have one page that calls it's self but passing different parameters via querystring, post from a form and menus (there will be be 10 - 15 main menu options each with different submenus with such things as view data from today, last week, last month etc the idea being to generate a dynamic SQL statement each time. this works with one table but not sure how it would work with more, i don't fancy having 50+ SQL statements each one getting called via a link. has anyone done this before or have any good ideas on how to do this better? like i said i am using $_GET and $_POST. i have a meeting in a few weeks about this as no one has decided how to store the data yet ie new table per department or store all data in one table with one field denoting the dept obviously this will impact on how i code the page.
Many thanks for any help i receive