Top "Mysqli" questions

Bind Param with array of parameters

I have a function that does this: function registerUser($firstName, $lastName, $address, $postcode, $email, $password) { $params = array($firstName, $lastName, $address, $…

php mysqli bind

mysqli_fetch_assoc() expects parameter / Call to a member function bind_param() errors. How to get the actual mysql error and fix it?

In my local/development environment, the MySQLi query is performing OK. However, when I upload it on my web host …

php mysqli prepared-statement environment error-reporting

Why is mysqli_insert_id() always returning 0?

I have the following code. The mysqli_insert_id() (in this case "$last_row"), which is supposed to return the …

php mysqli

Global Variable - database connection?

I am trying to connect to a database (MySQLi) just once, but am having problems doing so. How do I …

php class mysqli global connect

Pass by reference problem with PHP 5.3.1

Ok, this is a weird problem, so please bear with me as I explain. We upgraded our dev servers from …

reference mysqli php

PHP Commands Out of Sync error

I am using two prepared statements in PHP/MySQLi to retrieve data from a mysql database. However, when I run …

php mysql mysqli

using nulls in a mysqli prepared statement

In a mysqli prepared statement, a NULL gets turned into '' (in the case of a string) or 0 (in the …

php mysql null mysqli prepared-statement

Retrieving Multiple Result sets with stored procedure in php/mysqli

I have a stored procedure that has multiple result sets. How do I advance to the 2nd result set in …

php stored-procedures mysqli resultset

Mysqli Prepare Statement - Returning False, but Why?

I have a function that generates a prepared INSERT statement based on an associative array of column names and values …

php mysqli prepared-statement

PHP PDO and MySQLi

I just finished an introduction course in PHP, and throughout the stackoverflow forum people have recommended that I switch to …

php mysql pdo mysqli