Course
PHP Programming & MySQL for Web Development
Course Duration
5 Days
The PHP Programming & MySQL for Web Development course is designed to give delegates the knowledge to develop/maintain PHP scripts utilizing the MYSQL database system and HTML.
Public Scheduled Dates
<<
<
>
Public scheduled prices per delegate +VAT
This course is available as a private event. A private event can be held at one of our venues, your location, or somewhere else if you prefer.
Prerequisites
-
- Have attended Introduction to MySQL or have equivalent knowledge
- Familiarisation with programming concepts is useful, this knowledge can be obtained by attendance on the Concepts of Programming course
Objectives
-
- Demonstrate a good practical knowledge of how to write successful HTML/PHP code utilising a MySQL database
Target Audience
-
- This course would benefit UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MySQL.
Skills Gained
-
- Declare variables and initialise them
- Construct expressions with arithmetic, logical and relational operators
- Use iterative type statements
- Use conditional statements
- Read/write text and binary files
- Manipulate text using regular expression
- Use and code functions
- Use built-in library functions
- Use arrays and hashes
- Create and use external PHP Code
- PHP Configuration
- Basic SQL Syntax
- Connect to a MySQL Database with Error Checking
- Use PHP to Interact with a MySQL Database
- Utilise PHP with the HTML Environment
- Work with Email and Cookies
- Consider Security Implications when using PHP and MySQL
What's included
-
- Comprehensive course materials and exercises
Course Content
-
HISTORY OF PHPInstalling PHP
General Requirements
UNIX based Systems
Windows based Systems
Integrated Development Environment (IDE) -
PHP LANGUAGE BASICSProgramming Basics
Comment markers
PHP Tags
Output Commands
Using STDIN STDOUT and STDERR
Using Files
Include_path
Opening files
Reading files
Writing to Files
RTRIM -
PHP VARIABLESNaming Rules
Data Types
Numerical
Integer
Floating Point Numbers
Floating Point Precision
Single Quoted Strings
Double Quoted Strings
Creating and Assigning Variables
Assigning Values to Variables
Type Conversion
Variable Scoping
Global Keyword
Static Keyword
Super Globals
Constants
Variable Variables
Operators
Assignment Operators
Increment/Decrement Operators
Arithmetic Operators
String Operators
Comparison Operators
Logical Operators -
CONTROL STRUCTURESStatement Blocks
If Construct
Else Keyword
Elseif Keyword
Looping Constructs
While Loop
Do-while Loop
For Loop
Foreach Loop
Loop Control Words
Break
Continue -
REGULAR EXPRESSIONSMeta-Characters
Backslash
Unicode Character Properties
Circumflex and Dollar
Full Stop
Square Brackets
Vertical Bar
Multipliers
Subpatterns
Repetition
Pattern Matching with ereg and eregi
Pattern Matching with preg_match
Splitting Text
Switch -
PHP ARRAYSSyntax
Creating/Modifying with Square-Bracket Syntax
Array Functions
Pitfalls when using Arrays
Using a Return value as a Key
Converting to Array
Sorting an Array
Multi-Dimensional Arrays
Example
Creating a new Multi-Dimensional Array -
PHP FUNCTIONSConditionally Created Functions
Functions Created Inside Functions
Argument Passing by Value
Argument Passing by Reference
Returning Values
Including External PHP Functions -
PHP OBJECT ORIENTEDClasses and Inheritance
Classes
Inheritance
Keywords -
PHP & PEARWhat is PEAR?
Command Line Package Installer
Fully-Automatic Installation
Semi-Automatic Installation
What is PECL -
PHP & HTMLHTML/PHP Examples
-
PHP CONFIGURATIONWorking with External Files
Error Reporting
Interacting with External Programs -
BASIC SQL STATEMENTSCreating Databases and Tables
Inserting Data into Tables
Viewing Tables
UPDATE
Drop -
CONNECTING TO MySQLmysqli_connect
mysqli_error
Die -
USING PHP TO PERFORM DATABASE FUNCTIONSInserting Data into a Database
Creating Queries
Executing Queries
Processing the Returned Query Data
Updating the Database -
GENERATING HTML USING PHPPHP Inside HTML
HTML Form with Embedded PHP
Multiple HTML Pages/Forms with PHP -
EMAIL AND COOKIES USING PHPGenerating Email using PHP
Generating Cookies using PHP
Using Cookies -
PHP AND DATABASE SECURITYDesigning Databases
Connecting to Database
Encrypted Storage Model
SQL Injection
Security Techniques
Error Reporting
User Submitted Data
Your SQL course can be delivered online or in-person. You can choose your learning path and delivery style. Learn in-person or online with our virtual classrooms. Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. Course materials available online using your personal training account.
You can master SQL, please contact us to book a place or request a quote.
-
Course Options
Please contact us to discuss options for this coursePublic ScheduledPublic ScheduledFixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!PrivatePrivateFlexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.VirtualVirtualThese courses can be attended from anywhere.
- Virtual Training
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/26/2024 8:01:24 AM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/26/2024 8:01:24 AM