Converting mysqli to PDO?

LillianRoot — Mon, 08 Mar 2021 09:12:59 GMT

I've been out of the coding scene for about 10 years and I'm trying to catch back up. Much of what I learned has been deprecated or full-out removed and now there's so much emphasis on security (which there should be), but I'm used to the old mysql_query.

I started making everything as mysqli_query because that's what I was reading about, but recently I've reading a lot about PDO and that it's more secure and less typing. To be honest, it looks exactly the same as mysqli to me, but that's just a cursory glance.

Anyway, enough chattering, my main reason for this is that I'm a little confused on how to do PDO. Some examples that I have are:

$stmt = mysqli_prepare($conn, $sql)

That one is easy because it just turns into:

$stmt = $pdo->prepare($conn, $sql)

Right?

So how about replacing things like mysqli_stmt_bind_param or mysqli_stmt_execute?

I'm not asking for anybody to do it for me, but I guess the better question is... does anybody know a good place to learn how to convert mysqli to PDO? Or I guess maybe to learn PDO?

topic Converting mysqli to PDO? in Integration and Testing

Converting mysqli to PDO?