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
|
