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 […]
Author Archives: user
MySQLi – Quick Guide MySQLi – Introduction MySQLi is an extension to MySQL API available in PHP and is introduced from PHP 5.0 onwards. It is also known as MySQL improved extension. Motivation behind MySQLi was to take advantage of new features available in MySQL 4.1.3 onwards. It provides numerous benefits over MySQL extension. MySQL […]
MySQLi – Handling Duplicates Tables or result sets sometimes contain duplicate records. Sometimes, it is allowed but sometimes it is required to stop duplicate records. Sometimes, it is required to identify duplicate records and remove them from the table. This chapter will describe how to prevent duplicate records occurring in a table and how to […]