Chapter 15 - MySQL Integration

Question 1

Function to connect to MySQL database

Answer 1

mysql_connect()

Question 2

Function to select MySQL database

Answer 2

mysql_select_db()

Question 3

Arguments of mysql_select_db()

Answer 3

database name, link identifier

Question 4

mysql_pconnect()

Answer 4

Opens a persistent connection

Question 5

mysql_change_user()

Answer 5

Changes the user logged in

Question 6

mysql_list_dbs()

Answer 6

lists databases

Question 7

mysql_list_tables()

Answer 7

Lists tables

Question 8

mysql_fetch_…()

Answer 8

assoc = one result row as an associative array, row= one result row as a numerically indexed array

Question 9

mysql_affected_rows()

Answer 9

returns the number of rows affected by the query

Question 10

mysql_num_row()

Answer 10

Returns number of rows

Question 11

mysql_fetch_object()

Answer 11

Returns result row as object

Question 12

mysql_fetch_field()

Answer 12

gets column information from a result and returns it as an object

Question 13

mysql_field_name()

Answer 13

Gets the name of a specified field

Question 14

mysql_list_fields() or mysql_field_seek()

Answer 14

Sets result pointer to a specified field offset

Question 15

mysql_num_fields()

Answer 15

gets the number of fields in a result

Question 16

mysql_field_type()

Answer 16

Gets the data type of specified field

Question 17

mysql_field_len()

Answer 17

Returns the length of a field

Question 18

mysql_field_table()

Answer 18

Gets the name of the table that a specific field is in

Question 19

mysql_errno()

Answer 19

Returns the numerical value of error message