Can I mix MySQL APIs in PHP?
No, you can't use mysql
and mysqli
together. They are separate APIs and the resources they create are incompatible with one another.
There is a mysqli_close
, though.
Just to give a general answer here about all three MYSQL API's with a reference:
You can't mix any of the three (mysql_*
, mysqli_*
, PDO
) MYSQL API's from PHP together, it just doesn't work. It's even in the manual FAQ:
It is not possible to mix the extensions. So, for example, passing a mysqli connection to PDO_MySQL or ext/mysql will not work.
You need to use the same MySQL API and its related functions, from connection to querying.
- http://php.net/manual/en/mysqlinfo.api.choosing.php