[Lambda-cvs] lambda/include mysql.php,1.1,1.2
Status: Pre-Alpha
Brought to you by:
ariejan
From: Ariejan de V. <ar...@us...> - 2005-07-26 14:04:58
|
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 |