public function setCache($key, $data, $lifetimeInSeconds = false)
    {
        if ($this->sqlInitialized()) {
            if ($this->sql) {
                /* escape query data */
                $_key = $this->sql->real_escape_string($key);
                $_data = $this->sql->real_escape_string(serialize($data));
                $_expire = $this->getExpirationTimestamp($lifetimeInSeconds);

                $response = $this->sql->query("
                    SELECT *
                        FROM `{$this->table}`
                        WHERE
                            `{$this->key}` = '$_key'
                ");
                if ($response->fetch_assoc()) {
                    if ($this->sql->query("
                        UPDATE
                            `{$this->table}`
                            SET
                                `{$this->cache}` = '$_data',
                                `expire` = " . ($_expire === false ? 'NULL' : "'$_expire'") . "
                            WHERE
                                `{$this->key}` = '$_key'
                    ")) {
                        return true;
                    } else {
                        throw new SimpleCache_Exception(
                            'Could not update existing cache data. ' . $this->sql->error,
                            SimpleCache_Exception::CACHE_WRITE
                        );
                    }
                } elseif ($this->sql->query("
                    INSERT
                        INTO `{$this->table}`
                        (
                            `{$this->key}`,
                            `{$this->cache}`
                            " . ($_expire === false ? '' : ", `expire`") . "
                        ) VALUES (
                            '$_key',
                            '$_data'
                            " . ($_expire === false ? '' : ", '$_expire'") . "
                        )
                ")) {
                    return true;
                } else {
                    throw new SimpleCache_Exception(
                        'Could not insert new cache data. ' . $this->sql->error,
                        SimpleCache_Exception::CACHE_WRITE
                    );
                }
            }
            return false;
        }
    }
public function setCache($key, $data, $lifetimeInSeconds = false)
    {
        if ($this->sqlInitialized()) {
            if ($this->sql) {
                /* escape query data */
                $_key = $this->sql->real_escape_string($key);
                $_data = $this->sql->real_escape_string(serialize($data));
                $_expire = $this->getExpirationTimestamp($lifetimeInSeconds);

                $response = $this->sql->query("
                    SELECT *
                        FROM `{$this->table}`
                        WHERE
                            `{$this->key}` = '$_key'
                ");
                if ($response->fetch_assoc()) {
                    if ($this->sql->query("
                        UPDATE
                            `{$this->table}`
                            SET
                                `{$this->cache}` = '$_data',
                                `expire` = " . ($_expire === false ? 'NULL' : "'$_expire'") . "
                            WHERE
                                `{$this->key}` = '$_key'
                    ")) {
                        return true;
                    } else {
                        throw new SimpleCache_Exception(
                            'Could not update existing cache data. ' . $this->sql->error,
                            SimpleCache_Exception::CACHE_WRITE
                        );
                    }
                } elseif ($this->sql->query("
                    INSERT
                        INTO `{$this->table}`
                        (
                            `{$this->key}`,
                            `{$this->cache}`
                            " . ($_expire === false ? '' : ", `expire`") . "
                        ) VALUES (
                            '$_key',
                            '$_data'
                            " . ($_expire === false ? '' : ", '$_expire'") . "
                        )
                ")) {
                    return true;
                } else {
                    throw new SimpleCache_Exception(
                        'Could not insert new cache data. ' . $this->sql->error,
                        SimpleCache_Exception::CACHE_WRITE
                    );
                }
            }
            return false;
        }
    }
public function setCache ( $ key , $ data , $ lifetimeInSeconds = false ) { if ( $ this -> sqlInitialized ( ) ) { if ( $ this -> sql ) { /* escape query data */ $ _key = $ this -> sql -> real_escape_string ( $ key ) ; $ _data = $ this -> sql -> real_escape_string ( serialize ( $ data ) ) ; $ _expire = $ this -> getExpirationTimestamp ( $ lifetimeInSeconds ) ; $ response = $ this -> sql -> query ( "
                    SELECT *
                        FROM `{$this->table}`
                        WHERE
                            `{$this->key}` = '$_key'
                " ) ; if ( $ response -> fetch_assoc ( ) ) { if ( $ this -> sql -> query ( "
                        UPDATE
                            `{$this->table}`
                            SET
                                `{$this->cache}` = '$_data',
                                `expire` = " . ( $ _expire === false ? 'NULL' : "'$_expire'" ) . "
                            WHERE
                                `{$this->key}` = '$_key'
                    " ) ) { return true ; } else { throw new SimpleCache_Exception ( 'Could not update existing cache data. ' . $ this -> sql -> error , SimpleCache_Exception :: CACHE_WRITE ) ; } } elseif ( $ this -> sql -> query ( "
                    INSERT
                        INTO `{$this->table}`
                        (
                            `{$this->key}`,
                            `{$this->cache}`
                            " . ( $ _expire === false ? '' : ", `expire`" ) . "
                        ) VALUES (
                            '$_key',
                            '$_data'
                            " . ( $ _expire === false ? '' : ", '$_expire'" ) . "
                        )
                " ) ) { return true ; } else { throw new SimpleCache_Exception ( 'Could not insert new cache data. ' . $ this -> sql -> error , SimpleCache_Exception :: CACHE_WRITE ) ; } } return false ; } }
Store data in cache

@param string $key
@param mixed $data Must be serializable
@param int|false $lifetimeInSeconds (Optional)

@return boolean Returns `TRUE` on success, `FALSE` on failure

@see setLifetime() setLifetime()
Store data in cache