+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: Email Function (/showthread.php?tid=29010)
Email Function - El Forum - 03-27-2010
[eluser]Unknown[/eluser]
Hello,
I am using an email function - it works as expected when testing to myself. However, I can't seem to get an email field selected from a database to populate a variable :
Code:
$this->load->library('form_validation');
$this->form_validation->set_rules('username', 'Username','trim|required|callback_forgot_pass_username_check');
$this->form_validation->set_error_delimiters('', '<br />');
if ($this->form_validation->run() == TRUE)
{ // grab registered users email and send them the link
$this->db->select('email')->where('username', $this->input->post('username'));
$query = $this->db->get('users');
$this->email->from('[email protected]', 'Hello World');
$this->email->to($query);
$this->email->subject('Some Topic');
etc.....I am trying to select from the database --> table users ---> email, then use that variable as $query - Any thoughts?
EDIT : Just noticed this may be in the wrong forum - move as needed - thanks.
Email Function - El Forum - 03-28-2010
[eluser]hugle[/eluser]
Hello,
try;
Code:
$email = $this->db->select('email')->where('user_id', 1)->get('users')->row()->email;you select the user email from database whose user ID is euqal to 1...
home that helps you somehow
Email Function - El Forum - 03-28-2010
[eluser]Unknown[/eluser]
Thanks hugle. I was able to break that down and engineer it to work in my case. Thank you!