What's SQL, MySQL, MySQLi, PDO?

  • 2 years ago
  • Database
  • By Salma Mehanny
  • 490 Visits

What's SQL, MySQL, MySQLi, PDO?

SQL Structured Query Lanaguage.

MYSQL :Database System sama as [MSSQL,Oracle], it is poplaur database connecting with PHP .

(DEPRECATED) The mysql functions are procedural and use manual escaping.
Mysql has extension to connect to db.

MySQLi is a replacement for the mysql functions, with object-oriented and procedural versions. It has support for prepared statements.

PDO (PHP Data Objects) : is a general database abstraction layer with support for MySQL among many other databases. It provides prepared statements, and significant flexibility in how data is returned.

RBDMS Relation Database Managment System