Was wondering if anyone has any examples of a query builder...
public function compileInsertQuery($table, $data, $autoClean = true)
{
// Valid data
if (is_array($data))
{
$fields = "";
$values = "";
foreach ($data as $key => $value)
{
$fields .= "{$this->_colDelimiters['left']}{$key}{$this->_colDelimiters['right']}, ";
if ($autoClean)
{
$values .= "{$this->_strDelimiters['left']}{$this->cleanString($value)}{$this->_strlDelimiters['right']}, ";
}
else
{
$values .= "{$this->_strDelimiters['left']}{$value}{$this->_colDelimiters['right']}, ";
}
}
// Strip last , from string
$fields = preg_replace("/, $/", "", $fields);
$values = preg_replace("/, $/", "", $values);
$query = "INSERT INTO {$this->addTablePrefix($table)} ({$fields}) VALUES({$values})";
return $query;
}
}
Is mine but i was wondering if anyone knows of anyways to improve it etc.