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

12 votes400 views4 answers
Give custom field name in laravel form validation error message
PHP Laravel
0 vote395 views1 answer
Wordpress disable theme editor
PHP Wordpress
0 vote369 views2 answers
Laravel has one through relationship
PHP Laravel
2 votes321 views1 answer
Remove phpmyadmin ubuntu 20.04 completely
PHP
0 vote302 views1 answer
How to add a additional condition in a join using query builder laravel 5.3?
PHP
12 votes353 views4 answers
Laravel return redirect to named route
PHP Laravel
3 votes340 views2 answers
Strcmp php
PHP
0 vote362 views2 answers
Laravel event listener
PHP
8 votes305 views4 answers
Php console print
PHP
0 vote414 views1 answer
Dequeue recaptcha wordpress
PHP Wordpress