Hello,
orders_list.htm
============================
<SPAN class=buttonborder>
<INPUT class=button onclick="frmAdmin.a.value='email'; frmAdmin.submit(); return false;"
value="Email selected" type=button>
</SPAN>
========================
3. Add the following code to the List page: Before process event.
if(@$_REQUEST["a"]=="email")
{
if(@$_REQUEST["selection"])
{
$body="";
foreach(@$_REQUEST["selection"] as $keyblock)
{
$arr=split("&",refine($keyblock));
if(count($arr)<1)
continue;
$keys=array();
$keys["OrderID"]=urldecode(@$arr[0]);
$where = KeyWhere($keys);
$rs = CustomQuery("select * from orders where $where");
$data=db_fetch_array($rs);
$body .= "OrderID: " . $data['OrderID'] . "\n";
$body .= "Customer: " . $data['CustomerID'] . "\n";
$body .= "Employee: " . $data['EmployeeID'] . "\n-------------------\n\n";
}
// send the email
$email="test@test.com";
$subject="Sample subject";
$arr = runner_mail(array('to' => $email, 'subject' => $subject, 'body' => $body));
// if error happened print a message on the web page
if (!$arr["mailed"])
{
echo "Error happened:
";
echo "File: " . $arr["errors"][0]["file"] . "
";
echo "Line: " . $arr["errors"][0]["line"] . "
";
echo "Description: " . $arr["errors"][0]["description"] . "
";
}
}
}
I am using northwind database (livedemo3).
http://www.xlinesoft.com/phprunner/docs/email_selected_records.htm
copied the avove code from docs page.
After pressing Email selected button following details were mailed to my email;
OrderID: 10248
Customer: WILMK
Employee: 5
-------------------
OrderID: 10248
Customer: WILMK
Employee: 5
-------------------
OrderID: 10248
Customer: WILMK
Employee: 5
-------------------
OrderID: 10248
Customer: WILMK
Employee: 5
-------------------
OrderID: 10248
Customer: WILMK
Employee: 5
-------------------
OrderID: 10248
Customer: WILMK
Employee: 5
-------------------
OrderID: 10248
Customer: WILMK
Employee: 5
-------------------
OrderID: 10248
Customer: WILMK
Employee: 5
-------------------
What changes are required to email the all selected records instead of only first record.
Thanks,
--Anu