/    Sign up×
Community /Pin to ProfileBookmark

Live Feed

Copy linkTweet thisAlerts:
Sep 26.2012

Hi, i want to add a live feed to the home page of my website, that captures the following activities for all people who use my site:

  • – $username has just joined

  • – $username has just updated their email address

  • – $username has just changed their photo

  • – etc…

    • How should i go about capturing all of these? I have created a spreadsheet listing all of the activities that i want to capture… so should i just add an activity to a live-feed table in the database, each time one of these activites occure

    ========

    LIVE-FEED
    ========


  • – id

  • – timestamp

  • – activity_desc

    • Do you think this is the best way to set up / run the live feed, thanks in advance

    to post a comment
    PHP

    1 Comments(s) ↴

    Copy linkTweet thisAlerts:
    @hastxOct 02.2012 — your strategy sounds resonable...You will also need to add a userID field to know which user performed the action.

    You could also expand on your activity table to get more granular:

    ACTIVITY:

    ID

    UserID

    TimeStamp

    Action

    Affected

    then values would be inserted: ('HamHock','0000-00-00 xx:xx:xx','update','profile_pic')

    The reason ID is different from UserID is incase you wanted to show multiple profile updates within a time frame, rather than just showing the last update from the user...this would allow you to say "HamHock updated their pic and email address..."
    ×

    Success!

    Help @oo7ml spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 — BETA 5.18,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @AriseFacilitySolutions09,
    tipped: article
    amount: 1000 SATS,

    tipper: @Yussuf4331,
    tipped: article
    amount: 1000 SATS,

    tipper: @darkwebsites540,
    tipped: article
    amount: 10 SATS,
    )...