Display MySQL results in Newsletter

Questions about Version 3 phpList features (the answer is probably 'Yes!')
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation.

Display MySQL results in Newsletter

Postby coderdj412 » 5:03pm, Thu 13 Nov, 2014

Can PhpList display results from a MySQL query in a newsletter?

For example, I wanted to let people know what the top 10 most visited pages on my website were via a MySQL query.
coderdj412
phpLister
 
Posts: 9
Joined: 8:02pm, Thu 26 Jun, 2014

Re: Display MySQL results in Newsletter

Postby duncanc » 9:03pm, Fri 14 Nov, 2014

phplist doesn't help you with this. Two solutions are
  • develop a web page that shows the required email content and then use "send web page" when composing a campaign.
  • develop a plugin for phplist that replaces a placeholder, such as [TOP10] by the chunk of html that shows the top 10 pages. Then include the placeholder in your campaign.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London


Return to Does phpList do this?

Who is online

Users browsing this forum: No registered users and 1 guest