Ditutup

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.

Kemahiran: MySQL, PHP, SQL, XML

Lihat lebih lanjut: ebay xml feed product, xml feed import mysql, save xml feed mysql, product xml feed, prestashop product xml feed, xml feed mysql

Tentang Majikan:
( 20 ulasan ) rotterdam, Netherlands

ID Projek: #14682327

26 pekerja bebas membida secara purata $70 untuk pekerjaan ini

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 dalam 2 hari
(884 Ulasan)
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 Lagi

$55 CAD dalam sehari
(149 Ulasan)
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 Lagi

$133 CAD dalam 3 hari
(342 Ulasan)
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 Lagi

$64 CAD dalam 2 hari
(84 Ulasan)
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, Lagi

$111 CAD dalam sehari
(91 Ulasan)
6.3
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 dalam 2 hari
(45 Ulasan)
5.6
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 Lagi

$356 CAD dalam sehari
(33 Ulasan)
5.7
$55 CAD dalam sehari
(26 Ulasan)
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 dalam sehari
(11 Ulasan)
5.1
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 Lagi

$30 CAD dalam 5 hari
(12 Ulasan)
4.3
$37 CAD dalam sehari
(29 Ulasan)
4.6
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 Lagi

$94 CAD dalam 2 hari
(2 Ulasan)
4.5
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, Lagi

$111 CAD dalam sehari
(21 Ulasan)
5.3
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 Lagi

$50 CAD dalam sehari
(19 Ulasan)
4.2
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 dalam 0 hari
(17 Ulasan)
3.8
$37 CAD dalam sehari
(15 Ulasan)
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 Lagi

$37 CAD dalam sehari
(11 Ulasan)
3.9
$19 CAD dalam sehari
(11 Ulasan)
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 Lagi

$35 CAD dalam 2 hari
(6 Ulasan)
3.2
$100 CAD dalam sehari
(5 Ulasan)
2.6