Unity sql PHP script can log in with wrong password, what's wrong?
The php script reads the database for the correct email, however any password is "correct" according to the script. Do any of you know what needs to be changed in order for it to login with the correct password? Thank you very much!
<?php
$Hostname = "localhost";
$DBName = "accounts";
$User = "root";
$PasswordP = "";
mysql_connect($Hostname, $User, $PasswordP) or die("Can't connect into database");
mysql_select_db($DBName)or die("Can't connect into database");
$Email = $_REQUEST["Email"];
$Password = $_REQUEST["Password"];
if(!$Email || !$Password)
{
echo "Login or password cannnot be empty.";
}
else
{
$SQL = "SELECT * FROM accounts WHERE Email = '" . $Email . "'";
$result_id = @mysql_query($SQL) or die("DATABASE ERROR!");
$total = mysql_num_rows($result_id);
if($total)
{
$datas = @mysql_fetch_array($result_id);
if (strcmp($Password, $datas["Password"])){
$sql2 = "SELECT Characters FROM accounts WHERE Email = '" . $Email . "'";
$result_id2 = @mysql_query($sql2) or die("DATABASE ERROR!");
while($row = mysql_fetch_array($result_id2))
{
echo $row['Characters'];
echo":";
echo"Success";
}
}
else
{
echo "WrongPassword";
}
}
else
{
echo "EmailDoesNotExist";
}
}
mysql_close();
?>
Comment
Your answer
Follow this Question
Related Questions
i need help unity get data from php 0 Answers
Money from unity to mysql db 0 Answers
display data from mysql 0 Answers
Can I add a table to a mySQL database using C#? 0 Answers
WWW not working on my PHPs 0 Answers