Explore some examples of operational SELECT queries in a fully functional database application written in PHP.
- [Instructor] In this lesson I'll show you…the select queries in the CRUB application.…Here you'll see how I navigate the differences…between database engines.…This is the crud.php file from the exercise files…under the CRUD folder.…I'm just gonna use this handy little menu here in BB edit…to get to the init function.…This is where I initialize the database engines…and global variables and things like that…that I find convenient for the task…of programming and inscripting language.…
You notice that I use php's switch statement…to switch between database engines for sqlite3,…for mysql, and for post gress.…These are all able to use php's pdo driver,…which is a unified driver for multiple database engines.…I find that very convenient.…You notice here, under sql lite, I create some UDFs.…These are the same UDFs that we saw…in the chapter on UDFs in the main body of this course…and that includes this nice aggreger version.…
So if we come down here to get albums SQL…and you'll find it down there someplace…around line 631 in the source code.…
- Understanding SQL terminology and syntax
- Creating new tables
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Defining functions in PHP
Skill Level Beginner
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times1m 52s
11. Views and Subselects
12. Defined Functions
13. A Simple CRUD Application
- 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.