From f53c509ed4926d4822270008ecdc4de838c608b6 Mon Sep 17 00:00:00 2001 From: Jason Woofenden Date: Thu, 28 Dec 2006 04:50:42 -0500 Subject: [PATCH] db_insert() can take data as separate arguments or as an array --- db.php | 21 +++++++++++++-------- 1 file changed, 13 insertions(+), 8 deletions(-) diff --git a/db.php b/db.php index b8febdb..ea0a900 100644 --- a/db.php +++ b/db.php @@ -207,19 +207,24 @@ function db_get_value($table, $columns, $where = '') { return $value; } +# call either of these ways: +# +# db_insert('people', 'name,company', 'jason', 'widgets ltd'); +# or +# db_insert('people', 'name,company', array('jason', 'widgets ltd')); function db_insert($table, $columns, $values) { - $sql = "INSERT INTO $table ($columns) values("; + if(!is_array($values)) { + $values = func_get_args(); + $values = array_slice($values, 2); + } - $first = true; + $sql = ''; foreach($values as $value) { - if($first) { - $first = false; - } else { - $sql .= ','; - } + if($sql) $sql .= ','; $sql .= '"' . enc_sql($value) . '"'; } - $sql .= ')'; + + $sql = "INSERT INTO $table ($columns) values($sql)"; db_send_query($sql); } -- 1.7.10.4