Completed

Update/Insert data to another database from MSSQL to MYSQL using PHP and Button

Hi,

I have a simple script attached which performs a query and retrieves data in a table by connecting to an MSSQL Database. (the query and connection files are in different files)

I need to add a button below the table that will insert/update data to another database (mysql).

The column names are exactly the same as the data that is retrieved, although there is another column called ID which is AutoIncrement and Set to primary key, as such any new records will have a new ID.

If date, red and blue columns are the same as an existing record it should update the existing record on the mysql table, else it should create a new record.

I cannot supply sample data or the database connection, it should be clear from the script as to what the columns are.

The code must be fully commented and re-usable.

Skills: Database Programming, HTML, MySQL, PHP, SQL

See more: insert log field mysql using php, example insert data database using xml file vbnet, update form data database php ajax, php mysql using radio button update database, update mysql using radio button php, save xml data mysql using php, posting xml data mysql using php, edit delete insert data mysql using php, php excel file load database update insert data, php mysql insert data database, insert data txt mysql using php, insert data mysql using php joomla, insert data database using json php, using php json insert data database mysql, insert data excel file mysql database using jsp

About the Employer:
( 18 reviews ) essex, United Kingdom

Project ID: #17256639

Awarded to:

aryan151

Lets start................................................................................................................................................................

$20 USD in 1 day
(318 Reviews)
6.8

14 freelancers are bidding on average $33 for this job

khantek

Hi Sir, I am interested to do the job. I understand the task and I can complete it within a couple hours. The code I write will be re-usable and well documented. If you accept then please contact me so I get this do More

$20 USD in 1 day
(410 Reviews)
7.5
$61 USD in 1 day
(187 Reviews)
6.7
michealperfect

Good evening sir ,welcome to Freelancer.com !I am a professional web designer and developer.I can do this job of MYSQL using PHP for you . Ping me on chat for more details ,thank you !

$50 USD in 2 days
(120 Reviews)
6.2
rambanstola

Hi, I have worked with both php and database . I would be able to do this for you. Let me know if you are interested.

$88 USD in 1 day
(57 Reviews)
5.5
$25 USD in 2 days
(10 Reviews)
4.4
taiaburbdon

Dear sir, I would like to work with you. I want to check current platform. I hope i can solve it. thanks taiabur rahman

$25 USD in 1 day
(11 Reviews)
3.8
ahmadmtii

Hi, Hope you doing well.I read your Mysql project description and very confident to handle this project perfectly Let's have a discussion, negotiate costing, timeline and then we proceed Moreover, please have a loo More

$19 USD in 1 day
(21 Reviews)
4.2
sarthakmeh

Hey, I have written many scripts involving Python and mysql. I am pretty confident that i can complete the given task in due time. Looking forward to work with you. Thanks

$55 USD in 1 day
(2 Reviews)
4.9
manum11

i am experienced web developer in PHP, Mysql and as you mentioned in the description i can make your form working and add a button to insert data into another database.

$25 USD in 1 day
(16 Reviews)
3.9
$25 USD in 1 day
(3 Reviews)
2.7
muhammadwakkar77

Hi , Hope you are doing good. I am expert in Web Development and have made so many websites , you can see my portfolio as well. i have already worked with Australian employer and that was awesome experience , you ca More

$20 USD in 1 day
(3 Reviews)
2.2
seabdulbasit

Hello Sir I have been working on different projects on android and websites, besides these I have good experience working with Graphics, I can work professionally for you on this project. I hope you will not be disa More

$23 USD in 1 day
(2 Reviews)
1.8
LetsDoItApp

Hello, I can pass the structure of the tables in the database. Do you need it to be done with stored procedures?

$10 USD in 1 day
(2 Reviews)
0.0