WILEY PHP5 & MySQL Projects By Janet valade
Chapter1:Building Your Application:
Understanding PHP and MySQL Versions
MySQL
PHP
PHP and MySQL together
Using the Application Source Code
Choosing a location
Understanding The PHP code
Procedural versus Object-oriented programs
Modifying the Source code
Programming editors
Integrated Development Environment(IDE)
Planning your Application
Planning the software
Additional Planning
Chapter2:Building in Application Security:
Understanding Security Risks
Building Security into Your PHP Scripts
Don't trust any information from an outside source
Storing information
Using System calls
Handling errors
MySQL Security
Setting up accounts and passwords
Accessing MySQL from PHP scripts
Understanding SQL injection attacks
Backing up your Databases
Using a secure Web-server
Chapter3:User Authentication with PHP:
Understanding HTTP Authentication
Understanding how the WWW works
Requesting a password-protected file
Authorizing access
Using HTTP Authentication with Apache
Configuring Apache
Creating the.htaccess filr
Creating the password file
Apache HTTP Authentication in action
Designing an HTTP Authentication Application in PHP
Creating the user Database
Designing the user Database
Creating the user Database
Accessing the user Database
Building the Authentication Application in PHP:
The procedural Approach
Building the Authentication Application in PHP:
The Object-oriented Approach
Developing the objects
Writing the passwordprompter class
Writing the Database class
Writing the Account class
Writing the Webpage class
Writing the Auth-OO Script
Chapter4:User Login Application:
Designing the login application
Creating the user Database
Designing the Database
Building the Database
Accessing the Database
Adding data to the database
Building the login Web-page
Designing the login web page
Writing the code for the login page
Displaying the login web page
Building the login Application:
The procedural Approach
Writing the application script
Protecting your webpage
Building the login Application:
The Object-oriented Approach
Developing the objects
Writing the web form class
Writing the Database class
Writing the Account class
Writing the session class
Writing the Email class
Writing the login application script
Protecting your web pages
Adding Features to the application
Chapter5:Online Catalog Application:
Designing the Online Catalog Application
Creating the Catalog Database
Designing the Catalog Database
Building the Catalog Database
Accessing the food Database
Adding data to the database
Building the catalog Web-pages
Designing the catalog Web-pages
Writing the code for the index page
Writing the code for the products page
Displaying the catalog web pages
Building the Online Catalog Application:
The procedural Approach
Building the Online Catalog Application:
The Object-oriented Approach
Developing the objects
Writing the catalog class
Writing the catalog Application Script
Growing the catalog class
Chapter6:Shopping Cart Application:
Designing the Shopping Cart Application
Basic application design decisions
Application functionality design
Creating the Shopping Cart Database
Designing the Shopping Cart Database
Building the Shopping Cart Database
Accessing the Shopping Cart Database
Adding data to the Shopping Cart database
Building the Shopping Cart web pages
Designing the Shopping Cart web pages
Writing the code for the product information page
Writing the code for the shopping cart web page
Writing the code for the shipping information form
Writing the code for the summary page
Building the Shopping Cart Application:
The procedural Approach
Writing shopping catalog.php
Writing shopping cart.php
Writing processorder.php
Building the Shopping Cart Application:
The Object-oriented Approach
Developing the objects
Writing the catalog class
Writing the item class
Writing the shopping cart class
Writing the Database class
Writing the order class
Writing the web form class
Writing the web page class
Writing the Email class
Writing the shopping cart application script
Adding Features to the application
Chapter7:Building a Content Management System:
Designing the CMS Application
Creating the the CMS Database
Designing the CMS Database
Building the CMS Database
Accessing the CMS Database
Designing the CMS Web pages
Building the CMS Application:
The procedural Approach
Writing the login code
Writing CompanyHome.php,a data retrieval file
Writing company.inc,the main HTML display file
Writing the Content detail code
Writing Admin.php,the data manipulation code
Building the CMS Application:
The Object-oriented Approach
Writing the object model
Writing a basic data class
Writing the department class
Writing the contenttype class
Writing the contentitem class
Writing the contentdownload class
Writing the Database class
Writing the web form class
Writing the code for the login page
Writing fields_content.inc and content_form.inc
Writing the display code
Writing Admin_OO.php,the data manipulation code
Enhancing the Content Management System
Chapter8:Hosting Discussions with a Web Forum
Designing the Forum Application
Creating the Forum Database
Designing the Forum Database
Building the Forum tables
Accessing the Forum tables
Adding data to the Database
Building the forum Webpages
Designing the forum Web pages
Writing the code for the Forums page
Writing the code for the Threads page
Writing the code for the Messages page
Writing the code for the New Message page
Writing the code for the Reply page
Building the Forum Application:
The procedural Approach
Writing viewForums.php
Writing viewTopic.php
Writing viewThread.php
Writing postMessage.php
Writing postReply.php
Writing the supporting functions
Building the Forum Application:
The Object-oriented Approach
Developing the objects
Writing the TableAccessorclass
Writing the Thread class
Writing the post class
Writing the Database class
Writing the web form class
Writing the Forum application scripts
Writing the supporting functions
Chapter9:Ten Hints for Application Development
Plan First
Be Consistent
Test Code Incrementally
Remember Those Who Follow
Use Constants
Write Reusable Code
Separate Page Layout from Function
Don't Reinvent the wheel
Use the Discussion Lists Frequently,but Wisely
Document Everything
Chapter10:Ten Sources of PHP Code
SourceForge.net
WeberDev
PHP Classes
Codewalkers
PHP Builder
HotScripts.com
Zend
PHP Freaks
PX:The PHP Code Exchange
Free PHP and MySQL Hosting Directory.Download