Yesterday, one of our client requested to store SMTP email settings in database. Usually, we can do it in the email.php file. However,\u00a0it is more convenient if we store it in the database and provide a\u00a0web form to easily change\u00a0it.<\/p>\n

Let say we store the email settings in table called email_settings with model EmailSetting.<\/p>\n

One of the way is to retrieve the email settings record in every email sending method you have\u00a0as per below:<\/p>\n

 \/\/ get email settings\r\n$EmailSetting = ClassRegistry::init('EmailSetting');\r\n$email_settings = $EmailSetting->findById(1);\r\n$email_setting = $email_settings['EmailSetting'];<\/pre>\n
and load the SMTP email settings as per below:<\/p>\n
if (!empty($email_setting['smtp_host'])) {\r\n $email->config(array(\r\n    'host' => $email_setting['smtp_host'],\r\n    'port' => $email_setting['smtp_port'],\r\n    'username' => $email_setting['smtp_user'],\r\n    'password' => $email_setting['smtp_password'],\r\n ));\r\n}<\/pre>\n
But that way will not promote a code use. After digging CakePHP cookbook, we found out that we can retrieve the email settings in the EmailConfig class (in file \/app\/Config\/email.php). You can just load the SMTP email settings in\u00a0__construct() function. It’s very convenient and you can easily change it whenever needed.<\/p>\n
Here’s the codes:<\/p>\n
File:\u00a0 \/app\/Config\/email.php\r\n\r\nclass EmailConfig\r\n{\r\n  public function __construct()\r\n  {\r\n      $EmailSetting = ClassRegistry::init('EmailSetting');\r\n      $email_settings = $EmailSetting->findById(1);\r\n      $email_setting = $email_settings['EmailSetting'];\r\n\r\n      if (!empty($email_setting['smtp_host'])) {\r\n         $this->default = array(\r\n             'transport' => 'Smtp',\r\n             'from' => $email_setting['from'],\r\n             'host' => $email_setting['smtp_host'],\r\n             'port' => $email_setting['smtp_port'],\r\n             'timeout' => 30,\r\n             'username' => $email_setting['smtp_user'],\r\n             'password' => $email_setting['smtp_password'],\r\n             'client' => null\r\n          );\r\n      }\r\n  }\r\n}<\/pre>\n
Enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":"
Yesterday, one of our client requested to store SMTP email settings in database. Usually, we can do it in the email.php file. However,\u00a0it is more convenient if we store it in the database and provide a\u00a0web form to easily change\u00a0it. Let say we store the email settings in table called email_settings with model EmailSetting. One … Continue reading Use SMTP Email Settings from Database in CakePHP 2<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":95,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[26,34,35],"class_list":["post-85","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cakephp","tag-cakephp","tag-email","tag-smtp"],"_links":{"self":[{"href":"https:\/\/blog.neptunescripts.com\/wp-json\/wp\/v2\/posts\/85","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.neptunescripts.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.neptunescripts.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.neptunescripts.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.neptunescripts.com\/wp-json\/wp\/v2\/comments?post=85"}],"version-history":[{"count":1,"href":"https:\/\/blog.neptunescripts.com\/wp-json\/wp\/v2\/posts\/85\/revisions"}],"predecessor-version":[{"id":97,"href":"https:\/\/blog.neptunescripts.com\/wp-json\/wp\/v2\/posts\/85\/revisions\/97"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.neptunescripts.com\/wp-json\/wp\/v2\/media\/95"}],"wp:attachment":[{"href":"https:\/\/blog.neptunescripts.com\/wp-json\/wp\/v2\/media?parent=85"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.neptunescripts.com\/wp-json\/wp\/v2\/categories?post=85"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.neptunescripts.com\/wp-json\/wp\/v2\/tags?post=85"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}