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 vote182 views1 answer
Wordpress check shortcode exists
PHP Wordpress
1 vote175 views1 answer
Php time ago
PHP
0 vote245 views5 answers
Laravel create multiple models at once
PHP Laravel
4 votes191 views2 answers
Laravel eloquent get data without duplicates
PHP Laravel
16 votes170 views6 answers
Php write file
PHP
8 votes250 views4 answers
Codeigniter 4 redirect to home
PHP CodeIgniter
11 votes179 views6 answers
Redirect route with parameters laravel
PHP
0 vote180 views1 answer
Convert byte to megabyte php
PHP
21 votes154 views6 answers
Php sort array by value
PHP
23 votes198 views4 answers
Laravel carbon isoformat
PHP Laravel