Advertisement
Guest User

Untitled

a guest
Jun 12th, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.97 KB | None | 0 0
  1. <?php
  2.  
  3. // mysql variables
  4. $host='localhost';
  5. $user='root';
  6. $pass='mypass';
  7. $database='pager';
  8.  
  9. // SQL Queries
  10. $query1 = "SELECT *
  11. FROM feed, recipients
  12. WHERE feed.title LIKE concat('%', recipients.suburb, '%')
  13. ORDER BY pubDate DESC";
  14.  
  15. $recipients = "SELECT *
  16. FROM recipients
  17. ORDER BY id DESC";
  18.  
  19. // Make a MySQL Connection
  20. $db = mysql_connect($host, $user, $pass) or die(mysql_error());
  21. mysql_select_db($database) or die(mysql_error());
  22.  
  23. // Start script to send SMS/eMail
  24. $result = mysql_query($query1);
  25. $result2 = mysql_query($recipients);
  26. $row = mysql_fetch_array( $result2 );
  27. $row2 = mysql_fetch_array( $result );
  28. foreach($result2 as $row);
  29.  
  30. // actual email
  31. $to = $row['email'];
  32. $subject = "Page: ". $row2['title'];
  33. $body = $row2['description'];
  34. if (mail($to, $subject, $body)) {
  35.   echo("<p>sent!</p>");
  36.  } else {
  37.   echo("<p>failed!</p>");
  38.  }
  39. ?>
  40.  
  41. ERROR:
  42. Warning: Invalid argument supplied for foreach() in /var/whirltools/www/email.php on line 28
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement