Php & MySql Topics Covered
Php Topics Covered |
|
| Part I: Working with PHP | |
| Getting Started with PHP-Variables | |
| Assigning Simple Variables Within a Script | |
| ~ ~ ~ |
Delimiting strings Assigning arrays within a script Assigning two-dimensional arrays in a script |
| Accessing Variables Passed from the Browser | |
| ~ ~ ~ ~ |
HTML forms variables Passing arrays Cookies Sessions |
| Testing Variables | |
| ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ |
isset0 empty0 is_null0 is_int0 is_double0 is_string0 is_array0 is_bool0 is_object0 is_resource0 is_scalar0 gettype0 |
| Changing Variable Types | |
| ~ | Variable Variables |
| Control Structures | |
| The if Statement | |
| ~ ~ ~ ~ ~ ~ |
Determining true or false in PHP Comparison operators Logical operators Complex if statement if…else statements if…elseif statements |
| switch…case | |
| ~ ~ ~ ~ ~ ~ |
Loops White… do…while for foreach continue and break |
| PHP’s Built-in Functions | |
| ~ ~ ~ |
Function Basics Arguments Return values |
| Function Documentation | |
| ~ ~ |
Important PHP Functions String handling functions |
| Writing Organized and Readable Code | |
| ~ ~ ~ ~ |
Indenting Code blocks Function calls SQL statements |
| Includes | |
| ~ ~ |
Include0 and Require0 Include_once0 and Require_once0 |
| User-Defined Functions | |
| ~ ~ ~ ~ |
Function basics Returning values Using a variable number of arguments Variable scope |
| Object-Oriented Programming | |
| ~ ~ ~ ~ |
Classes, Continued Object cloning Destructors Exceptions |
Working on a E-Commerce ( Shopping Cart ) Live Project |
|
| Click to view the live project the students would be working with during this course | |
| Synopsis: | |
| The data is stored in Products Table, Supplier Table, Category Table. Each product has a single supplier and single category. | |
| Each supplier supplies multiple products under multiple categories | |
| 1) | Login Page |
| The user will be authenticated before they enter the website for the correct username/password. |
|
| There are 2 types of users Admin / User, the admin would have administrative rights, where as a user will only be able to view the products |
|
| 2) | Search Page |
| After login, the user will be directed to a search page, where they can search for a product by selecting the supplier / category name. |
|
| In advance search, string searches can be done. | |
| 3) | Product Result list |
| This page will return the result of the search criteria. |
|
| A single page will display the records dynamically from the database, 5 records at a time. Using the Next / Previous button users can navigate through the list of products |
|
| 4) | Details |
| Once the user clicks on the product name in the result list page, they are directed to the details page, where user can get the detail information with a image of the product | |
| If the user is an admin, they would be given an option to add / update / delete If the user is not a admin, the following permissions will be disabled. | |
| 5) | Add / Update / Delete |
| Displaying data from multiple tables using forms & Adding / Updating / Deleting data | |
| 6) | Security |
| Extensive use of Sessions / Cookies for security purposes | |
| 7) | E-Commerce Module |
| Once the above project is completed, it’s taken to a next level where the e-commerce module is generated. Multiple Products can be added to the shopping cart, a dynamic bill is generated and user is forwarded to a payment gateway to complete the transaction. | |