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 vote105 views1 answer
Codeigniter sms send
PHP
-1 vote104 views1 answer
How to upgrade php in mac mojave
PHP
41 votes102 views6 answers
Time in php
PHP
1 vote63 views1 answer
Php if string is already in database
PHP
-1 vote106 views1 answer
Clear Caching of Queries Laravel Specific Model Cache
PHP
8 votes177 views4 answers
Codeigniter 4 redirect to home
PHP CodeIgniter
0 vote149 views1 answer
How to fetch associate data from csv in php
PHP
0 vote87 views1 answer
Laravel foreach localstorage
PHP Laravel
34 votes106 views6 answers
Format date in php
PHP
33 votes113 views4 answers
Php ucwords
PHP