get array of last product and information from prestashop

Job ID: 34562887

Budget: $10 – $30 USD

i want to get something like this:
array = {
title: 'Product Title',
price: 150,
details: 'product details',
product_id: 20,
product_url: 'https://my domain/inicio/20 .html',
product_img: 'https://my domain/my first picture.jpg '
}

also add rows in mysql where product is located:
fb_post boolean
wa_post boolean
ln_post boolean
tl_post boolean

it for fetch the latest product posted in my site and once i publish it my js code will change the value from 0 to 1
Related categories: PHP Software Architecture Prestashop MySQL HTML