Today's big project was to create a .csv file of all of my book covers and all of my DVD video covers, from mySQL table.
The "message," the url to the image, and the url of the link to the product detail page to buy.
Plus a "date/time" field. Since I want to do two posts per day, I used php date functions to create Col A of the .csv.
Code:
$date=date_create("05/14/2020");
date_add($date,date_interval_create_from_date_string("$nd days"));
$mdy= date_format($date,"m/d/Y");
I post 2 per day, 12 hours apart.
So the first few items date field looked like:
05/14/2020 15:00
05/14/2020 05:00
05/15/2020 15:00
I had to have php generate the .csv file, or I'd still be working on today and tomorrow's posts!
contentstSnip.jpg
Bookmarks