It's important to understand what SimplePie's MySQL caching is and
isn't.

It's a MySQL *CACHE*, not a *MYSQL* cache. Does that make sense? The
data isn't relational. It's just a cache. It's virtually identical to
what gets dumped into flat files with our file-based caching.

The only benefit that SimplePie's MySQL caching has is that you can
hang onto items longer, even after they've left the feed. It's not
meant to be interacted with. You turn it on and never think about it
again.

If you want to pull that data and store it in your OWN MySQL database,
with your own schema, you'll need to write the code yourself that does
that by plucking out the bits of data you want.

--
Ryan Parman
<http://ryanparman.com>

Please don't email/IM me directly. That's why we have a mailing list. ;)






On Aug 24, 2009, at 2:50 PM, chrisbondam wrote:

> Hey all,
>
> First off, SimplePie looks truly great and my first experience is
> very good!
>
> For my site www.baanict.com I want to integrate/import multiple
> feeds on the Jobboard. Because I want the feeds to be part of the
> other jobs, so that all the jobs are searchable and indexed.
>
> 1.
> But I stumble now on a small problem, I want to save the cache in a
> specific table of my database (called jobs). This is where all my
> Jobs of the Jobboard are placed.
>
> I've found this code/demo
http://simplepie.org/wiki/faq/how_do_i_do_database_caching
>
> There's the code
>
> $feed->set_cache_location('cache');
>
> That I replace with
>
> $feed->set_cache_location('mysql://username:password@hostname:port/
> database/table'); (with the option I believe to write directly in
> my Jobs table)
>
> I'm confused about the values I've got to enter on/instead of
> hostname (localhost?) and port (777?)
>
> 2.
> Also I would like to know what the options are to import certain
> data like city/date/e-mail/company/description/title etc. to
> specified fields in a table of MySQL? Is this possible and what's
> the best way to make this work?
>
> 3.
> Is it possible to auto remove/deactivate the feed if it's removed by
> the feed of the company?
>
> 4.
> Lastly how to implement the code in a smarty template or is this is
> not necessary because the files are being imported to the MySQL
> table . If this not the case where do you've got to place the code
> like index.tpl?
>
> Sorry for the long question list hope you can help me! If you need
> more information I will give it to you pronto!
>
> Thanks in advance
>
> Chris
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>