MySQL

Caches data to a MySQL database

Registered for URLs with the "mysql" protocol

For example, mysql://root:password@localhost:3306/mydb?prefix=sp_ will connect to the mydb database on localhost on port 3306, with the user root and the password password. All tables will be prefixed with sp_

• Full name: \SimplePie\Cache\MySQL
• Parent class: \SimplePie\Cache\DB
• Warning: this class is deprecated. This means that this class will likely be removed in a future version.

Properties

mysql

PDO instance

protected \PDO $mysql

---

options

Options

protected array $options

---

id

Cache ID

protected string $id

---

Methods

__construct

Create a new cache object

public __construct(string $location, string $name, \SimplePie\Cache\Base::TYPE_FEED|\SimplePie\Cache\Base::TYPE_IMAGE $type): mixed

Parameters:

Parameter	Type	Description
$location	string	Location string (from SimplePie::$cache_location)
$name	string	Unique ID for the cache
$type	\SimplePie\Cache\Base::TYPE_FEED|\SimplePie\Cache\Base::TYPE_IMAGE	Either TYPE_FEED for SimplePie data, or TYPE_IMAGE for image data

---

save

Save data to the cache

public save(array|\SimplePie\SimplePie $data): bool

Parameters:

Parameter	Type	Description
$data	array|\SimplePie\SimplePie	Data to store in the cache. If passed a SimplePie object, only cache the $data property

Return Value:

Successfulness

---

load

Retrieve the data saved to the cache

public load(): array

Return Value:

Data for SimplePie::$data

---

mtime

Retrieve the last modified time for the cache

public mtime(): int

Return Value:

Timestamp

---

touch

Set the last modified time to the current time

public touch(): bool

Return Value:

Success status

---

unlink

Remove the cache

public unlink(): bool

Return Value:

Success status

---

Inherited methods

prepare_simplepie_object_for_cache

Helper for database conversion

protected static prepare_simplepie_object_for_cache(\SimplePie\SimplePie $data): array

Converts a given {@see \SimplePie\Cache\SimplePie} object into data to be stored

• This method is static.

Parameters:

Parameter	Type	Description
$data	\SimplePie\SimplePie

Return Value:

First item is the serialized data for storage, second item is the unique ID for this item

---

---

Automatically generated on 2025-03-18