带变量的MySQL查询

Question

我的查询有一个问题：

$result = $this->Database->prepare("SELECT * FROM kunden WHERE partner = '$pName'");

你能帮我写好查询吗？

Answer 1

试试这边

$result = $this->Database->prepare("SELECT * FROM kunden WHERE partner = '".$pName."'");