php的sql语句里面怎么使用数组,php – 使用数组键和值来创建sql select语句

您可以像这样构建一个简单的SQL Select：

/**

* @param array Column => Value pairs

* @return string

*/

function create_sql_select(array $pair){

$condition = array();

foreach ( $pair as $key => $value){

$condition[] = "{$key} = '{$value}'";

}

// Separate by AND delimiter if there are more than 1 pair

$condition = join(' AND ', $condition);

// Return prepared string:

return "SELECT * FROM your_table WHERE {$condition}";

}

//Will print: SELECT * FROM your_table WHERE user = 'some' AND age = '10'

print create_sql_select(array('user' => 'some', 'age' => 10));