Đã hoàn thành

Improve my PHP script

I have a PHP script (attached) that is fetching traffic information about specified websites from Alexa database via Amazon Web Service (AWS) and make .csv output.

I need to adjust the script in three points:

1) to change the format of the output - global rank for each domain should have separate line:

Example - at the moment the format of output looks like this ([url removed, login to view] example):

Site URL; Global Rank;Country name; Rank;% of Views;% of Users

[url removed, login to view];255367;Myanmar;6599;3.4%;11.5%

[url removed, login to view];255367;Thailand;7176;44.9%;28.1%

The new format should look like this:

Site URL; Country name; Rank;% of Views;% of Users

[url removed, login to view];Global;255367;xxx%;xxx%

[url removed, login to view];Myanmar;6599;3.4%;11.5%

[url removed, login to view];Thailand;7176;44.9%;28.1%

2) to add a new parameter to each line: change of rank over the past three months

Example

Site URL; Country name; Rank;% of Views;% of Users;3M Change

[url removed, login to view];Global;255367;xxx%;yyy%; +1,957

[url removed, login to view];Myanmar;6599;3.4%;11.5%;-123

[url removed, login to view];Thailand;7176;44.9%;28.1%;+366

3) to add a new option for domains input - the script should be able via PHP and SQL make query on table in mySQL db and get a list of domains

Example:

$result = @mysql_query('SELECT * FROM domains ORDER BY domain ASC’)

$numofrows = mysql_num_rows($result);

for($i = 0; $i < $numofrows; $i++) {

$row = mysql_fetch_array($result);

-> get the values for each domain from alexa

}

Kĩ năng: PHP, SQL

Xem nhiều hơn: php optimization tools, php performance tuning tools, php advanced programming, advanced php programming tutorials, how to optimize php script to increase speed, php tricks for beginners, php tips and tricks advanced, improve php performance, http www2 scielo org ve scielo php script sciarttext&pid s1317 58152006000100006&lng es&nrm i, i need a php script for ecurency business, php script football manager improve, i`m looking php script rent villa, php script read attached file, php script attached file attached, attached file email php script, php script email attached, php script attached file mail, php script play attached mp3, send attached file mail php script, php script send attached files

Về Bên Thuê:
( 1 Nhận xét ) Zlin, Czech Republic

ID dự án: #16746396

Được trao cho:

liangjongai

Hi, sir I have a detail look to your project, I have a great skill in php and sql. I'm sure I can complete your project. My price and period is negotiable. We can discuss the details via chat. Thanks.

€100 EUR trong 3 ngày
(195 Đánh Giá)
7.1

19 freelancer đang chào giá trung bình €113 cho công việc này

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W Thêm

€222 EUR trong 3 ngày
(202 Nhận xét)
8.5
octopus823

How are you? I am very interested in your project. I have read your proposal carefully. I have much experiences in developing PHP. I am ready to develop your task. Please contact with me in details. Best regard. Thêm

€166 EUR trong 3 ngày
(145 Nhận xét)
8.5
onedeepen

Hello, I can do the changes to the script, if we can discuss further over chat in detail. I have 10+ years of experience in asp, asp.net, php, wordpress and many other CMS and frameworks. regards, Deepen

€100 EUR trong 3 ngày
(158 Nhận xét)
7.0
NayaPakistan

Hello, I have gone through the details of your project regarding improvement in your PHP Script which fetches traffic information about specified websites from Alexa Database. Please send me a message to get started!

€75 EUR trong 2 ngày
(224 Nhận xét)
6.5
ludwig333

hello i have read your description very carefully/ i am full stack web developer i can do your job in time

€155 EUR trong 3 ngày
(20 Nhận xét)
5.6
jonyahmed105

Hi I can update your PHP code. I want to do it as look like done professional for you.. looking forward. Thanks

€155 EUR trong 3 ngày
(90 Nhận xét)
5.9
€138 EUR trong 15 ngày
(27 Nhận xét)
5.3
abhi98041

I am a php expert and i can do your job. I can start immedaitely and can complete on time. Please check my reviews.

€34 EUR trong 3 ngày
(83 Nhận xét)
5.2
CreativeExpertIT

Hello Sir, Hope you are doing well.. Our Skill is completely match with job [login to view URL] allow us to prove our good [login to view URL] are team of young & experience [login to view URL] have an experience of 7+ years and hav Thêm

€155 EUR trong 3 ngày
(41 Nhận xét)
4.7
aromaticdeal

HTML [login to view URL] [login to view URL] ==PHP/MYSQL,JAVASCRIPT,CSS,HTML/Bootstrap== [login to view URL] [login to view URL] [login to view URL] [login to view URL] Thêm

€155 EUR trong 3 ngày
(15 Nhận xét)
3.4
Aramics

A proposal has not yet been provided

€55 EUR trong 2 ngày
(3 Nhận xét)
2.6
meera6533

i will do iti will do iti will do iti will do iti will do ii will do iti will do iti will do iti will do iti will do itvvvti will do iti will do iti will do iti will do iti will do it

€34 EUR trong 3 ngày
(4 Nhận xét)
2.3
manojtacty

I have seen your complete job post and I got exact idea of your need. I have worked on similar kind of script earlier and also working on PHP script for CSV file. Please share your best discussion time to move further.

€55 EUR trong 3 ngày
(1 Nhận xét)
1.4
ossy

I am a web developer and expert in wordpress, PHP, Javascript, HTML5, Bootstrap expert, i would be most glad to help you modify your application according to your expectations, would appreciate if you consider me for Thêm

€155 EUR trong 3 ngày
(0 Nhận xét)
0.0
CodeApex

Hello, I am PHP Professional and will adjust the script in three points as per given. If we can discuss these 3 points in detail then will provide a exact solution. Assure quality of work within your cost & time. Thêm

€100 EUR trong 3 ngày
(0 Nhận xét)
0.0
Soumi002

A proposal has not yet been provided

€30 EUR trong 3 ngày
(0 Nhận xét)
0.0
singhlalit8006

html css php wordpress Relevant Skills and Experience html php wordpress css

€155 EUR trong 3 ngày
(0 Nhận xét)
0.0
ivanes75

Hi. I can do it. you can contact me to discuss the details. I have experience in solving such problems.

€111 EUR trong 2 ngày
(0 Nhận xét)
0.0