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 vote136 views1 answer
Wc php order view order link
PHP
0 vote142 views1 answer
Get_transient wordpress
PHP
0 vote139 views2 answers
Solaris 11 php mysql
PHP
0 vote150 views1 answer
Tidak bisa install php7.3 di ubuntu 20.04
PHP
1 vote138 views1 answer
Difference betwen include and indlude once
PHP
12 votes220 views6 answers
Laravel relationship
PHP
0 vote156 views2 answers
Current url wordpress
PHP Wordpress
0 vote161 views1 answer
Laravel route match
PHP Laravel
1 vote151 views1 answer
StorePublicly laravel with name
PHP
1 vote106 views1 answer
Getoriginal laravel
PHP