Recordset-based email not sending

I've created an email template with a couple of recordsets, and I have a page that sends/triggers the email and this also has the same recordsets, so I think the email template is set up correctly to receive the correct database records. I have tried to test by dumping/printing the session, but nothing is being printed to the screen. Therefore I assume that the email isn't sending for some reason.

I've attached the trigger page and the email template page; any thoughts on what I've done wrong?

Thanks.

Right, I've tried again with two new pages and the original email template (because it took ages to create and don't want to have to do it again).

zzz.php is the trigger email page (a user needs to be signed in to populate the recordset which is filtered on SecurityAssist_UserID). This has an update behaviour (which works) and error reporting switched on and produces this error:


Notice: Undefined variable: conn_mrs in /home/blah/blah/email-your-details.php on line 5

Fatal error: Uncaught Error: Call to a member function query() on null in /home/blah/blah/webassist/mysqli/rsobj.php:195 Stack trace: #0 /home/blah/blah/email-your-details.php(8): WA_MySQLi_RS->execute() #1 /home/blah/blah/webassist/email/WA_Email.php(306): require('/home/hp3-linc4...') #2 /home/blah/blah/webassist/email/WA_Email.php(465): WA_Email->getFromPage('email-your-deta...') #3 /home/blah/blah/zzz.php(42): WA_Email->send(0) #4 {main} thrown in /home/blah/blah/webassist/mysqli/rsobj.php on line 195


zzzz.php has the session dump in it to print the contents of the email being sent to screen, but it's not getting to this page because the send email page is erroring.

email-your-details.php is attached again, but I don't think there is an issue with this page either because if I am signed in as a user and manually type this page address in, it loads with the correct data.

So my assumption is that the issue lies with the trigger page (zzz.php), but I have no idea what it could be!

Any help would be greatly appreciated.

Thanks.

Try adding this to the top of your email-your-details.php page:

<?php

global $conn_mrs;

?>

Since the email body page is included from the main page, the require_once() referencing the connection is ignored because it was already added before.

But since it is referenced from a function, the variables defined (the connection) is out of scope and can't be referenced.

Adding the global declaration will bring the variable back into scope. Another solution would be to change the require_once() around the connection reference to require(), but that is less efficient since it will open a new connection when one is already available from the original page.