You are here

PHP & MySQL

PHP & MySQL

Overview

Noble Desktop
594 Broadway
Ste 1202
New York, NY 10012
Register for Course
Tuesday, April 24, 2018 -
6:00pm to 9:00pm
$975

Details

PHP is the webs 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 interactive user 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 worlds 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. Well start from the ground up, building a solid foundation of how PHP works, thus allowing you to tackle your own projects and applications. Well 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. Youll interact with databases using SQL to fetch, insert, update, delete, and search records. Youll learn how to use phpMyAdmin to create databases and tables, as well as data-typing and indexes. Prerequisites This class assumes that you have a solid understanding of HTML, but you dont need to have prior programming experience. Please note that to run a local server on each machine we use XAMPP (Free) for the PC and MAMP Pro ($59) for the Mac. What You'll Learn: Section 1 Basic PHP Syntax Working with Numbers Conditionals Section 2 Arrays Loops Working with Strings Section 3 Form Basics and Security Sending Email Simple Form Validation and Email Section 4 Cookies Sesssions File Uploads Section 5 Creating a Database/MySQL/SELECT Making a Reusable Connection Script Prepared Statements Section 6 SQL: Insert SQL: Update SQL: Delete SQL: Search

Register for Course

Additional Sessions