$data[":" . $key] = $val;
unset($data[$key]);
}
$result = self::query($sql, $data);
if (isset($return_field)) {
return $result->fetchColumn(0);
} else {
return (bool) $result;
}
}
public static function update($table, $data, $where)
{
$fields = "";
foreach ($data as $key => $val) {
$fields .= "\"" . $key . "\" = :" . $key . ", ";
}
$sql = "UPDATE \"" . $table . "\" SET " . rtrim($fields, ", ") . " WHERE " . $where;
foreach ($data as $key => $val) {
$data[":" . $key] = $val;
unset($data[$key]);
}
$result = self::query($sql, $data);
return (bool) $result;
}
public static function delete($table, $where)
{
return (bool) self::query("DELETE FROM \"" . $table . "\" WHERE " . $where);
}
}
DigiplayDB::connect();
