Update of /cvsroot/lambda/lambda/include
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6278/include
Modified Files:
mysql.php
Log Message:
Added db_insert and made some minor fixes to db_select
Index: mysql.php
===================================================================
RCS file: /cvsroot/lambda/lambda/include/mysql.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql.php 26 Jul 2005 14:04:49 -0000 1.2
--- mysql.php 26 Jul 2005 14:22:39 -0000 1.3
***************
*** 154,158 ****
foreach($fields as $field)
{
! $sql .= " ". $field .",";
}
--- 154,158 ----
foreach($fields as $field)
{
! $sql .= " `". $field ."`,";
}
***************
*** 188,190 ****
--- 188,228 ----
}
+ /**
+ * db_insert
+ *
+ * Easy INSERT function
+ *
+ * table: string *Required*
+ * data: array with data to be inserted ('field' => 'value') *Required*
+ *
+ * Returns true on succes, otherwise false
+ **/
+ function db_insert($table, $data)
+ {
+ $sql = "INSERT INTO `". $table ."` (";
+
+ while(list($key, $val) = each($data))
+ {
+ $sql .= "`".$key."`, ";
+ }
+
+ // remove last space and comma
+ $sql = substr($sql, 0, -2);
+
+ $sql .= ") VALUES (";
+
+ reset($data);
+ while(list($key, $val) = each($data))
+ {
+ $sql .= "'".$val."', ";
+ }
+
+ // remove last space and comma
+ $sql = substr($sql, 0, -2);
+
+ $sql .= ")";
+
+ // Perform query
+ return db_query($sql);
+ }
?>
\ No newline at end of file
|
