Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now

Add a default subject behavior PHP in MySQL

Adding a default subject behavior provides you with in-depth training on Developer. Taught by Kevin … Show More

From:

PHP with MySQL Essential Training

with Kevin Skoglund

Ready to watch this entire course?

Start your free trial now, and access our 3,500+ expert-taught video courses.

Start Your Free Trial Now

Ready to watch this entire course?

Join lynda.com and access our 2,000+ expert-taught video courses.

Start Your Free Trial Now

Expand all | Collapse all

Introduction

4m 8s
1. Welcome
  
  1m 0s
2. Using the exercise files
  
  3m 8s
1. PHP Overview

15m 6s
1. What is PHP?
  
  3m 52s
2. The history of PHP
  
  2m 51s
3. Why choose PHP?
  
  4m 10s
4. Installation overview
  
  4m 13s
2. Mac Installation

1h 3m
1. Overview
  
  2m 33s
2. Working with Apache Web Server
  
  6m 56s
3. Changing the document root
  
  7m 24s
4. Installing to Yosemite
  
  8m 13s
5. Enabling PHP
  
  6m 16s
6. Upgrading PHP
  
  3m 30s
7. Configuring PHP
  
  10m 3s
8. Installing MySQL
  
  5m 46s
9. Configuring MySQL
  
  7m 24s
10. Text editor
  
  5m 1s
3. Windows Installation

31m 25s
1. Overview
  
  3m 27s
2. Installing WampServer
  
  5m 46s
3. Finding the document root
  
  2m 24s
4. Configuring PHP
  
  8m 12s
5. Configuring MySQL
  
  5m 45s
6. Text editor
  
  5m 51s
4. First Steps

19m 12s
1. Embedding PHP code on a page
  
  6m 43s
2. Outputting dynamic text
  
  5m 55s
3. The operational trail
  
  2m 27s
4. Inserting code comments
  
  4m 7s
5. Exploring Data Types

1h 18m
1. Variables
  
  7m 50s
2. Strings
  
  4m 38s
3. String functions
  
  8m 54s
4. Numbers part one: Integers
  
  6m 27s
5. Numbers part two: Floating points
  
  5m 25s
6. Arrays
  
  10m 0s
7. Associative arrays
  
  6m 37s
8. Array functions
  
  6m 33s
9. Booleans
  
  3m 50s
10. NULL and empty
  
  5m 15s
11. Type juggling and casting
  
  8m 27s
12. Constants
  
  4m 43s
6. Control Structures: Logical Expressions

27m 37s
1. If statements
  
  6m 0s
2. Else and elseif statements
  
  4m 16s
3. Logical operators
  
  7m 30s
4. Switch statements
  
  9m 51s
7. Control Structures: Loops

42m 15s
1. While loops
  
  8m 41s
2. For loops
  
  5m 59s
3. Foreach loops
  
  8m 16s
4. Continue
  
  8m 28s
5. Break
  
  4m 8s
6. Understanding array pointers
  
  6m 43s
8. User-Defined Functions

37m 25s
1. Defining functions
  
  8m 25s
2. Function arguments
  
  5m 32s
3. Returning values from a function
  
  7m 33s
4. Multiple return values
  
  4m 53s
5. Scope and global variables
  
  6m 2s
6. Setting default argument values
  
  5m 0s
9. Debugging

20m 18s
1. Common problems
  
  3m 47s
2. Warnings and errors
  
  8m 36s
3. Debugging and troubleshooting
  
  7m 55s
10. Building Web Pages with PHP

57m 57s
1. Links and URLs
  
  5m 33s
2. Using GET values
  
  5m 35s
3. Encoding GET values
  
  8m 41s
4. Encoding for HTML
  
  9m 26s
5. Including and requiring files
  
  7m 40s
6. Modifying headers
  
  6m 45s
7. Page redirection
  
  6m 43s
8. Output buffering
  
  7m 34s
11. Working with Forms and Form Data

1h 3m
1. Building forms
  
  7m 28s
2. Detecting form submissions
  
  5m 59s
3. Single-page form processing
  
  7m 57s
4. Validating form values
  
  10m 40s
5. Problems with validation logic
  
  9m 54s
6. Displaying validation errors
  
  7m 23s
7. Custom validation functions
  
  6m 28s
8. Single-page form with validations
  
  7m 25s
12. Working with Cookies and Sessions

28m 5s
1. Working with cookies
  
  2m 49s
2. Setting cookie values
  
  5m 55s
3. Reading cookie values
  
  6m 1s
4. Unsetting cookie values
  
  4m 51s
5. Working with sessions
  
  8m 29s
13. MySQL Basics

48m 39s
1. MySQL introduction
  
  6m 43s
2. Creating a database
  
  7m 41s
3. Creating a database table
  
  7m 42s
4. CRUD in MySQL
  
  5m 48s
