MCQs
An example of this- #include 'mysql.connect.php';//begin database selection and queries.?>
Its prototype looks like-class mysqli{mixed query(string query [, int resultmode])}
The method num_rows() is only useful for determining the number of rows retrieved by a SELECT query. But to retrieve the number of rows affected by INSERT, UPDATE, or DELETE query, use affected_rows().
Their prototype is as follows- calss mysqli_result{mixed fetch_array ([int resulttype])}calss mysqli_result{mixed fetch_row()}
Once this method is executed, the result set is no longer available.
MySQL
PHP required that MySQL client library be installed on the server from which PHP was communicating with MySQL, whether the MySQL server also happened to reside locally or elsewhere. PHP 5.3 removes this problem by introducing MySQL Native Driver.
CREATE TABLE table_name (column_name column_type);
The updated MySQL extension with PHP 5 is known as MySQL and typically referred to as mysqli.
Also make sure that extension_dir directive points to the appropriate directory.