I gang

Relational database in Mysql + PHP for handling company and related contacts

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

Færdigheder: Database Administration, MySQL, PHP

Se mere: relational database mysql, related companies, c# database mysql, advanced excel 2013, what is database management, webb, relational, name it company, Mysql php, Import and export, export mysql, companies database, update mysql csv php, mysql excel export, php import excel file mysql, excel file mysql, php excel export csv, mysql else insert, php table csv, excel add csv import, mysql search table, mysql update else, mysql function update, delete mysql tables, import database excel mysql

Om arbejdsgiveren:
( 45 bedømmelser ) G?vle, Sweden

Projekt-ID: #4098315

Tildelt til:

Days

Hello my friend, Will be a pleasure to provide you this job. Please give me this opportunity. Regards, Days.

€80 EUR på 1 dag
(18 bedømmelser)
3.8

18 freelancere byder i gennemsnit €186 for dette job

denisCh

Please check PM

€200 EUR in 5 dage
(62 bedømmelser)
7.5
ambar

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 Freelance Mere

€225 EUR in 7 dage
(81 bedømmelser)
7.2
soumyadeb

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 Mere

€200 EUR in 10 dage
(33 bedømmelser)
6.0
metodi25sl

Ready to do it

€165 EUR in 12 dage
(68 bedømmelser)
6.0
TheInnoVibes

Please check private message

€200 EUR in 4 dage
(35 bedømmelser)
5.7
phpxpert89

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 compa Mere

€200 EUR in 8 dage
(23 bedømmelser)
5.6
phpprogramming

please check PM for details

€110 EUR in 2 dage
(41 bedømmelser)
5.6
jcodemasters

Will be done.

€100 EUR på 1 dag
(47 bedømmelser)
5.5
coolrankit

------ 2YEARS EXPERIENCED PHP, WORDPRESS, HTML, CSS & WEB DEVELOPING EXPERT ------

€150 EUR in 3 dage
(19 bedømmelser)
5.1
Butterfly718

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!!

€120 EUR in 2 dage
(35 bedømmelser)
4.6
svipl7

Hello we are 8+ years old web-development company. please check our portfolio for more details. thanks

€500 EUR in 14 dage
(10 bedømmelser)
4.6
neeraj24a

Hello Sir, I have seen your requirement and i can complete your task in 2 days. Please check your PMB for more details. Thank You

€150 EUR in 2 dage
(3 bedømmelser)
3.6
codeware1

Hello Sir, Hope you are well and doing good!!! we are eager to work with [url removed, login to view] are ready to start the project right away. Codeware is a website development company providing professional website design, web Mere

€225 EUR in 7 dage
(9 bedømmelser)
3.5
spencetech

Located in Iowa (US) and available via Skype and Email throughout course of the project. I am quoting a very simple UI (no graphic design) with login required to add/edit/remove company or contact information.

€200 EUR in 2 dage
(5 bedømmelser)
2.8
lucentasolutions

I am interested in this project and ready to start work.

€200 EUR in 5 dage
(2 bedømmelser)
0.0
poonaminfo

I am interested in this job.

€100 EUR in 5 dage
(0 bedømmelser)
0.0
VysakhV

Ensure completion in time

€200 EUR in 10 dage
(0 bedømmelser)
0.0
futureworks20

Hello, Please check your PM. i am going to bid on your project. I have applied for your job. I can do this please give me chance. Thanks

€250 EUR in 15 dage
(1 bedømmelse)
0.0