Build a Database
$30-250 USD
着払い
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.
プロジェクトID: #9025560
プロジェクトについて
17人のフリーランサーが、平均$230 で、この仕事に入札しています。
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 もっと
This is really a amazing job. I worked with Website Development in 8 years. Please work with me to solve them out. Thanks!
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
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
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
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 もっと
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.