Adding new data to the email

[denial]

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");
}

 

[Barand]

13 minutes ago, denial said:

I'd like to add "customer_name", "customer_surname" and "amount" too

Then append those to the content too.

[denial]

$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

[Barand]

18 minutes ago, denial said:

like this?

If that's how you want the layout to look. Only you know that.

[denial]

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>";

 

[Barand]

The one with braces will work, the other won't even run.

[Barand]

20 minutes ago, denial said:

I care more about whether it will work.

You find that out with a process commonly known as "testing" (You might want to Google that)

[denial]

Thank you so much for your help. It works!