Mysqli real escape string php

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = mysqli_connect("localhost", "my_user", "my_password", "world");

$city = "'s-Hertogenbosch";

/* this query with escaped $city will work */
$query = sprintf("SELECT CountryCode FROM City WHERE name='%s'",
    mysqli_real_escape_string($mysqli, $city));
$resu = mysqli_query($mysqli, $query);
printf("Select returned %d rows.\n", mysqli_num_rows($result));

/* this query will fail, because we didn't escape $city */
$query = sprintf("SELECT CountryCode FROM City WHERE name='%s'", $city);
$result = mysqli_query($mysqli, $query);

Source: php.net

Php var_export to string

$someString = var_export($anyVariable, true);

Similar codes

0 vote74 views1 answer
Fatal error: cannot redeclare
PHP
3 votes120 views2 answers
Laravel .htaccess settings
PHP Laravel
0 vote129 views1 answer
Show images laravel 8 showJobImage($filename)
PHP Laravel
10 votes111 views6 answers
Laravel new project
PHP
1 vote123 views1 answer
Php http_build_query
PHP
0 vote108 views1 answer
How to get post by comment in laravel
PHP
5 votes112 views1 answer
Check if user is on mobile php
PHP
0 vote211 views1 answer
How to use “find_in_set” in cakephp 3 find method
PHP CakePHP
0 vote114 views1 answer
Laravel carbon Could not parse '28/09/2021, 12:00:00 pm': DateTime::__construct(): Failed to parse time string (28/09/2021, 12:00:00 pm) at position 0 (2): Unexpected character
PHP
1 vote162 views2 answers
Faker image laravel 8
PHP Laravel