我尝试在postgres select语句中使用php数组。
我试过了:
$sql = "SELECT * FROM some_table WHERE string_field IN ($1) AND other_field = $2;";
$result = pg_query_params($conn, $sql, array(implode(',', $my_arr), $other_field));
但当我运行它时,没有任何回报。(当我在postgres中硬键入所有内容时,会返回一些内容)
$data = ['a','b','c','d'];
$x = "'" . implode("','", $data) . "'";
var_dump($x);
结果:
'a','b','c','d'