global recordset

Good morning, I have worked on this for a couple of days with no success. I am trying to sent out an email from a page that has a form in it. I added the Send Email behavior, everything works fine until I try to add a global recordset to the email page. Obviously I do not understand how to use the global statement. In the page that calls the Send Email behavior I added this code to the top of the page:

<?php
global $MyConnection;
?>

<?php ini_set("display_errors",1);?>
<?php require_once('../Connections/MyConnection.php'); ?>
<?php require_once('../webassist/mysqli/rsobj.php'); ?>
<?php require_once("../webassist/email/WA_Email.php"); ?>
<?php require_once('../webassist/mysqli/queryobj.php'); ?>

Could you please help explain how to the global statement in my .php page.

Thank you as always
Karen

global is used to bring a variable from a higher scope into a function where it wouldn't normally be defined.

So if you have this on a page"

<?php

$mylocalvariable = "defined!";



function writeLocalVariable() {

  echo($mylocalvariable);

}



writeLocalVariable();

This will error: "$mylocalvariable is not defined"

Because by default the scope of the variable means it isn't carried into the function. To solve that problem you can use:

<?php

$mylocalvariable = "defined!";



function writeLocalVariable() {

  global $mylocalvariable;

  echo($mylocalvariable);

}



writeLocalVariable();

By declaring the variable global in the function it becomes available to use.

My question is I have this recordset that I want to make global (if I am understanding this correctly):

<?php
$rs_select = new WA_MySQLi_RS("rs_select",$MyConnection,1);
$rs_select->setQuery("SELECT emailaddr, fullname, username, password FROM v_MemberProfile WHERE persSeq = ?");
$rs_select->bindParam("i", "".(isset($_GET['persSeq'])?$_GET['persSeq']:"") ."", "-1"); //colname
$rs_select->execute();
?>

Do I just make this statement

<?php
$mylocalvariable = "$rs_select";
function writeLocalVariable() {
global $mylocalvariable;
echo($mylocalvariable);
}
writeLocalVariable();
?>

What do you mean by "make global"? What does "global" mean to you in this context?

sorry Ray if I was not clear, I guess I am a little lost on getting dynamic fields in an email page.

I have 2 recordsets on a page that has a form and the Send Email behavior ( resendEmail.php).
The recordset has the selected member's name, password, username, email, etc and the second recordset for the business name, email adddress, url, etc.

In the Email Page (Block6.php) I would like to reference the fields in the two recordsets (one the members info and the other recordset the business info).


I am under the impression that $global means I could create a recordset in one .php page and that recordset would be available throughout my other pages.

I thought I could create $global recordsets (on the resendEmail.php page) and then be able to use them in the Email page (Block6.php)
For instance on the Email page have a line where it reads
<p>Welcome <?php echo($rs_select->getColumnVal("v_name")); ?></p>- //The v_name is the members full name from the recordset

Hope I was able to explain myself better.

That is not what global does. You can never declare a database connection or recordset on one page and reference it on another.

Specifically in the email body page you can add a recordset from the main page to use in the body by declaring it on the top of the page like:

<?php
global $RecordsetName;
?>