topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

server-webapi-code-03-onPageWidget.php / php



  <?php
  function getStories(count, source = "")
  {
    titleLength = 25;
    storyLength = 100;
    if(source == "")
    {
      query = "SELECT `title`, `content`, `link` FROM 03_feed_raw ORDER BY `date` DESC LIMIT count";
    }else
    {
       query = "SELECT `title`, `content`, `link` FROM 03_feed_raw WHERE source = 'source' ORDER BY `date` DESC LIMIT count";
    }
    echo query;
    stories = getAssoc(query);
    foreach(stories as &story)
    {
      story['title'] = substr(strip_tags(story['title']), 0, titleLength);
      story['content'] = substr(strip_tags(story['content']), 0, storyLength);
      echo ".";
    }
    return stories;
  }
  
  function printWidget(count, source = "")
  {
   stories = getStories(count, source);
   foreach(stories as story)
   {
     echo "<a href=\"{story['link']}\">{story['title']}</a><br>\n";
     echo "<p>{story['content']}</p>\n";
   }
  }
  
  ?>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.