Understanding PHP Data Objects (PDO)

Understanding PHP Data Objects (PDO), available at $19.99, has an average rating of 4.2, with 18 lectures, based on 28 reviews, and has 383 subscribers.

You will learn about Work with MySQL and other database software from PHP including connecting, inserting, updating records, displaying database records in lists within HTML and database security. This course is ideal for individuals who are Anyone with basic knowledge of PHP, database experience not required but is helpful, as this is demonstrated. It is particularly useful for Anyone with basic knowledge of PHP, database experience not required but is helpful, as this is demonstrated.

Enroll now: Understanding PHP Data Objects (PDO)

Summary

Title: Understanding PHP Data Objects (PDO)

Price: $19.99

Average Rating: 4.2

Number of Lectures: 18

Number of Published Lectures: 17

Number of Curriculum Items: 18

Number of Published Curriculum Objects: 17

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

Work with MySQL and other database software from PHP including connecting, inserting, updating records, displaying database records in lists within HTML and database security.

Who Should Attend

Anyone with basic knowledge of PHP, database experience not required but is helpful, as this is demonstrated.

Target Audiences

Anyone with basic knowledge of PHP, database experience not required but is helpful, as this is demonstrated.

The course teaches PHP Data Objects (PDO), the preferred way to connect to databases within PHP. It covers connecting to the database, and using all the features required to build fast, scalable applications that use a database connection. It covers essential concepts like security, and best practices with using the data retrieved from the database.

While a basic knowledge of PHP is recommended for this course, both beginners and experienced web developers will gain a complete understanding of how PHP Data Objects work.

A basic knowledge of PHP is recommended for this course. You will need to be able to open and write to a basic PHP file and be able to have a server and database installed. This course will use MySQL server.

Exactly What Is PDO?

The PHP Data Objects (PDO) extension defines a lightweight, consistent interface for accessing databases in PHP. Each database driver that implements the PDO interface can expose database-specific features as regular extension functions. Note that you cannot perform any database functions using the PDO extension by itself; you must use a database-specific PDO driver to access a database server.

PDO provides a data-access abstraction layer, which means that, regardless of which database youre using, you use the same functions to issue queries and fetch data. PDO does not provide a database abstraction; it doesnt rewrite SQL or emulate missing features. You should use a full-blown abstraction layer if you need that facility.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Understanding PHP Data Objects (PDO)

Lecture 1: Listing Available Drivers

Lecture 2: Setting Up A Database

Lecture 3: Connecting

Lecture 4: Error Levels

Chapter 3: Fetching Results

Lecture 1: Basic Queries

Lecture 2: Fetching Results

Lecture 3: Looping

Lecture 4: Fetch All

Lecture 5: Fetch As Object

Lecture 6: Row Count

Chapter 4: Hands On Project: User Class Dates

Lecture 1: Project: User Class Dates

Chapter 5: Security

Lecture 1: Escaping

Lecture 2: Prepared Statements

Chapter 6: Inserting

Lecture 1: Inserting

Lecture 2: Last Inserted ID

Chapter 7: Bonus Material

Lecture 1: Bonus Lecture

Instructors

Stone River eLearning
Over 1,000,000 Happy Students

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 2 votes

4 stars: 14 votes

5 stars: 10 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!