Sedang Disiapkan

Build a Database

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 "[url removed, login to view]",

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.

Kemahiran: eDagang, Javascript, jQuery / Prototaip, MySQL, PHP

Lihat lebih lanjut: xml data entry form, what is manual data entry, what is a data entry form in a database, what is a banner ad, microsoft project import, microsoft access data entry form, make a banner ad, i want to create a database website, info data entry works, how to create data entry form in excel, how to create banner ad, how to create a data entry form in excel, how to create a data entry form in access, how to create a data entry form, how to create a banner ad, how to build a banner ad, excel automatic data entry form, data entry form without excel, create an access form for data entry, create a banner ad, automatic data entry in excel, outlook add automatic email forward, excel database creator add, database virtuemart add attribute installation, add image product oscommerce upload option

Tentang Majikan:
( 3 ulasan ) Tel aviv, Israel

ID Projek: #9025560

19 freelancers are bidding on average $212 for this job

alifinteractive

Dear Client, We have a great team of expert coders and responsive website designers in New Delhi [url removed, login to view] have many satisfied clients all over the [url removed, login to view] already have successfully launched many eCommerce,blog, socia Lagi

$263 USD dalam 8 hari
(104 Ulasan)
7.2
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 Lagi

$209 USD dalam 5 hari
(127 Ulasan)
6.8
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 Lagi

$611 USD dalam 16 hari
(50 Ulasan)
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 dalam 10 hari
(72 Ulasan)
6.4
vamir

Dear Hiring Manager, I have 6 year experience and my skill are: Web Developer & Designer (Wordpress, Core php, Magento, joomla, Prestashop, drupal, Responsive, Bootstrap) You can check my feedback and my rehire r Lagi

$147 USD dalam 4 hari
(126 Ulasan)
6.3
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 dalam 6 hari
(46 Ulasan)
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 dalam 5 hari
(32 Ulasan)
5.1
prprojectsl

Dear Employer, I have just seen your changed requirement. This is okay with me. I can go ahead. I have read and understood your concept regarding this system. I have planned to develop this project with agile mod Lagi

$177 USD dalam 3 hari
(32 Ulasan)
5.3
zExcel

A proposal has not yet been provided

$250 USD dalam 3 hari
(14 Ulasan)
5.1
swsinfotech

Hi, I have read Your WEBSITE project description. i can do work as per ur requirment. I will Provide you with Great Options I am here for long term work relationship so will give 101% best output from my end so Lagi

$250 USD dalam 5 hari
(15 Ulasan)
4.6
ATLASFSD

Hi, I'm a software and web developer with more than 8 years of experience in PHP, MySQL, JavaScript, CSS, HTML/HTML5, C++, C#, Java, and Apache. I believes in harnessing the power of technology to make websites smarter Lagi

$75 USD dalam 2 hari
(19 Ulasan)
4.3
webexpert24hr

Hello, Thank you for giving me the opportunity to bid on the project posted by you and I am very interested in your project. I am web designer having more than 5 years experience in Website Designing/Development. Lagi

$77 USD dalam sehari
(6 Ulasan)
3.9
florinbacu

A proposal has not yet been provided

$500 USD dalam 30 hari
(20 Ulasan)
4.3
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 dalam 0 hari
(18 Ulasan)
4.1
Vikramsoni12

Want to see your idea brought to life? Whether you have a stick figure on a napkin or an entire work flow diagram laid out, I can make your dream come true! My greatest advantage is that I am reliable. I just went Lagi

$35 USD dalam 7 hari
(15 Ulasan)
3.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 Lagi

$111 USD dalam sehari
(5 Ulasan)
3.5
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 Lagi

$155 USD dalam 3 hari
(6 Ulasan)
3.8
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 dalam 3 hari
(0 Ulasan)
0.0
sumeet00

A proposal has not yet been provided

$155 USD dalam 3 hari
(0 Ulasan)
0.0
TheSkillAgents

I am ready to start this project now. We can discuss anytime about this project. I will do my level best as you wish. Thank you.

$155 USD dalam 3 hari
(1 Ulasan)
0.0