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 vote138 views1 answer
Laravel collection max
PHP Laravel
-2 votes118 views1 answer
Html to image php
PHP
0 vote117 views2 answers
How to remove duplicate values from an array in php
PHP
22 votes124 views6 answers
Php array_merge
PHP
0 vote75 views1 answer
Add field to migration laravel
PHP
0 vote106 views1 answer
Laravel routes options
PHP
0 vote99 views1 answer
Remove MainWP Child phpmyadmin
PHP
0 vote105 views1 answer
Foreach empty laravel
PHP
8 votes130 views4 answers
Wordpress enqueue if shortcode
PHP Wordpress
0 vote159 views1 answer
Drupal 9 remove field from view
PHP Drupal