/PHP/How can I prevent SQL injection in PHP?

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

5 votes102 views2 answers
Laravel chmod
PHP
4 votes120 views4 answers
Get file size in php
PHP
0 vote109 views1 answer
Post type taxonomy loop wordpress
PHP
2 votes90 views3 answers
Php collection to array
PHP
0 vote132 views1 answer
Laravel get fillable attributes
PHP Laravel
2 votes112 views1 answer
WhereNull in laravel
PHP Laravel
0 vote92 views1 answer
Laravel load models by id array
PHP
0 vote103 views1 answer
Display picture in pdf generated with laravel
PHP
3 votes95 views1 answer
Array and string offset access syntax with curly braces is deprecated
PHP
0 vote122 views1 answer
Laravel array to string error
PHP