Top "Mysqli" questions

Fetching one row only with MySQLi

How can I only fetch one INDEXED row with MySQLi? I'm currently doing this: $row = $result->fetch(MYSQLI_ASSOC); $…

php mysqli

How to Check Whether mysqli connection is open before closing it

I am going to use mysqli_close($connection) to close the $connection. But Before Closing I need to ensure that …

php mysqli

MySQLi equivalent of mysql_result()?

I'm porting some old PHP code from mysql to MySQLi, and I've ran into a minor snag. Is there no …

php mysqli

mysqli last insert id

I would like to associate the image with firstname, lastname...how can I retrieve the last rowand use it to …

php mysql mysqli lastinsertid

php mysqli prepared statement LIKE

How can I with mysqli make a query with LIKE and get all results? This is my code but it …

php sql mysqli sql-like

How to start and end transaction in mysqli?

As far as I understood transaction starts once we call $mysqli->autocommit(FALSE); statement and ends after calling $mysqli-&…

php transactions mysqli

Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /private/tmp/wordpress/wp-includes/wp-db.php on line 1452

I'm trying to run PHPUnit to unittest a WordPress plugin, but the error in the title keeps showing up. I …

php mysql wordpress mysqli mysql-connect

PHP MySQLI Prevent SQL Injection

I've build a website that will be going live soon and just have a couple questions about preventing SQL injection, …

php mysql security mysqli code-injection

Fatal error: Call to undefined method mysqli_result::fetch_all()

I have problems with PHP in Ubuntu 10.04. When I try use mysqli_result::fetch_all this error appears: Call to …

php mysqli fetchall mysqlnd

mysqli - Do I really need to do $result->close(); & $mysqli->close();?

Just started using mysqli. If I'm working with small data sets on small websites (traffic-wise), do I really need to …

php mysql mysqli