Lukket

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.

Færdigheder: MySQL, PHP, SQL, XML

Se mere: 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

Om arbejdsgiveren:
( 21 bedømmelser ) rotterdam, Netherlands

Projekt-ID: #14682327

25 freelancers are bidding on average $72 for this job

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 in 2 dage
(921 bedømmelser)
8.6
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 Mere

$55 CAD på 1 dag
(150 bedømmelser)
7.5
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: [url removed, login to view] Best regards, web Mere

$133 CAD in 3 dage
(359 bedømmelser)
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 Mere

$64 CAD in 2 dage
(89 bedømmelser)
6.8
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, Mere

$111 CAD på 1 dag
(95 bedømmelser)
6.4
$55 CAD på 1 dag
(37 bedømmelser)
5.8
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 Mere

$356 CAD på 1 dag
(41 bedømmelser)
6.0
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, Mere

$111 CAD på 1 dag
(44 bedømmelser)
5.9
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 in 2 dage
(45 bedømmelser)
5.6
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 på 1 dag
(16 bedømmelser)
6.0
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 Mere

$50 CAD på 1 dag
(41 bedømmelser)
5.0
$37 CAD på 1 dag
(34 bedømmelser)
5.0
imagicaworld

Hello Relevant Skills and Experience database solutions and client/server applications. please have a look at our portfolio link:- [url removed, login to view] Mere

$37 CAD på 1 dag
(23 bedømmelser)
4.9
$37 CAD på 1 dag
(19 bedømmelser)
4.3
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 Mere

$30 CAD in 5 dage
(12 bedømmelser)
4.4
jarki2017

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

$37 CAD på 1 dag
(7 bedømmelser)
3.8
$19 CAD på 1 dag
(12 bedømmelser)
3.9
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 in 0 dage
(19 bedømmelser)
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 Mere

$35 CAD in 2 dage
(6 bedømmelser)
3.2
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 Mere

$94 CAD in 2 dage
(4 bedømmelser)
5.4