As a beginner MYSQL, MYSQLi, PDO. What the best choice .

Hi Claudio,

The difference between MySQL and MySQLI is the version. In the future MySQL functions will be deprecated which means that it will no longer be supported in nearby versions. SQL will still stay SQL, only the functions get an extra i in its code.

My personal experience is to use Procedural PHP, which is much easier to get into and much easier to understand and get the hand of it than Objected Oriented & PDO, but give it a shot and see which suits you best.

for example if you try to make a query with Procedural all you have to do is give 2 variables along with the function which takes them as parameter. Where in parameter 1 should be the connection variable, either included in the file or written in the file itself, and the variable which contains the query

f.e: $query = "SELECT * FROM phpdatabase"; $result = mysqli_query($conn, $query);

mysql - no, as it is deprecating. mysqli - is what, what I would recommend, as you have mentioned, you are a newbie PDO - is what, you have to ultimately aim for.