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

8 votes139 views4 answers
Join multiple tables in laravel eloquent
PHP
0 vote151 views1 answer
Php rounded to the nearest degree time with ms calculator
PHP
9 votes203 views4 answers
Composer require laravel/ui laravel 7
PHP Laravel
0 vote164 views1 answer
Return view('user.profile', ['User' => UserController3::fineOrFail($id)]);
PHP
0 vote114 views1 answer
Upper php
PHP
4 votes215 views6 answers
Create middleware laravel
PHP
0 vote199 views2 answers
Laravel join query sum example
PHP
0 vote167 views1 answer
Password change logout from wordpress
PHP Wordpress
22 votes135 views9 answers
Php convert string to date
PHP
0 vote155 views1 answer
How check the checkbox is check php
PHP