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 vote298 views1 answer
Laravel update all relations
PHP
0 vote293 views1 answer
Php season calculation
PHP
0 vote246 views1 answer
"message": "Call to a member function canNot() on null", "exception": "Symfony\\Component\\Debug\\Exception\\FatalThrowableError",
PHP
102 votes348 views6 answers
Push element in array php
PHP
4 votes323 views1 answer
Pakistan time zone
PHP
0 vote295 views3 answers
Laravel public ParseError syntax error, unexpected '$conversion' (T_VARIABLE), expecting ',' or ')' /
PHP
0 vote278 views1 answer
Propel find index
PHP
0 vote283 views1 answer
Access config variable in codeigniter controller
PHP
-2 votes288 views1 answer
Laravel model bind with route in model
PHP
7 votes302 views1 answer
Laravel auth user_id
PHP Laravel