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:

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

{{ parent.tldr }}

{{ parent.urlSource.name }}