Accessing Databases with Object-Oriented PHP

#777
Год выпуска: 2014
Производитель: lynda.com
Страница курса
Автор: David Powers
Продолжительность: 3ч 47мин
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание:
Now that PHP has true object-oriented capabilities, it's best practice to access databases using PDO (PHP Data Objects) and MySQLi. These methods produce database-neutral code that works with over a dozen systems, including MySQL, SQL Server, PostgreSQL, and SQLite. Learn how to use PDO and MySQLi to perform basic select, insert, update, and delete operations; improve security with prepared statements; and use transactions to execute multiple queries simultaneously. Author David Powers also covers advanced topics like instantiating custom objects, and compares PDO to MySQLi so you can decide which method is right for you.

Topics include:
Connecting to a database with PDO or MySQLi
Fetching a result set
Executing simple non-SELECT queries
Sanitizing user input
Binding input and output values
Passing an array of values to the execute() method
Working with advanced PDO fetch methods
Executing a MySQLi transaction
Freeing resources that are no longer needed
Submitting multiple queries
Creating an instance of a class from a result set

Цитата:

Файлы примеров: присутствуют
Формат видео: MP4
Видео: MPEG4 Video (H264) 1280x720 15fps 492kbps
Аудио: AAC 44100Hz mono 128kbps

Скриншоты