- <?php
- require_once('includes/realm1.php')
- ?>
- <!DOCTYPE html
- PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
- <title>Newsletter</title>
- <link type="text/css" rel="stylesheet" href="black.css" />
- </head>
- <body>
- <?php
- include 'includes/settings.php';
- include 'includes/header.php';
- include 'includes/leftsidebar.php';
- include 'includes/extraleftsidebar.php';
- ?>
- <div id="main">
- <h1 class="centered">Newsletter Directory</h1>
- <p></p>
- <?php
- if(isset($_POST['submit'])){
- $from='henry@condeso.net';
- $subject=$_POST['subject'];
- $text=$_POST['text'];
- $output_form=false;
- if (empty($subject) && empty($text)){
- echo 'You forgot the email subject and message.<br />';
- $output_form=true;}
- if (empty($subject) && (!empty($text))){
- echo 'You forgot the email subject.<br />';
- $output_form=true;}
- if ((!empty($subject)) && empty($text)){
- echo 'You forgot the email message.<br />';
- $output_form=true;}
- if ((!empty($subject)) && (!empty($text))){
- $dbc=mysqli_connect('localhost', 'User', 'Password', 'Database')
- or die('Error connecting to MySQL server.');
- $query="SELECT * FROM users";
- $result=mysqli_query($dbc, $query)
- or die('Error querying database.');
- while($row=mysqli_fetch_array($result)){
- $firstname=$row['firstname'];
- $lastname=$row['lastname'];
- $message="Dear $firstname $lastname,\n$text";
- $to=$row['email'];
- mail($to, $subject, $message, 'From:'.$from);
- echo 'Email sent to : '.$to.'<br />';}
- mysqli_close($dbc);}}
- else{$output_form=true;}
- if ($output_form){
- ?>
- <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
- Subject : <input type="text" value="<?php echo $subject; ?>" name="subject" /><br />
- Message : <textarea rows="8" cols="40" name="text"><?php echo $text; ?></textarea><br />
- <input type="submit" value="Send mass email" name="submit" />
- </form>
- </div>
- <?php
- }
- include 'includes/extramain.php';
- include 'includes/analytics.php';
- ?>
- </body>
- </html>