What is the best and latest way to make connection to your database in PHP?

Question

I am learning PHP and I have seen different ways of making connection to your MySQL database. Which method is the best and acceptable on php 7?

Answer 1

You can use mysqli or pdo, but you have to know mysqli only works for mysql databases, however pdo works on 12 different database systems. Both are object oriented, but mysqli also offers a procedural option. And both support prepared statements to avoid sql injections. However i personally prefer pdo.

Answer 2

Mysql is still useful, but I've heard and read articles saying PDO is faster and safer.

even thinking of starting writing game all over again using php 7 and PDO. Was using before php 5.2+ & mysql.

Answer 3

both mysqli and pdo...but, mysqli's syntax is easier!

Answer 4

PDO is a good method
or a ORM like Doctrine

Answer 5

mysql is deprecated now use mysqli or pdo (preferred).

Answer 6

up

Answer 7

PDO is considered the latest and the greatest. If you want to use MySQL, be my guest but PDO is better.

Answer 8

as far as I think.. MySQL is still a good choice

Answer 9

both MySQLi and pdo
but pdo can connect 12 languages at a time.

Answer 10

10 language connect QCP driver with draw ling segment error mine... but nice performance..

Answer 11

my sql

Answer 12

hey help me too with this https://www.sololearn.com/Discuss/405725/?ref=app