Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
PHP with PDO - ULTIMATE Crash Course
Rating: 4.7 out of 5(507 ratings)
2,562 students

PHP with PDO - ULTIMATE Crash Course

Learn PHP Data Object Objects or PDO and make better secured database queries.
Created byEdwin Diaz | 900,000+ Students, Coding Faculty Solutions
Last updated 1/2022
English

What you'll learn

  • Learn to use PDO with PHP to build more secured applications
  • Students will learn how to use PDO with PHP and MySQL

Course content

1 section • 19 lectures • 1h 31m total length

  • Introduction1:27
  • Editors, Video Quality and Udemy Interface Walk Through8:54

    Explore the Udemy interface and learn how to adjust video quality, captions, transcripts, and playback controls. Discover course resources, notes, Q&A, and announcements that enhance your learning experience.

  • Update - Editors I recommend0:37
  • Creating Database, table and data4:18
  • Connecting6:27
  • Catching errors6:14
  • Reading data / Fetching7:33
  • Reading all data / Fetching4:28

    Pull all rows from the database with a simple PHP PDO query, compare fetch and fetching all, then loop with foreach to access fields as objects or associative arrays.

  • Prepare statement part 18:37
  • Prepare statement part 2 - different placeholder3:38

    Learn how to use PHP with PDO prepared statements using question mark placeholders, binding parameters for first name and password, and executing queries securely.

  • Binding values3:33
  • Complex binding6:27
  • Bind params feature2:47
  • Manually escaping data3:20

    Learn how to manually escape data in PHP with PDO using the quote method, before executing a simple non-prepared query, to safely fetch a user.

  • Updating data3:53
  • deleting and inserting data5:26

    Execute delete and insert operations on user data using SQL statements, including fields like first name, user name, email, active, and password.

  • Counting table rows1:57
  • Last inserted id, insertion and update4:54
  • Affected rows6:36

    Learn how affected rows reflect updates, selections, and deletions in a database using PHP with PDO, including checking rowCount and verifying changes in the browser.

Requirements

  • A little basic understanding of OOP in PHP will be good but not required to follow the course
  • Basic MySQL knowledge

Description

PDO is the best way to access databases in PHP among other web programming languages. PDO is not database specific, so we can use it to connect and control data for a very broad selection of databases. PDO is most  secured and easy way to access any database.

PDO stands for PHP Data Objects and a little Object Oriented Programming understanding is necessary but not required to follow the course.


The awesome thing about PDO is that because it offers data-access abstraction you can use the same functions to create, read, update and delete with any database you choose. PDO doesn't replace SQL or rewrites it but it adds features that are not accessible any other way.


If I am writing an application from scratch on PHP, I mostly use PDO to handle my queries since sometimes I like to switch databases and it would be a hassle to rewrite the API for manipulating data in each database, OUCH.


In this course you will learn how to use PDO to Create, read, update, delete data from any database and lots more.

The best thing about this course is that it goes right to the point and it doesn't waste much time on trivial matters.

If you are ready to get started learning how to use PDO with PHP, lets go......

Who this course is for:

  • Any student looking for better secured way to access PHP databases
  • Students who want a better solution to prevent SQL injection
  • Studens with some basic knowledge of PHP

Report abuse