List of Php Content to Complet Knowledge

Only available on StudyMode
  • Download(s) : 156
  • Published : December 27, 2012
Open Document
Text Preview
• 1. Installing Required Software
Duration: 2 Hours After taking this course, the learner will be able to download, install, configure, and test all the software required to create dynamic Web sites using PHP and MySQL.

Installing MySQL
Installing Apache with PHP
Setting MySQL permissions
Testing the installation
Configuring PHP

• 2. PHP Basics
Duration: 3 Hours After taking this course, the learner will be able to describe the PHP scripting language, and create basic PHP scripts using proper PHP syntax.

PHP
Basic syntax
Sending data
Understanding PHP, HTML, and white space
Writing comments
Using variables
Using strings
Using numbers
Using constants

• 3. Programming with PHP
Duration: 4 Hours After taking this course, the learner will be able to create elaborate scripts, write HTML forms, and program PHP to handle the form data.

Creating HTML forms
Handling HTML forms
Managing magic quotes
Using conditionals and operators
Validating form data
Using arrays
Creating and accessing arrays
Multidimensional arrays
Arrays and strings
Sorting arrays
For and While loops

• 4. Creating Dynamic Web Sites
Duration: 3 Hours This course provides the learner with step-by-step instructions for using PHP to create dynamic Web sites that are responsive to users and can alter content based on differing situations.

Including multiple files
Using PHP redux
Making sticky forms
Creating your own functions
Creating a function that takes arguments
Setting default argument values
Returning values from a function
Variable scope
Date and time functions

• 5. SQL and MySQL
Duration: 4 Hours After taking this course, the learner will be able to create databases and tables, and sort and retrieve data using SQL and MySQL.

MySQL
Choosing column types
Choosing other column properties
Using mysql client
Creating databases and tables
Inserting records
Selecting data
Using conditionals
Using LIKE and NOT LIKE
Sorting and limiting query results
Updating and deleting data
Using text and numeric functions
Formatting date and time functions

• 6. Advanced SQL and MySQL
Duration: 3 Hours After taking this course, the learner will be able to use the principles of database design, including normalization and use of forms. They will also be able to use MySQL to create relational databases, and perform searches on those databases.

Normalization, keys, and relationships
First Normal Form
Second Normal Form
Third Normal Form
Creating and populating the database
Performing joins
Grouping selected results
Creating indexes
Using different table types
Performing basic FULLTEXT searches
Performing Boolean FULLTEXT searches
Optimizing the database

• 7. Error Handling and Debugging
Duration: 2 Hours This course provides the learner with the steps and tools necessary to identify and correct errors that can occur when running PHP and MySQL applications.

General error types and debugging
Debugging HTML
Displaying PHP errors
Adjusting PHP error reporting
Creating custom error handlers
Logging PHP errors
PHP debugging techniques
SQL and MySQL debugging techniques

• 8. Using PHP with MySQL
Duration: 2 Hours This course provides the learner with step-by-step instructions for using PHP to create dynamic Web sites that allow for database interactions such as the storing, gathering, and updating of information.

Modifying the template
Connecting to MySQL and selecting the database
Executing simple queries
Retrieving query results
Ensuring secure SQL
Counting returned records
Updating records with PHP

• 9. Developing Web Applications
Duration: 2 Hours This course provides the learner with information about a number of independent topics that are present in more sophisticated Web applications.

Adjusting behavior for server settings
Sending values manually
Using hidden form inputs
Editing...
tracking img