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

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

Update of /cvsroot/lambda/lambda/include
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1891/include

Modified Files:
	mysql.php 
Log Message:
Added db_select meta function


Index: mysql.php
===================================================================
RCS file: /cvsroot/lambda/lambda/include/mysql.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql.php	26 Jul 2005 13:33:00 -0000	1.1
--- mysql.php	26 Jul 2005 14:04:49 -0000	1.2
***************
*** 100,104 ****
  function db_res2array($res)
  {
!     // TODO
  }
  
--- 100,114 ----
  function db_res2array($res)
  {
!     // We want the entire resource, so move the interal data pointer
!     @mysql_data_seek($res, 0);
!     
!     $result = array();
!     
!     while($row = db_fetch_row($res))
!     {
! 	$result[] = $row;
!     }
!     
!     return $result;
  }
  
***************
*** 123,126 ****
--- 133,190 ----
  }
  
+ /**
+  * db_select
+  *
+  * Easy SELECT function 
+  *
+  * table: string							*Required*
+  * fields: array with fields to select, null will return all fields 	*Optional*
+  * conditions: Array with SQL conditions, null for no conditions	*Optional*
+  *
+  * Returns Assoc Array on succes, otherwise false
+  **/
+ function db_select($table, $fields = null, $conditions = null)
+ {
+     // Construct SQL Query
+     $sql = "SELECT";
+     
+     // Add fields
+     if(is_array($fields))
+     {
+ 	foreach($fields as $field)
+ 	{
+ 	    $sql .= " ". $field .",";
+ 	}
+ 	
+ 	// Remove the trailing comma
+ 	$sql = substr($sql, 0, -1);
+ 	
+ 	
+     }
+     else
+     {
+ 	$sql .= " *";
+     }
+     
+     // Add table
+     $sql .= " FROM `".$table ."`";
+     
+     // Add conditions
+     if(is_array($conditions))
+     {
+ 	foreach($conditions as $condition)
+ 	{
+ 	    $sql .= " ". $condition ." AND";
+ 	}
+ 	
+ 	// Remove trailing AND
+ 	$sql = substr($sql, 0, -4);
+     }
+     
+     // Perform query
+     $sqlresult = db_query($sql);
+     
+     return db_res2array($sqlresult);
+ }
  
  ?>
\ No newline at end of file