Re: [PHP] confused big time

[Mark Ackroyd]

I always found this way of inserting data into a database messy. Here is 
a handy function to do array inserts and it builds the sql for you.

        function arrayINSERT($a,$tablename)
        {
                $sql = "INSERT INTO $tablename (";
                foreach($a as $key => $value)
                {
                        $sql .= $key .",";
                }               
                $sql[strlen($sql)-1] = ')';
                $sql .= " VALUES (";
                foreach($a as $key => $value)
                {
                        if (gettype($value) == 'string')
                        {       
                                $sql .= "'". addslashes($value) ."',";
                        }
                        else
                        {
                                $sql .= $value .",";
                        }
                }
                $sql[strlen($sql)-1] = ')';
                return $sql;
        }
if you do this :

$a['field1'] = $blah;
$a['field2'] = $here;
$a['field3'] = $etc;
$sql = arrayINSERT($a,"tablename");
it builds the sql statement for you.  It covers 99.9% of the inserts 
your likely to need.  I use an update and insert function like this all 
the time. :-)

Mark



Richard Davey wrote:

$sql = "
INSERT INTO
       tablename
       (
                field1,
                field2,
                field3
       )
VALUES
      (
                '$blah',
                $here',
                '$etc'
      )
";
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php