Training » All Courses » PHP » PHP

Course Summary

PHP Training with MySQL is an introductory course in the PHP and MySQL technology. Students will receive hands-on training in PHP programming language, and an introduction to MySQL database administration, SQL database language, and web development principles.

Upon completion of PHP Training, you will be able to create powerful database-driven websites.

Duration

3 days.

Objectives

The objective of PHP Training course is to train students in becoming proficient PHP/MySQL web developers.

At the end of the course, students will have basic understanding of the web technology and be able to architect, write, debug, and run complete web applications using PHP and MySQL.

Instructors

Photo

Aleksandar (Saša) Gargenta is the technology brains at Marakana. Always on top of the latest in software, Aleksandar is company's radar for technology that matters.

Aleksandar is the author of Marakana's Java, Advanced Java, Spring/Hibernate, JBoss, Apache, XML/XSL, and JUnit/TestNG training courses. Phew. And if that's not enough, he's also the chief architect of Marakana Spark, the on-demand software platform that powers marakana.com and a number of other training companies. As an instructor he's taught hundreds of classes for everyone from Apple to Disney, from NASA to the Department of Defense.

In his spare time Aleksandar runs the San Francisco Java and the San Francisco Android User Groups with over a thousand members between the two. More about Aleksandar Gargenta...

Photo

Marko founded Marakana back in 2001 to help underprivileged youth, minorities, and inner-city kids learn web technologies and get ahead in life. So Marakana emerged with goal of helping people get better at what they do professionally, focused on open source software training.

Learning Android by O'Reilly Marko is the developer of Marakana Android Training series. He has taught Android for companies such as Sony-Ericsson, Qualcomm, Ericsson Canada, and many others. Marko is a co-founder of San Francisco Android Users Group and regularly teaches Android Bootcamp at Marakana.

Marko is author of upcoming Learning Android book published by O'Reilly Media. This book is based on Android Bootcamp and incorporates best learning practices for new developers to start creating applications for this exciting open source mobile platform.

In 2006 Marko Gargenta published "PHP and MySQL By Example", a collection on PHP examples. The book was published by Prentice Hall, world's largest technology publisher and has been also translated to Spanish.

Marko Gargenta obtained his Bachelor of Mathematics Degree from University of Waterloo (Canada's MIT) and has been developing in Java since 1996. He lives in San Francisco, California.

Speaking Engagements

More about Marko Gargenta...
Photo
Robyn Overstreet is a web developer and teacher who specializes in PHP. She is a Zend Certified Engineer who also works in Javascript, AJAX, and Actionscript. Robyn designs and builds custom content management systems, in addition to developing with the open-source content management systems WordPress and Drupal.

Robyn teaches web development in many different contexts, from corporate trainings to community groups, to one-on-one tutoring.

She holds a Master’s degree from New York University’s Interactive Telecommunications Program, where she built interactive art pieces with everything from microcontrollers to cardboard.

Robyn is a displaced New Yorker living pretty comfortably in San Francisco. When she's not coding, she's making collages or jewelry, riding her bike, or cooking something in season. More about Robyn Overstreet...

Additional Notes

About Your Instructor

PHP and MySQL By Example - Book Marko Gargenta the co-author of PHP and MySQL by Example, a by-example book published by Prentice Hall (world's largest tech publisher). Marko has been tinkering with the web since Mosaic browser hit the net in 1994. Marko is now a Zend Certified Engineer and instructor for most of the Zend PHP classes, with fine focus on advanced PHP topics such as Zend Framework. Marko is big on Agile development processes, eXtreme Programming, and is a Certified ScrumMaster. He's a frequent speaker at Bay Area users' groups, including SFAgile.org (which he runs), SFJava.org and SFAndroid.org (which he co-founded). Marko's PHP specialty is bringing grownup concepts such as OOP, Agile, and the design patterns to the PHP community. Marko's other specialties are Java and Android.


Outline


Introduction to PHP

  • From Static to Dynamic Websites
  • What is PHP?
  • What is MySQL?
  • Where to get PHP and MySQL?
  • The Big Picture: How PHP and MySQL fit the Web

PHP Fundamentals

  • PHP.ini Configuration File
  • Basic Syntax
  • Mixing PHP and HTML
  • About Comments

Quick Start for Programmers

  • PHP Language Overview

Variables, Datatypes, Operators

  • Escaping Special Characters
  • Strings
  • Numbers

String Manipulations

  • String Concatenation, Upper/Lower Case, Sub Strings, Replacement
  • String Formatting with printf

Conditionals

  • If Statement
  • Switch Statement

Loops

  • For Loop
  • While Loop
  • Foreach Loop
  • Loop Control (break and continue)
  • Nested Loops

Functions

  • Function Definition
  • Function Scope
  • Arguments and Return Values

Arrays

  • What Are Arrays (definition)
  • Indexing by Number
  • Indexing by Strings - Associative Arrays
  • Arrays and Loops

Form Processing

  • Review of HTML Forms (check boxes, text fields, radio buttons)
  • Retrieving Form Data
  • The GET and POST method
  • Submitting to Itself

Validating User Input with Regular Expressions

  • Intro to Regular Expression Metacharacters
  • Verifying Email Addresses, ZIP code, Phone Numbers, Credit Cards
  • PCRE Functions

Files and Directories

  • Read and Writing Files
  • Working with Directories
  • Working with CSV Files
  • About File Permissions

Introduction to MySQL Administration

  • The Command-Line Client
  • MySQL Control Center
  • Connecting to Database Server
  • Selecting a Database

SQL Language

  • The Big Picture: Databases, Tables, and Fields
  • SELECT Statement
  • INSERT, UPDATE, and DELETE Statement
  • CREATing Databases

PHP and MySQL

  • Connecting from PHP to MySQL
  • Executing SQL Queries
  • Retrieving Query Results
  • Putting It All Together

Sessions and Cookies

  • Introduction to Sessions and Cookies
  • Password-protecting Pages

Objects in PHP

  • Introduction to Objects
  • Properties and Methods

Introduction to PEAR

  • Installing PEAR
  • Overview of PEAR Library

Debugging PHP Code

  • About PHP Error Handling
  • Using Print to Narrow Error Messages

Advanced Topics

  • PHP and Javascript
  • PHP and Images
  • PHP and PDF
  • PHP and Flash

Course Testimonials

The PhP and MySql class was presented in a way that was easy to understand.

- BCDC

Enjoyed the class. The instructor broke down the material into very understandable form.

- Idea Integration

This class gave me a greater understanding on PHP coding using best practices and was a great start to my professional development.

- Tachometry Corporation

I feel as if I have gained a clear knowledge of PHP and how I can use it in my future projects.

- Idea Integration

Marko is an excellent instructor, he presents the material clearly and reinforces it well with examples. I would recommend him to anyone wanting to learn PHP.

- Idea Integration

Instructor is an expert and it made the course progress with ease. Great instructor!

- Experian

After the class I gained a lot of confidence in handling PHP/MySQL projects. Excellent educational experience - Nick Stoianov

- Union Bank of California

Instructor, was very good, patient and courteous.

- Experian

Real-life application and one-on-one training. Instructors care very much. Great facility!

- UCSF