Events  Deals  Jobs  NFT NYC 2024 
    Sign in  
 
 
PHP is fast, free, stable, & feature-rich. It can help bring your website to life, changing it from a static HTML-only experience to a two-way interactive user experience.
Tue, Feb 03, 2015 @ 06:00 PM   $975   Noble Desktop, 594 Broadway, Ste 1202
 
     
 
 
              

      
 
Sign up for our awesome New York
Tech Events weekly email newsletter.
   
LOCATION
EVENT DETAILS
Dynamic Websites & Databasing

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 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 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 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. 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
Topics
Echo, Strings, and Variables
Single Quotes vs Double Quotes
Escaping Characters
Heredoc
Concatenation
Comments
Working with Numbers
Topics
Arithmetic Operators
Assignment Operators
Table of Arithmetic Operators
Table of Assignment Operators
Defining a Site and Testing Server in Dreamweaver
Conditionals
Topics
If/Else
Elseif
Switch
Comparison Operators
Logical Operators
The Difference Between == and ===

SECTION 2

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

SECTION 3

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

SECTION 4

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

SECTION 5

Creating a Database/MySQL/SELECT
Topics
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
Making a Reusable Connection Script
Topics
Error Checking
Making an Include
Sorting Results
Prepared Statements
Topics
Selecting and Filtering Results
Preventing SQL Injection Attacks with Prepared Statements

SECTION 6

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