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

2 votes80 views2 answers
Php preg_replace
PHP
0 vote109 views1 answer
How to change laravel logo image
PHP
1 vote117 views2 answers
How to pass parameter in routes of laravel
PHP
21 votes125 views3 answers
Php array remove keys keep values
PHP
0 vote114 views1 answer
How to give dynamic value in onlick in php
PHP
0 vote146 views2 answers
Loop variable in laravel
PHP Laravel
0 vote160 views1 answer
Message"Class 'Input' not found"
PHP
0 vote115 views1 answer
Auto submit button php
PHP
49 votes125 views6 answers
Laravel migrate seed
PHP
4 votes135 views2 answers
Laravel reduce
PHP Laravel