Yama's Memorandum

        public function insertAccess ( $access ) {
            is_null($this->mysqli) and $this->connect();
        // page_visited to page_id in table mypage;
// 修正（挿入）箇所（１）-- 始まり
        $sql_lock = "LOCK TABLES access WRITE";
        $result_lock = $this->mysqli->query($sqli_lock); 

        $sql_last_id = "SELECT count(*) AS last_id FROM access";
        $result      = $this->mysqli->query($sql_last_id);
        $row = $result->fetch_array(MYSQLI_ASSOC);
        $last_id = $row["last_id"];
        $sql_data        = "SELECT time, visitor FROM access WHERE id='" . $last_id . "'";
        $result_access   = $this->mysqli->query($sql_data);

        if ( $result_access->num_rows > 0 ) {
           $row = $result_access->fetch_array(MYSQLI_ASSOC);
           $time_access = $row["time"];
           $visitor_access = $row["visitor"];

           $time_in = $access->getTime();
           $visitor_in = $access->getVisitor();

           // Compare data between DB and InData
           $comp_visitor    = strcmp( $visitor_in,    $visitor_access );
           $time_diff       = strtotime( $time_in ) - strtotime( $time_access );

        }
// 修正（挿入）箇所（１）　-- 終わり
        if ( $comp_visitor != 0 || $time_diff >= 1 ) {
            $sql = "SELECT id FROM mypage WHERE page_visited='" . $access->getPageVisited() . "'";
            $result = $this->mysqli->query($sql);
            if ( $result->num_rows == 0 ) {
               if ( strpos( $access->getPageVisited(), '.html' ) ) {
                    if (have_posts()) : while (have_posts()) : the_post();
                    $new_title = get_the_title();
                    endwhile; endif;
               }
               else {
                    $new_title = $access->getPageVisited();
               }
               $sql = "INSERT INTO mypage values('',
                       '" . $access->getPageVisited() . "', '" . $new_title . "')";
               if (!$this->mysqli->query($sql)) {
                       print "Failed to register(1010) " . $this->mysqli->error . "\n";
               }
               else {
                       $page_id    = $this->mysqli->insert_id;
                       $page_title = '$new_title';
               }
            }
            else {
                  $row = $result->fetch_array(MYSQLI_ASSOC);
                  $page_id = $row["id"];
                  $sql = "SELECT title FROM mypage WHERE id =' " . $page_id . "'";
                  if(!$this->mysqli->query($sql)) {
                       print "Failed to register(1011) " . $this->mysqli->error . "\n";
                  }
                  else {
                      $page_title = $row["title"];
                  }
            }

        // Set access table for new data
            $sql = "INSERT INTO access values('',
                           '" . $access->getTime() . "',
                           '" . $access->getVisitor() . "',
                           '" . $access->getIpAddress() . "',
                           '" . $access->getUniqueness() . "',
                           '" . $access->getReffUri()   . "',
                           '" . $access->getRefferer() . "',
                           '" . $access->getSearchEngine() . "',
                           '" . $access->getKeyWords() . "',
                           '" . $page_id . "',
                           '" . $access->getUserAgent() . "')";

            if(!$this->mysqli->query($sql) ) {
                 print "FAILED TO SET DATA(1012) " . $this->mysqli->error . "\n";
            }
// 修正（挿入）箇所（２）　始まり
        }
        $sql_lock = "UNLOCK TABLES";
        $result_lock = $this->mysqli->query($sql_lock);
// 修正（挿入）箇所（２）　終わり
        }