Käynnissä

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

Taidot: Tietokannan hallinto, MySQL, PHP

Näytä lisää: 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

Tietoa työnantajasta:
( 51 arvostelua ) G?vle, Sweden

Projektin tunnus: #4098315

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

€225 EUR 7 päivässä
(198 arvostelua)
8.9
TheInnoVibes

Please check private message

€200 EUR 4 päivässä
(580 arvostelua)
8.5
denisCh

Please check PM

€200 EUR 5 päivässä
(88 arvostelua)
7.5
phpprogramming

please check PM for details

€110 EUR 2 päivässä
(203 arvostelua)
6.8
jcodemasters

Will be done.

€100 EUR 1 päivässä
(58 arvostelua)
6.5
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 Lisää

€200 EUR 10 päivässä
(51 arvostelua)
6.2
metodi25sl

Ready to do it

€165 EUR 12 päivässä
(78 arvostelua)
6.3
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 Lisää

€200 EUR 8 päivässä
(43 arvostelua)
6.3
coolrankit

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

€150 EUR 3 päivässä
(43 arvostelua)
6.0
svipl7

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

€500 EUR 14 päivässä
(21 arvostelua)
5.5
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 2 päivässä
(33 arvostelua)
4.8
Days

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

€80 EUR 1 päivässä
(33 arvostelua)
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 2 päivässä
(3 arvostelua)
3.6
poonaminfo

I am interested in this job.

€100 EUR 5 päivässä
(0 arvostelua)
0.0
lucentasolutions

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

€200 EUR 5 päivässä
(2 arvostelua)
0.0
VysakhV

Ensure completion in time

€200 EUR 10 päivässä
(0 arvostelua)
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 15 päivässä
(1 arvostelu)
0.0