php - SQLSTATE[42S02] 错误提示未找到基表或 View 1146

Question

这个问题已经有答案了:

What is the difference between single-quoted and double-quoted strings in PHP? (7 个回答)

已关闭 4 年前。

<?php
      $assignmentsTable = $ssubjectnamewithoutspace.'_assignments';

        try {
            $stmt = $db->query('SELECT contentID, contentTitle,contentAuthor, contentLink FROM .$assignmentsTable ORDER BY contentID ASC');
            while($row = $stmt->fetch()){

                    echo '<tr><td><a href="'.$row['contentLink'].'">'.$row['contentTitle'].'</a></td></tr>';            


            }

        } catch(PDOException $e) {
            echo $e->getMessage();
        }
    ?>

我收到此错误

SQLSTATE[42S02]: Base table or view not found 1146 Table 'epiz_5453564654654_newdata.$assignmentsTable' doesn't exist

但是表存在于数据库中，当我替换 $assignmentsTable 时使用表名它可以工作...

Answer 1

您的查询中不会评估$assignmentsTable。

尝试:

$stmt = $db->query('SELECT contentID, contentTitle,contentAuthor, contentLink FROM `'.$assignmentsTable.'` ORDER BY contentID ASC');