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

15 votes382 views4 answers
Laravel session flash 2020
PHP Laravel
0 vote318 views2 answers
Php undefined offset
PHP
0 vote352 views1 answer
Magento 2 get connection
PHP
2 votes463 views2 answers
How to make doctrine schema update in symfony 2.8
PHP Symfony
1 vote328 views1 answer
Php temp directory
PHP
0 vote394 views1 answer
Wordpress disable edit files
PHP Wordpress
0 vote357 views2 answers
Steps to create laravel project
PHP
0 vote341 views1 answer
Cake php 2.x joins
PHP
0 vote333 views2 answers
How to link a external modules using href in php
PHP
3 votes338 views1 answer
Php get uploaded file extension
PHP