Suljettu

Need PHP JSON Help With a Function That Combines 4 tables into one Product Object/Array

Hi there. I have an E-Commerce project and I need help combining 4 mysql tables into a function that outputs all the products (we actually already have a function made, but it's not fully working).

I'm attaching an example of the API function's output which we are trying to re-create (and base this function on) - basically, we import the product data, so we can list the products from our local mysql database which is way faster than pulling the products from the API.

The API example in my screenshot has lots more data than we actually need for the local version, so in the attached screenshot - just look at the "variations" part of it - that's what I need to add - and like I said I already have a function that works, but it's missing that part. I can give you access to it (VPS, PHP, MySQL).

My Tables:

Products

Variations

Modifier Lists

Modifiers

Example:

Product: Coffee

Variations: Large - $4.50 | Medium - $3.50 | Small - $2.50

Modifier Lists: Milk/Cream, Flavor, Sweetener

Modifiers:

Milk/Cream: 2%, Whole, Skim, Coconut Milk

Flavor: Vanilla, Hazelnut, Mocha

Sweetener: Sugar, Coconut Sugar, Sweetener

That structure makes up a product. Right now the Modifiers and Variations aren't outputting, but I'm more concerned with fixing the Variations first - then we can fix the Modifiers after.

Also there is either a location_id or item_id in every table and that's how you can bind/link all the different parts of the products.

So first you could do select * from products where location = $any_location_id

Then that would return all our products and then I think we also have the location in the variations table too plus we can link them on the item_id (note: we have lots of locations in the table so using the location id keeps the query result limited to only the products for one location/shop).

I can't remember what modifiers has but it's very easy to see what binds each table once you look at the table.

Taidot: PHP, MySQL, JavaScript, Tietojärjestelmäarkkitehtuuri, AJAX

Tietoa asiakkaasta:
( 17 arvostelua ) Chicago, United States

Projektin tunnus: #34307517

52 freelanceria on tarjonnut keskimäärin $13/tunti tähän työhön

OutsourceMan

Greetings, You are chatting with Raman. Trust me we are expert at php json with a function that combines 4 tables into one product object/array. Our team is expert at this work. We completed more than 20+ Database, Lisää

$12 USD / tunti
(538 arvostelua)
8.8
WebInfoSolutions

is it php? can you tell if there is any framework/cms?

$15 USD / tunti
(267 arvostelua)
8.0
(28 arvostelua)
7.7
(343 arvostelua)
7.8
gauravmittal1989

Hello Kenneth D., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on Software Architecture [login to view URL] Lisää

$12 USD / tunti
(133 arvostelua)
7.0
maxpl

Hi, Hope you are doing great. I am an experienced web developer. I have 8+ years of experience in webdesign/d Lisää

$15 USD / tunti
(37 arvostelua)
6.8
webmaestro2013

Hi I will write query to combine all 4 tables and fetch result. I know PHP, MYSQL, AJAX, javascript , jquery , css, html very well. PLEASE HAVE A LOOK AT MY PROFILE FOR MORE ABOUT MY RATING AND REVIEWS I have 13+ y Lisää

$12 USD / tunti
(208 arvostelua)
7.1
c0909h1179

Hi there, I'm the best here! Would love to work together. Thanks!

$12 USD / tunti
(40 arvostelua)
6.5
Koki1216

Hello, this is Koki from Japan who has been working with PHP, JavaScript, Ajax, MySQL for over 8 years now I have checked your project description carefully and I think that I can help you to complete this project full Lisää

$15 USD / tunti
(16 arvostelua)
6.9
(132 arvostelua)
6.4
guptaranjeet

Hello there, *****I CAN START WORK ON IT IMMEDIATELY.***** Thanks for the opportunity. It is my pleasure to be able to bid on your project. Really very much interested to have this project if you permit. I went throug Lisää

$15 USD / tunti
(16 arvostelua)
6.4
Shivamf

Hello Project ID: 34307517, This is Shivam, I am a professional web developer and have been working in this field for 7 long years. Your requirements are fully clear to me and I am applying only because I meet all the Lisää

$10 USD / tunti
(177 arvostelua)
6.5
(60 arvostelua)
6.3
anastasbestdew

Hello. First receive warm greetings, and hoping you are good. Thanks for your job posting. I am a Full stack developer in having 7years experiences in websites' development. I have worked with PHP, JavaScript, Ajax, Re Lisää

$12 USD / tunti
(28 arvostelua)
6.3
vitalboan

I've gone through your project details and understood it. I am available to start work immediately and I'll provide full satisfaction and best price. I hope to work with you. Thanks for reading me.

$12 USD / tunti
(29 arvostelua)
5.9
abubakar12345678

I have read all description. I will combine 4 tables into 1 array. Give me chance to show you good result. Thanks.......

$10 USD / tunti
(110 arvostelua)
6.1
ememocela16

Dear Client! I have a lot of experience in php. If you give me the assignment, I will satisfy you with good results. because I am a full-time developer, you can contact with any time. I am focusing on Trust & Credit to Lisää

$15 USD / tunti
(26 arvostelua)
6.3
kevinmartialex

Hello. I am ready to start work right now. I am very familiar with wordpress, woocommerce website building and theme & plugin customization, Child theme development, payment gateway & API integration, custom widget & Lisää

$15 USD / tunti
(33 arvostelua)
5.6
(65 arvostelua)
5.7
malikbilal15

Hi I have vast exp in php and jquery and can start your job righ tnow thanks bilal

$10 USD / tunti
(143 arvostelua)
5.7