topical media & game development

talk show tell print

basic-php-14-quickmsg.php / php



  <?php
  require('config.php');
  ?>
  <html>
  <head>
  <title>Quick Message</title>
  </head>
  <body>
  
  <form method="post" action="admin_transact.php">
  
  <p>
    Choose Mailing List:<br />
    <select name="ml_id">
      <option value="all">All</option>
  <?php
  
  conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS)
    or die('Could not connect to MySQL database. ' . mysql_error());
  
  mysql_select_db(SQL_DB, conn);
  
  sql = "SELECT * FROM ml_lists ORDER BY listname";
  result = mysql_query(sql)
    or die('Invalid query: ' . mysql_error());
  
  while (row = mysql_fetch_array(result)) {
    echo "    <option value=\"" . row['ml_id'] . "\">" . row['listname'] .
         "</option>\n";
  }
  
  ?>
    </select>
  </p>
  
  <p>Compose Message:</p>
  
  <p>
    Subject:<br />
    <input type="text" name="subject" />
  </p>
  
  <p>
    Message:<br />
    <textarea name="msg" rows="10" cols="60"></textarea>
  </p>
  
  <p>
    <input type="submit" name="action" value="Send Message" />
  </p>
  
  </form>
  
  <p>
    <a href=<admin.php>>Back to mailing list administration</a>
  </p>
  
  </body> 
  </html>
  


(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.