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 votes225 views1 answer
Ian holm
PHP
1 vote213 views2 answers
Php strtotime plus 1 day
PHP
0 vote236 views2 answers
PHP Fatal error: Uncaught Error: Class 'IntlDateFormatter' not found in /var/www/html/test/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:121
PHP
0 vote252 views1 answer
Php utc time
PHP
2 votes217 views1 answer
Laravel asset
PHP
0 vote224 views1 answer
Laravel htaccess for aws ec2
PHP Laravel
0 vote242 views1 answer
Laravel - Comparison betweeon two column values - whereColumn
PHP Laravel
0 vote232 views1 answer
Die laravel
PHP
1 vote240 views1 answer
Laravel plural and singular
PHP Laravel
2 votes249 views2 answers
Laravel migration add unique column
PHP