I've completed my bare-bones version of the web-based record search tool. All of the logic for the search - both displaying the available options and parsing out a form submission - is contained within two classes, Search and Search_Form. The classes build the search query in an organized manner based on passed parameters. This format makes the search easy to change or extend, which I can foresee happening based on the needs of the data and the researcher SD. All of the code is documented using comments and standard docblock syntax.
The database-side of things is handled with Zend_Db, the Zend Framework's RDBMS adapter. Since the search form can result in some very complex queries, Zend_Db makes the process of building the select statement relatively easy. Plus, it's a more robust database adapter in terms of security and integrity than I could build in any decent amount of time.
The search form doesn't yet have any styling and is bare, but now that the functionality is done everything else will fall into place eventually. SD is coming in for a meeting Thursday Jan 27th so I hope to hammer out some more details then.
No Pingbacks for this post yet...
Simon Devereaux has approximately 10,000 records of people convicted in potentially capital cases between 1710 and 1840 in London heard at the Old Bailey court. This project will create a web-based database which will allow interested researchers and members of the public to compose queries on that data (e.g. women charged with robbery 1710-1720). It must be able to support a range of queries and produce output allowing researchers to identify trends in judicial practice over that time.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| << < | > >> | |||||
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 | 31 | |