Small project to manage radio urls. - repost

The project or application will be hosted on single folder. /public_html/radios

So all php files and xml/plist will be in root (of radios folder).

The host provider allows user to schedule scripts in crontab.

Description:

The project consists of two parts:

1- Creation of a php script that will run in crontab everyday on a weekly basis.

The script will read all url sites from “radiostations” table in ‘station_urls’ field.

It will ping every url and it will update ‘is_live’ field in “radiostations” [url removed, login to view] will update to TRUE if url is live or FALSE if not. It will do that for every single entry in radio stations table. Check [url removed, login to view] file to understand the database structure.

2- The second part consists of a creation of [url removed, login to view] file that will manage the radio urls from the [url removed, login to view] check “manager”[url removed, login to view]” for html layout.

The main combo box allows you to select a specific radio station from radiomain table. It will read content from radio_name field.

If the user clicks on Go. The page will be refreshed and the list of radio stations will be displayed on the screen. The station name, station url and station type will be presented inside a text field. The user can click on radio button in the left, update the content if he wants to and then click on Update button in order to update in database.

If the user wants to delete a radio, he simply select it (first column of table - radio button) and then click on Delete button. The row selected will be deleted from database.

If the user wants to create a new radio, he needs to click on “Create New” button. It will create an entry in radio stations table.

Don’t need to worry about creating a page for radioman. It will be a must if it is created but for this table, i can input the radios by my own. Most of the fields in there will not change.

If you check [url removed, login to view] file you will see two button at the bottom. The first one called “SAVE to PLIST” saves the radio content in plist file format. Please check the template of the file attached (you can check [url removed, login to view],etc.).This file will be overwriting or saved in root folder. The file would have the name composed by data_+(“radiomain.radio_name” field).plist. For example: if you have radioman.radio_file=“80s” in the database, if you export the file to PLIST. It will be saved as data_80s.plist.

The same thing for SAVE to XML. It will save the radio list in a different format (please check [url removed, login to view] for example). However it will save the file as strings_+(“radiomain.radio_name”). Example: strings_80s.xml.

PS: Both php files (radio content manager and crontab php file) will be placed under the same directory that the xml file and plist file are. The Radio content manager file will overwrite xm and plist file keeping current format. These xml and plist files are attached below...

Pre-requisites:

Be a professional php programmer.

Know how to use json and save the files in the template provided.

PS2: I will provide the mysql database structure. So dont need to worry about database modeling.

Please check the scope below. There is also a screenshot of manager.php file.

MySQL PHP Arquitectura de software

Nº del proyecto: #5344694

Sobre el proyecto