60 likes | 189 Views
Brief Summary of Database/Web Connectivity. Mark Mesarch mmesarch1@unl.edu. Overview. Why Use Databases Database/Server Platforms & Language Examples: Output Input. Why use Databases. Use of data on multiple web pages
E N D
Brief Summary of Database/Web Connectivity Mark Mesarch mmesarch1@unl.edu
Overview • Why Use Databases • Database/Server Platforms & Language • Examples: • Output • Input
Why use Databases • Use of data on multiple web pages • Change data in one place in the database all the web pages will change. • Reduce number of web pages • Same webpage can display different data based on • Defined parameters • User Requests • Retrieve Information • Secure web pages
Database/Web Platforms • Microsoft ACCESS • Tables and Queries • Windows Web Server • Active Server Pages (ASP) • Why this route? • Department invested in ACCESS & Windows • Separation of database and web
Examples - Output • Simple Listing • http://snr.unl.edu/aboutus/who/people/facultydirectory.asp • Complex Display • http://snr.unl.edu/aboutus/who/people/faculty/awada-tala.asp • Searching text • http://snr.unl.edu/aboutus/who/people/expertisedirectory.asp • Sorting • http://nfs.unl.edu/championtree/championtreeregister.asp • Mapping • http://nfs.unl.edu/wildfire/iconstatefiremapmannature.asp
Examples – Input & Security • Registrations • http://snr.unl.edu/registration/wmo2009/wmoregistration2009-step1.asp • Data • http://nfs.unl.edu/wildfire/loginwildfire.asp