Search Results
If the query contains any variable input then parameterized prepared statements should be used instead. Alternatively, the data must be properly formatted and all strings must be escaped using the mysqli_real_escape_string () function. In order to determine if a given query should return a result set or not, see mysqli_field_count ().
Definition and Usage The real_query () / mysqli_real_query () function executes a single SQL query. The result can be retrieved or stored with the store_result () or use_result () functions.
The MySQLi::real_query () method is a powerful tool when you need to execute raw SQL queries in PHP, especially for handling large datasets without memory issues.
The mysqli_real_query () function accepts a string value representing a query as one of the parameters and, executes/performs the given query on the database. The data passed in the query should be properly escaped.
The mysqli_real_query () function is used to execute only a query against the database represented by the link whose result can then be retrieved or stored using the mysqli_store_result () or mysqli_use_result () functions. Note: In order to determine if a given query should return a result set or not, see mysqli_field_count () .
Alternativement, les données doivent être correctement formatées et toutes les chaînes de caractères doivent être échappées en utilisant la fonction mysqli_real_escape_string (). Pour déterminer si une requête donnée aurait dû retourner un jeu de résultats ou non, voyez la fonction mysqli_field_count ().
The mysqli_real_query() function is a built-in function in PHP that is used to execute an SQL query on a MySQL database. This function is similar to the mysqli_query() function, but it has a few key differences. Unlike the mysqli_query() function, the mysqli_real_query() function does not automatically retrieve the result set of the query.
