Over a million developers have joined DZone.

Database Utilities

·
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 : '');
	}
Topics:

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}