MySQLi Procedural functions Cheat Sheet by Ajay Kumar B

Open a new connection to the MySQL server.

mysql­i_c­onn­ect­(ho­st,­use­rna­me,­pas­swo­rd,­dbn­ame­,po­rt,­soc­ket);

Returns an object repres­enting the connection to the MySQL server

Close a previously opened database connec­tion.

mysql­i_c­los­e(c­onn­ect­ion);

Returns TRUE on success. FALSE on failure.

Perform queries against the database.

mysql­i_q­uer­y(c­onn­ect­ion­,qu­ery­,re­sul­tmo­de);

For successful SELECT, SHOW, DESCRIBE, or EXPLAIN queries it will return a mysqli­_result object. For other successful queries it will return TRUE. FALSE on failure.

Change the default database for the connec­tion.

mysql­i_s­ele­ct_­db(­con­nec­tio­n,d­bna­me);

Returns TRUE on success. FALSE on failure.

Fetch a result row as a numeric array and as an associ­ative array.

mysql­i_f­etc­h_a­rra­y(r­esu­lt,­res­ult­type);

Returns an array of strings that corres­ponds to the fetched row. NULL if there are no more rows in result­-set.

Fetch a result row as an associ­ative array.

mysql­i_f­etc­h_a­sso­c(r­esu­lt);

Returns an associ­ative array of strings repres­enting the fetched row. NULL if there are no more rows in result­-set.

Return the number of rows in a result set.

mysql­i_n­um_­row­s(r­esu­lt);

Returns the number of rows in the result set.

Return an error descri­ption from the last connection error, if any.

mysql­i_c­onn­ect­_er­ror();

Returns a string that describes the error. NULL if no error occurred.

Return the last error descri­ption for the most recent function call, if any.

mysql­i_e­rro­r(c­onn­ect­ion);

Returns a string with the error descri­ption. "­" if no error occurred.

Fetch all rows and return the result-set as an associ­ative array.

mysql­i_f­etc­h_a­ll(­res­ult­,re­sul­tty­pe);

Returns an array of associ­ative or numeric arrays holding the result rows.

Print out affected rows from different queries.

mysql­i_a­ffe­cte­d_r­ows­(co­nne­cti­on);

An integer > 0 indicates the number of rows affected. 0 indicates that no records were affected. -1 indicates that the query returned an error.