如何在动态电子邮件模板中用数据库中的值替换自定义标记或表达式

Question

Hi I am getting an email template from frontend. This Email Templates looks like:

Hi {{USER}},
We have created an account for you. Here are your details:
Email:{{EMAIL}}
Password:{{PASSWORD}}

and I am saving this email template in database. Later while any new user signs up I want to send above email template replacing the USER with username, {{EMAIL}} with email of user and {{PASSWORD}} with password of user

I am struck at how can I find this tags or expression from above template and replace it with any dynamic values from db. Let say this values are USER:Test Email: [e-mail] and Password: 123456

Answer 1

There needs to be some kind of consistency in data if you want to make your email dynamic which I believe it is as you have given an example.

or maybe I am not getting it right but why don't you just use the whole placeholder to recognize what to replace with what?

Like create a table lets say mappings with two custom column (other than id and timestamps one), let's say label and field

and there you could store values like:

| label        | field    |
|--------------|----------|
| {{USER}}     | username |
| {{EMAIL}}    | email    |
| {{PASSWORD}} | password |

Then you can use that table to replace the correct label with correct field value from the database.