Embedded Files
2015-2016 we will be using this book
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition) Paperback – September 23, 2011
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition) Paperback – September 23, 2011
by Larry Ullman (Author) http://www.larryullman.com
ISBN-13: 978-0321784070
ISBN-10: 0321784073 Edition: 4th
Books web page http://www.larryullman.com/books/php-and-mysql-for-dynamic-web-sites-visual-quickpro-guide-4th-edition/
Amazon's Preview this book - Introduction and Chapter 1 Table of Contents
Prices: New, Used & Kindle Amazon $31.28 ..... used $21 <--JilMac Recommends
Google Books https://books.google.com/books?id=44uIVmlM3XoC&printsec=frontcover&dq=PHP+and+MySQL+for+Dynamic+Web+Sites,+Fourth+Edition:+Visual+QuickPro+Guide&hl=en&sa=X&ved=0ahUKEwi58v-FudjKAhVIPxoKHRJqCrYQ6AEIMDAA#v=onepage&q=PHP%20and%20MySQL%20for%20Dynamic%20Web%20Sites%2C%20Fourth%20Edition%3A%20Visual%20QuickPro%20Guide&f=false
Complete Set of Scripts and SQL Commands
phpmysql4_scripts.zip (175 KB, last modified May 1, 2012)
ASSINGNMENT01
Introduction
Chapter 1: Introduction to PHP (Download files from Website)
Basic Syntax
Sending Data to the Web Browser
Writing Comments
What Are Variables?
Introducing Strings
Concatenating Strings
Introducing Numbers
Introducing Constants
Single vs. Double Quotation Marks
Basic Debugging Steps
Review and Pursue
ASSINGNMENT02
Chapter 2: Programming with PHP (Download files from Website)
Creating an HTML Form
Handling an HTML Form
Conditionals and Operators
Validating Form Data
Introducing Arrays
For and While Loops
Review and Pursue
ASSINGNMENT03
Chapter 3: Creating Dynamic Web Sites (Download files from Website)
Including Multiple Files
Handling HTML Forms, Revisited
Making Sticky Forms
Creating Your Own Functions
Review and Pursue
ASSINGNMENT04 Chapters 4 - 7 skim
Chapter 4: Introduction to MySQL WE WILL JUST BE READING THIS - IF A STUDENT WANTS
Naming Database Elements THEY CAN INCORPORATE THIS BY ......
Choosing Your Column Types Installing SQL - directions are in the APPENDIX
Choosing Other Column Properties
Accessing MySQL
Review and Pursue
Chapter 5: Introduction to SQL -
Creating Databases and Tables
Inserting Records
Selecting Data
Using Conditionals
Using LIKE and NOT LIKE
Sorting Query Results
Limiting Query Results
Updating Data
Deleting Data
Using Functions
Review and Pursue
Chapter 6: Database Design
Normalization
Creating Indexes
Using Different Table Types
Languages and MySQL
Time Zones and MySQL
Foreign Key Constraints
Review and Pursue
Chapter 7: Advanced SQL and MySQL
Performing Joins
Grouping Selected Results
Advanced Selections
Performing FULLTEXT Searches
Optimizing Queries
Performing Transactions
Database Encryption
Review and Pursue
ASSINGNMENT05
Chapter 8: Error Handling and Debugging (Download files from Website)
Error Types and Basic Debugging
Displaying PHP Errors
Adjusting Error Reporting in PHP
Creating Custom Error Handlers
PHP Debugging Techniques
SQL and MySQL Debugging Techniques
Review and Pursue
Chapter 9: Using PHP with MySQL - JilMac will email each student the Database name, password, etc.
Modifying the Template (Download files from Website)
Connecting to MySQL <---- the file mysqli_connect.php is were you will put the info from JilMac
Executing Simple Queries
Retrieving Query Results
Ensuring Secure SQL
Counting Returned Records
Updating Records with PHP
Review and Pursue
ASSINGNMENT06
Chapter 10: Common Programming Techniques (Download files from Website)
Sending Values to a Script
Using Hidden Form Inputs
Editing Existing Records
Paginating Query Results
Making Sortable Displays
Review and Pursue
ASSINGNMENT07
Chapter 11: Web Application Development (Download files from Website)
Sending Email
Handling File Uploads
PHP and JavaScript
Understanding HTTP Headers
Date and Time Functions
Review and Pursue
ASSINGNMENT08
Chapter 12: Cookies and Sessions (Download files from Website)
Making a Login Page
Defining the Login Functions
Using Cookies
Using Sessions
Improving Session Security
Review and Pursue
ASSINGNMENT09
Chapter 13: Security Methods (Download files from Website)
Preventing Spam
Validating Data by Type
Validating Files by Type
Preventing XSS Attacks
Using the Filter Extension
Preventing SQL Injection Attacks
Review and Pursue
Chapter 14: Perl-compatible Regular Expressions (Download files from Website)
Creating a Test Script
Defining Simple Patterns
Using Quantifiers
Using Character Classes
Finding All Matches
Using Modifiers
Matching and Replacing Patterns
Review and Pursue
ASSINGNMENT10
Chapter 15: Introducing jQuery (Download files from Website)
What is jQuery?
Incorporating jQuery
Using jQuery
Selecting Page Elements
Event Handling
DOM Manipulation
Using Ajax
Review and Pursue
ASSINGNMENT11
Chapter 16: An OOP Primer (Download files from Website)
Fundamentals and Syntax
Working with MySQL
The DateTime Class
Review and Pursue
ASSINGNMENT12
Chapter 17: Example—Message Board (Download files from Website)
Making the Database
Writing the Templates
Creating the Index Page
Creating the Forum Page
Creating the Thread Page
Posting Messages
Review and Pursue
ASSINGNMENT13
Chapter 18: Example—User Registration (Download files from Website)
Creating the Templates
Writing the Configuration Scripts
Creating the Home Page
Registration
Activating an Account
Logging In and Logging Out
Password Management
Review and Pursue
ASSINGNMENT14
Chapter 19: Example—E-Commerce - (Download files from Website)
Creating the Database NOTE: JilMac does NOT recommend writing your own Shopping cart!
The Administrative Side this is just CONCEPTS - and contains NO SECURITY!
Creating the Public Template
The Product Catalog
The Shopping Cart
Recording the Orders
Review and Pursue
Appendix A: Installation(AVAILABLE ONLINE) - JilMac's class will NOT be using Local Host -
Installation on Windows we will use a Shared Web Host Set up with JilMac's Educational site.
Installation on Mac OS X Students can Install but it is not part of the class.
Managing MySQL Users
Testing Your Installation
Configuring PHP
Configuring Apache
==============================================================================
==================== PREVIOUS SEMESTERS this book was used ==============================
==============================================================================
PHP for the Web
by Larry Ullman
ISBN-13: 978-0321733450 | Publication Date: March 19, 2011 | Edition: 4
Read the first chapter: http://www.amazon.com/PHP-Web-Visual-QuickStart-Guide/dp/0321733452/ref=sr_1_1?ie=UTF8&qid=1324068655&sr=8-1
Code Source: Download the ZIP file and use this as your before examples.
With PHP for the World Wide Web, Fourth Edition: Visual QuickStart Guide, readers can start from the beginning to get a tour of the programming language, or look up specific tasks to learn just what they need to know. This task-based visual reference guide uses step-by-step instructions and plenty of screenshots to teach beginning and intermediate users this popular open-source scripting language. Leading technology author Larry Ullman guides readers through the latest developments including use and awareness of HTML5 with PHP. Other addressed changes include removal of outdated functions and more efficient ways to tackle common needs.
Both beginning users, who want a thorough introduction to the technology, and more intermediate users, who are looking for a convenient reference, will find what they need here--in straightforward language and through readily accessible examples.
About the Author: PHP expert Larry Ullman has written several best-selling books on the topic, including the previous edition of this guide. In addition, he serves as the Director of Digital Media Technology at DMC Insights and teaches numerous classes on PHP.
Larry's Forum - is where you can ask the author directly questions http://www.larryullman.com/forums/
about the book http://www.larryullman.com/forums/index.php?/forum/10-php-for-the-web-visual-quickstart-guide-4th-edition/
Larry's Page for this textbook: http://www.larryullman.com/books/php-for-the-web-visual-quickstart-guide-4th-edition/
Larry's Errata PHP for the web: http://www.larryullman.com/books/php-for-the-web-visual-quickstart-guide-4th-edition/errata/
Introduction
Chapter 1: Getting Started with PHP
Chapter 2: Variables
Chapter 3: HTML Forms and PHP
Chapter 4: Using Numbers
Chapter 5: Using Strings
Chapter 6: Control Structures
Chapter 7: Using Arrays
Chapter 8: Creating Web Applications
Chapter 9: Cookies and Sessions
Chapter 10: Creating Functions
Chapter 11: Files and Directories
Chapter 12: Intro to Databases
Chapter 13: Regular Expressions
Appendix A: Installation and Configuration
Appendix B: Resources and Next Steps Index
CHECK CCV Bookstore for Courses & Required Books www.ccvbooks.com
Page updated
Google Sites
Report abuse