NYCPHP Meetup

[Adam Fields]

On Sat, Jan 21, 2006 at 12:31:02PM -0500, csnyder wrote:
> Jon Baer wrote in a couple weeks ago with news that MySQL 5.1 will
> support extraction of values from XML fields using XPATH.
> http://dev.mysql.com/tech-resources/articles/mysql-5.1-xml.html
> 
> That led me to think about ways in which this might be useful to PHP developers.
> 
> Which in turn led me to XML_Serializer (and unserializer) at
> http://pear.php.net/package/XML_Serializer
> 
> Hmmm, select and update serialized php object properties in the database...
> 
> SELECT * FROM object WHERE extractvalue( object.xml, 
> '/object/color/hue/blue' ) > 64;
> 
> SELECT extractvalue( UpdateXML( object.xml,
> '/object/icon/href[self::text() = '/icons/xml.gif']'
> ,'<href>/icons/xml.png</href>' ),''/object/icon/href' ) FROM object;
> 
> Can't wait to try it.

"Wait" is probably the correct word.

-- 
				- Adam

** Expert Technical Project and Business Management
**** System Performance Analysis and Architecture
****** [ http://www.everylastounce.com ]

[ http://www.aquick.org/blog ] ............ Blog
[ http://www.adamfields.com/resume.html ].. Experience
[ http://www.flickr.com/photos/fields ] ... Photos
[ http://www.aquicki.com/wiki ].............Wiki
[ http://del.icio.us/fields ] ............. Links