Can i write prepared statements in procedural php?

Question

The example from the PHP manual is using OOP. Is there a way to do it procedurally?

Answer 1

MySQLi has procedural-style function calls that can handle prepared statements. (Some of the procedural-style functions are deprecated, however.)

http://us.php.net/manual/en/mysqli-stmt.prepare.php

Answer 2

Yes, you can. As far as I know PDO is completely object-oriented, but you may want to look into mysqli which allows both procedural and OO styles.

Procedural coders will find the basics almost identical. Where before you would used a function such as mysql_connect(), the new function is simply mysqli_connect(). Most of the old mysql_x functions have equivalent mysqli_x versions.

Source