存储在MySQL中的PHP变量无法解析

Good Day,

I have got a problem with my script. What I'm doing is:

I want to send an email to user. There are different templates for different type of mails like one design for SignUp confirmation, one for recent news etc. So, what I did is, I created a table and stored each design in column called content with its complete HTML code.

My database design is pretty simple for this purpose:

ID    |    type    |    content

1     |   signup   |    <html> ... <body> .. content of email ... </body></html>

So, right above is my database. field with ID 1 Now, when someone signs up, I am trying to send him an email whose content is fetched from table above. Text under content field is like:

<html>
.
.
<body>
Good Day,

You have successfully created your account.
Please activate your account now by clicking below:

<a href="activate.php?md5=$md5&code=$code">ACTIVATE</a>

</body>
</html>

In above code, if you checkout the activate link, I have used PHP variables $md5 and $code, thinking that their corresponding values would be printed in actual email. But they are printed as it is, like $md5 and $code.

Well, I did little research and from few forums, I got to know that,

1st: While we added content of HTML template to database along with these PHP variables, they have become a value of that database column itself and would not be treated as PHP variables anymore.

2nd: One person claims that he have made it's working using eval() function. I can use eval since, im not taking any value from user but database, from point of security. I tried it, but still nothing.

Below is code which I tried with eval():

$md5    =   $row['md5'];  // These variables values I'm expecting to come in template content
$code   =   $row['activ_code'];  // These variables values I'm expecting to come in template content

ob_start();
eval("\$template_content = \"$template_content\";");
$message    =   $template_content;
ob_end_clean();

Can someone help me out with this? I don't want to put complete template (HTML) on the same page where I'm using the mail function. It makes code look ugly instead of keeping it short and neat.

Please help!

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

4条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
drctyr2869 2013-07-30 10:09
关注
Use str_replace http://php.net/manual/en/function.str-replace.php and replace those variables to tags, i.e. something like %MD5%. You could still use $code but it is just no this readable and may result in wrong text being substituded (consider a string "this was $codeveloped")

mixed str_replace ( mixed $search , mixed $replace , mixed $subject [, int &$count ] ) This function returns a string or an array with all occurrences of search in subject replaced with the given replace value.

Then,

$template_content = '<a href="activate.php?md5=%MD5%&code=%CODE%">ACTIVATE</a>'; $template_content = str_replace("%MD5%", $md5, $template_content); $template_content = str_replace("%CODE%", $code, $template_content);

str_replace also accepts arrays as arguments, so this may be a better one

$placeholders = array("%MD5%", "%CODE%"); $values = array($md5, $code); $template_content = str_replace($placeholders, $values, $template_content);

Eval is a potentially dangerous and generally an overkill
本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(3条)

报告相同问题？

关注问题

存储在MySQL中的PHP变量无法解析 mysql php
2013-07-30 10:07

回答 4 已采纳 Use str_replace http://php.net/manual/en/function.str-replace.php and replace those variables to t
不确定如何在mysql中使用php变量 mysql php
2017-02-01 06:09

回答 3 已采纳 The most correct way to use PHP variables in PHP is to use prepared statements. $query = $dbh-&gt
使用get方法在mysql中使用php变量 mysql php
2017-02-28 18:52

回答 1 已采纳 Try out this: $query = mysqli_query("SELECT * FROM imgtable where id='$id'"); Instead of $que
php执行语句在MySQL批量插入大数据量的解决方案及计算程序执行时间(大数据量、MySQL语句优化)
2023-04-26 12:29

漏刻有时的博客近期在MySQL报表开发过程中，需要爬取多API返回JSON数据，然后插入到数据库中。因不同API的返回时间、返回数据、返回格式、插入数据表等因素各不相同。如果前期架构不完善，会导致服务器的直接崩溃，为此，做了下...
如何在MySQL插入中包含PHP变量 php
2017-09-21 08:45

回答 1 已采纳 You would prefer prepared statement, safer and cleaner. <?php $stmt = $dbh->prepare("
使用存储在mysql文本中的变量 mysql php
2015-01-11 23:00

回答 2 已采纳 The right solution is to use a template library. To do what you're trying, you need to use eval:
如何在MySQL中包含PHP数组变量 mysql php
2016-06-08 15:24

回答 3 已采纳 You can use (no single quotes on the occurance) "SELECT `lastUpdate` FROM `summoner` WHERE `name`
mysql千万级大数据SQL查询优化
2022-04-20 14:53

didi558的博客 2.应尽量避免在 where 子句中对字段进行 null 值判断，否则将导致引擎放弃使用索引而进行全表扫描，如：select id from t where num is null可以在num上设置默认值0，确保表中num列没有null值，然后这样查询：select...
无法在MySQL查询中使用变量[关闭] mysql php
2016-07-20 22:52

回答 3 已采纳 The query you were trying to execute looked like this: SELECT * FROM data1 ORDER BY name LIMIT '0
在for循环中存储mysql中的变量 mysql php
2014-05-16 13:55

回答 1 已采纳 You might try something like this: $createSqlString = `INSERT INTO results (var, var, var) VALUES
在PHP中的mysql查询中的内联变量无法正常工作 mysql php
2015-11-10 10:24

回答 3 已采纳 Change $page_set = mysqli_query($db_link, 'SELECT * FROM pages WHERE subject_id= {$subject["id"]}
mysql把游标数据存入表中_mysql存储过程中的游标
2020-12-18 18:16

weixin_39933484的博客 MySQL利用存储过程清除所有表中的所有记录MySQL利用存储过程清除所有表中的所有记录在使用MySQL过程中，难免会出现一些测试数据，然而这些测试数据在真正部署运行的时候，通常要被清楚掉，并且自增长的字段要回复...
PHP - mySQL查询中的几个变量 mysql php
2017-10-14 09:01

回答 2 已采纳 You must use " or ' about string in SQL $reponse = $bdd->query('SELECT * FROM user_data WHERE
mysql 大数据 查询优化原则
2017-05-18 16:37

大树叶的博客今天，数据库的操作越来越成为整个应用的性能瓶颈了，这点对于Web应用尤其明显。...这里，我们不会讲过多的SQL语句的优化，而只是针对MySQL这一Web应用最多的数据库。希望下面的这些优化技巧对你有用。　
2023大数据面试题+附答案
2023-04-26 23:19

小獾哥的博客 2023大数据面试题+附答案。
没有解决我的问题, 去提问

悬赏问题

¥20 求各位懂行的人，注册表能不能看到usb使用得具体信息，干了什么，传输了什么数据
¥15 个人网站被恶意大量访问，怎么办
¥15 Vue3 大型图片数据拖动排序
¥15 Centos / PETGEM
¥15 划分vlan后不通了
¥20 用雷电模拟器安装百达屋apk一直闪退
¥15 算能科技20240506咨询（拒绝大模型回答）
¥15 自适应 AR 模型参数估计Matlab程序
¥100 角动量包络面如何用MATLAB绘制
¥15 merge函数占用内存过大

存储在MySQL中的PHP变量无法解析

4条回答 默认 最新

悬赏问题

4条回答默认最新