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

Using a context for conditional code


PHP with MySQL Essential Training

with Kevin Skoglund

Video: Using a context for conditional code

Using a context for conditional code provides you with in-depth training on Developer. Taught by Kevin Skoglund as part of the PHP with MySQL Essential Training
Expand all | Collapse all
  1. 4m 8s
    1. Welcome
      1m 0s
    2. Using the exercise files
      3m 8s
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 27m 37s
    1. If statements
      6m 0s
    2. Else and elseif statements
      4m 16s
    3. Logical operators
      7m 30s
    4. Switch statements
      9m 51s
  8. 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
  9. 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
  10. 20m 18s
    1. Common problems
      3m 47s
    2. Warnings and errors
      8m 36s
    3. Debugging and troubleshooting
      7m 55s
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. 2m 4s
    1. Next steps
      2m 4s

please wait ...
PHP with MySQL Essential Training from
Video Duration: 11m 37s14h 24m Beginner Jun 04, 2013 Updated May 20, 2015

Viewers: in countries Watching now:

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
Kevin Skoglund

Using a context for conditional code

In this movie we're going to learn to use a simple programming technique, to make our code flexible and help us not repeat ourselves. If we have code that should behave almost the same in more than one context. Then instead of duplicating that code and making a few changes, its better to use a variable to identify the current contacts. And then use conditionals in the code to get the multiple behaviors that we want. The idea's extremely simple, but actually very powerful. Let me give you a quick example. Let's say that we have a context. The context can be morning, day, evening or night.

And then in our code, we can just say if the context is equal to night talk quietly, otherwise talk normally. This example is very simple, but it makes the point well. Context is a variable that's used, just so that we can base our conditionals off of it. Let me give you more of a real world example. Let's imagine that we have some code, and that code can exist in the header of our website, in the footer of our website, or somewhere in the body. We want it to behave almost identical in all three scenarios, with just some slight differences. We want to change the way that we apply margins to the item, depending on where it is.

So, instead of duplicating everything, we just make those changes using context. If the context is the header, then add margin on the bottom. If it's in the footer, add margin on the top, otherwise, add no margin at all. I think you get the point, and where I think we can make good use of this idea on our application is to differentiate between the public side of our website and the admin side. Right now, if we're on the public side, index.php, it looks the same, Widget Corp. Click over here, it looks exactly the same. I want us to have some way that we can quickly identify which area we're in.

So, let's open up header.php and let's do that, right here in the h1, that's the big blue block at the top. Let's just put in a conditional here that just says php If the layout context, I could just use the word context. But layout context is something I'm unlikely to use in any other way so I'm going to stick with that. If layout context is equal to admin, then just echo admin. Right? Nice and straightforward. So then we just have to set layout context.

So let's just come up here to the top, and PHP and it's not double equals it's just a single equal. So now, if layout context is equal to admin, we should see admin echoed right here in the header. Now, I'm forcibly setting it all the time right now, but let's just go back and take a peek at what that looks like. See? Widget Corp Admin. And I'll add that same thing up here to the top to the title as well,so it'll show up right here. I'll put a space and then, so if layout context is equal to admin, then it'll also say admin up in the title bar. Right up here at the top.

Okay so now I just need to make this conditional, right, right now I'm setting up all the time. Instead what I want to do is, I want to just jump over here and when I'm on admin.php, then before I load it in the header, I want to set the context equal to admin. And then when I'm on the public side of things, index.php, before I load the header, I'm going to set the context equal to public. Right, so in this case, it's set to public, and over here, in this case, it's set to admin. See how that works? Save that. So, instead of forcibly setting that here, we could just take that away for now.

And let's come over here and reload. And you see that we get admin on this side. When we reload here, on index.php, it doesn't show up. So, now we have a way to see. See, my tabs even show a different tab name on them. That's nice. So, now we know which area we're in, just like that. And one last step. It's good to set a default value for these kinds of things, so that if we forget to set it, we'll still have something here. So, let's say, if not isset layout_context, so if we forget to set it, then what do we want to set it to? And I am, instead of setting it to admin, by default I am going to set it to public.

I think, in general, it's better to set it to the more restricted version, the less privileged version. So, by default it will go to the public side. So, we actually don't even have to declare it in index.php, but it is okay if we don't. Now, we also need to, though, on the admin side, we're going to need to add this line throughout our admin area. Every time that we have some HTML, these three pages don't have any HTML in them, but edit_page does. We're just going to do a find for the header, and then we'll just want to put in our context. So, we set the context before we include our file.

Edit_subject, same thing, right before the header. index.php we've already done. Manage_content, and new_page, and new_subject. Okay. So, once it's in front of all of those, now I should be able to go to my admin area, and as I move around in the admin area It keeps that same look. It keeps the layout still always showing Admin.

Even if I go to edit subject. Right? It's still, same thing. No matter where I go, it maintains the fact that it's in the admin area. Now you could have duplicated this file. You could have a regular header. And you could have an admin header. And that's a perfectly valid approach. And you'll find me doing that a lot of times. But I just want to show you that you don't have to. You can just have this one single header file that has conditional logic in it. And you can take it even further. You could have different style sheets that load, you can have different JavaScripts that loads, all based on the context in which this, include file has been included.

