Before you begin your PHP MySQL training, you need to understand what PHP is and how it relates to MySQL. That way you will know exactly what it is that you are dealing with, and how you are going to use it during the training. This online lesson will address the question of "What is PHP?" by giving a concise overview.
We're going to start out by talking about what is PHP? PHP is a server side scripting language. Now you may have thought that PHP was a programming language. Well, technically speaking, it's not. So how's a scripting language different from a programming language? The distinction between them is largely artificial, and the lines can get a bit blurry. But we can do a general comparison. A script only runs in response to an event. It also usually runs a set of instructions by working down the page from the start to the end. It has little or no user interaction after that initial event. So PHP script does not run until a web page is requested. Then it launches, follows its instructions from top to bottom, and then quits until another action launches the script again. On the other hand, a program, runs even when not responding to events. It continues to run, and to wait for interaction.
Whether that interaction comes from a user, making choices, or from other programs or input. A programs also jumps around with instructions a lot more. So that there's often not a clear start and end point. And it often involves lots of user interaction. Photoshop is a good example of an application. After you launch it, it keeps running, waiting for more interactions or for you to tell it to quit. The task that it performs are not a linear set of instructions. It jumps around based on the task that you want to do at that particular moment. But as I said, the lines get blurry as scripts get more complex, they start to resemble programs.
We'll be able to just write our PHP, put it where our web server can find it, and then we can load up the web page and see the results. PHP is designed for use with HTML. It can be embedded in our HTML. And we can use it to generate HTML. In the end PHP is going to return HTML to the browser. PHP code is going to be our input and web pages are going to be our output. Now if you've been working with HTML you're already familiar with having .htm or .html at the end of your file names. PHP is going to work exactly the same but we're going to put php at the end.
The php is going to tell the web server that this file contains php codes that needs to be executed. PHP is going to provide more flexibility than html does on it own. HTML pages are static by their nature. So all visitors to a web page see that same page all the time. A PHP lets us create dynamic pages. And page content can change based on conditions. Such as interactions with the user, or data stored in a database. You can think of PHP as turbo charging your html. PHP syntax is going to be very similar to C, Java, and Perl.
The small details are going to vary quite a bit, but the structure of logical expressions and loops, those kinds of things will be kind of familiar to anyone with programming experience in one of these languages. Now that we know what PHP is, in the next movie, we'll find out a little bit about the history of PHP.
- 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
Skill Level Beginner
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.
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m Intermediate
Ajax with PHP: Add Dynamic Content to Websiteswith Kevin Skoglund3h 37m Intermediate
1. PHP Overview
2. Mac Installation
3. Windows Installation
4. First Steps
5. Exploring Data Types
6. Control Structures: Logical Expressions
7. Control Structures: Loops
8. User-Defined Functions
10. Building Web Pages with PHP
11. Working with Forms and Form Data
12. Working with Cookies and Sessions
13. MySQL Basics
14. Using PHP to Access MySQL
15. Building a Content Management System (CMS)
16. Using Site Navigation to Choose Content
17. Application CRUD
18. Building the Public Area
19. Regulating Page Access
Next steps2m 4s
- Mark as unwatched
- Mark all as unwatched
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.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.