在SQL语句中,常见join()函数,乍一看,还以为是MySQL函数呢。有不少童鞋都被误导!
常以这种形式出现:
select * from table where id in (join(',', $arrId))
其中$arrId是数组,而join()就是把数组$arrId中的元素以逗号为分界符连接为一个字符串。
如以下实例:
$array = array('lastname', 'email', 'phone');
$comma_separated = join(",", $array);
echo $comma_separated; // lastname,email,phone
注:
join — 别名 implode()
1: $array = array('lastname', 'email', 'phone');
2: $comma_separated = implode(",", $array);
3: echo $comma_separated; // lastname,email,phone