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

80 votes194 views6 answers
Php explode
PHP
-1 vote213 views1 answer
Laravel edit form select don't repeat a selected value
PHP Laravel
0 vote210 views2 answers
Where () laravel Eloquent
PHP Laravel
0 vote209 views10 answers
Event handler with worker laravel
PHP Laravel
1 vote175 views1 answer
Php foreach associative array
PHP
0 vote205 views2 answers
Carbon Format date with timezone in views Laravel
PHP
0 vote175 views1 answer
Wc php retrieve the order Id on Order pay page
PHP
0 vote292 views1 answer
Drupal 9 how to pass arguments to custom blocks
PHP Drupal
3 votes204 views1 answer
Wordpress wp_head
PHP Wordpress
0 vote197 views5 answers
PHP detect spam name
PHP