/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

0 vote305 views1 answer
Laravel where has query
PHP Laravel
7 votes192 views3 answers
How to show validation error in laravel blade
PHP
0 vote296 views1 answer
Laravel redis sentinel
PHP Laravel
18 votes194 views4 answers
God
PHP
0 vote242 views1 answer
Laravel datepicker date format
PHP
0 vote217 views2 answers
Iframe site bi link laravel
PHP
8 votes146 views1 answer
How to make laravel eloquent "not in" query?
PHP
7 votes194 views3 answers
Php info file
PHP
1 vote185 views2 answers
Wordpress get option value
PHP
1 vote214 views1 answer
Enable extensions in php.ini
PHP