[Adding new data to the email]

Thank you so much for your help. It works!

[Adding new data to the email]

OK. Thank you so much. I'm not looking for something fancy thb. I care more about whether it will work.

One last thing.. Could you please tell me what is the difference between those two lines? dots vs curly braces

$mail_content .= "".$a['pay_url']. - .$a['customer_name']. - .$a['customer_surname']. - .$a['amount']." -> Paid <br>";

 

$mail_content .= "{$a['pay_url']} - {$a['customer_name']} - {$a['customer_surname']} - {$a['amount']} -> Paid <br>";

 

[Adding new data to the email]

$mail_content .= "{$a['pay_url']} - {$a['customer_name']} - {$a['customer_surname']} - {$a['amount']} -> Paid <br>";

like this?

Because there are 4-5 paid reservations every day. Here's the regular email: https://imgur.com/a/baEkQ7s

[Adding new data to the email]

Hi,

The code below checks the "Paid" reservations from the database and sends them as an email with a cron job.

Normally only "pay_url" data is added, yet I'd like to add "customer_name", "customer_surname" and "amount" too with pay_url.

Could you please guide me how to do it?

Thank you in advance.

<?php
include "../lib/include.php";

$yesterdayDate = date("Y-m-d 09:00:00", strtotime("-1 days"));
$query = "select * from links where status = 1 and cc_payment_id != '' and payment_date >= '".$yesterdayDate."' and payment_date <= '".date("Y-m-d 08:59:59")."'";


$q = $db->query($query);
foreach ($q AS $a) {

	$mail_content .= "".$a["pay_url"]." -> Paid<br>";
}

if ($mail_content != "") {
	SendMail($settings["system_email"],$mail_content,"Paid Reservations");
}

 

[Adding a new email address]

Hi there,

I would like to add another email address to my code below:

<?php

include "../lib/include.php";

$yesterdayDate = date("Y-m-d 09:00:00", strtotime("-1 days"));

$query = "select * from links where status = 1 and cc_payment_id != '' and payment_date >= '".$yesterdayDate."' and payment_date <= '".date("Y-m-d 08:59:59")."'";

$q = $db->query($query);

foreach ($q AS $a) {
$mail_content .= "".$a["pay_url"]." -> Paid<br>";

}
if ($mail_content != "") {

SendMail($settings["system_email"],$mail_content,"Paid Reservations");

}

Will it work and be enough if I make a change as below:

SendMail("email1@domain1.com; email2@domain2.com",$mail_content,"Paid Reservations");

Thank you in advance.