php - 无法从 mysqli 进行 Base64 解码

Question

我目前正在尝试从 SQL 数据库中回显信息，我必须对这些信息进行编码才能有效地将其写入表中；现在，当我尝试回显信息时，在对其进行解码时，页面没有显示任何内容，我不完全确定此时我做错了什么。

<?php
$type = $_SESSION['SESS_ACC_TYPE'];
$login = $_SESSION['SESS_LOGIN_NAME'];
$log = base64_decode(''.$row['log'].'');
if ($type == '2') {
    $qry = "SELECT log FROM logs ";
    $result = mysqli_query($GLOBALS["___mysqli_ston"], $qry);
    while($row = mysqli_fetch_assoc($result)){
        echo ''.$log.'';
    }
}
if ($type == '1') {
    $qry = "SELECT log FROM logs WHERE login = '.$login.'";
    $result = mysqli_query($GLOBALS["___mysqli_ston"], $qry);
    while($row = mysqli_fetch_assoc($result)){
        echo ''.$log.'';
    }
} else {
    //do nothing
}
?>

Answer 1

您的代码有很多错误:

我修好了它们。

$type  = $_SESSION['SESS_ACC_TYPE'];
$login = $_SESSION['SESS_LOGIN_NAME'];

if ($type == '2') {
    $qry = "SELECT `log` FROM `logs`;";
}
if ($type == '1') {
    $qry = "SELECT `log` FROM `logs` WHERE `login` = '" . $login . "';";
}

$result = mysqli_query($GLOBALS["___mysqli_ston"], $qry);
while($row = mysqli_fetch_assoc($result)) {
    echo base64_decode($row['log']);
}