Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- How to access variable in a while loop from a function in PHP?
- <?php
- while ($row = mysql_fetch_assoc($result))
- {
- print_r($row); echo "<br><br>";
- $name = $row['Name'];
- $date = $row['sDate'];
- $time = $row['sTime'];
- $phone = $row['Phone'];
- $email = $row['Email'];
- sendMail($row['Email']);
- $company = $row['Company'];
- $course = $row['Course'];
- $ref = $row['Reference'];
- $optout = $row['optout'];
- echo "<tr bgcolor=#ABB5F6>
- <td>$name</td>
- <td>$date</td>
- <td>$time</td>
- <td>$phone</td>
- <td>$email</td>
- <td>$company</td>
- <td>$course</td>
- <td>$ref</td>
- <td>$optout</td>
- </tr>";
- }
- // Mail to $to and $emailarray recipients
- function sendMail($to)
- {
- $subject = 'Test mail';
- $message = 'Hello'.$name; // I want $name from the while loop
- $headers = array();
- $headers[] = "From:" . "myemail@email.com";
- $headerz = implode("rn", $headers);
- mail($to, $subject, $message, $headerz);
- }
- ?>
- // Mail to $to and $emailarray recipients
- function sendMail($to, $name)
- {
- $subject = 'Test mail';
- $message = 'Hello'.$name; // I want $name from the while loop
- $headers = array();
- $headers[] = "From:" . "myemail@email.com";
- $headerz = implode("rn", $headers);
- mail($to, $subject, $message, $headerz);
- }
- function sendMail($to, $name)
- sendMail($row['Email'], $row['Name']);
- function sendMail($to, $name);
- sendMail($row['Email'], $row['name']);
- <?php
- while ($row = mysql_fetch_assoc($result))
- {
- print_r($row); echo "<br><br>";
- $name = $row['Name'];
- $date = $row['sDate'];
- $time = $row['sTime'];
- $phone = $row['Phone'];
- $email = $row['Email'];
- // i added name as a parameter
- sendMail($row['Email'],$name);
- $company = $row['Company'];
- $course = $row['Course'];
- $ref = $row['Reference'];
- $optout = $row['optout'];
- echo "<tr bgcolor=#ABB5F6>
- <td>$name</td>
- <td>$date</td>
- <td>$time</td>
- <td>$phone</td>
- <td>$email</td>
- <td>$company</td>
- <td>$course</td>
- <td>$ref</td>
- <td>$optout</td>
- </tr>";
- }
- // Mail to $to and $emailarray recipients
- // i added name as a parameter
- function sendMail($to,$name)
- {
- $subject = 'Test mail';
- $message = 'Hello'.$name; // I want $name from the while loop
- $headers = array();
- $headers[] = "From:" . "myemail@email.com";
- $headerz = implode("rn", $headers);
- mail($to, $subject, $message, $headerz);
- }
- ?>
Add Comment
Please, Sign In to add comment