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 vote341 views1 answer
Wordpress max post revision
PHP
0 vote338 views2 answers
Bigtext migration laravel
PHP Laravel
3 votes363 views5 answers
Php loop object
PHP
0 vote325 views1 answer
Mysql Cannot pass parameter 2 by reference
PHP
0 vote331 views1 answer
Menampilkan hari dan tanggal sekarang di php
PHP
0 vote325 views1 answer
Laravel override eloquent all function
PHP
0 vote380 views8 answers
Syntax error, unexpected token "}", expecting "," or ";" php
PHP
0 vote444 views1 answer
Laravel creating event get data
PHP Laravel
7 votes342 views3 answers
Php array flip
PHP
0 vote466 views1 answer
Wp query meta in array
PHP Wordpress