Find Jobs
Hire Freelancers

66814 SQL Database with PHP

N/A

In Progress
Posted over 19 years ago

N/A

Paid on delivery
Need a little script like a simple php member script as described: I want to store datas like: Surname Lastname Company Town of company registration Registration number date of founding ebay-id paypal-id - if a private and not business: - date of birth town of birth Street Address Postbox Address ZIP City State Country Phone Fax Domain CEO of the company Founded in year Company deleted in year bank and account no. (up to 10 bank accounts) Data created at Last modification by -username- Date of last modification Comments to this company -number- Last comment added by -username- Date of first comment Date of last comment Number of comment-feedbacks by owner -number- Date of first comment feedback by owner Date of last comment feedback by owner Number of positive comments Number of negative comments Number of neutral comments percentage of positive / negative and neutral comments It must be possible to save up to 5 addresses and up to 100 domains and up to 20 CEOs per data. The comments and feedbacks must be added up to an unlimited number of entries. These are the fields I need to save. Now I need a search function for public requests, where user can search for: 1. Search argument: CEO or Domain or Company ID or Lastname or Company name - and - 2. Search argument: Country or ZIP or town For public requests both fields are necessary These public request must only deliver: number of entries found according to this search request Now that´s all for the public area Then I need a member area Only members can search by all database fields and combine up to 3 search fields like: lastname or company and town When the search is done it must be display: Number of entries found and a list with the found entries sorted by the fields the user searched for like: companyname, ceoname, city Behind each entry a link must be shown -view details- -view details and reports- When the user clicks on view details the full entry is shown including the summary of positive and negative feedbacks and a link -view reports- When the user clicks on view details and reports or - view reports the comments saved to the company including feedbacks are shown additional to the basic data entry. A user can only view details or reports when his account has a psoitive amount. For requesting details a amount must be payed from the users account. for showing details and reports a higher amount has to be payed by the user or an additional amount for clicking on view reports when details already shown. A button add comment must be included. For adding a comment the user gets an amount. If the search was negative a button is shown "create entry" - so the user can create a company entry. For creating an entry a amount is given to the user - for adding an comment an additional amount is given. That´s the member area. At last a company owner can get access to his company data only for wrting feedbacks. He had to registrate and to pay an amount for signup and for each login. He can activate a function: notify me by mail when a comment according to my company is written. The mail is only sent when he has a positive amount in his account. Each email costs an amount. The company owner can´t use the functions a user can use only viewing comments and give a feedback and can add an dataset named actuall address submitted by owner where he can enter all basic entries like creating a dataset. This didn´t update the stored dataset - is only saved additional to the stored dataset. When a search is made both are searched (the original dataset and the updated set). Each entry must have an unique number and the number must be displayed in the search results. So a user can deteced duplicates on his search or if a search matched differnt criterias. A user can also activate the function: notify me when dataset about -unique companyid- is modified. For each email notification a amount must payed from the users account. Signup: when anyone signup the system he must enter the follwing datas: Surname Lastname Street ZIP City State Country Phone Fax Mail bank account business or private (selectable) signup for adding feedbacks to comments on my own company - or - signup as member After signup a confirmation mail is sent with must be clicked for getting access. First the user had to pay some money in his account to make things that cost anything. For refering an other user by an referal link the user gets a percentage of the money the refered user had to pay. user gets username and password by mail. when user enteres his mailaddress or username his account data will be sent to him by mail (password forgotten function). Counter for: total searches, total entries, total comments, total feedbacks, total companyower-accounts, total user-accounts. Admin: can add amount to a user, can add visible / invisible comment to a user, can add / modifiy / delete all entries. Each feedback or comment and dataset creation must be approved by admin before showing to all. Website-button: a companyowner-account holder can add a button to his website where the percentage of positive / negative and neutral comments on his company are displayed. When this button is clicked the user is directed to a site with two links: show full company profile - or - add comment (both only possible if the user has already an useraccount or signs up for an useraccount). All in all a simple sql store and search system.
Project ID: 1815003

About the project

1 proposal
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, I would like to work on your project, I find it interesting for me. My subject is web-development with PHP/MySQL background.
$50 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of
5.0
10
Member since Jul 21, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.