/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

9 votes374 views3 answers
Laravel join 2 tables eloquent
PHP Laravel
1 vote333 views1 answer
How to use plugin shortcode in wordpress template
PHP
14 votes429 views5 answers
Wordpress get post thumbnail url
PHP Wordpress
0 vote346 views1 answer
Laravel delete controller still cached
PHP Laravel
0 vote313 views1 answer
Laravel eloquent return array where
PHP Laravel
1 vote387 views1 answer
I cannot login to my CPanel hosted Laravel Application, my SSL has expired
PHP Laravel
4 votes341 views2 answers
How to rename a table element in laravel
PHP Laravel
1 vote279 views1 answer
Remove gutenberg styles
PHP
1 vote284 views2 answers
Str_shuffle in php
PHP
0 vote293 views1 answer
Php conditionally remove element from array
PHP