dongshi7433 2018-07-21 07:59
浏览 70

如何从PDO fetchAll()中删除第一个数组?

So I'm trying to do a login system but, I have a problem.

I'm using PDOStatement::fetchAll() function to retrieve user's data from database and as expected, returns this:

Array
(
    [0] => Array
        (
            [id] => 1
            [username] => Berk
            [password] => $2y$12$.TDZWwCFfBkM.uVdUkwrVODWu6Nt8QsWMWOFXnOTFQ5CHw57pa1Cu
            [discord] => Berkay#1603
            [likes] => 5
            [role] => Developer
            [avatar] => 
            [region] => Global
        )

)

My code:

if($requestType == 'login')
{
    $username = $_POST['username'];
    $password = $_POST['password'];

    $user = $conn->prepare("SELECT * FROM users WHERE username = :u");
    $user->bindParam(':u', $username);
    $user->execute();
    if($user->rowCount() > 0)
    {
        $user->setFetchMode(PDO::FETCH_ASSOC);
        $user = $user->fetchAll(PDO::FETCH_ASSOC);
        print_r($user);
        if(password_verify($password,$user[0]['password']))
        {
            // Logged in 
            foreach($user as $key => $value)
            {
                    $_SESSION[$key] = $value;
                    print_r($_SESSION);
            }
    }
    }

}

And my question is, how can I remove the first array where only return is 0?

Any help is appreciated.

Thanks.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Vue3 大型图片数据拖动排序
    • ¥15 划分vlan后不通了
    • ¥15 GDI处理通道视频时总是带有白色锯齿
    • ¥20 用雷电模拟器安装百达屋apk一直闪退
    • ¥15 算能科技20240506咨询(拒绝大模型回答)
    • ¥15 自适应 AR 模型 参数估计Matlab程序
    • ¥100 角动量包络面如何用MATLAB绘制
    • ¥15 merge函数占用内存过大
    • ¥15 使用EMD去噪处理RML2016数据集时候的原理
    • ¥15 神经网络预测均方误差很小 但是图像上看着差别太大