StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I felt inspired since I was providing an answer.... I whipped up a little class that'll do this for you...</p> <h2>Table</h2> <pre><code>kick_ass_data_t </code></pre> <h2>Schema</h2> <pre><code>CREATE TABLE `kick_ass_data_t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `key_text` varchar(1024) NOT NULL, `value_text` mediumtext, `create_date` datetime NOT NULL, `lmod_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB </code></pre> <h2>Class</h2> <pre><code><?php /** * Property Bag */ class KickAssProps { /** * gets a property from a database bag. * If $remove is true, item is deleted after retrieved. * @param string $key * @param mixed $defaultValue * @param bool $remove * @return mixed */ public function getProperty( $key, $defaultValue = null, $remove = false ) { $_result = $defaultValue; // Lookup key if ( null === ( $_model = $this->_loadProperty( $key ) ) ) { $_model = new KickAssData(); $_model->key_text = $key; $_model->value_text = self::_serialize( $_result ); $_model->create_date = date( 'Y-m-d H:i:s' ); if ( ! $_model->save() ) { // bitch alot... } } else $_result = self::_unserialize( $_model->value_text ); if ( $remove ) { if ( ! $_model->delete() ) { // bitch alot... } } return $_result; } /** * sets a property in a database bag. * @param string $key * @param mixed $value * @return \KickAssProps $this */ public function setProperty( $key, $value = null ) { // Lookup key if ( null === ( $_model = $this->_loadProperty( $key ) ) ) { $_model = new KickAssData(); $_model->key_text = $key; $_model->create_date = date( 'Y-m-d H:i:s' ); } $_model->value_text = self::_serialize( $value ); if ( ! $_model->save() ) { // bitch alot... } // Allow chaining... return $this; } /** * Retrieves a property from the database bag * @param string $key * @return KickAssData */ protected function _loadProperty( $key ) { // Example sql // $_sql = 'select * from kick_ass_data_t where key_text = :key_text'; // read row from database however you want... this is how I'd do it in Yii (http://www.yiiframework.com) $_model = KickAssData::model()->find( 'key_text = :key_text', array( ':key_text' => $key ) ); return $_model; } /** * Serializer that can handle SimpleXmlElement objects * @param mixed $value * @return mixed */ protected static function _serialize( $value ) { try { if ( $value instanceof SimpleXMLElement ) return $value->asXML(); if ( is_object( $value ) ) return serialize( $value ); } catch ( Exception $_ex ) { } return $value; } /** * Unserializer that can handle SimpleXmlElement objects * @param mixed $value * @return mixed */ protected static function _unserialize( $value ) { try { if ( self::_isSerialized( $value ) ) { if ( $value instanceof SimpleXMLElement ) return simplexml_load_string( $value ); return @unserialize( $value ); } } catch ( Exception $_ex ) { } return $value; } /** * Tests if a value needs unserialization by unserializing the value then * re-serializing. If both are successful then it's cool. I know this is * slower but it guarantees data integrity in my database. * @param mixed $value * @return boolean */ protected static function _isSerialized( $value ) { return !( false === @unserialize( $value ) && $value != @serialize( false ) ); } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload