mysql or mysqli is best?

thanks for that data friend and very nice job on the last one! A+ ??

You are welcome alvaw and thanks for the A+.

Doesn’t matter how you called it, Mysql remains Mysql… If you know what I mean. ??
There are however three extensions, that let php utilize the mysql features.
Namely:
1. mysql_* extension – which is the first, the worst, and official deprecated.
2. mysqli_* extension – which means ‘improved’ version. kk
3. And, mysql odbc – this is the best driver / extension, and I strongly encourage using it.
If I’m not mistaken the latest wp only supports odbc version, so if it gets successfully installed on your system you should worry about nothing.

Xarran BS – You did not mention the PDO extension.

https://jp2.php.net/manual/en/ref.pdo-mysql.php

Personally for all my databasing I use the MySQLi database connection, because I am only developing with MySQL databases. However if there is a chance you may be using multiple different DBMS, the PDO extension is most likely the best bet for you.

PDO_ODBC is a driver that implements the PHP Data Objects (PDO) interface…

So it’s the same thing I guess? isn’t it?

Well, I am not sure.

I have not used the ODBC driver – I assume that allows you to connect to many different DBMS?

There is a PDO_MYSQL, however I think the main difference is that it looks like PDO is specifically re-written for each DBMS – I will look into this soon and confirm this… And that PDO is object-oriented. Is the ODBC extension procedural or object-oriented?

And that PDO is object-oriented. Is the ODBC extension procedural or object-oriented?

PDO is object oriented, ODBC extension is procedural (As far I can recall).

By the way, I found a good DBMS comparison table – https://troels.arvin.dk/db/rdbms/

I will test with MySQL.