Untitled

  405         $db = DB::getHandle();
  406         $sessid = $this->_sessionKey;
  407         $val=base64_encode($val);
  408         $s="UPDATE lcSessions SET username= '".$this->username."', sessdata = '".$val."' WHERE sesskey = '".$sessid."'";
  409         if ($this->username == "anonymous" ) {
  410             $s="UPDATE lcSessions SET sessdata = '".$val."' WHERE sesskey = '".$sessid."'";
  411         }
  412         if (!$db->query($s,true)) {
  413             //no update record, try insert
  414             $s="INSERT into lcSessions (username,sessdata,sesskey) values ('".$this->username."','$val','$sessid')";
  415             if ($this->username == "anonymous" ) {
  416                 $s="INSERT into lcSessions (sessdata,sesskey) values ('$val','$sessid')";
  417             }
  418             $db->query($s,true);
  419         }
  420         echo "strlen = ".strlen($val)."<br/>\n";
  421         $db->queryOne('select sessdata from lcSessions where sesskey = "'.$sessid.'"');
  422         echo "strlen = ".strlen($db->record['sessdata'])."<br/>\n";
  423         echo "val = ".$val."<br/>\n";
  424         echo "val = ".$db->record['sessdata']."<br/>\n";
  425         echo "<p></p>\n";
  426         echo "query is = ".$s;
  427         $db->query('COMMIT');
  428         $db->disconnect();
  429         exit();