I am starting to develop a page using PHP and, as I am still learning the language, I decided to find which module to use to connect to a MySQL database.
From this answer , I discovered that the mysql_*
module has already been deprecated and contains several security issues . In the same answer it indicates the use of the mysqli_ * and the PDO , as I was in doubt was to compare the differences between the two .
This has made me even more confused because mysqli_*
seems to offer much more support than PDO
, however only PDO
supports client-side prepared statements
.
My question is what is the difference between server-side and client-side prepared statements? When to use one and when to use the other?