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 vote171 views2 answers
Get wordpress page link by id
PHP Wordpress
16 votes271 views4 answers
Laravel auth helper function
PHP Laravel
0 vote301 views1 answer
How to use attempt in laravel
PHP Laravel
1 vote215 views2 answers
Fetch body show in php code
PHP
0 vote190 views1 answer
Laravel csrf token or protection or laravel form
PHP Laravel
1 vote156 views1 answer
Add 2 hours to current time in cakephp
PHP
0 vote160 views1 answer
Add class to row laravel
PHP
2 votes155 views2 answers
Sort a multidimensional array by date element in php
PHP
0 vote163 views1 answer
Php getgmail name
PHP
8 votes182 views1 answer
Laravel validation string type
PHP Laravel