php - SQL 查询中的变量被视为列

Question

我使用 XCRUD 框架。

我有一个问题:

$xcrud->query('SELECT * FROM table2 WHERE category IN (SELECT category FROM table1 WHERE '.$login_session.' = username)');

我不断收到以下错误:

 Unknown column 'userx' in 'where clause'

Userx 是变量的值。

我也试过

$xcrud->query('SELECT * FROM table2 WHERE category IN (SELECT category FROM table1 WHERE '$login_session' = username)');

和

$xcrud->query('SELECT * FROM table2 WHERE category IN (SELECT category FROM table1 WHERE $login_session = username)');

我无法让我的查询工作。该变量被视为一列。

Answer 1

像这样更改查询

$xcrud->query('SELECT * FROM table2 WHERE category IN (SELECT category FROM table1 WHERE username ="'.$login_session.'" )');