php - 这段代码怎么会有错误呢？

Question

我不断收到此错误，我非常肯定我的语法是正确的!

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='00001010'' at line 1

PHP 代码:

<?php
$decode = str_split($_POST['ascii'], 8);
mysql_connect("localhost","Username","Password");
mysql_select_db("information");
foreach($decode as $char){
    $query = mysql_query("SELECT * FROM ascii_binary WHERE binary='$char'") or die(mysql_error());
    while ($row = mysql_fetch_array($query)) {
        $char = $row['character'];
        echo $char;
    }
}
?>

Answer 1

你必须在 BINARY 周围使用反引号，因为 BINARY 是 mysql 的保留关键字。

像这样:

 SELECT * FROM ascii_binary WHERE `binary` ='$char'