DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Database Utilities

11.17.2008
| 3889 views |
  • submit to reddit
        Simple functions to build insert/delete/update statements.

//+ Jonas Raoni Soares Silva
//@ http://jsfromhell.com

class DBUtils{
	public static function insert($table, $fieldset){
		return 'INSERT INTO ' . $table . '(' . implode(',', array_keys($fieldset)) . ') VALUES (' . implode(',', array_values($fieldset)) . ')';
	}
	public static function delete($table, $where = ''){
		return 'DELETE FROM ' . $table . ($where ? ' WHERE ' . $where : '');
	}
	public static function update($table, $fieldset, $where = ''){
		$set = array();
		foreach($fieldset as $field=>$value) $set[] = $field . '=' . $value;
		return 'UPDATE ' . $table . ' SET ' . implode(',', $set) . ($where ? ' WHERE ' . $where : '');
	}