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 vote333 views1 answer
Contact us page mail prestashop
PHP
0 vote344 views1 answer
Add controller to laravel with requests
PHP
17 votes338 views2 answers
Find type in php
PHP
0 vote382 views1 answer
Laravel repository update multiple row
PHP Laravel
1 vote391 views1 answer
Laravel validateexception no error description
PHP Laravel
3 votes320 views2 answers
Php get string before character
PHP
9 votes342 views1 answer
A facade root has not been set phpunit
PHP
18 votes315 views5 answers
If statement in laravel blade
PHP
4 votes365 views1 answer
Types of method in api
PHP
4 votes328 views2 answers
What sign is less than or equal to php
PHP