Duration
5 days
Overview
Essentially three courses in one: provides thorough introductions to the PHP language and the MySQL database, and shows how these two technologies can be effectively integrated to build powerful websites.
When it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. With this course, and there's no limit to the powerful, interactive Web sites that developers can create.
Training will basically covers step-by-step instructions, complete scripts, and tips to guide trainee. Not only this training includes the discussions on the scripting language (PHP) and then the database program (MySQL), it also goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications.
This training is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic.
Course Outlines
- Getting started
- Introducing PHP
- Installing XAMPP
- Embedding PHP script code
- Scripting by the rules
- Storing values
- Creating variables
- Quoting strings
- Producing arrays
- Sorting arrays
- Describing dimensions
- Checking types
- Defining constants
- Exploring superglobals
- Performing operations
- Doing arithmetic
- Making comparisons
- Examining conditions
- Assessing logic
- Comparing bits
- Changing values
- Grasping precedence
- Testing conditions
- Seeking truth
- Providing alternatives
- Switching branches
- Performing loops
- Looping while true
- Breaking from loops
- Employing functions
- Defining functions
- Passing arguments
- Varying parameters
- Recognizing scope
- Returning values
- Calling back
- Manipulating strings
- Comparing characters
- Searching text
- Extracting substrings
- Changing case
- Formatting strings
- Making dates
- Encoding entities
- Building classes
- Encapsulating data
- Creating an object
- Initializing members
- Using constructors
- Inheriting properties
- Embracing polymorphism
- Handling files
- Reading files
- Reading lines
- Reading characters
- Writing a file
- Appending text
- Handling errors
- Catching exceptions
- Producing forms
- Performing actions
- Checking set values
- Validating form data
- Filtering data
- Sending hidden data
- Handling submissions
- Making sticky forms
- Uploading files
- Surrounding forms
- Appending link data
- Preserving data
- Submitting cookie data
- Setting cookies
- Getting cookies
- Viewing cookie data
- Submitting session data
- Setting sessions
- Getting sessions
- Viewing session data
- Connecting databases
- Making a connection
- Creating a forum
- Providing the page
- Supplying a form
- Processing messages
- Confirming success
- Adding web services
- Loading data
- Getting nodes
- Getting attributes
- Including feeds
- Setting parameters
- Selecting components
- Security
- Preventing spam
- Validating by type
- Preventing XSS attacks
- Preventing SQL Injection attacks
- Database encryption
Programme scope, delivery arrangements and suitability are confirmed during enquiry.