Build a Database

進行中 投稿 Dec 2, 2015 着払い
進行中 着払い

I want to create a database that will store data about every visitor session in my website.

A. The data should include:

1. General data such as:

-Date and time of visit

-IP address

-browser info

-entry page URL

-exit page URL

-time spent in the website

2. Several designated columns, for certain url strings that the visitor might have arrived with:

Example:

A visitor arrives to "[login to view URL]",

I want to strip down the "?source=partner1&adtype=banner" from the URL address bar (which can be done with a 302 redirect).

Simultaneously, I want to store the "source=partner1" and "adtype=banner" values in the session data,

and have in database designated columns named "referrer" and "type of ad", that would contain the values "partner1" and "banner" under that session׳s row.

3. Actions which the visitor took on the website, probably ‫ in the form of events (Note that this is dynamic data that should be updated while the session is ongoing)

Example:

I have a "more info" button that pops up a modal window. If I a visitor clicked that button, I want it to be indicated in the database.

4. Unique Identifying number:

Each row in the database be given a unique identifying number or value (that should never repeat again).

B. I am also strongly interested in the option of having that database communicate with another external data source, in the form of an automatic XML request every 30 minutes to that external source, and look up the aforementioned unique identifying number, and in case it finds it, it should import the content of another field which correlates with this number in that XML output (I have the relevant information and access keys in order to make a manual XML request from that source).

C. General :

- I am thinking about having such a database separately for each month of the year.

- In general I am open to any of your advice and suggestions about the optimal way for building this whole project.

- I would like to be able to view the database with Microsoft Excel so I can analyze it occasionally and draw conclusions about user behavior.

- I need the database to be flexible in case I would like to add more data columns to it in the future.

- I also want to know if it will be possible to manually edit and modify the database from a friendly excel-like interface (though without running over new data that was generated by new sessions while I was modifying older sessions).

- I will also need a basic explanation about how the code works and what every line of code does, perhaps, in the form of comments within the code.

- The database should not slow down the website.

- It should be stored in a secured way to prevent it from being obtained by unauthorized sources.

The website was not originally built using any platform (such as wordpress), It was built from scratch from HTML and some PHP.
It is hosted on a VPS server with a Cpanel.

eコマース JavaScript jQuery/プロトタイプ MySQL PHP

プロジェクトID: #9025560

プロジェクトについて

17個の提案 リモートプロジェクト アクティブ Dec 5, 2015

17人のフリーランサーが、平均$230 で、この仕事に入札しています。

techwelfare

Dear Sir we are capable of performing the required task perfectly with accuracy, please let us know if you want to clarify in details.. if you want us to share our skill and previous work please initiate the chat b もっと

$209 USD 5日以内
(187件のレビュー)
7.3
flaxweb

Hello Sir, We have studied all of the requested features very closely, and we have one question. Q : Can you kindly explain point "B": B. I am also strongly interested in the option of having that database commu もっと

$611 USD 16日以内
(50件のレビュー)
6.4
phpmagic

This is really a amazing job. I worked with Website Development in 8 years. Please work with me to solve them out. Thanks!

$250 USD 10日以内
(75件のレビュー)
6.5
florinbacu

A proposal has not yet been provided

$500 USD 30日以内
(36件のレビュー)
6.1
cowboy14

Hello sir, Which platform do you use ?? I mean Wordpress, Magento, Shopify or what ?? Waiting for your reply. I have done such thing before but i need to know about your platform. Thanks, Sakib

$200 USD 0日以内
(95件のレビュー)
5.7
davidphp5

Hi, I can do this project for you. Please check my profile, and if you\'re interested, contact me with more details! Best regards, David

$150 USD 6日以内
(47件のレビュー)
5.6
sainulabidnv

Hi, I have reviewed your project details and I would like to work on this, please send me the details. Please come over to a conversation so that we can have a better discussion. regards sainul

$250 USD 5日以内
(35件のレビュー)
5.4
Climaxwares

Dear Employer , we have been in this industry for 7 years and such jobs are our daily practice in separate. This is our first time on this site and hence you can see that we do not have any ratings/testimonials to sh もっと

$111 USD 1日以内
(17件のレビュー)
5.0
zExcel

A proposal has not yet been provided

$250 USD 3日以内
(15件のレビュー)
5.2
secureway

​Hi, ​Good Day!! ​ I reviewed your post and It is doable. Thanks for the details. We can easily deliver with our certified ​developers​ But it will be great if we can discuss/chat a bit more. ​​​​​​ We are new in もっと

$155 USD 3日以内
(7件のレビュー)
3.8
sumeet00

A proposal has not yet been provided

$155 USD 3日以内
(レビュー1件)
1.2
xcellentpiyush

I have worked in MNC for 2 years and within this short period of time i have gained enough appreciations from my managers and lead. I will provide quality work.

$155 USD 3日以内
(0件のレビュー)
0.0