private function writeLogToSQL($file, $logname, $description) { $table = 'Logs'; $queryType = 'Insert'; $condition = null; $types = array('text', 'text', 'text', 'timestamp'); $columns = array('Filename', 'LogName', 'Description', 'Datetime'); $now = getdate(date("U")); $datetime = new DateTime(); $datetime->setDate($now['year'], $now['mon'], $now['mday']); $datetime->setTime($now['hours'] + 3, $now['minutes'], $now['seconds']); $values = array($file, $logname, $description, $datetime->format('Y/m/d H:i:s')); $args = array('column' => $columns, 'value' => $values, 'type' => $types); $xml = $this->createXML($table, $args); $sql = new SQLMediator(); $sql->connect(); $res = $sql->query($xml, $queryType, $condition); $sql->disconnect(); }