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.
Bu iş için 24 freelancer ortalamada $73 teklif veriyor
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
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 Daha Fazla
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, Daha Fazla
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 Daha Fazla
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, Daha Fazla
I am a web developer. Relevant Skills and Experience php, mysql Proposed Milestones $18.5 CAD - 1 $18.5 CAD - 2 no
10 years of PHP experience. Relevant Skills and Experience 10 years of PHP experience. Proposed Milestones $27.5 CAD - milestone $27.5 CAD - milestone
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
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 Daha Fazla