php - 本地主机中的 SQL 语法错误

Question

这个问题已经有答案了:

When to use single quotes, double quotes, and backticks in MySQL (13 个回答)

已关闭 7 年前。

这是我的代码:

<?php
require_once $_SERVER["DOCUMENT_ROOT"] . '/Lol/inc/head.php';

$name = $_POST['name'];

// I think that error is about this next line, but i cant find it

$query = "SELECT * FROM 'heroes' WHERE 'name' = '$name'";
$run =  mysql_query($query);
$row = mysql_fetch_array($run) or die(mysql_error()); 
$id = $row['id'];
$name = $row['name'];
$role = $row['role'];
$srole = $row['srole'];
$atack = $row['atack'];
$health = $row['health'];
$ability = $row['ability'];
$difficulty = $row['difficulty']; 


?>



Name: <?php echo $name; ?><br>
Role: <?php echo $role;?><br>
Secondary Role: <?php echo $srole;?> <br>
Atack: <?php echo $atack;?>/100<br>
Health: <?php echo $health;?>/100<br>
Ability: <?php echo $ability;?>/100<br>
Difficulty: <?php echo $difficulty;?>/100<br>

我在 phpMyAdmin 中创建了表

这就是所显示的 - 我在 XAMPP 中本地运行。

Answer 1

问题就出在这里

$query = "SELECT * FROM 'heroes' WHERE 'name' = '$name'";

您不能在表名称或列上使用“' ”，请将其更改为

$query = "SELECT * FROM `heroes` WHERE `name` = '$name'";