例：

function createQueryString($arrayToSelect,$table,$conditionalArray) {
$queryStr = "SELECT ".implode(",",$arrayToSelect)." FROM ".$table." WHERE ";
$queryStr = $queryStr.implode(" AND ",$conditionalArray); /*NEED HELP HERE*/
return $queryStr;
}

$columnsToSelect = array('ID','username');
$table = 'table';
$conditions = array('lastname'=>'doe','zipcode'=>'12345');
echo createQueryString($columnsToSelect,$conditions); /*will result in incorrect sql Syntax*/

正如你所看到的那样,我需要第三行的帮助,因为它正在打印

SELECT ID,username FROM table WHERE
lastname AND zipcode

但它应该是打印

SELECT ID,username FROM table WHERE
lastname = ‘doe’ AND zipcode = ‘12345’

$terms = count($conditionalArray);
foreach ($conditionalArray as $field => $value)
{
    $terms--;
    $queryStr .= $field . ' = ' . $value;
    if ($terms)
    {
        $queryStr .= ' AND ';
    }
}