MySQLi Procedural functions Cheat Sheet by Ajay Kumar B

Open a new connection to the MySQL server.

mysqli­_co­nne­ct(­hos­t,u­ser­nam­e,p­ass­wor­d,d­bna­me,­por­t,s­ocket);

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

Close a previously opened database connec­tion.

mysqli­_cl­ose­(co­nne­ction);

Returns TRUE on success. FALSE on failure.

Perform queries against the database.

mysqli­_qu­ery­(co­nne­cti­on,­que­ry,­res­ult­mode);

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.

mysqli­_se­lec­t_d­b(c­onn­ect­ion­,db­name);

Returns TRUE on success. FALSE on failure.

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

mysqli­_fe­tch­_ar­ray­(re­sul­t,r­esu­ltt­ype);

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.

mysqli­_fe­tch­_as­soc­(re­sult);

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.

mysqli­_nu­m_r­ows­(re­sult);

Returns the number of rows in the result set.

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

mysqli­_co­nne­ct_­err­or();

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.

mysqli­_er­ror­(co­nne­ction);

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.

mysqli­_fe­tch­_al­l(r­esu­lt,­res­ult­type);

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

Print out affected rows from different queries.

mysqli­_af­fec­ted­_ro­ws(­con­nec­tion);

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