1
|
- Week 8
- LBSC 690
- Information Technology
|
2
|
- Questions
- PHP
- SQL
- Midterm review
|
3
|
- Static: Written in a markup language
- Dynamic: Generated using a program
- Common Gateway Interface (.cgi)
- Java servlets
- Dynamic: Generated from a database
- Cold Fusion (.cfm)
- PHP (.php)
|
4
|
- Remote access to a database
- Client does not need the database software
- Serve rapidly changing information
- e.g., Airline reservation systems
- Provide multiple “access points”
- By subject, by date, by author, …
- Record user responses in the database
|
5
|
|
6
|
|
7
|
- Demo 1: a “Hello World” program
- Demo 2: Reading input from a form
- Demo 3: Printing output from a table
|
8
|
|
9
|
|
10
|
- SELECT Company.CompanyName, Company.CompanyPhone, Flight.Origin,
Flight.DepartureTime
- FROM Flight,Company
- WHERE Flight.CompanyName=3DCompany.CompanyName
- AND
Flight.AvailableSeats>3;
|
11
|
- mysql –u dbname –h host –p password
- show databases;
- use RentAPlane;
- show tables;
- describe Flight;
- select * from Flight;
- insert into …
|
12
|
- <HTML>
<HEAD>
<TITLE>Show All Students in Our School</TITLE>
<CFQUERY NAME=3D“allStudents”
DATASOURCE=3D“student20”>
- SELECT * FROM Students
- </CFQUERY>
- </HEAD>
- <BODY BGCOLOR=3D"LIGHTBLUE">
- <H2> <B>All Students in Our School</B> </H2&=
gt;
- <BR> <hr> <pre> studentID FirstName MiddleName
LastName<br></pre>
- <CFOUTPUT QUERY=3D"allStudents">
- <PRE>
- #studentID# #FirstName# #MiddleName# #LastName#
- </PRE>
- </CFOUTPUT>
- <FORM ACTION=3D"mainMenu.cfm" Method=3D"post&quo=
t;>
- <input type=3D"submit" value=3D"Main Menu"&=
gt;
- </FORM>
- </BODY> </HTML>
|
13
|
- Show who borrowed which book
- <CFQUERY name=3D"borrowedBook"
dataSource=3D"student20">
- SELECT
Books.Title, Students.FirstName, Students.MiddleName, Students.LastName, Ch=
eckout.DueDate
- FROM Book=
s,
Students, Checkout
- WHERE
Books.BookID=3DCheckout.BookID AND Students.StudentID=3DCheckout.Stu=
dentID;
- </CFQUERY>
|
14
|
|
15
|
- Quiz/homework should be good preparation
- A variety of question types
- Some questions will require computer use
- Lots of prior exams are available
- Many have solutions available
- Open book/notes/Internet/mind/…
- Just don’t get help from another person
|
16
|
- Hardware
- Types of hardware
- Storage hierarchy
- Moore’s law
- Software
- Types of software
- Types of interfaces
|
17
|
- Types of Networks
- LAN, WAN, Internet, Wireless
- Packet Switching
- Ethernet, routers, routing tables
- Layered Architecture and protocols
- TCP/UDP
- IP address/domain name
- Encryption
|
18
|
|
19
|
|
20
|
- Input and output devices
- Mental models
- Interaction styles
- Direct manipulation, menus, command line
|
21
|
- Programming languages
- Machines require low-level specific instructions
- Humans require high-level abstraction
- Can create any behavior from 3 control structures
- Sequential execution
- Conditional
- Iteration
- Javascript interpreters are in Web browsers
|
22
|
- Structured information
- Field->record->table->database
- Primary key
- Normalized tables (relations)
- Remove redundancy, inconsistency, error
- Easy update, search
- Join links tables together
- Access provides visual operations
|
23
|
- Access “Data Access Pages”
- PHP
- SQL
|