<!DOCTYPE html>
<head>
<title>Auth</title>
<meta charset="utf-8">
</head>
<body>
<?php
$mysqli = new mysqli($host, $user, $password, $db_name);
$mysqli->set_charset("utf8");
if ($mysqli->connect_errno){
$json_array = array("error" => 1, "message" => "Ошибка подключения к БД");
$json = json_encode($json_array, JSON_UNESCAPED_UNICODE);
exit($json);
}
else {
if (isset($_GET['login'])) {
$query = "SELECT * FROM `test` WHERE login=".$_GET['login'];
$sql = mysqli_query($mysqli,$query) or die(mysqli_error());
if (mysqli_num_rows($sql) > 0) {
$myrow = mysqli_fetch_array($sql);
$pass = $myrow['pass'];
echo $pass->format("%d");
}else{
echo '-1';
}
}
}
?>
</body>
$query = "SELECT * FROM `test` WHERE login=\"" . $_GET['login'] . "\"";
if (isset($_GET['login'])) {
$query = "SELECT * FROM `test` WHERE login=".$_GET['login'];
echo "query=$query\n";
$sql = mysqli_query($mysqli,$query) or die(mysqli_error());
echo "num_rows=".mysqli_num_rows($sql)."\n";
if (mysqli_num_rows($sql) > 0) {
$myrow = mysqli_fetch_array($sql);
$pass = $myrow['pass'];
var_export($myrow);
echo $pass->format("%d");
}else{
echo '-1';
}
}