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

30 votes250 views6 answers
Php loop array
PHP
1 vote300 views3 answers
Jump to line phpstorm
PHP
0 vote259 views1 answer
$query->free_result();
PHP
4 votes279 views1 answer
Php is string
PHP
18 votes303 views4 answers
Protected table laravel
PHP
1 vote284 views1 answer
Php kril to eng
PHP
7 votes267 views6 answers
Laravel loop index
PHP
0 vote305 views1 answer
How to add javascript to a php variable
PHP
19 votes244 views3 answers
Root composer.json requires php ^7.2.5 but your php version (8.0.3) does not satisfy that require
PHP
0 vote243 views1 answer
How t hide php extension in youur browser
PHP