## 數組轉數據庫IN查詢字符串
```
// 數組轉數據庫IN查詢字符串
function arrToInStr($array=[],$field,$type=0){
if($type){
$string = join(",",array_column($array,$field));
}else{
$string = "'".join("','",array_column($array,$field))."'";
}
return $string;
}
```
```
# 例子：
// 獲取經銷商地址
function getAgenAddressStr($agent_guid){
$area = Db::name("agent_area")
->where(['agent_guid'=>$agent_guid])
->select();
$address = "";
if ($area){
foreach ($area as $k=>$v){
$address .= "'".$v['province'].",".$v['city'].",".$v['area']."',";
}
$address = trim($address,",");
}
return $address;
}
```
