Event #3139: Introduction to PHP & MySQL

Date: 2008-8-12 Country: CAN Category: Training URL: http://www.coresolutions.ca Introduction to PHP & MySQL Course Overview This three day introductory course has been structured to cover aspects of PHP 4 and PHP 5. PHP and MySQL are undoubtedly the two most popular open source technologies available today. PHP is a very powerful web based scripting language and MySQL is the most popular open source database engine in use today. Together these two tools allow you to create very powerful data driven web sites and applications. What you will learn In this course we show you how to take your static web pages and turn them into dynamic content for your site visitors; allowing them to interact with your site through form submissions and allowing you to provide dynamic content through the use of database back ends such as MySQL. Target Audience This course is designed for the individual who is new to PHP and who wants to learn the fundamental skills required to create and maintain PHP based websites. It’s also suitable for existing web programmers who may already be using a server side language such as JSP and wants to learn how to use PHP in their day to day work. Knowledge of client side scripting languages such as JavaScript is an asset but not required. Prerequisites This course requires individuals to be already familiar with HTML, an HTML Editor and possess the skills to create basic static web sites. Training Materials Each student receives a 240 page PHP Training Guide to help you master the skills of PHP and website development. In addition, you will receive a CD-ROM containing all the files used during the class. Software Needed on Each Student PC The included CD-ROM contains versions of software needed which can be installed as necessary. Please Note* If using a provided work station, all software will be pre-installed, if you are bringing your own, please having the following software installed* • Linux or Windows operating system • Internet Explorer 7 or later or Firefox 2 or later Modules 1. Introduction to Web Applications and Web Servers 2. PHP Editors 3. Getting Started with PHP 4. Passing Information between Pages 5. Conditions and Branches 6. Looping 7. Advanced Data Passing 8. Functions 9. Strings, Dates & Arrays 10. My SQL 11. Using MySQL from PHP Duration 3 Days Pricing $1,495.00 Introduction to PHP & MySQL Topics Module 1 - Introduction to Web Applications and Web Servers  Difference between Static and Dynamic Web Pages  Difference between Client-side and Server-side Scripting Module 2 - PHP Editors  Zend Studio Overview and Features  Getting Around in Zend Studio Module 3 - Getting Started with PHP  PHP Introduction  Scripting Tag  Debugging with Zend Studio  FTP Your PHP Pages with Zend Studio Module 4 - Passing Information between Pages  The Difference between GET and POST  Retrieve Data After a Form Submission Module 5 - Conditions and Branches  IF Statement  Some Helpful Tips  Logical Operators (AND, OR, NOT)  Nested IF Statements  Switch Statement Module 6 - Looping  Loops Module 7 - Advanced Data Passing  Learn how to Pass Data To the Same PHP Page Module 8 - Functions  Functions  Variable Scoop  Setting A Default Value for Parameter  Pass-by-Value versus Pass-by-Reference  Importing Files Into a PHP Page Module 9 - Strings, Dates & Arrays  String Manipulation  Working with Dates and Times  Arrays Module 10 - MySQL  What is a Database  Introduction to MySQL  Administrating a Database  Summary Module 11 – Using MySQL from PHP  Querying MySQL from PHP  Connecting PHP to a MySQL database  Retrieving Data from a MySQL database  Fetching Data  PHP Data, HTML Forms and MySQL  Reviewing the Shopping Cart program  Explanation of the Shopping Cart program -- https://master.php.net/manage/event.php?id=3139&action=approve https://master.php.net/manage/event.php?id=3139&action=reject https://master.php.net/manage/event.php?id=3139