03-02-2017, 03:28 AM
Hey guys!
To preface - I'm a total php noob... Mainly a front end dev here who fiddles with php only every now and then. I've been using Usercake, and now Userspice, to build a secure container around a product/investment website our company runs so we can hand out logins for certain people we want to show the product to. So far I'm really enjoying the learning process.. It's a steep curve, but so far the software and the documentation here has been really good
Now, I'm trying to extend a couple of things in the framework. So far, I've fiddled with the registration system so now when a user registers, it sends the admin an email asking to approve that member. Once the member is approved by the admin, they get an email notifying them that they can now log in.
However, I'm trying to get the initial approval notification email to display more information. Basically, I want the email that my admin recieves to show all the fields about that user: first/last name, username, company name, phone number etc... I can see that $fname; is queried and appended to the email easily enough, but the block of php in the _email_template_activated.php file (below) doesn't seem to be enough to fetch $lname;, $company, and the other custom fields I've added like phone and so forth...
Can someone please point out what I need to query to show these other values? I've been trying things like $results = $query->all(); which doesn't seem to work..
Thanks guys!
<pre></pre>
To preface - I'm a total php noob... Mainly a front end dev here who fiddles with php only every now and then. I've been using Usercake, and now Userspice, to build a secure container around a product/investment website our company runs so we can hand out logins for certain people we want to show the product to. So far I'm really enjoying the learning process.. It's a steep curve, but so far the software and the documentation here has been really good
Now, I'm trying to extend a couple of things in the framework. So far, I've fiddled with the registration system so now when a user registers, it sends the admin an email asking to approve that member. Once the member is approved by the admin, they get an email notifying them that they can now log in.
However, I'm trying to get the initial approval notification email to display more information. Basically, I want the email that my admin recieves to show all the fields about that user: first/last name, username, company name, phone number etc... I can see that $fname; is queried and appended to the email easily enough, but the block of php in the _email_template_activated.php file (below) doesn't seem to be enough to fetch $lname;, $company, and the other custom fields I've added like phone and so forth...
Can someone please point out what I need to query to show these other values? I've been trying things like $results = $query->all(); which doesn't seem to work..
Thanks guys!
<pre>
Code:
<?php
$db = DB::getInstance();
$query = $db->query("SELECT * FROM email");
$results = $query->first();
?>