Prevent SQL injection in PHP?

$str = "<script>alert('Hacked')</script>";
echo htmlentities($str);

How can I prevent SQL injection in PHP?

//Connect
$unsafe_variable = $_POST["user-input"];
$safe_variable = mysql_real_escape_string($unsafe_variable);

mysql_query("INSERT INTO table (column) VALUES ('" . $safe_variable . "')");
//Disconnect

Source: stackoverflow.com

Similar codes

0 vote231 views1 answer
Twig\Error\SyntaxError: Unknown "file_uri" function. Did you mean "file_url"?
PHP
1 vote283 views1 answer
How to catch query exception in laravel 8
PHP Laravel
3 votes294 views2 answers
Laravel migration remove nullable
PHP Laravel
2 votes257 views2 answers
Php strftime datetime
PHP
2 votes267 views3 answers
Laravel 8 404 status
PHP
7 votes259 views3 answers
Wordpress echo the date in post
PHP Wordpress
2 votes281 views1 answer
Laravel sluggable
PHP Laravel
0 vote252 views1 answer
Laravel 8 crud api example
PHP
0 vote248 views2 answers
Upload_max_filesize in wordpress
PHP
5 votes252 views5 answers
Laravel composer update
PHP