Penn Computing
Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

Simple Database Search - Interface Examples

Here are four interfaces created for the same test database of information. This is only a test database of less than 100 records but you can follow the links and actually search on the database from any of the four sample interfaces to see how the different levels of customization affect the look of the search form and search results pages.

This is the header record that is included as the first record in the database file.

SSN|Ref Lastname|Ref Firstname|Ref Middleinit|Ref Title|Date|Letter Type|Student Lastname|Student Firstname|Student Middleinit|Code

  1. Default interface
    The only configuration option set for this interface is the required configuration option dbfile, the location of the database file.
    dbfile=/computing/web/webdev/dbsearch/sample/Webdata.txt
    
    
  2. Interface customized through configuration options
    This interface uses a customized header, footer, and navbar as specified in the configuration file. This interface also makes use of selectlists. The provider has also turned on sortallow and has defined datatypes for fields that have datatypes other than the default of "data".
    dbfile=/computing/web/webdev/dbsearch/sample/Webdata.txt
    title=Career Services
    title_url=http://www.upenn.edu/careerservices/
    dbtitle=Credentials
    header=/computing/web/webdev/dbsearch/sample/header.html
    footer=/computing/web/webdev/dbsearch/sample/footer2.html
    navbar=off
    excludefields=SSN
    selectlist=Ref Title|Adjunct|Dean|Director|Professor|Registrar|Supervisor
    selectlist=Letter Type|Dean's Letter|HPAB|Law Employer Form|Notice to Employer Form|Recommendation Letter|Resume|Request
    sortallow=on
    datatype=Code|numeric
    datatype=Date|date
    view=long|quick
    daterange=Date
    
    
  3. Search form created by the provider
    This interface uses the same configuration options as the second example above but the provider has created their own search interface, bypassing the ability of the Simple Database Search script to create its own search form. Please see our guidelines for creating a search form, if you wish to create your own search form.
    dbfile=/computing/web/webdev/dbsearch/sample/Webdata.txt
    title=Career Services
    title_url=http://www.upenn.edu/careerservices/
    dbtitle=Credentials
    header=/computing/web/webdev/dbsearch/sample/header.html
    footer=/computing/web/webdev/dbsearch/sample/footer3.html
    navbar=off
    excludefields=SSN
    selectlist=Ref Title|Adjunct|Dean|Director|Professor|Registrar|Supervisor
    selectlist=Letter Type|Dean's Letter|HPAB|Law Employer Form|Notice to Employer Form|Recommendation Letter|Resume|Request
    sortallow=on
    datatype=Code|numeric
    datatype=Date|date
    searchargs=off
    search_url=http://www.upenn.edu/computing/web/webdev/dbsearch/sample/recommend.html
    
    
    This search form is a framed document. The actual HTML coding used to create the framed search form is available.
  4. Restricted interface
    This interface restricts the searching of the database.
    dbfile=/computing/web/webdev/dbsearch/sample/restricted/Webdata.txt
    title=Career Services
    title_url=http://www.upenn.edu/careerservices/
    dbtitle=Credentials
    header=/computing/web/webdev/dbsearch/sample/header.html
    excludefields=SSN
    selectlist=Ref Title|Adjunct|Dean|Director|Professor|Registrar|Supervisor
    selectlist=Letter Type|Dean's Letter|HPAB|Law Employer Form|Notice to Employer Form|Recommendation Letter|Resume|Request
    sortallow=on
    datatype=Code|numeric
    datatype=Date|date
    view=long|quick
    #domain_restricted=upenn.edu
    #pas_authenticated=on
    #pasauthfile=/computing/web/webdev/dbsearch/sample/restricted/auth.file
    password_protected=on
    
    



penn web developers
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


University of Pennsylvania Penn Computing University of Pennsylvania Information Systems & Computing (ISC)
Information Systems and Computing, University of Pennsylvania