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

11 votes315 views4 answers
Redirect back with input laravel in request
PHP Laravel
2 votes260 views1 answer
Php reverse shell oneliner
PHP
0 vote278 views1 answer
Default php email prot
PHP
0 vote291 views1 answer
Laravel move file from local to s3
PHP
0 vote323 views1 answer
Remove controller cache laravel
PHP Laravel
0 vote496 views1 answer
Unique string faker laravel
PHP
0 vote300 views3 answers
Type declaration php
PHP
61 votes328 views6 answers
Php rand int
PHP
0 vote279 views1 answer
Send data to api php
PHP
0 vote268 views1 answer
How to get event dates on change in datetimepicker with laravel livewire
PHP Laravel