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 vote350 views1 answer
Laravel password require one letter and one number
PHP Laravel
0 vote308 views4 answers
There is no extension able to load the configuration for "_translation_webui"
PHP
0 vote335 views1 answer
Total days between two dates carbon
PHP
0 vote370 views4 answers
Get_adjacent_post wordpress
PHP Wordpress
1 vote333 views1 answer
Mysqli_query insert in laravel
PHP
2 votes304 views1 answer
Laravel model string primary key
PHP
1 vote313 views2 answers
Php curl add user agent
PHP
44 votes433 views2 answers
Laravel version command
PHP Laravel
0 vote291 views1 answer
<warning>PHP Warning: preg_grep() expects parameter 2 to be array, string given in G:\Office Projects\Luggage Backend\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Concerns \Guards Attributes.php on line 207</warning>
PHP
0 vote317 views1 answer
Laravel redirect to previous page
PHP