Join Bill Weinman for an in-depth discussion in this video Using PHP to insert, read, update, and delete rows in a PostgreSQL database, part of PostgreSQL 9 with PHP Essential Training.
Now we're going to take a look at the code that makes the CRUD application work.…If you look in your CRUD folder in your ExerciseFiles, you'll see that there's…an assets folder and inside that assets folder is a little icon file and four…PHP files and an index.html file.…The index.html file is really not even used at all.…It says, This page intentionally left blank, and the purpose of it is in case…this is on a web server someplace and somebody tries to look at a directory, I…do this in all of my unused directories.…
You'll notice the same thing in the css directory--there's another one of those.…The css directory has the main.css file, and this is exactly the same as the one…for the SID program, which explains the similar color scheme.…In the assets folder, you've got a footer.php.…There is a bit of HTML with some variables that get replaced in PHP.…There is a header.php, similar deal there,…plain.php, which I think in this case is actually not even used,…and main.php, which is the main layout of the middle of the screen here.…
- Installing PostgreSQL
- Understanding database architecture
- Inserting, updating, and deleting data in a table
- Creating a database library
- Indexing ID fields
- Storing numbers, text, and Boolean values
- Reading data
- Using casts to force type
- Using mathematical functions
- Concatenating strings
- Working with date and time functions and operators
- Defining CRUD
- Using PHP to insert, read, update, and delete rows in a database
Skill Level Beginner
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m Intermediate
1. Quick Start
2. Creating a Database
3. Data Types
4. Storing and Reading Data
5. SQL Expressions
6. Mathematical Functions and Operators
Using math functions3m 2s
7. String Functions and Operators
8. Date and Time Functions and Operators
9. PHP Interfaces
10. Web Applications
- 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.