/**
* Executes the SQL with vars
* @param string $sql
* @param mixed $vars
* @example
* rad_update::execSQL('INSERT INTO @RAD@settings(fldName, fldValue, position, description, rtype, defValue)VALUES("test", "test",100,"description","modules","@value@")', array('value'=>'defValue'));
* @return rad_update
*/
public function execSQL($sql, $vars = null)
{
if (!empty($vars) and is_array($vars)) {
foreach ($vars as $key => $value) {
if (is_scalar($value)) {
$sql = str_replace('@' . $key . '@', $value, $sql);
}
}
}
echo $sql . "\r\n";
rad_dbpdo::exec($sql);
if ((int) rad_dbpdo::errorCode()) {
echo "\r\n" . (int) rad_dbpdo::errorCode();
print_r(rad_dbpdo::errorInfo());
echo "\r\n";
}
return $this;
}