下面是我的代码:
<?php
if(isset($submit)){
require 'db/connect.php';
$sql = "SELECT ID from users WHERE username='$username' AND password='$password'";
$entered_user = mysql_query($sql);
$num_rows = mysql_num_rows($entered_user);
$errors = array();
if( $num_rows != 1 )
{
$errors[] = '-Account does not exist ';
}
elseif( $num_rows == 1 )
{
while($row = mysql_fetch_array($entered_user)){
$id = $row['id'];
}
$errors[] = 'ID NUMBER --> '.$id;
}
}
?>
我的问题:如何将特定帐户的id号存储到变量中?我无法生成id号,并且在输入现有帐户时收到的唯一输出是' id number ->',没有下面的id。
数据库列名:id,用户名,密码
$username, $password和$submit是post变量
更改查询中列的名称:
$sql = "SELECT ID as id from users WHERE username='$username' AND password='$password'";
或者当你试图获取它时:
$id = $row['ID'];
也请不要将密码存储为明文。详细阅读如何在PHP中处理密码。