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 vote204 views1 answer
Target class [BannerController] does not exist.
PHP
0 vote171 views1 answer
Laravel import xml to database
PHP
103 votes270 views6 answers
Array_push php
PHP
0 vote198 views1 answer
Alter mysql 8 user root phpmyadmin first install
PHP
1 vote217 views2 answers
Array_unique multidimensional php
PHP
5 votes216 views3 answers
Wordpress get_permalink
PHP Wordpress
0 vote228 views1 answer
Comment ajouter nofollow à un lien spécifique ou à tous les liens WordPress dans the_content
PHP
2 votes228 views3 answers
Laravel check empty string
PHP Laravel
7 votes222 views2 answers
Wordpress loop
PHP Wordpress
6 votes195 views5 answers
Jetstream laravel
PHP