SqLite Database Query - Display Chart / Graph - PHP

Our goal is to display charts and graphs of our data on our website using “Open Flash Chart” charting code. This job requires creating a SQL query, output in JSON format and display of multiple “Open Flash Chart”.

** SqLite database


1. Create a SqLite database query: We will be plotting 4 points (one for each search engine) on a graph to show the daily website search ranking over time (daily, weekly). One chart for each website + keyword.

a. X axis = time

b. Y axis = page ranking

c. Plotted Points = different color for each search engine.

i. Google = Blue, Bing = Orange, Yahoo = Purple, Ask = Red.

d. Combine “PageNo” and “Rank” into a single number, we need to create this decimal for graphing display purposes. For example 3.4 for a website on search engine page 3 and result number 4.

i. “PageNo” represents the page number in search engine results.

ii. “Rank” represents the number within the page where the results are displayed.

1. Each search engine has a different number of results displayed per page – “Rank” should be rounded to a number from 1-10 for easy display.

2. Calculation

b. Number or records

c. time and date calculations

d. Percentage of change

3. Prepare data in JASON format to be read by “Open Flash Chart”

4. Chart will display data for one website per chart (multiple websites will be present in SqLite database)

e. X Axis (bottom): Time (per week with daily data) from “LoggedAt” column (date / time stamp)

f. Y Axis (side): Page rank calculated from “PageNo” and “Rank”

g. Plot 4 different lines, one for each search engine: Google, Bing, Yahoo and Ask

h. Apply labels

2. Display Statistics

a. Website URL

b. From Dates (first date to last date)

c. Google (repeat this for Bing, Yahoo and Ask)

i. Total Google clicks (total number of records for website + keyword + google)

ii. Average daily Google clicks (above divided by number of days)

iii. Percentage Change (total change in “PageNo” and “Rank” from first record to last)

5. Install the query code on our server and display charts on a Wordpress page.

SqLite databases contains a total of 7 columns of data: rowid, Link, Keyword, SearchEngine, PageNo, Rank, LoggedAt (date / time stamp)


Open Flash Chart allows you to add buttons to change the data / view. Could be used to represent multiple website / key word combinations. Also change the time period from daily to weekly to monthly

Kemahiran: MySQL, PHP, Kejuruteraan Perisian

Lihat lagi: sqlite php charts, chart sqlite, graphing sqlite data, sqlite chart, php sqlite chart, php sqlite graph, sqlite plot data, sqlite plot, sqlite query graph, sqlite graph php, create graph using sqlite php, php sqlite database display, sqlite database php graph, php display database sqlite, plot php sqlite, sqlite monthly graph, php graph chart database, php charts sqlite, display sqlite database php, query chart sqlite, php query link, google chart php sqlite, php display chart database, php chart query, graph php

Tentang Majikan:
( 13 ulasan ) Winter Springs, United States

ID Projek: #1529429

Dianugerahkan kepada:


I can set up a demo for you if you want. More details via Inbox. Regards, Mike

$35 USD dalam 25 hari
(27 Ulasan)

6 pekerja bebas membida secara purata $206 untuk pekerjaan ini


Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Lagi

$250 USD dalam 10 hari
(43 Ulasan)

Hello sir , I am ready for this [url removed, login to view]

$250 USD dalam 5 hari
(102 Ulasan)

php/mysql experienced

$250 USD dalam 2 hari
(13 Ulasan)

Please check PMB for more

$200 USD dalam 7 hari
(3 Ulasan)

Check PMB please.

$250 USD dalam sehari
(0 Ulasan)