Join Bill Weinman for an in-depth discussion in this video Choosing an interface, part of PostgreSQL 9 with PHP Essential Training.
PHP provides two distinct interfaces for the Postgres database system.…The PDO interface PHP data objects use a normalized interface that works very…similarly across the different supported database systems.…Its PDO that allows me to write some of the scripts so that they work in MySQL, they…work with SQL Light and they also work with Postgres with very little changes.…PHP also supports a more native Postgres interface called PGSQL that more…closely resembles the Postgres C library.…
First let's talk about PDO. PDO provides a common interface that's very similar…across different database engines.…This is the interface that's used most often and therefore it's the interface…that gets most attention from developers.…It has a rich set of methods, so it's possible to do just about anything you…will want to do with your code.…And it provides excellent performance, even superior performance in some cases…over the native interface.…The PGSQL interface is the native interface for the Postgres database engine.…
- 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
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.