I have a php function that retrieves tweets from Twitter & returns them in simplexml_load_string. I have to store those into database. Whats is an easy way to store those into database on page load? I have already tried my luck with ajax but json that is returned from twitter seems invalid. thanX a Lot in advance.
Simply store them in the table as XML and then parse them on demand.
// perform query
$res = mysql_query('SELECT * from tweets');
// place xml objects into array
$tweets = array();
while ($row = mysql_fetch_assoc($res)) {
$tweets[] = new SimpleXMLElement($row['data']);
}