Write some Software

I have a small MySQL database which contains the following rows: 1. URL to the TV channel (supported streaming protocols: RTSP, RTMP, MMS, HHTP , M3U8) 2. Country 3. Status It often happens that a TV channel stream is broken and it is too much work to check it manually at services like [login to view URL]<HERE-COMES-THE-STREAM-URL> Note: The online test player only works for rtmp and m3u8 files Maybe there are other solutions for testing all 4 protocols online, I have no idea. I only know that they can be manually tested with desktop tools like VLC Media Player, Winamp or Quick Time. Also it is very time consuming always search the web to find working streams for all countries. I need a script which fetches country TV channel streams (for all countries), checks if any existing stream in the database is broken and if so changes the status from "1" to "0". Either the fetched (only working) country TV channel streams should be added to the databases that the correct country will be chosen in the table or stored in a file (csv, txt) containing the country and then list the working TV channel streams. As mentioned the supported (required) streams can have the following format: RTSP, RTMP, MMS, HHTP , M3U8 I am not able to provide the sources for the country TV channel streams, so either you (the programmer) knows the best sources or knows a way how to search for those streams. It can be a php script which runs automatically on the server using a cron job or one which I can manually run daily on my PC.