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 vote338 views1 answer
Disable sidebar widget wordpress 5.8
PHP Wordpress
1 vote357 views1 answer
Insert php variable css
PHP
2 votes407 views1 answer
Wp_options siteURL new wordpress
PHP Wordpress
0 vote366 views1 answer
Laravel 8 template favicon
PHP Laravel
0 vote303 views1 answer
File viewer codeigniter
PHP
9 votes302 views1 answer
Php string to uppwe
PHP
1 vote275 views1 answer
Using middleware auth laravel in controller constructor
PHP
0 vote345 views1 answer
SET DEFAULT hide title astra wordpress
PHP Wordpress
0 vote298 views6 answers
Php email
PHP
22 votes293 views4 answers
While in php
PHP