MySQL PDO Tutorial - Introduction

Показать описание

This is a short series of tutorials on how to connect to a MySQL database using a PDO connection and display the database records in the browser.

Why should we use PDO?

Well first there is a choice of only two ways to connect – either mysqli, the ‘i’ standing for ‘improved’, or PDO, which stands for ‘PHP data objects’.

The old mysql_* commands are deprecated and inherently a security risk and should no longer be used. If possible they should be replaced in old code.

Both PDO and mysqli are equivalent in terms of security as both support prepared statements, meaning that user input is not entered straight into the SQL query but sent along a different channel where it is sanitised and safe to use. So both remove the risk of SQL injection inherent in using mysql_* commands.

Unlike mysqli, PDO supports named parameters and placeholder question marks; mysqli only supports placeholders. I will show how to work with both in this tutorial and you will see that named parameters are an easier and more convenient way of working with database fields easier.

Unlike mysqli, PDO supports many different database vendors – mysqli as we would gather from the name, only supports mysql databases. If you did have to swap from one database type to another you would still have work to do as the SQL queries would be different, but at least it would be possible without many changes.

In summary, PDO is secure, flexible, and convenient and the best choice for all new projects and updates.

Once you've done that, let's get started...

Рекомендации по теме

Комментарии

The introduction is very clear. It is explained clearly. Thank you very much.

srinivasaraoyp

I kept facing problems with php codes using MySQL database.. and I am getting tired of it. So, right now I am ready for your amazing tutorials Mr. Stibbard, O thank you very much sir!

xmx

Hello Dr. Stibbard ! Thank you so much for these tutorial lession, awesome how easy you explained us what we need to know.

kaydues

You are awesome. Thanks for that perfect easy to understand and learning tutorial. God Bless You

zdravkokrastev

incredibly useful.
I sincerely thank you!

coldmow

Thanks for these videos. I hope you will carry on

santoshdevnath

With the connection file, would there be any issue with writing your connection like

$user = 'root';
$password = 'password';
$host = 'localhost';
$db = 'cms';

try{

$pdo = new PDO('mysql:host=' . $host . ';dbname=' . $db . ';charset=utf8', $user, $password);
//var_dump($pdo);
} catch(Exception $e) {
echo 'There is a problem connecting you to the database, please try again later.';
//echo $e->getMessage();
}

I am thinking the variables kept in another file convar.php and included in the connection file but then you can just amend as required if live or local site?

Thanks

DavidAshby

can you make a video of how to store files in filesystem and storing their url in the database.
would really appreciate.

nickbizz

please the link is not opening. its sending a msg that the page isnt found

johnsonanuoluwapo

MySQL PDO Tutorial - Introduction

MySQL PDO Tutorial - Introduction

MySQL PDO Tutorial Lesson 1 - Connection

Part-1 | PHP MySql PDO Tutorial For Beginner | Introduction, Create Database and Connecting to DB

MySQL PDO Introduction

PDO | PHP | MySQL | PDOStatement Intro #001 | BEGINNERS // Tips from the Self Taught Developer

Section 1: Introduction to Learn PDO with MySQL

Introduction to PDO and Prepared Statements for MySQL Queries

PHP PDO Tutorial Part 1 - Prepared Statements - SQL Injection - Full PHP 8 Tutorial

MySQL PDO Tutorial Lesson 8 - Insert, update and delete records

MySQL PDO Tutorial Lesson 5 - FetchAll method

PHP For Beginners, Ep 17 - PDO First Steps

Connect To Database Using PDO In OOP PHP | Object Oriented PHP Tutorial | PHP Tutorial | mmtuts

Code Walkthrough: PHP, MySQL, and PDO - Part 1

PDO | PHP | MySQL | Connection #000 | BEGINNERS GUIDE #php #pdo #mysql

Introduction to PHP Data Objects (PDO)

PDO Tutorial [1080p] (Part 1 of 5) - Setting up a database

PDO Tutorial PHP MYSQL LIVE DEMO

How To MySQL - PDO from PHP - bindParam() vs bindValue() - Intro Tutorial - HD Video

PHP MySQL PDO tutorial for beginners | PHP MySQL Programming

Connecting to MySQL Database with PDO

PHP, MySQL, and PDO - Part 1

Creating a table with PDO

PHP for Beginners: PDO, MySQL, phpMyAdmin - Lesson 1

MySQL PDO Tutorial Lesson 2 - Error catching