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 vote120 views2 answers
Pluck only category name and id from model in laravel
PHP
13 votes157 views6 answers
Php new line
PHP
1 vote186 views2 answers
Is home page if wordpress
PHP Wordpress
1 vote191 views1 answer
Laravel multiple orderby
PHP Laravel
0 vote189 views1 answer
Check for headers laravel
PHP Laravel
20 votes165 views3 answers
Ucfirst meaning in php
PHP
13 votes156 views5 answers
Remove empty array elements php
PHP
20 votes174 views6 answers
Sha256 in php
PHP
0 vote166 views10 answers
Laravel sanctum
PHP
0 vote214 views1 answer
How to perform form inpot in laravel 8 and export database
PHP Laravel