TalkPHP - View Single Post

adamdecaf · 07-03-2009, 05:56 PM

I don't see an API, if they have one it would be the answer to this question.

*EDIT*

Alright This should get you started.

PHP Code:


			
<?php
// Set the detauls
    $hostname = "db1932.perfora.net";
    $dbname = "db291144085";
    $username = "dbo291144085";
    $password = "qNwx9kTX";
    
// Now grab the lastest item
$connect = mysql_connect($hostname, $username, $password);
    mysql_select_db($dbname);
    
    // build the query.
    $sql = "SELECT * FROM items ORDER BY id DESC LIMIT 1";
    $query = mysql_query($sql);
    
    // Now make it an array
    $query = mysql_fetch_array($query, MYSQL_ASSOC);
    
        // A Little Debugging
        // print_r($query);
        
    // Now we can take the query and treat it like an array
        echo "Title: <a href='" . $query["item_permalink"] . "'>" . $query[item_title] . "</a><br />";
        echo "Content: " . $query["item_content"] . "<br />";
        echo "Time: " . $query["item_date"] . "<br />";

?>

A sample response is:

Code:

Array
(
    [ID] => 1
    [item_date] => 1246652528
    [item_content] => Whats up?
    [item_title] => Hello World
    [item_permalink] => 
    [item_status] => publish
    [item_name] => hello-world
    [item_parent] => 0
    [item_data] => a:0:{}
    [item_feed_id] => 0
)

Example: http://open.ashannon.us/junk/sweetcr...-sweetcron.php

*Notes*
I have to give the guy who created this a LOT of credit, he has tons of features. I think that he lost interest or didn't have and visible support so he stopped this project, but it's a great system. I would recommend it if you like the demo.

07-03-2009, 05:56 PM	#2 (permalink)
adamdecaf The Addict Join Date: May 2009 Posts: 308 Thanks: 5	I don't see an API, if they have one it would be the answer to this question. EDIT Alright This should get you started. PHP Code: <?php // Set the detauls $hostname = "db1932.perfora.net"; $dbname = "db291144085"; $username = "dbo291144085"; $password = "qNwx9kTX"; // Now grab the lastest item $connect = mysql_connect($hostname, $username, $password); mysql_select_db($dbname); // build the query. $sql = "SELECT * FROM items ORDER BY id DESC LIMIT 1"; $query = mysql_query($sql); // Now make it an array $query = mysql_fetch_array($query, MYSQL_ASSOC); // A Little Debugging // print_r($query); // Now we can take the query and treat it like an array echo "Title: <a href='" . $query["item_permalink"] . "'>" . $query[item_title] . "</a><br />"; echo "Content: " . $query["item_content"] . "<br />"; echo "Time: " . $query["item_date"] . "<br />"; ?> A sample response is: Code: Array ( [ID] => 1 [item_date] => 1246652528 [item_content] => Whats up? [item_title] => Hello World [item_permalink] => [item_status] => publish [item_name] => hello-world [item_parent] => 0 [item_data] => a:0:{} [item_feed_id] => 0 ) Example: http://open.ashannon.us/junk/sweetcr...-sweetcron.php Notes I have to give the guy who created this a LOT of credit, he has tons of features. I think that he lost interest or didn't have and visible support so he stopped this project, but it's a great system. I would recommend it if you like the demo. __________________ My Site Last edited by adamdecaf : 07-05-2009 at 11:28 PM.