Variables from database

Asked Mar 22 '17 at 23:57

Active Mar 23 '17 at 01:18

Viewed 57 times

For automatise the email sending in PHP, i store the content of the emails in a database.

Is it possible to store the name of the variable in the database for using after run in the result of the query ? and how to do this?

I've try this: $body = preg_replace('#\$[a-z0-9_]+#i', "$$0", $bodyFromDB);

For example, i want to store this:

Dear $firstname $lastname, ...

Thanks for your help

PS: I am open to an other solution.

edited May 23 '17 at 12:02

Community

asked Mar 22 '17 at 23:57

Denis Germanier

Yes but it is a bad idea – RiggsFolly Mar 22 '17 at 23:59
Search for template systems. – Barmar Mar 22 '17 at 23:59
Honestly I could be wrong, but I imagine the question you want to be asking is "I'm storing var names in the DB,how can I improve my approach" – James Mar 23 '17 at 00:03
@RiggsFolly, what is the better solution for this? – Denis Germanier Mar 23 '17 at 00:03
@James, Exactly – Denis Germanier Mar 23 '17 at 00:04
@Barmar, For example? – Denis Germanier Mar 23 '17 at 00:04
@DenisGermanier i usually use simple txt files (eg. Dear {1} {2}) and then pass the arguments in php. – Nodir Rashidov Mar 23 '17 at 00:06
@DenisGermanier I have no idea. Google is your friend. – Barmar Mar 23 '17 at 00:06
The general concept is called "mail merge", google that. – Barmar Mar 23 '17 at 00:06
@Barmar, Ok, i'll try this – Denis Germanier Mar 23 '17 at 00:08
I've found my hapiness here : http://stackoverflow.com/a/17274461/7754097 – Denis Germanier Mar 23 '17 at 01:17

0 Answers0