<?php
$servername = "localhost";
$username = "root";
$password = "root";
$conn = mysqli_connect($servername, $username, $password);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$name =$_REQUEST['name'];
$password =$_REQUEST['password'];
if (!isset($name) || !isset($password))
{
return;
}
$sql = "SELECT id, username, password FROM test.user where (username=('$name')) and password='$password';";
echo $sql . '<br>';
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
echo 'get succ ' . '<br>';
while($row = mysqli_fetch_assoc($result)) {
echo "id: " . $row["id"]. " - Name: " . $row["username"]. " ;password " . $row["password"]. "<br>";
}
} else {
echo "0 结果";
}
mysqli_close($conn);
?>
