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

3 votes229 views2 answers
Php remove all parameter from url
PHP
26 votes215 views6 answers
Drop foreign key laravel
PHP
2 votes216 views1 answer
Laravel mix purge css
PHP
0 vote241 views1 answer
Codeigniter 4 radio button isset
PHP CodeIgniter
1 vote205 views2 answers
Laravel get url parameter value in controller
PHP
1 vote215 views2 answers
Install php unzip
PHP
2 votes208 views3 answers
Laravel migration drop foreign keys
PHP
0 vote228 views1 answer
Php pdo error 500
PHP
14 votes239 views5 answers
Php artisan migrate reset
PHP
2 votes211 views2 answers
How to store file in public folder laravel
PHP