Thursday, 4 June 2015

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;
}
?>

0 comments:

Post a Comment