Sedang Disiapkan

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

Kemahiran: Pentadbiran Pangkalan Data, MySQL, PHP

Lihat lebih lanjut: 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

Tentang Majikan:
( 45 ulasan ) G?vle, Sweden

ID Projek: #4098315

Dianugerahkan kepada:

Days

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

€80 EUR dalam sehari
(18 Ulasan)
3.8

18 pekerja bebas membida secara purata €186 untuk pekerjaan ini

denisCh

Please check PM

€200 EUR dalam 5 hari
(62 Ulasan)
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 Lagi

€225 EUR dalam 7 hari
(81 Ulasan)
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 Lagi

€200 EUR dalam 10 hari
(33 Ulasan)
6.0
metodi25sl

Ready to do it

€165 EUR dalam 12 hari
(68 Ulasan)
6.0
TheInnoVibes

Please check private message

€200 EUR dalam 4 hari
(35 Ulasan)
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 Lagi

€200 EUR dalam 8 hari
(23 Ulasan)
5.6
phpprogramming

please check PM for details

€110 EUR dalam 2 hari
(41 Ulasan)
5.6
jcodemasters

Will be done.

€100 EUR dalam sehari
(47 Ulasan)
5.5
coolrankit

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

€150 EUR dalam 3 hari
(19 Ulasan)
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 dalam 2 hari
(35 Ulasan)
4.6
svipl7

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

€500 EUR dalam 14 hari
(10 Ulasan)
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 dalam 2 hari
(3 Ulasan)
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 Lagi

€225 EUR dalam 7 hari
(9 Ulasan)
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 dalam 2 hari
(5 Ulasan)
2.8
lucentasolutions

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

€200 EUR dalam 5 hari
(2 Ulasan)
0.0
poonaminfo

I am interested in this job.

€100 EUR dalam 5 hari
(0 Ulasan)
0.0
VysakhV

Ensure completion in time

€200 EUR dalam 10 hari
(0 Ulasan)
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 dalam 15 hari
(1 Ulasan)
0.0