~~~ /** * 生成sql語句，如果傳入$in_cloumn 生成格式為 IN('a', 'b', 'c') * @param $data 條件數組或者字符串 * @param $front 連接符 * @param $in_column 字段名稱 * @return string */ function to_sqls($data, $front = ' AND ', $in_column = false) { if($in_column && is_array($data)) { $ids = '\''.implode('\',\'', $data).'\''; $sql = "$in_column IN ($ids)"; return $sql; } else { if ($front == '') { $front = ' AND '; } if(is_array($data) && count($data) > 0) { $sql = ''; foreach ($data as $key => $val) { $sql .= $sql ? " $front `$key` = '$val' " : " `$key` = '$val' "; } return $sql; } else { return $data; } } } ~~~