5. Populating a MySQL database
  
  7m 32s
6. Relational database tables
  
  6m 40s
7. Populating the relational table
  
  6m 33s
14. Using PHP to Access MySQL

56m 4s
1. Database APIs in PHP
  
  4m 51s
2. Connecting to MySQL with PHP
  
  7m 45s
3. Retrieving data from MySQL
  
  8m 47s
4. Working with retrieved data
  
  6m 12s
5. Creating records with PHP
  
  6m 58s
6. Updating and deleting records with PHP
  
  9m 6s
7. SQL injection
  
  3m 5s
8. Escaping strings for MySQL
  
  6m 45s
9. Introducing prepared statements
  
  2m 35s
15. Building a Content Management System (CMS)

35m 58s
1. Blueprinting the application
  
  7m 19s
2. Building the CMS database
  
  5m 14s
3. Establishing your work area
  
  4m 38s
4. Creating and styling the first page
  
  4m 22s
5. Making page assets reusable
  
  6m 36s
6. Connecting the application to the database
  
  7m 49s
16. Using Site Navigation to Choose Content

32m 49s
1. Adding pages to the navigation subjects
  
  5m 58s
2. Refactoring the navigation
  
  6m 7s
3. Selecting pages from the navigation
  
  6m 2s
4. Highlighting the current page
  
  5m 26s
5. Moving the navigation to a function
  
  9m 16s
17. Application CRUD

1h 45m
1. Finding a subject in the database
  
  9m 48s
2. Refactoring the page selection
  
  10m 52s
3. Creating a new subject form
  
  6m 55s
4. Processing form values and adding subjects
  
  11m 20s
5. Passing data in the session
  
  9m 16s
6. Validating form values
  
  9m 40s
7. Creating an edit subject form
  
  8m 30s
8. Using single-page submission
  
  7m 44s
9. Deleting a subject
  
  9m 44s
10. Cleaning up
  
  10m 37s
11. Assignment: Pages CRUD
  
  4m 30s
12. Assignment results: Pages CRUD
  
  6m 10s
18. Building the Public Area

39m 26s
1. The public appearance
  
  8m 52s
2. Using a context for conditional code
  
  11m 37s
3. Adding a default subject behavior
  
  6m 9s
4. The public content area
  
  5m 51s
5. Protecting page visibility
  
  6m 57s
19. Regulating Page Access

1h 3m
1. User authentication overview
  
  4m 3s
2. Admin CRUD
  
  8m 41s
3. Encrypting passwords
  
  7m 26s
4. Salting passwords
  
  5m 42s
5. Adding password encryption to CMS
  
  11m 54s
6. New PHP password functions
  
  3m 13s
7. Creating a login system
  
  11m 28s
8. Checking for authorization
  
  5m 48s
9. Creating a logout page
  
  5m 40s
Conclusion

2m 4s
1. Next steps
  
  2m 4s

please wait ...

Adding a default subject behavior

Video Duration: 6m 9s 14h 24m Beginner Jun 04, 2013 Updated May 20, 2015

Adding a default subject behavior provides you with in-depth training on Developer. Taught by Kevin Skoglund as part of the PHP with MySQL Essential Training

View Course Description

PHP is a popular, reliable programming language at the foundation of many smart, data-driven websites. This comprehensive course from Kevin Skoglund helps developers learn the basics of PHP (including variables, logical expressions, loops, and functions), understand how to connect PHP to a MySQL database, and gain experience developing a complete web application with site navigation, form validation, and a password-protected admin area. Kevin also covers the basic CRUD routines for updating a database, debugging techniques, and usable user interfaces. Along the way, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques to improve existing code.

Topics include:

What is PHP?
Installing and configuring PHP and MySQL
Exploring data types
Controlling code with logical expressions and loops
Using PHP's built-in functions
Writing custom functions
Building dynamic webpages
Working with forms and form data
Using cookies and sessions to store data
Connecting to MySQL with PHP
Creating and editing database records
Building a content management system
Adding user authentication

Subject:: Developer
Software:: MySQL PHP
Author:: Kevin Skoglund

Closed captioning isn’t available for this video right now. New videos usually include captioning within 24 hours after they’re released.

Find answers to the most frequently asked questions about PHP with MySQL Essential Training .

Expand all | Collapse all

please wait ...

Q: This course was revised on 6/4/2013. What changed?: A: The old version of this course was 6 years old and it was time for a complete revision, using PHP 5.4. (The tutorials will work with any version of PHP and covers any differences you might encounter). The author has also added updated installation instructions for Mac OS X Mountain Lion and Windows 8. The topics and end project are the same, but the code is slightly different. It also addresses frequently asked questions from the previous version.
Q: This course was updated on 5/20/2015. What changed?: A: We added one movie called "Changing the document root in Yosemite," which helps the Mac installation run more smoothly.