无法从MySQL数据库获取行

debugcn 发表于 Dev

米卡德

我对mysql有点生疏，尤其是现在是mysql i ...下面的脚本中什么都没有发生，变量$ row [username]等为空。我究竟做错了什么？

<?php

session_start();
include_once('./db_config.php');

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$username = mysqli_real_escape_string($conn, $_POST['username']);
$password = md5(mysqli_real_escape_string($conn, $_POST['password']));

$query = "SELECT * FROM players WHERE username = '".$username."' AND password = '".$password."'";

if($res = mysqli_query($conn, $query))
{
    $row = mysqli_num_rows($res);
    $_SESSION['Username'] = $row['username'];
    $_SESSION['uID'] = $row['id'];
    $_SESSION['Join_Date'] = $row['join_date'];
    mysqli_free_result($res);

    header('Location: ../index.php');
} else
{
    echo mysqli_error($conn);
}

?>

阿尼什

您不是在获取记录，而是在进行myql_num_rows（这只会提供任何记录）

用它来获取记录

$row = mysqli_fetch_array($res,MYSQLI_ASSOC);

<?php

session_start();
include_once('./db_config.php');

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$username = mysqli_real_escape_string($conn, $_POST['username']);
$password = md5(mysqli_real_escape_string($conn, $_POST['password']));

$query = "SELECT * FROM players WHERE username = '".$username."' AND password = '".$password."'";

if($res = mysqli_query($conn, $query))
{

    $row = mysqli_fetch_array($res,MYSQLI_NUM);
    $_SESSION['Username'] = $row['username'];
    $_SESSION['uID'] = $row['id'];
    $_SESSION['Join_Date'] = $row['join_date'];
    mysqli_free_result($res);

    header('Location: ../index.php');
} else
{
    echo mysqli_error($conn);
}

?>

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。