DEV Community

Salma
Salma

Posted on

2

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

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more