View Full Version : direct sql (insert new listing)

Aleksander Godzilo-godlewski
March 7, 2020, 08:31 PM
Hi all,
I'm looking for the simplest way to inser new listing into only one category from specific user with Title, price, description and 3 photos.
I already did home work and analyzed mysql. log but I don't want to force open doors and maybe someone already did some script (bash/php/other)?

March 9, 2020, 04:09 AM

you can use sql request for inserting listing but without photos:

INSERT INTO `fl_listings` ( `Plan_ID`, `Plan_type`, `Last_type`, `Date`, `Category_ID`, `Account_ID`, `Status`, `Pay_date`, `title`, `price`, `additional_information`)
VALUES ( '1', 'listing', 'standard', NOW(), '122', '1', 'active', NOW(), 'Test AD', '15000|dollar', 'some text')

Aleksander Godzilo-godlewski
March 9, 2020, 07:22 PM
Thank you.