Completed

Most Active User Stats

What I want to do is pull a list of online users from a file on my webserver (i will maintain the file and can make it show with tags before and after the username if that helps). I want these usernames to be added to a mysql database and if the username isn't already in there then to add it. I want to track how active each user is. I am ok with something like a database that just has the date and a tally count in minutes, so for example today is 6/5/2018 if i pull the user list every 15 minutes then the value associated to todays date of 6/5/2018 will have +15 added to it. I am just a novice coder so if you have a better way to hold a ton of activity data let me know. I then want to have a website that shows a list of the online users sorted by most minutes online in the last 7 days but also show the stat for minutes online in the last 30 days. I picture it going like this:

Code grabs userlist, checks if username is already in the database, if its not then it adds the username. It then checks to see if todays date is already in the database if not then it creates the table (or whatever its called) for todays date . The value of +15 is added to todays date to signify 15 minutes as the code should run every 15 minutes (I may change the frequency in the future). I figure i'll put this in a cronjob or something that runs every 15minutes?

I also want separate code for me to be able to search a username and have it calculate the number of minutes spent online in the last 7 days and last 30 days.

Skills: MySQL, PHP

See more: social media statistics, facebook users statistics, number of facebook users by country, how many people use facebook, facebook users 2018, facebook statistics 2018, facebook daily active users, how many facebook users 2018, most active freelance illustrator site, most active freelance design site, clipshare active user mysql, appstore active user, exchange 2010 wmi active user, mysql php user stats, penny bidding active user counter, create user stats, visual basic code active user winsock, purevolume user stats, phpbb2 rpg style user stats, phpbb3 user stats system

About the Employer:
( 0 reviews ) United States

Project ID: #17113777

Awarded to:

rits477

Greetings! I will like to work on this project. I am Web application and software developer having many years of experience. In past i have worked in various project so i have gain knowledge about implementing various More

$30 USD in 1 day
(1 Review)
1.5

10 freelancers are bidding on average $124 for this job

amrshawky35

Hi there, You'll need two tables in database, one is for the users that store unique username for every one and the other table is to store the online activity for each user (database relation here). Message me t More

$200 USD in 3 days
(95 Reviews)
7.0
vw8092236vw

I have 5 years of experience in web development . Feel free to contact me .........................

$100 USD in 3 days
(41 Reviews)
4.9
$133 USD in 2 days
(16 Reviews)
4.4
an1566706

I read your project description ……Most Active User Stats …..and we are very exited to work on it We are an group and we have an expert & qualified to accomplish your project in professional & unique We are wo More

$50 USD in 3 days
(22 Reviews)
4.5
sku5551ed6fd9643

Greetings! ***IMMEDIATE START*** I read your job requirements carefully. Your job profile completely matches my skills. I have got 4 years of work experience in working with MySQL, PHP for INTERNATIONAL CLIENTS More

$155 USD in 3 days
(9 Reviews)
2.9
davidmcu18

Hi Nice to meet u I have good skills about php and mysl I have developed for 5 years If u want me, I will work at the best I thanks to view my proposal I hope everything good

$111 USD in 31 days
(1 Review)
2.9
a2ztechno

​​With an overall experience of 12 years in creation and development of digital properties and online marketing activities, all my solutions are process based. With a customized solution that meets business objectives, More

$102 USD in 2 days
(4 Reviews)
2.1
$140 USD in 15 days
(1 Review)
0.8
ersiddharthshah

i ma having 2+ years of experience in java and salesorce.i did projects in java on spring,hibernate,javafx,image processing,data scrapping,audio library,jsp,servlets. What we can do is we can use separate field for More

$222 USD in 3 days
(0 Reviews)
0.0