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

4 votes131 views2 answers
Php http authentication
PHP
12 votes139 views4 answers
If request method post php
PHP
0 vote161 views1 answer
Add selected to dropdpown item laravel
PHP Laravel
0 vote141 views1 answer
Composer require laravelcollection
PHP
8 votes123 views2 answers
Eloquent where date between
PHP
1 vote167 views1 answer
Laravel sprintf span in controller
PHP Laravel
17 votes122 views6 answers
Php migrate
PHP
65 votes233 views6 answers
Datetime php
PHP
37 votes148 views4 answers
Laravel migration add column first
PHP
0 vote132 views1 answer
Pregmatch php only numbers and comma and dot
PHP