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, php, 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

Tietoa työnantajasta:
( 25 arvostelua ) rotterdam, Netherlands

Projektin tunnus: #14682327

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


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ä
(1001 arvostelua)

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ä
(150 arvostelua)

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: [login to view URL] Best regards, web Lisää

$133 CAD 3 päivässä
(399 arvostelua)

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ä
(109 arvostelua)

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ä
(115 arvostelua)
$55 CAD 1 päivässä
(72 arvostelua)

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ä
(57 arvostelua)

Hello Relevant Skills and Experience database solutions and client/server applications. please have a look at our portfolio link:- [login to view URL] Lisää

$37 CAD 1 päivässä
(74 arvostelua)

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ä
(71 arvostelua)

I am a web developer. Relevant Skills and Experience php, mysql Proposed Milestones $18.5 CAD - 1 $18.5 CAD - 2 no

$37 CAD 1 päivässä
(33 arvostelua)

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)

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ä
(16 arvostelua)

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ä
(12 arvostelua)

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ä
(43 arvostelua)
$37 CAD 1 päivässä
(46 arvostelua)

*"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)
$37 CAD 1 päivässä
(21 arvostelua)

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ä
(23 arvostelua)
$19 CAD 1 päivässä
(16 arvostelua)

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ä
(10 arvostelua)