PHP & MySQL Training Classes New York

			Free Seminars Buy Our Books 1400+ Testimonials


		PHP and MySQL Class Syllabus

PHP is the web’s most popular server-side scripting language. Huge sites like Yahoo, Wikipedia, Flickr, Digg, Vimeo, and more run on it as it is fast, free, stable, and feature-rich. PHP can help bring your website to life, changing it from a static HTML-only experience to a two-way user interactive experience. PHP is the backbone of many web related activities that we take for granted, such as handling form submissions, powering e-commerce transactions, and interacting with a database. In addition many of the most popular CMS (Content Management Systems) such as WordPress, Drupal, and Joomla are written in PHP. Understanding this language will enable you to have a deeper understanding of these web tools making them easier to customize for your needs. And what database is nearly always paired with PHP? MySQL. MySQL is the world’s most popular open source database. Your database can store customer information, product information, and much, much more. Together PHP and MySQL are available for free on nearly every host. This class will introduce you to the basics of PHP and MySQL. We’ll start from the ground up, building a solid foundation of understanding of how PHP works, thus allowing you to tackle your own projects and applications. We’ll show you how to work with forms, sanitize user input for security, send emails, work with cookies to collect information on your users, and upload files. You’ll interact with databases using SQL to fetch, insert, update, delete, and search records. You’ll learn how to use phpMyAdmin to create databases and tables, as well as data-typing and indexes. This class assumes that you have a solid understanding of HTML, but you don’t need to have prior programming experience. Although you can code PHP in any text editor, we use Dreamweaver for the class. In addition, to run a local server on each machine we use XAMPP (free) for the PC and MAMP Pro ($59) for the Mac. 18 hours of hands-on training, one person per computer Includes workbook with CD (used by teachers and colleges worldwide) Workshop fee: $975 \| Discounts Course Schedule \| Register Now
	Session 1: PHP and Programming Basics	Exercises

	PHP Syntax Echo, Strings, and Variables Single Quotes vs Double Quotes Escaping Characters Heredoc Concatenation Comments Linking to a Testing Server Arithmetic Operators Assignment Operators Table of Arithmetic Operators Table of Assignment Operators Conditionals If/Else Elseif Switch Comparison Operators Logical Operators The Difference Between == and ===	Basic PHP Syntax Defining a Site and Testing Server in Dreamweaver Working with Numbers Conditionals

	Session 2: More Useful Programming Concepts	Exercises

	Arrays Creating a Simple Array Using array() Multidimensional Arrays Printing an Entire Array Using print_r() Loops While Loops Do...While For loops Foreach Break Out of Loop Continue Comparing Strings Converting to Upper and Lower Case Searching Through Strings Case Sensitive and Case Insensitive	Arrays Loops Working with Strings

	Session 3: Forms, Security, Email	Exercises

	Form Basics and Security Post vs Get Radios, Checkboxes, and Select Fields Magic Quotes Securing the page Sending Email Setting Up MAMP Pro Setting Up XAMPP and Mercury Mail Sending a Test Email Simple Form Validation and Email Sanitizing Input Error Checking Displaying Errors Sending Email Adding a Thank You Page	Form Basics and Security Sending Email Simple Form Validation and Email

	Session 4: Cookies, Sessions, File Uploads	Exercises

	Adding Cookies Tracking the Number of Visits Sending an Email with the Cookie Info Maintaining Variables Between Pages with Sessions Starting a Session Using Session Variables Log In/Log Out Destroying Session Variables File Uploads Making a File Upload Form The $_FILES Array Uploading Files Basic Security	Cookies Sessions File Uploads

	Session 5: Intro to MySQL and Databases	Exercises

	Creating a New Database Connecting to the Database SQL Basics The SELECT Statement Display the Number of Rows Returned Making a Reusable Connection Script MySQL vs MySQLi vs PDO Error Checking Making an Include Sorting Results Prepared Statements Selecting and Filtering Results Preventing SQL Injection Attacks with Prepared Statements	Creating a Database, MySQL, SELECT Making a Reusable Connection Script Prepared Statements

	Session 6: More SQL and Working with Forms	Exercises

	Using phpMyAdmin The INSERT Statement Inserting Information from a Form The UPDATE Statement Update Form Display Data in the Update Form Display Checkboxes Hidden Fields Deleting Rows from a Database The DELETE Statement Passing ID Variables in a URL Wildcard Searches Searching with a Form	SQL: Insert SQL: Update SQL: Delete SQL: Search

Workshop fee: $975 \| Discounts Course Schedule \| Register Now

Noble Desktop, LLC
594 Broadway, Suite 1202, New York, NY 10012 212.226.4149
Send all inquiries to .