CIS 264: Web and Database Applications

Introduction

This class seeks to take a variety of technologies you have learned (HTML, Javascript, Databases, etc) and blend them together to create database driven web applications. Specifically, we will be using the so-called LAMP stack (Linux, Apache, MySQL and PHP).

ClassDateSubject
11/24Introduction

Brief explanation of the web, PHP, MySQL, etc. Syllabus. Link to notepad++.

Explanation of DNS

Available snippets

Snippets are small pieces of code aimed to demonstrate one very small concept that may be helpful but I haven't necessarily gone over in class.

lastinsertWhen you insert a row into a table with an auto_increment field, sometimes you want to know what value was assigned.
quotesShows how to download a page from the internet and get data out of it.
redirectRedirect a user to a website without Javascript.
searchSearch a text field in a database.
simplevalPerform simple validation on a form.
tableOutput values from a database into a variable number of column table.

Demo files

Demo files are everything I've done in class and sample solutions to assigned work. You can view them on the web using the links provided or view the source through notepad++. To see the code, login to the server using notepad++. You should see a folder named 'demo'. Go in there and then you will see the hierarchy of folders.