Example #1
0
 function write()
 {
     global $sg;
     $this->fin();
     $sql = "insert into access_log (log_date,accept_date,proc_time,status,url,uri,from_ip,from_addr,referer,referer_full,ua,\r\ncarrier,ment_flg,option1,option2,option3,option4,option5,option6) values (\r\nsysdate(), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     $db = new DBLib($sg);
     $db->connect();
     $db->prepare($sql);
     $db->bind(date("Y/m/d H:i:s", $this->accept_date / 1000));
     $db->bind(floor($this->proc_time));
     $db->bind($this->status);
     $db->bind($this->url);
     $db->bind($this->uri);
     $db->bind($this->from_ip);
     $db->bind($this->from_addr);
     $db->bind($this->referer);
     $db->bind($this->referer_full);
     $db->bind($this->ua);
     $db->bind($this->carrier);
     $db->bind($this->ment_flg);
     $db->bind($this->option1);
     $db->bind($this->option2);
     $db->bind($this->option3);
     $db->bind($this->option4);
     $db->bind($this->option5);
     $db->bind($this->nowment);
     $r = $db->execute_update(false);
     if (!$r) {
         print ht(mysql_error());
         $db->rollback();
     } else {
         $db->commit(false);
     }
     $db->close();
 }