mysqli_query
Performs a query against a MySQL database and returns a result set or boolean value.
Parameters
main.php
Return Values
mysqli_result|bool
Returns mysqli_result object for SELECT queries, boolean for others
On success:mysqli_result object for SELECT/SHOW/DESCRIBE/EXPLAIN, true for other successful queries
On failure:false on failure
Notes
- For queries with user input, use prepared statements instead
- MYSQLI_STORE_RESULT is default mode (buffered result set)
- MYSQLI_USE_RESULT creates unbuffered result set
- Connection must be established before calling this function
Changelog
- 8.1.0: result_mode parameter added
Related Functions
array_column
ArrayReturns the values from a single column in a multi-dimensional array or array of objects.
extractcolumndatabase