MySql with PHP Basic MCQ

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.

Also make sure that extension_dir directive points to the appropriate directory.

MySQL

The updated MySQL extension with PHP 5 is known as MySQL and typically referred to as mysqli.

CREATE TABLE table_name (column_name column_type);

If you choose to interact with MySQL server using the object-oriented interface, you need to first instantiate the mysqli class via its constructor.

Empty String

Error numbers are often used in lieu of natural-language message to ease software internationalization efforts and allow for customization of error messages.

$mysqli->select_db(‘databasename’);

The mysqli extension includes a few features that can be used to capture error messages or alternatively you can use exceptions.

When the query() method is looped repeatedly it comes at a cost of both overhead, because of the need to repeatedly parsing of the almost identical query for validity, and coding convenience, because of the need to repeatedly reconfigure the query using the new values for each iteration. To help resolve the issues incurred by repeatedly executed queries, MySQL introduced prepared statements.

Once the statement has been prepared, it needs to be executed. Exactly when it’s executed depends upon whether you want to work with bound parameters or bound results. In the case of bound parameters, you’d execute the statement after the parameters have been bound with the bind_param() method.

Once you’ve finished using a prepared statement, the resources it requires can be recuperated with the close() method.

Its prototype follows:

Its prototype follows:

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- 

Once this method is executed, the result set is no longer available.

Its prototype looks like-

An example of this-