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 vote174 views2 answers
Laravel notification database
PHP
0 vote174 views1 answer
Laravel redis sentinel
PHP
0 vote248 views1 answer
Php adding options from an array
PHP
-1 vote279 views1 answer
Carbon last day of month in timestamp
PHP
7 votes172 views5 answers
Connect sql server php
PHP
0 vote242 views1 answer
Php pdo prepare doesn't work
PHP
21 votes225 views5 answers
Laravel 7 auth command
PHP Laravel
9 votes212 views1 answer
Npm run dev error laravel 8
PHP Laravel
0 vote163 views1 answer
Laravel eloquent save method return value
PHP
-4 votes242 views1 answer
Apache/2.4.52 (win64) openssl/1.1.1m php/8.1.2 server at localhost port 80
PHP