Đã hoàn thành

144872 Crontab + PHP Job Needed

This is a pretty simple project, shouldn't take more than a couple hours (if that), do not mistake my thorough explanation for project value (I'm just a guy who likes to comb through every detail beforehand). I've been a web designer for 9 years and have managed several programmers under me during that time. I'll take whichever bid matches what I consider the value of the project, and seems trustworthy.

I currently have a top 10 font download list displaying on the right sidebar of every page that changes based on which category you're viewing (it will show the top 10 out of the entire db if you're not in category view).

In an effort to minimize the number of MySQL queries being run on the page, I'd like for a cron job (that you will write) to HOURLY run a php script (that you will also create) which calculates the top 10 overall, and top 10 of each category, and saves the lists as static .html files that I can include into my pages.

There are 16 categories overall so there should be 17 .html files being generated based on the category IDs, for example:

[url removed, login to view] (overall top 10)

[url removed, login to view] (brush font top 10)

[url removed, login to view] (cartoon font top 10)


[url removed, login to view] (western font top 10)

The list in each of these html files should be formatted the way I will describe to you. They will be plain text with a link and a div tag seperating each of them.

The way the counting works the MySQL is, there's a 'font' table, and a column on that table called 'count' - the value in this column increases by 1 each time somebody downloads this particular font. There's another column called 'catid', this number refers to the 'id' of the category (defined in a different table called 'category') the font is listed in.

I believe that's all you need to know to produce the script and crontab. Post on the PMB if you need more information or clarification.

Kỹ năng: Bất kì công việc gì, PHP

Xem thêm: what web designer should know, what needed to be a web designer, what is job id, web designer job post, web designer job needed, view job, top 10 programmers, should i take the job, project list in php, post a job web designer, php catid, need programmers job, me into a cartoon, job matches, job id, job categories, create my cartoon, create me cartoon, create cartoon of me, create cartoon me, category php id, cartoon categories, a web page designer job, all job categories, 10 top job

Về Bên Thuê:
( 50 nhận xét ) Calgary,

Mã Dự Án: #1891048

Đã trao cho:


Hi there, I can do it for you. escrow needed.

$50 USD trong 0 ngày
(341 Đánh Giá)