MySQLi – Useful Functions Here is the list of all important MySQLi functions. Each function has been explained along with suitable example. − It used to get the information about number of affected rows in a previous MySQL operation − It used to turn on or off auto-committing database modifications operation − It used to […]
Category Archives: mysqli
MySQLi – Sorting Results We have seen the SQL SELECT command to fetch data from a MySQL table. When you select rows, the MySQL server is free to return them in any order, unless you instruct it otherwise by saying how to sort the result. But, you sort a result set by adding an ORDER […]
MySQLi – Handling NULL Values We have seen the SQL SELECT command along with the WHERE clause to fetch data from a MySQL table, but when we try to give a condition, which compares the field or the column value to NULL, it does not work properly. To handle such a situation, MySQL provides three […]