Answers for "sql injection prevention php"

PHP
4

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
Posted by: Guest on May-18-2020
0

how to stop bank entry in php mysql server database

if($name!="" && $email!=""){
$sql="insert into info(name,email)values('".$name."','".$email."')";
$query=mysqli_query($conn,$sql);
                                                         
}else{

echo "All field are required";

}
Posted by: Guest on January-05-2021
-2

sql injection attack prevention in php

SELECT UserId, Name, Password
FROM Users WHERE UserId = 105 or 1=1;
Posted by: Guest on March-05-2021

Browse Popular Code Answers by Language