piccola newsletter

[pieroflash]

e questo e il codice per la pagina index.php

<?php
  //carico il config
  require("config.php");
  
  //stampo l'header
  echo $header;
?>

<h1><?php echo $title; ?></h1>
<hr>
<?php  
  //form 
  if(isset($_POST["submit"])){
    //connessione al database
    @mysql_connect($db_server,$db_user,$db_password) or die("Database server connection failed. Check variables \$db_server, \$db_user and \$db_password in config.php");
    @mysql_select_db($db_name) or die("Selecting database failed. Check variable \$db_name in config.php");

    $nome = $_POST["nome"];
    $email = $_POST["email"];
    
    //iscrizione
    if($_POST["action"]=="subscribe"){
      //verifico la lunghezza del nome
      if(strlen($nome)<3){
        ?>
<p align="center" class="Stile1">Il nome deve essere almeno di 3 caratteri</p>
<?php
      //verifico l'email se esiste gia
      }else if(!eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}$",$email)){
        ?><p align="center" class="Stile1">Email non valida.</p>
<?php
      //l'email e gia esistente
      }else if(@mysql_num_rows(@mysql_query("SELECT id FROM  news  WHERE email='$email';"))){
        ?><p align="center" class="Stile1">Email gia' esistente.</p>
<?php
      //inserisco i dati nome e email nella tabella news
      }else{
        @mysql_query("INSERT INTO  news (email, nome) VALUES ('$email','$nome');");

        //se mi dai errore
        if(@mysql_error()){
          ?><p align="center" class="Stile1">Errore. riprova dopo.</p>
<?php
        //allora tutto bene
        }else{
          ?><p align="center" class="Stile1">Iscrizzione avvenuta.</p>
<?php
        }
      }
    //cancello i dati dal database
    }else{
     
      @mysql_query("DELETE FROM $news WHERE email='$email';");
      //errore
      if(@mysql_error()){
        ?><p align="center" class="Stile1">Errore. Riprova dopo.</p>
<?php
     
      }else if(@mysql_affected_rows()==0){
        ?><p align="center" class="Stile1">Email non inserita.</p>
<?php
      
      }else{
        ?><p align="center" class="Stile1">Cancellata con successo!</p>
<?php
      }
    }
  }
?>
<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post">
  <table>
    <tr>
      <td> Nome:</td>
      <td><input type="text" name="nome" value="" maxlength="255"></td>
    </tr>
    <tr>
      <td>Email:</td>
      <td><input type="text" name="email" value="" maxlength="255"></td>
    </tr>
    <tr>
      <td></td>
      <td><input type="radio" name="action" value="subscribe" id="action_subscribe" checked> <label for="action_subscribe">Iscrivimi</label><input type="radio" name="action" value="unsubscribe" id="action_unsubscribe"> <label for="action_unsubscribe">Cancellami</label></td>
    </tr>
    <tr>
      <td></td>
      <td><input type="submit" name="submit" value="Submit"></td>
    </tr>
  </table>
</form>
<p align="right">[url="admin.php"]Amministratore[/url]</p>
<?php
  
  echo $footer;

  //chiudo la connessione al database
  @mysql_close();
?>

grazie per l'aiuto Virus