[Lambda-cvs] lambda/include mysql.php,1.2,1.3

[Ariejan de V. <ar...@us...>]

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