PHP5 & MYSQL5 Essential Course
Hits: 7681
 |
||
| Beginner | Programing | 80 Hours |
| Introduction to PHP | Taking User Input from Forms via PHP |
| History of PHP PHP tools and set up (web browser/server, editor, etc) Embedded into HTML code Create a basic PHP Script Use PHP to generate HTTP headers Pass PHP variables via the URL Debugging Tips |
Creating forms with PHP Security Protection from Cross Site Scripting Using the form GET method Using the form POST method Obtaining data from forms through variables Using hidden fields Secure Web Forms (HTTPS and SSL) Calling pages from themselves using forms Quoting HTML entities in user input |
| Variables and Expressions in PHP | PHP Operators |
| Identifiers Data Types (integers, floats, strings and Booleans) Creating Variables Variable assignment Variable Scope Namespaces User-defined Constants HTTP environment variables Variable References |
Arithmetic Operators Logical Operators Relational (Comparison) Operators The Identity Operator Bitwise Operators Other Operators Assignment Operators Operator Precedence and associative |
| Conditional statements in PHP | PHP Flow Control |
| If Comparing Strings and Numbers else and elseif The? : Operator Comparing for equality or identity o The switch…case statement |
PHP Flow Control Loops while do ... while for break and continue exit |
| PHP Functions | Storing Data in Arrays using PHP |
| Purpose of functions Built-in functions Declaring functions Functions Arguments Default Arguments Arguments - Call by Reference Return Returning References Variable Scope (global vs. local) Static variables Recursion include and require Variable function calls |
What are arrays? How and when to use arrays Initializing arrays Using foreach Add/remove elements from arrays One-dimensional arrays Multi-dimensional arrays Associative arrays References to array elements Arrays in forms Array operators Array related functions |
| String Manipulation in PHP | Sessions |
| String Manipulation in PHP String Manipulation Formatting Strings Concatenation String Manipulation Functions Examples of String Functions |
What is a session? Dependencies on the php.ini file Understanding PHP session variables Create a PHP session variable Register and modify PHP session variables Putting PHP session IDs in pages Good Practice with sessions and PHP |
| Cookies | Handling Email with PHP |
| Cookie properties Setting a cookie in PHP Retrieving PHP cookies Expiring/Deleting PHP cookies Drawbacks to cookies Using cookies well Cookie Security Issues Reading and writing files Finding and manipulating files Opening, reading, writing, and closing files Other interesting file functions |
Sending email Sending multi part email - MIME Accessing mail boxes - IMAP & POP |
| Using MySQL 5.0 | Create & Manage Database and tables |
| Introduction to MySQL AB Overview of MySQL AB What is MySQL? History of MySQL The Main Features of MySQL |
Connecting to and Disconnecting from the Server Entering Queries Creating and Using a Database Creating and Selecting a Database Creating a Table Loading Data into a Table Retrieving Information from a Table Getting Information About Databases and Tables |
| Data Manipulation Statements & Control Statements | Final Project |
| DELETE Syntax DO Syntax INSERT Syntax LOAD DATA INFILE Syntax REPLACE Syntax SELECT Syntax Subquery Syntax TRUNCATE Syntax |
Final Project |
Mailing List
Events
Poll
which course type do you prefer ?
Location
Visitors
Contact Details
Location: Egypt Cairo 74 Abbas Al-Akkad St Nasr City Postcode: 11727
Phone: 002-26714397
Mobile: 01007741468 || 01144498894 || 01013433836
Phone: 002-26714397
Mobile: 01007741468 || 01144498894 || 01013433836
Email:
This email address is being protected from spambots. You need JavaScript enabled to view it.