Creating twitter like xml feed

[Samuz]

Example is: https://twitter.com/statuses/user_timeline/kevinhart4real.xml

 

I have all the relevant information I need that i'd like to go in the field, I just need to know how to dynamically create the file with the content and have it update at specific intervals.

 

Any one have any ideas (with PHP)

 

So far I have come up with this:

 

$link = mysql_connect('localhost','root','');
mysql_select_db('test',$link);  

$result = mysql_query('SELECT `nationid`,`ruler`,`nation`, `resource1`, `resource2`, `alliance` FROM `nation`');  

$doc = new DomDocument('1.0');  

$root = $doc->createElement('nationlist');
$root = $doc->appendChild($root);  

while($row = mysql_fetch_assoc($result))
{
    $nation= $doc->createElement('nation');
    $nation = $root->appendChild($nation);


foreach($row as $fieldname => $fieldvalue)
{
    $child = $doc->createElement($fieldname);
    $child = $car->appendChild($child);
    //add data to the new element
    $value = $doc->createTextNode($fieldvalue);
    $value = $child->appendChild($value);
    
}  
}
$doc->save("nations.xml");

Now that generates 1 .xml file with all the details returned from my query. (also don't bash me for using mysql, it's a quick test)

 

What I would like to do is create a new file for each record in my table and have only the values in that recorded saved to its respective file.

[trq]

Why do you need to create any actual files? PHP can generate the xml when a request is made, just as it is generally used to generate html when a request is made.

[Samuz]

Why do you need to create any actual files? PHP can generate the xml when a request is made, just as it is generally used to generate html when a request is made.

Hi there thorpe.

 

I need to generate actual files, because the content within them need to be specific to the actual user account.

 

Would you recommend another solution for my situation?

[laffin]

You don't need to generate files, as Thorpe said php is dynamic, so it can generate the file content on the fly.

with a bit of htaccess help to map xml urls to a php script (http://mysite.com/user.xml), or path_info (http://mysite.com/timeline.php/user.xml)(both using apache, other webservers you will have to lookup how to create a virtual file mapping) or just use url parameters (http://mysite.com/timeline.php?u=user).

 

To generate actual files at specific intervals, you will probably looking at cron with a long running php process, or someway to update users while browsing your site.

 

Of all Thorpe's suggestion is by far the easiest method.

 

 

[Samuz]

You don't need to generate files, as Thorpe said php is dynamic, so it can generate the file content on the fly.

with a bit of htaccess help to map xml urls to a php script (http://mysite.com/user.xml), or path_info (http://mysite.com/timeline.php/user.xml)(both using apache, other webservers you will have to lookup how to create a virtual file mapping) or just use url parameters (http://mysite.com/timeline.php?u=user).

 

To generate actual files at specific intervals, you will probably looking at cron with a long running php process, or someway to update users while browsing your site.

 

Of all Thorpe's suggestion is by far the easiest method.

 

Thanks that solution would make more sense now that I think of it.

 

Now if I want to use url parameters, all i'd have to do is use the $GET array right? (Ensuring everything is sanitized of course)

[laffin]

Correct, and you will have to use

header('Content-Type: text/xml');

to dictate that the content being delivered is an xml file and be handled by the browser appropriately