PHP MySQL Select Query
PHP mysqli_query function
The mysqli_query function is used to execute SQL queries.
The function can be used to execute the following query types;
- Insert
- Select
- Update
- delete
There are two other MySQLi functions used in select query.
- mysqli_num_rows(mysqli_result $result): returns number of rows.
- mysqli_fetch_assoc(mysqli_result $result): returns row as an associative array. Each key of the array represents the column name of the table. It return NULL if there are no more rows.