/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

3 votes213 views1 answer
Php extensions for laravel
PHP Laravel
3 votes234 views4 answers
Delete multiple row by model in laravel
PHP
0 vote189 views1 answer
Date format in wordpress post
PHP
7 votes171 views4 answers
Max_execution_time php
PHP
-1 vote273 views1 answer
Element cakephp
PHP CakePHP
0 vote219 views1 answer
Laravel stack script
PHP Laravel
0 vote175 views1 answer
Old function use in checkbox selected in laravel blade
PHP
15 votes226 views2 answers
Update column value laravel
PHP Laravel
0 vote189 views2 answers
Laravel collection intersect
PHP Laravel
-1 vote184 views4 answers
Laravel collection find
PHP Laravel