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

6 votes115 views2 answers
Custom autoload without composer
PHP
0 vote179 views1 answer
Drupal 8 entity_view
PHP
6 votes138 views4 answers
Session has laravel blade
PHP
22 votes156 views4 answers
Laravel orWhere
PHP Laravel
1 vote170 views2 answers
Laravel eloquent join two models
PHP
8 votes163 views6 answers
Laravel new project
PHP Laravel
1 vote133 views1 answer
What is app_env in laravel
PHP
0 vote163 views10 answers
Laravel sanctum
PHP Laravel
0 vote145 views1 answer
Laravel collection forget
PHP
4 votes136 views3 answers
Wp+get feature image
PHP