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 vote186 views1 answer
Can i back up mysql database from php code?
PHP
1 vote196 views1 answer
How get just one parameter of all objects in one array in laravel
PHP
0 vote183 views2 answers
Php convert dbf to mysql
PHP
-1 vote206 views1 answer
Connect an if statement to an input php
PHP
1 vote183 views3 answers
Php string to char array
PHP
2 votes186 views1 answer
Php array map cast to int
PHP
8 votes202 views2 answers
Eloquent firstOrCreate
PHP
5 votes218 views3 answers
Laravel blade for if
PHP
1 vote188 views1 answer
Shoulder blade technical name
PHP
0 vote211 views2 answers
Create model controller migration factory laravel in one command
PHP Laravel