Relational database in Mysql + PHP for handling company and related contacts
€30-250 EUR
Käynnissä
Julkaistu yli 11 vuotta sitten
€30-250 EUR
Maksettu toimituksen yhteydessä
I need a database mysql and management in php for the webb to handle companies and contacts related to them with import and export function ( excel or csv files )
The unique ID is AddressID
So I need 2 tables
One for the company details and one for the related persons both with datestamp
Import function needs to handle insert, update ( when I pick the file to import I want to have so I pick were the column should go example, company name to company name etc etc ( I have several thousands of files and they are not in the same order ) problably I need to have 2 imports stage one for the company details and one for the personal details and problably I need the unique ID to be in both tables for the easiest way to import personal details to the right company ( all details is in the same file ) ( see attached example file i have done easy header so you better understand what is what in the file and wich table it has to go to )
Example:
If I have the company in the database it should update the details and put the today date in the datestamp
If I have the person related to the company it should update if new details and put today date in the datestamp
Else if the company not exists create a new
Else if the person not exists for the company create a new
Then I need to have search function for all details and export from search results ( advanced search were I can add new conditions example OR, Contains, AND etc.)
The export should be one file with all the details from company and related persons
Also need delete function from search criterias
Dear Sir/Madam,
We are on Freelancer for last 7 years with NO INCOMPLETE projects. We have executed more than 50 projects and have gotten 5 out of 5 in all of them. Please check the feedback given to us on Freelancer and you will see that most of them are from repeat customers. It proves we are consistent and we are here to stay. Please check my private message for details.
Thanks
Shome
Hello Dear Employer,
I am a Custom PHP/MySQL developer. I have designed and developed, many websites on PHP amd MySQL. I have 4 years of total experience in IT industry, and had built popular applications with companies. I will include some top websites from my portfolio in a private message, please check my private message.
Thank you!
I am very much interested for that job. I submitted details proposal in your pmb. So please check it and let me know if I need to give further suggestion or clarification. So if I get some response from your end would be very much appreciated.
Hello sir.
I read all your requirements.
And i am good at all that.
Please check attached doc for my previous works.
Hope to hear from you soon.
Thanks!!