예제 #1
0
 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();
 }