Information, News, Tables and Pictures on TV webbased

Hello,

I want to make a sort of ‘narrow-casting’ system for our small football club. I want to run it on our website. With a laptop I want to visit the page. Then a want the laptop to send the video to a TV that is in the canteen. The site has to show banners of our sponsors, news, competition tables and so on.

I was thinking of a website with php and mysql. The site must be easy to update with new pictures and information.
Is there something to start from? Can someone give me some ideas how to start or get me going?

Kind regards,

Robin

To answer this, I need more information from you - what kind of content are you thinking of putting on the TV? (i.e. static pages, or videos?).

Either way, your simplest choice is PHP/MySQL on the backend and JavaScript to dynamically refresh content on the page.

We want to put local news on the site. Every 20 seconds a new news-message. We want the last twitter @mentions on the page static. We want the sponsor-banners to change every 10 seconds.

Can you help me out? A link to a tutorial or something? How do you normally call such a system?

Okay. You’ll definitely need JS (and a set of methods commonly used in it called AJAX) to refresh the page.

For the rest, the Twitter part is a simple matter of using their API. This should be trivial for any developer to do.

For the local news part… local as in “your news” or “news from a provider around somewhere”? If it is your news, do you already have a framework for the distribution of those? If not, you’ll need to think about how to lay this one out, and on this one, a consultant/freelancer may help you. If you’d like to avoid India, drop me an email and we can think this one through together.
If you already have a content distribution platform somewhere, ask them if they have an API that would allow you to read the news from them. If they don’t, you’ll need to build a scraper and pull the news from somewhere already visible. If they do, you’re golden.

This is all relatively trivial. Sadly, I do not know of a ready-made CMS that would allow this out of the box. You may be better off writing your own - or getting someone else to write it.

If you plan on writing it from scratch, here are a couple of useful resources:

Sponsor our Newsletter | Privacy Policy | Terms of Service