Notification sistem

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
fciprian
Veteran Member
Posts: 52
Joined: 2020-04-20 10:51

Notification sistem

Post by fciprian » 2020-11-26 12:36

Hello
I try to make a notification sistem.
I have made a table with Name and E_mail and a CHECKBOX:
Emil [email protected]
I have added the automatically email sending code after insert to /hooks folder to the table file and at email recipients i put $notifications
When i check the box it is 1 in the db. So i search like this :
$notifications =sqlValue("SELECT E_mail FROM Notifications where CHECKBOX='1'");
When i have only one line with one email it works. When i check the box it is sending the email and when i disable the box it does not send the email.

The problem is then i have 2 or more lines with emails:
Emil [email protected]
Marius [email protected]
Ema [email protected]
So i need to request: [email protected], [email protected], [email protected]
I have tryed with : $notifications =sqlValue("SELECT E_mail,+', ' FROM Notifications where CHECKBOX='1'"); but no luck...

Can anyone help me with the corect $notifications request? i need to recive [email protected], [email protected], [email protected] from the request.

Thank you.

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Notification sistem

Post by pbottcher » 2020-11-26 18:51

Please dont post the same question in different parts of the forum.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

fciprian
Veteran Member
Posts: 52
Joined: 2020-04-20 10:51

Re: Notification sistem

Post by fciprian » 2020-11-27 00:08

Hello.
Sorry! I understand. Thank you

Post Reply