Suljettu

Product feed xml to mysql Functions

I am looking for somebody to make a php script for me with 3 functions. The functions are as follows

A Product feed data to a mysql table called source_table

• A.1 Insert function

• A.2 Update function

B Transfer or Update data from Source table to a list of tables

• B.1 Insert (distribute) function

A Product feed (XML) to Mysql table.

A.1 Insert function

1. The function should collect an xml link from a table called “product_feed” , parse the data to a table called “source_table” and change the value of the field “status” in product feed table from 0 to 1

2. Will provide the source_table & product_feed table . Will provide a list should where to put each of the xml fields in the source_table.

A.2 Update function

a. Select link_id given smallest “number_of_runs” from table: “product_feed”

b. In table “source_table” select all items given “link_id”

c. For rows where its “affiliate_link” in “source_table” is not found in product feed change field”update_status” in “source_table” from 0 to 2

d. In the case where there is or are “affiliate_link” in the product feeds but not found in source_table, insert the product feed as a row in the source_tble as indicated in A.1. Value for the update_status in source table should be 1. Instead of the default 0.

B Source table to a set of Markt tables

B.1 Distribute data from source to list of tables

a. Go to “aff_table” Select fields: “aff_id” & “site_list” from row with smallest “Number_of_runs”

b. In source_table collect rows given the “aff_id”. The number rows collected should be 3 x number of elements in the “site_list” array

c. From the table: “site_table” For each “side_id” in the “site_list” array select the corresponding “db_id”.

d. Insert the rows collected in the “source_table” table to the respective tables given the “db_id”.

I will provide the tables and will be available answer question as it arise.

Taidot: MySQL, PHP, SQL, XML

Näytä lisää: ebay xml feed product, drupal xml feed product import, import xml feed mysql script, import cwr xml feed url mysql database, xml feed import mysql, use java collect xml feed mysql, load data mysql xml feed, amazon product xml feed example, php code parse xml feed, parse xml feed mysql, parse remote xml feed php, save xml feed mysql, product xml feed, parse xml feed php, prestashop product xml feed, php parsing xml feed mysql database, parse xml feed swf, save xml feed mysql php, xml feed mysql

About the Employer:
( 20 reviews ) rotterdam, Netherlands

Projektin tunnus: #14682327

26 freelanceria on tarjonnut keskimäärin 70 $ tähän työhön

rinsadsl

Hi there I can process those xml files in the source xml file and update the secondary tables. Looking forward to work with you. Thanks Rinsad

59 $ CAD 2 päivässä
(884 arvostelua)
8.5
neoconcepts

i am an expert in website designing and I can Develop sites in Wordpress, Magento and Core PHP, API. let's discuss. ready to start. thanks. Relevant Skills and Experience MySQL, PHP, SQL, XML Proposed Milestones $55 Lisää

55 $ CAD 1 päivässä
(149 arvostelua)
7.4
webexpert0102

Hi I am ready to start and I would like to discuss with you on this project. Relevant Skills and Experience Please check my portfolio here: http://stacreatewebsite.com/webexpert0102-portfolio.pdf Best regards, web Lisää

133 $ CAD 3 päivässä
(342 arvostelua)
7.2
webdesign786

HI My Motion : "No Satisfaction, No Payment" We have expertise in Web Design & Development. Please check our client reviews to determine the quality of our work. Let start now? I am very hard working and always Lisää

64 $ CAD 2 päivässä
(84 arvostelua)
6.7
sauravkumar120

Hi there, I would like to explore the further possibilities of the project. Our team works on web design, CMS, HTML, CSS, PHP, JS, WORDPRESS, JOOMLA etc. Regards Saurav Relevant Skills and Experience Wordpress, HTML, Lisää

111 $ CAD 1 päivässä
(91 arvostelua)
6.3
krishan725

Dear employee After Read your project, we are expert and completed many similar work and we have a team with 30+ highly skilled Designers and Developers with over 7+ years of experience. Relevant Skills and Experienc Lisää

356 $ CAD 1 päivässä
(33 arvostelua)
5.7
suraj2

10 years of PHP experience. Relevant Skills and Experience 10 years of PHP experience. Proposed Milestones $27.5 CAD - milestone $27.5 CAD - milestone

55 $ CAD 2 päivässä
(45 arvostelua)
5.6
55 $ CAD 1 päivässä
(26 arvostelua)
5.4
nurealam0055

Hello, Honorable Hiring Manager, Relevant Skills and Experience I am Expert Web Developer & I have 7+ years of experience. Web Development and Graphics designer Proposed Milestones $37 CAD - Project Milestone

37 $ CAD 1 päivässä
(11 arvostelua)
5.1
37 $ CAD 1 päivässä
(29 arvostelua)
4.6
bestit4u

Hi. I have review your job description carefully. I am a highly skilled developed with 6+ years experience in full stack web development, cross platform mobile app development like Ionic, Xamarin, Unity, Phonegap, Lisää

111 $ CAD 1 päivässä
(21 arvostelua)
5.3
tsebro

Hello! Ready to help you with php script for 3 functions. I am professional Front-End Developer and co-owner of a web-development team with a 17 years experience in Web Development, especially in HMTL/CSS/JavaScr Lisää

94 $ CAD 2 päivässä
(2 arvostelua)
4.5
abbalove

Hello, can you send me the sql file that contains the tables, I will write the codes for you right away. I can send you demo script. I am very expert in PHP and MySQL database. Rocky Stay tuned, I'm is still worki Lisää

50 $ CAD 1 päivässä
(19 arvostelua)
4.2
phpboss786

*"We provide you quality in least budget" ****Greetings**** I have read your project and checked details. I can do this task. For my portfolio (previous work) please contact me. If needed I can prov Lisää

30 $ CAD 5 päivässä
(12 arvostelua)
4.3
37 $ CAD 1 päivässä
(15 arvostelua)
3.8
vw7590795vw

Please review my profile. I have 7.5 years experience in SQL and PHP. Please let me know more details and when we will start. Sky pe jikenjd

55 $ CAD 0 päivässä
(17 arvostelua)
3.8
imagicaworld

Hello Relevant Skills and Experience database solutions and client/server applications. please have a look at our portfolio link:- https://docs.google.com/document/d/1P2YbLbXQY9CaWn10vxUqR-baQmn7YTgGUGWI4z3DpyQ/edit Lisää

37 $ CAD 1 päivässä
(11 arvostelua)
3.9
19 $ CAD 1 päivässä
(11 arvostelua)
3.9
vaibhavzain

I have been working in web development for 3 years and gained considerable experience in various skills. Relevant Skills and Experience PHP MYSQL JQUERY AJAX CODEIGNITER Proposed Milestones $35 CAD - after completati Lisää

35 $ CAD 2 päivässä
(6 arvostelua)
3.2
100 $ CAD 1 päivässä
(5 arvostelua)
2.6