As you begin working in MySQL, the sandbox feature is where you'll do most of your editing. It will also serve as a depository for any pertinent files you may be using. Eventually, though, you'll have to get more organized as projects grow. Watch this tutorial to learn how to establish your work area and keep track of any and all files you may be using when building within a database.
- View Offline
- Exercise Files
In this movie, we'll establish the project work area for our content …management system. That is, we're going to create the …directory structure that we can use to put our php files in while we're developing. …Up until now, we've been using the sandbox directory and that's what we've …been accessing. That's still going to be useful to keep around. …That's going to be a place that you can refer back to if you want to see how we …did things. It's also a place where you can try out things. …I use a sandbox like this all the time. Just a place to Jump over to do a quick experiment. …And then jump back to my project again. But I'm going to fold that up. …And we're going to create a new directory here that's going to be for our project.…
Go to File > New Folder. And I'm going to call it Widget Corp. …Now, you can call yours something else if you want. …But this CMS is going to be for a fictional company called Widget Corp. …So that's what I'm going to call it. So, I'm going to double click on that. …
- 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
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m 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.