db connect: http://pastebin.com/99T834zP
home.php after the form: http://pastebin.com/YGBakPWQ
Welcome to the PHP Web Development Course from Awesome Inc U! Our goal is to take the first steps, together, in learning how to make websites. We hope this will be a fun, useful learning experience.
Link to this document: awesomeincu.com/notes/php-crash
Prerequisites
- The ability to type text on a computer (e.g. write an email, edit a Word document)
- Access to a computer with OSX/Windows/Linux (must have permission to install programs)
To Do: Before Class
- Install XAMMP, and Sublime Text (no need to purchase it).
What you’ll learn
- How to use PHP to collect data via forms
- How to use MySQL to store, fetch, and search data
Course materials
This document!
Schedule
9am
- Dev Environment
- First File
- Hello, World!
- Intro - slides
- php.net
10 am
- The Basics: Globals, Functions, Arrays, and Forms
- Say Hello my name is _____ (function definitions)
- Class roster: Array(name1, name2, name3)
- madlibs (Download http://pastebin.com/xb3UxSd3)
- GET versus POST
11 am
- phpmyadmin, tables, rows versus cols, etc.
- Build user Table
- Basic SQL: Selects
- Connecting via PHP: mysqli docs
- Basic Session Management
12 pm
Lunch
1pm
Modules we’ll need:
- Includes/Requires
- Login
- User Table
- Session Management
- INSERT a property (http://pastebin.com/pcSu6A9X)
- Property Table
- Property Feeds (SELECT) http://pastebin.com/HHeMY6AX
- Delete a Property (DELETE)
- Comment on a property (INSERT/SELECT)
3:30pm
- Sandbox Time
- Feature: “like” a property that was posted
- Feature: mark a property as a “favorite”
- Make a favorites page
- Security: only the user who inserted the property can delete it
- Add twitter bootstrap to a few pages!
- header.php, home.php, footer.php
4pm