I need a simple PHP aplication with a simple Admin and front end.
On the admin side, we will be able to import an csv or xml file to a mysql database (secure connection via config.php file required)
The front end side is not more than a Top 10,20,50 ranking of the similar data count imported on the database. And a search box for any visitor write his name or a code to see a result from the data.
Example:
the xml or csv file stores the following data:
Name,RefferCode,IP
Once loaded on the mysql database via Admin (every upload replace all results) on the front end there will be a chart with the results with one filter to see the top 10, top 20, top 50, top 50 Results.
The results will be the sum(add count) of each duplicate RefferCode asigned to an unique IP + Name, Example:
ROWS on DATABASE
Name RefferCode CODE
Jhon (NULL) 30.12.11.20
Albert 30.12.11.20 80.45.11.20
Matt (NULL) 50.11.55.55
Charles 30.12.11.20 54.55.11.55
Jane 50.11.55.55 80.55.12.90
Result public Ranking Top 10. Top 20,
Position Name CODE Points
1 Jhon 30.12.11.20 2
2 Matt 50.11.55.55 1
3 Albert 80.45.11.20 0
4 Charles 54.55.11.55 0
5 Jane 80.55.12.90 0
Position will be determinated by the most points
Each point will be given by every single equal RefferCode count on the Database on the ReferCode Column
Then, on the result top ranking page there will be a box for every visitor searh their points writing down their code.
