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

1 vote322 views1 answer
Laravel string builder
PHP
0 vote288 views1 answer
Woocommerce php products list div
PHP
0 vote284 views1 answer
Age date de naissance php
PHP
5 votes289 views2 answers
Php get string size
PHP
0 vote316 views1 answer
Bitnami lightsail PHP Fatal error: Out of memory (allocated
PHP
2 votes302 views1 answer
Check image is available on server php
PHP
0 vote305 views1 answer
.htaccess Preventing access to your PHP includes files
PHP
0 vote300 views1 answer
Laravel Facades\DB update
PHP
2 votes282 views6 answers
How to completely delete php
PHP
1 vote331 views1 answer
Insert data using model in laravel 8
PHP Laravel