Join Bill Weinman for an in-depth discussion in this video Creating a library, part of PostgreSQL 9 with PHP Essential Training.
- View Offline
- Exercise Files
Here I have opened the lib or library folder in the Exercise folders and this…the copy of the Exercise folders that's in the web server document root in the…htdocs folder and in this directory there are two files.…One of them is the bwPgSQL.php.…This is the database wrapper library that I created and this is actually the…library that I use most of the time when I'm creating applications in PHP…that use a database.…Then there is the test-bwPgSQL, which is a simple test suite for testing the library.…
So what we're going to do we're going to take a look at this and we're going to…talk about why I do this, why I think it's important to do this and what makes…this a powerful choice for creating applications.…So we'll go ahead and open the library in the text editor here, and let's…just start by taking a little tour of the library.…I call this a database CRUD wrapper.…What that means is that it's a wrapper, because it basically wraps around…the existing interface.…The library itself uses the PDO interface to access the database, but it…
- 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.