The other place that I think we can make good use of this is in our functions. You'll remember that in our navigation we're finding all subjects in both our regular navigation and in our public navigation. But we only want to show visible subjects to the public while the staff area, the admin area, is able to see all subjects regardless of their visibility. So, let's go to our find all subjects, and what we want to do is make find all subjects context aware. So, the best way to do that is to pass in an argument telling it what it's context is.

Now you could just simply do context equals and you could say, you know, admin or public. But instead, I'm just going to do a different approach just to show you another way. Public and the default value is equal to true. So, we're going to pass in either true or false and by default it'll be true. And then whether or not it's public or not. So, if we are finding all the subjects and if public right? Public equals true, so we just have to say, if public, then we need to add this visibility to our query. All right? So, if we're not public, if we passed in false, then we won't have it.

Make sense? We're not calling it context, but it's the same idea. We're just using a variable to determine the behavior inside the function. We're going to do the same thing for find_pages_for_subject, because that also is part of the navigation. Public equals true and you could have it default to false but again I think it's better to default to the thing that has less privileges. And that's the public side of things. Now here it's a little more complicated because our where statement includes visible equals one. We can't just make this conditional, right? If we did, then we would have from pages and, that's not valid SQL.

So, we actually just need to rearrange things a little bit, sometimes it takes a little bit of creativity in how you write these and construct them. But I'm going to say from pages where subject id equals this, because that always happens. And then I'll just use my conditional here, and the conditional is the exact same one that I had there. If public, then add the invisible one, and you'll always just want to check and make sure that the lines still read correctly. That the constructed SQL reads correctly regardless of whether the if statement takes place. Make sure that you have any kind of ANDs that you need, that you have spaces, that you have commas or anything like that, that has to be added in there. So that's it, so if public is equal to true then we'll only find the visible ones otherwise we won't.

Alright so now both of these are now context sensitive. Both find all subjects and find all pages are aware of their context. So, we just have to then call the context. Well, public_navigation doesn't actually need to pass anything in because it can default to those values, right? We could pass in true, that we're in the public context, but I'm just going to leave it. I'm just going to say that it's fine. The only thing that I want to change is just in the admin side, when we find all_subjects, I'm going to pass in false. So, by passing in false as a value, it'll show be all the ones that are not visible as well as the visible ones. And then same thing for fine pages for subject.

So let's just try that out. Let's go over here. And we have our two navigations. Let's reload the page first of all and let's go to, Today's Widget Trivia. You can edit any one of them. But make sure that one of the subjects is equal to visible no. Right, so I still see it here. It tells me that visible is equal to no. But if I go to the public side, and I reload the page, it disappears. Right? So, I've got one function, behaving in two different contexts, just based on that variable, that I pass in.

Now, we're not quite done with this, because we do use find_all_subjects and find_pages_for_subject in other parts of our code, in the admin area. So, we're need to track those down. For example, when we edit our subject, we do find_all. You'll see find_all_subjects gets called here, when we're trying to figure out how many pages there are for the position. We want to make sure that we include all subjects in that list. Not just the visible ones, because we're in the admin area. So you want to track all those down. I'm going to leave that for you to do. Go through all the times that you find, find all subjects.

Find all pages for a subject and if you're in the admin area, you'll want to include that context. You'll notice that we do still completely repeat our navigation and our public navigation. We haven't combined those. I'm going to leave that as an extra credit assignment for you to do on your own. If you want to tackle that, you can actually have one function for the navigation. And you can pass in the context for whether or not it's the public navigation or whether it's the admin navigation. And you can have that context. Have both behaviors, so that we can have our code not repeated between those two.

But again, that's going to be an exercise for you to do on your own. The final point that I want to leave you with on this subject, is I want to show you that you can take this one step further by using an options array. The exact same idea, but instead of just having a single variable for context, you can have multiple variables and you just put those together into an associative array. An options array. Then you can pass that options array into your function. And then in the function, you can look at the different keys inside the associative array as if they were your context variables.

So, if options visible has been set, then we could do our visibility. This is a common pattern. And if you find that you need even more flexibility than with what we've been working with before. It's something you might want to consider. The other nice advantage that it has is a lot of times it makes for very readable code. Because for example, we can just very clearly see, that were asking for visible to be set to false. It's really very plain there. Where it's not quite as clear, in our code. It's not quite as readable that we're sending in just false as a single value.

Here, by putting a label on it, it helps us to identify it, as we're reading our code.

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.
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

* Estimated file size

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.

Mark all as unwatched Cancel


You have completed PHP with MySQL Essential Training.

Return to your organization's learning portal to continue training, or close this page.


Upgrade to View Courses Offline


With our new Desktop App, Annual Premium Members can download courses for Internet-free viewing.

Upgrade Now

After upgrading, download Desktop App Here.

Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Start your FREE 10-day trial

Begin learning software, business, and creative skills—anytime,
anywhere—with video instruction from recognized industry experts. provides
Unlimited access to over 4,000 courses—more than 100,000 video tutorials
Expert-led instruction
On-the-go learning. Watch from your computer, tablet, or mobile device. Switch back and forth as you choose.
Start Your FREE Trial Now

A trusted source for knowledge.


We provide training to more than 4 million people, and our members tell us that helps them stay ahead of software updates, pick up brand-new skills, switch careers, land promotions, and explore new hobbies. What can we help you do?

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.