Php Programming Code Examples
Php > Arrays Code Examples
Takes an array and returns a string, suitable for inputing in an SQL statement
Takes an array and returns a string, suitable for inputing in an SQL statement
<?php
function makeSQLList($array) {
if (is_Array($array)) {
reset($array);
unset($SQL);
while (list(,$item)=each($array)) {
if (is_String($item)) {
$SQL[] = "'" . addslashes($item) . "'";
} else {
$SQL[] = $item;
}
}
$sql = "(" . implode($SQL, ", ") . ")";
} else {
$sql = false;
}
return $sql;
}
?>