Database Connections

Question 0

mysql::$client_info

string $mysqli->client_info;

Answer 0

Returns a string that represents the MySQL client library version.

Question 1

mysqli::$affected_rows

OOP Style
int $mysqli->affected_rows;

Answer 1

Returns the number of rows affected by the last INSERT, UPDATE, REPLACE, or DELETE query.

For SELECT statements mysqli_affected_rows() works like mysqli_num_rows()

Question 2

mysqli::$client_version

int $mysqli->client_version;

Answer 2

Returns client version number as an integer.

Question 3

mysqli::$connect_errno

string $mysqli->connect_errno;

Answer 3

Returns the last error code number from the last call to mysqli_connect();

Question 4

mysqli::$connect_error

string $mysqli->connect_error;

Answer 4

Returns the last error message string from the last call to mysqli_connect();

Question 5

mysqli::$errno

int $mysqli->errno;

Answer 5

Returns the last error code for the most recent MySQLi function call that can succeed or fail.

Question 6

mysqli::$error_list

array $mysqli->error_list;

Answer 6

Returns an array of errors for the most recent MySQLi function call that can succeed or fail.

Question 7

mysqli::$error

string $mysql->error;

Answer 7

Returns the last error message for the most recent MySQLi function call that can succeed or fail.

Question 8

mysqli::$field_count

int $mysqli->field_count;

Answer 8

Returns number of columns for the most recent query on the connection represented by the “link” parameter. This function can be useful when using the mysqli_store_result() function to determine if the query should have produced a non-empty result set or not without knowing the nature of the query;

Question 9

mysql::$host_info

string $mysqli->host_info;

Answer 9

Returns a string describing the connection represented by the “link” parameter (including the server host name).

Question 10

mysqli::$protocol_version

string $mysqli->protocol_version;

Answer 10

Returns an integer representing the MySQLi protocol version used by the connection represented by the “link” parameter.

Question 11

mysqli::$server_info

string $mysqli->server_info;

Answer 11

Returns a string representing the version of the MySQL server that the MySQLi extension is connected to.

Question 12

mysqli_version

int $mysqli->server_version

Answer 12

Returns the version of the server connected to (represented by the “link” parameter) as an integer.

Question 13

mysqli::$info

string $mysqli->info;

Answer 13

Returns a string providing information about the last query executed.

Question 14

mysqli::$insert_id

mixed $mysqli->insert_id;

Answer 14

Returns the ID generated by a query on a table with a column having the AUTO_INCREMENT attribute. If the Kat query wasn’t an INSERT or UPDATE statement or if the modified table does not have a column with the AUTO_INCREMENT attribute, this function will return zero.

Question 15

mysqli::$sqlstate

string $mysqli->sqlstate;

Answer 15

Returns a string containing the SQLSTATE error code for the last error. The error code consists of five characters. ‘00000’ means no error

Question 16

mysqli::$thread_id

int $mysqli->thread_id;

Answer 16

Returns the thread ID for the current connection which can then be killed using the mysqli_kill() function.
If the connection is lost and you reconnect with mysql_ping(), the thread ID will be other. Therefore you should get the thread ID only when you need it.

Question 17

mysqli::$warning_count

int $mysqli->warning_count;

Answer 17

Returns the number of warnings from the last query in the connection.