Central Washington University Agenda main content
Agenda for Day 25 of CS 350
- Announcements
- Quiz 3 on Friday
- Short Answer Questions - Comprehensive
- 10 questions, 2 points each (20 points total)
- Closed book, closed Web
- Programming Problem using PHP & Forms
- One problem (30 points total)
- Open book, open Web
- Done on Computer, graded online
- Short Answer Questions - Comprehensive
- Lab Assignments
- no Lab 11 assignment
- Lab 12 due at the start of class on Monday
- Project 1 Milestones
- Individual Memorandums assessing individual and team effectiveness due Tuesday (by each team member)
- Reflect on what is working well, areas for improvement, and serious deficiencies in team member's efforts and contributions
- Individual Memorandums assessing individual and team effectiveness due Tuesday (by each team member)
- Readings
- For today: SQLite: Introduction
- Today's topics and learning objectives
After today's class, you should be able to- Write simple Structured Query Language (SQL) statements
- Use SQL and PHP with SQLite
- Use PHP to handle User Login
- login.php
- authenticate.php
- day25.sqlite
- username="fred", password="abc", email="fcs@cwu.edu"
- username="ed", password="123", email="gellenbe@cwu.edu"
- Session Variables
- Setting a session variable for user authenticated
- Checking a session variable to authorized a user
- Clearing a session variable
- References
- Beginner SQL Tutorials
- PowerPoint Presentation on SQLite
- SQLite API
- Create a Login Script with PHP 4