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

0 vote224 views1 answer
Install php 5.5.9 ubuntu 18.04
PHP
0 vote262 views1 answer
How to clear post array on referesh + not refill when return
PHP
0 vote261 views1 answer
Php slim inspect request method
PHP
7 votes244 views3 answers
Wordpress get date of post
PHP
0 vote332 views1 answer
Comment supprimer le fil d’Ariane WooCommerce dans WordPress
PHP
0 vote299 views1 answer
Multidimensional session-array
PHP
0 vote260 views1 answer
Php get myme type of image
PHP
0 vote243 views1 answer
If(!empty($_POST['full_name'])){ echo("Hello " . $_POST['full_name']); }
PHP
6 votes346 views6 answers
Laravel get current route name
PHP Laravel
0 vote269 views1 answer
Copy folder contect to anthor folder php
PHP