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

1 vote228 views1 answer
Php remove numbers from string
PHP
0 vote295 views1 answer
Can we use 2 select in a query laravel
PHP Laravel
0 vote262 views1 answer
Run php code file
PHP
4 votes287 views1 answer
Laravel validation numeric vs integer
PHP Laravel
0 vote297 views1 answer
Laravel db query log string replacements
PHP Laravel
0 vote238 views1 answer
Phph get server protocol
PHP
0 vote272 views2 answers
How to fix Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from `users` where `api_token laravel
PHP
0 vote274 views1 answer
Substr last 3 characters
PHP
0 vote313 views1 answer
Share link in facebook php
PHP
-1 vote245 views1 answer
Phpunit/phpunit[6.0.0, ..., 6.5.14] require php ^7.0 -> your php version (8.0.0) does not satisfy that requirement.
PHP