diff options
Diffstat (limited to 'class')
| -rw-r--r-- | class/CommonTable.php | 39 |
1 files changed, 38 insertions, 1 deletions
diff --git a/class/CommonTable.php b/class/CommonTable.php index a7d029d..7e1dd8e 100644 --- a/class/CommonTable.php +++ b/class/CommonTable.php @@ -30,7 +30,7 @@ * @license http://www.gnu.org/licenses/agpl-3.0-standalone.html AGPL License 3.0 or (at your option) any later version * @link http://github.com/remicollet/rpmphp/ * @since The begining of times. -*/ + */ abstract class CommonTable { @@ -117,6 +117,38 @@ abstract class CommonTable } /** + * Find a row from the table (the first matching criteria) + * + * @param hastable $crit array of field name => value + * + * @return hashtable (the first row) + */ + function find(array $crit) + { + if (count($crit)) { + foreach ($this->request($crit) as $row) { + return $row; + } + } + return false; + } + + /** + * Read a row from the table + * + * @param integer $id of the row + * + * @return hashtable + */ + function get($id) + { + if (intval($id)>0) { + return $this->find(array('id'=>$id)); + } + return false; + } + + /** * Delete a row in the table * * @param hashtable $crit of key => value @@ -160,6 +192,11 @@ abstract class CommonTable $link = 'SET'; foreach ($fields as $key => $value) { + if ($key=='id') { + // Don't update id + continue; + } + $sql .= "$link `$key`="; if (is_null($value)) { $sql .= 'NULL'; |