Sending email

[benchew0904]

I need some help over here.

 

I want to send an email to my friends by checking the database and extract the id.

After extracting the id from the database, i want to include a URL with the id.

E.g.

www.abc.php?35 (35 is the id)

www.abc.php?40 (40 is the id)

 

May I know how to send an email with multiple url?

Is it using a for loop in the php email function?

 

Your help is greatly appreciated.

 

[joel24]

To send one ID to the corresponding email;

use a while loop to cycle through the ids from the database and then use the mail() function to send an email to each.

 

Or if you want to send all the ids to one email;

use a while loop to cycle through the ids and add it to a string which will be emailed using mail();

[benchew0904]

how should i go about doing it if i want to send all the ids to one email?

[cyberRobot]

So basically, you want to loop through the content extracted from the database and display a link for each entry. Then you want the user to click each link which would send an e-mail to whoever's entry was clicked. Is that correct?

[benchew0904]

..

So basically, you want to loop through the content extracted from the database and display a link for each entry. Then you want the user to click each link which would send an e-mail to whoever's entry was clicked. Is that correct?

No..i'm trying to extract my friend appointment_id and send an email to them if they have any appointment date on the following week.

And the email content will be the link to their appointment date to let them confirm their appointment date.

 

E.g. of the email content

www.abc.php?40 (40 will be my friend appointment_id)

www.abc.php?42 (42 will be my friend appointment_id)

 

Hope you get what i mean

[joel24]

what are the fields in the db table?

 

where are the emails stored...?

 

just to make sure I'm understanding your intentions; you want to extract the appointments from the database and send an email to each user with their appointments?

[benchew0904]

Email are stored in session after customer log in..

They will click on the button to send..

 

This is the code after clicking on the button

<?php

include 'config.php'; //my configuration, username, password etc

$sql = "SELECT * from customer c WHERE c.uid = " . $_SESSION['uid'] . "and c.appointmentDate BETWEEN CURRENT_DATE AND (CURRENT_DATE + INTERVAL 7 DAY )";
$sql1= exeSelectQuery($sql);


if (isset($_POST['submit'])) { //after clicking on the button 
    if ($sql1) {
        $to = $_SESSION['mail'];
        $subject = "Appointment Reminder";
        $body = "Dear Customer \n\n" .
                "Please confirm your following appointment date by clicking on the link  . \n" .
                "http://abc.php?40  \n" . #40 is the appointment_id
                "http://abc.php?42  \n" . #42 is the appointment_id
                "Regard\n" .
                "Admin";
        $header = 'From: myemail@abc.com' ;
        $deliver = mail($to, $subject, $body, $header);

        if ($deliver) {
            echo "Appointment Reminder Sent. \n";
        } else {
            echo "Appointment Reminder Sending Fail. \n";
        }
    }
}
?>

[joel24]

<?php

include 'config.php'; //my configuration, username, password etc

$sql = "SELECT * from customer c WHERE c.uid = " . $_SESSION['uid'] . "and c.appointmentDate BETWEEN CURRENT_DATE AND (CURRENT_DATE + INTERVAL 7 DAY )";
$sql1= exeSelectQuery($sql);


if (isset($_POST['submit'])) { //after clicking on the button 
    if ($sql1) {
        $to = $_SESSION['mail'];
        $subject = "Appointment Reminder";
        $body = "Dear Customer \n\n" .
                "Please confirm your following appointment date by clicking on the link  . \n";

while ($row = mysql_fetch_assoc($sql)) {
$body .= "http://abc.php?{$row['appointment_id']} \n";
}

$body .=  "Regard\n" .
                "Admin";
        $header = 'From: myemail@abc.com' ;
        $deliver = mail($to, $subject, $body, $header);

        if ($deliver) {
            echo "Appointment Reminder Sent. \n";
        } else {
            echo "Appointment Reminder Sending Fail. \n";
        }
    }
}
?>

[benchew0904]

I tried adding in the while loop but it didnt print out the link..

[joel24]

You need to put in a html anchor tag to link it...

while ($row = mysql_fetch_assoc($sql)) {
$body .= "<a href='http://abc.php?{$row['appointment_id']}'>http://abc.php?{$row['appointment_id']}</a> \n";
}

 

#edit

you should set the content type to HTML if you're having links in there

 

read this

//FROM php.net
// To send HTML mail, the Content-type header must be set
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

[benchew0904]

I have edited but it also didn't show the link

[joel24]

what does it display?

 

post your code

[benchew0904]

This is my code

<?php

include 'config.php';

$sql = "SELECT * from customer c WHERE c.uid = " . $_SESSION['uid'] . "and c.appointmentDate BETWEEN CURRENT_DATE AND (CURRENT_DATE + INTERVAL 7 DAY )";
$sql1 = exeSelectQuery($sql);

if (isset($_POST['submit'])) {
    if ($sql1) {
        $to = $_SESSION['mail'];
        $subject = "Appointment Reminder";
        $body = "Dear Customer <br/><br/>" .
                "Please confirm your following appointment date by clicking on the link. <br/>";

        while ($row = mysqli_fetch_assoc($sql)) {
            $body .= "<a href='http://abc.php?{$row['appointment_id']}'>
            http://abc.php?{$row['appointment_id']}</a> <br/>";
        }
        $body .= "Regard<br/>" .
                "Admin";
        $headers = 'MIME-Version: 1.0' . "\r\n";
        $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
        $headers .= 'From: myemail@abc.com' . "\r\n";
        $deliver = mail($to, $subject, $body, $headers);

        if ($deliver) {
            echo "Appointment Reminder Sent. \n";
        } else {
            echo "Appointment Reminder Sending Fail. \n";
        }
    }
}
?>

 

This is the output which I have received.

 

Dear Customer

 

Please confirm your following appointment date by clicking on the link.

 

 

Yours Sincerely

Admin

[Muddy_Funster]

change this

while ($row = mysqli_fetch_assoc($sql)) {

to

while ($row = mysqli_fetch_assoc($sql1)) {

you are using the wrong variable in your fetch, I suggest using more relative variable names to avoid this issue in the future.  Also, checking mysql_num_rows($sql1) will allow you to check for no appointments and handle that accordingly.

[benchew0904]

oh ok..

by the way what you meant by checking mysql_num_rows($sql1)?

[Muddy_Funster]

if (mysql_num_rows($sql1) == 0){
echo "you have no appointments in the next 7 days.  Thank you for checking with us.";
}
else{
//produce email
}

[benchew0904]

Sorry, i'm quite weak in php..May I know which line i should add in the

if (mysql_num_rows($sql1) == 0){

[cyberRobot]

Sorry, i'm quite weak in php..May I know which line i should add in the

if (mysql_num_rows($sql1) == 0){

 

That's where you put whatever should happen if no results were found.