php - Zend SQL 正在放弃我的 where 标准

Question

为什么此查询会删除条件？如果我在逗号后使用变量或硬键值(“97225”)似乎并不重要。感谢您的见解。

$pro_zip = '97224';

Zend PHP:
        $sql = new Sql($adapter);
        $select = $sql->select();
        $select->from('pro_table')
            ->join(array('specialty' => 'pro_specialty_table'),
                    'specialty.pro_id = pro_table.pro_id')
            ->join(array('specialty_name' => 'specialty_name_table'),
                    'specialty_name.specialty_name_id = specialty.speciality_name_id')
           ->where('pro_table.pro_zip = ?',$pro_zip);

SQL 输出:

    SELECT `pro_table`.*, `specialty`.*, `specialty_name`.* FROM `pro_table` 
INNER JOIN `pro_specialty_table` AS `specialty` ON `specialty`.`pro_id` = `pro_table`.`pro_id` 
INNER JOIN `specialty_name_table` AS `specialty_name` ON `specialty_name`.`specialty_name_id` = `specialty`.`speciality_name_id`
 WHERE pro_table.pro_zip = ''

Answer 1

因为这看起来像 ZF2，我想你想要:

->where(array('pro_table.pro_zip' => $pro_zip));