Script send mail and save into mysql db

[toretto]

Hello,

I have a script php that I use on my website to permit visitors to send me some email with some data, this is the html table code:

<table width="730" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td><div align="center" class="textorange1"><strong>Richiesta Ricarica</strong></div></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td><div align="center" class="textblack1">Prima di compilare questo form bisogna effettuare le registrazioni come indicato nel regolamento, poi compilare tutti i campi o la richiesta di ricarica non verrà accettata.</div></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td><div align="center">
              <div align="center">
                <form id="commentform" name="commentform" method="post" action="ricarica.php">
                  <table width="500" border="0" cellspacing="0" cellpadding="0">
                    <tr align="left" valign="middle">
                      <td width="170" height="20" class="textblack1"><div align="left">Nome  *:</div></td>
                      <td width="120"><div align="left">
                        <input name="nome" type="text" class="inputdepartment" id="nome" size="20" />
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Cognome *:</div></td>
                      <td><div align="left">
                        <input name="cognome" type="text" class="inputdepartment" id="cognome" size="20" />
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Data di nascita *:</div></td>
                      <td><div align="left">
                        <input name="datadinascita" type="text" class="inputdepartment" id="datadinascita" value="gg/mm/aaaa" size="20" />
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Sesso *:</div></td>
                      <td><div align="left">
                        <select name="sesso" id="sesso" class="inputdepartment">
                          <option value="-------" selected="selected">-------</option>
                          <option value="Maschio">Maschio</option>
                          <option value="Femmina">Femmina</option>
                        </select>
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Indirizzo *:</div></td>
                      <td><div align="left">
                        <input name="indirizzo" type="text" class="inputdepartment" id="indirizzo" size="20" />
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">CAP *:</div></td>
                      <td><div align="left">
                        <input name="cap" type="text" class="inputdepartment" id="cap" size="20" />
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Provincia  *:</div></td>
                      <td><div align="left">
                        <input name="provincia" type="text" class="inputdepartment" id="provincia" size="20" />
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Comune *:</div></td>
                      <td><div align="left">
                        <input name="comune" type="text" class="inputdepartment" id="comune" size="20" />
                      </div></td>
                    </tr>
 
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Numero cellulare/carta da ricaricare/email Paypal *:</div></td>
                      <td><div align="left">
                        <input name="ricarica" type="text" class="inputdepartment" id="ricarica" size="20" />
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Il suo indirizzo e-mail *: </div></td>
                      <td><div align="left">
                        <input name="email" type="text" class="inputdepartment" id="email" size="20" />
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Conferma indirizzo e-mail *: </div></td>
                      <td><div align="left">
                        <input name="email" type="text" class="inputdepartment" id="email" size="20" />
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Orario registrazione *:</div></td>
                      <td><div align="left">
                        <input name="orario" type="text" class="inputdepartment" id="orario" value="XX:XX" size="20" />
                      </div></td>
                    </tr>
 
 
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Data registrazione *:</div></td>
                      <td><div align="left">
                        <input name="data" type="text" class="inputdepartment" id="data" value="gg/mm/aaaa" size="20" />
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Operatore *:</div></td>
                      <td><div align="left">
                        <select name="operatore" id="operatore" class="inputdepartment">
                          <option value="-------" selected="selected">-------</option>
                          <option value="Tim">Tim</option>
                          <option value="Vodafone">Vodafone</option>
                          <option value="Wind">Wind</option>
                          <option value="Tre">Tre</option>
                          <option value="PosteMobile">PosteMobile</option>
                          <option value="PostePay">PostePay</option>
                          <option value="Paypal">Paypal</option>
                          <option value="MediasetPremium">MediasetPremium</option>
                        </select>
                      </div></td>
                    </tr>
                    <tr align="left" valign="middle">
                      <td height="20" class="textblack1"><div align="left">Come ci hai conosciuto *: </div></td>
                      <td><div align="left">
                        <select name="know" id="know" class="inputdepartment">
                          <option value="-------" selected="selected">-------</option>
                          <option value="Google">Google</option>
                          <option value="Yahoo">Yahoo</option>
                          <option value="Amici">Amici</option>
                          <option value="Parenti">Parenti</option>
                          <option value="Altro">Altro</option>
                        </select>
                      </div></td>
                    </tr>
 
                    <tr align="left" valign="middle">
                      <td class="textblack1"><div align="left">Media partners su cui ci si è iscritti:
 *:</div></td>
                      <td><div align="left">
                        <textarea name="msg" cols="35" rows="10" class="inputtextarea" id="msg"></textarea>
                      </div></td>
                    </tr>
                  </table>
                  <table border="0" cellpadding="0" cellspacing="0" width="500">
                    <tr align="center" valign="middle">
                      <td height="30">
                          <div align="center">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                            <input onclick="return confirm('Siete sicuri di aver effettuato le registrazioni ai media partner come indicato nel regolamento? Se non l\'avete fatto la richiesta non sarà accettata.');" name="Submit" type="submit" class="inputbutton" value="Invia" />
                            <input name="Submit2" type="reset" class="inputbutton" value="Reset" />
                          </div></td>
                    </tr>
                    <tr align="left" valign="top">
                      <td height="20"><div class="textblack1">
                        <div align="left"><strong>* Richiesto</strong></div>
                      </div></td>
                    </tr>
                  </table>
                </form>
              </div>
            </div></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td><div align="center">Inviando la richiesta si accettano il <a href="regolamento.html" target="_blank" class="textorange1"><strong>regolamento</strong></a> e le <a href="faq.html" target="_blank" class="textorange1"><strong>faq</strong></a>.</div></td>
          </tr>
        </table>

and this is the php code:

<html>
 
<head>
 
<title>Mail</title>
 
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
 
<style type="text/css">
 
<!--
 
 
 
.mini {
 
    font-family: Tahona, Verdana;
 
    font-size: 11px;
 
        color: #333333;
 
}
 
body, td, th {
 
    font-family: Tahoma, Verdana, Arial, Helvetica, sans-serif;
 
    font-size: 11px;
 
    color: #333333;
 
}
 
a:link {
 
    text-decoration: none;
 
}
 
a:visited {
 
    text-decoration: none;
 
}
 
a:hover {
 
    text-decoration: underline;
 
}
 
a:active {
 
    text-decoration: none;
 
}
 
body {
 
    margin:50px; background-color: #ffffff
 
}
 
.status {
 
    font-size: 11px;
 
    color: #FF7E00;
 
}
 
-->
 
 
 
</style>
 
<div class="message">
 
<?php
 
 
 
$receiverMail    = "[e-mail]";
 
$nome        = ltrim(rtrim(strip_tags(stripslashes($_POST['nome']))));
 
$cognome    = ltrim(rtrim(strip_tags(stripslashes($_POST['cognome']))));
 
$datadinascita    = ltrim(rtrim(strip_tags(stripslashes($_POST['datadinascita']))));
 
$sesso      = ltrim(rtrim(strip_tags(stripslashes($_POST['sesso']))));
 
$indirizzo    = ltrim(rtrim(strip_tags(stripslashes($_POST['indirizzo']))));
 
$cap        = ltrim(rtrim(strip_tags(stripslashes($_POST['cap']))));
 
$provincia    = ltrim(rtrim(strip_tags(stripslashes($_POST['provincia']))));
 
$comune     = ltrim(rtrim(strip_tags(stripslashes($_POST['comune']))));
 
$ricarica    = ltrim(rtrim(strip_tags(stripslashes($_POST['ricarica']))));
 
$email        = ltrim(rtrim(strip_tags(stripslashes($_POST['email']))));
 
$orario     = ltrim(rtrim(strip_tags(stripslashes($_POST['orario']))));
 
$data        = ltrim(rtrim(strip_tags(stripslashes($_POST['data']))));
 
$operatore    = ltrim(rtrim(strip_tags(stripslashes($_POST['operatore']))));
 
$know       = ltrim(rtrim(strip_tags(stripslashes($_POST['know']))));
 
$msg        = "Media partners su cui ci si è iscritti: \n--------------------------------------------\n".ltrim(rtrim(strip_tags($_POST['msg'])));
 
 
 
$ip        = getenv("REMOTE_ADDR");
 
$msgformat    = "Da: $nome $cognome - ($ip)\nData di nascita: $datadinascita\nSesso: $sesso\nIndirizzo: $indirizzo\nCAP: $cap\nProvincia: $provincia\nComune: $comune\nRicaricare: $ricarica\nEmail: $email\nOrario: $orario\nData di registrazione: $data\nOperatore: $operatore\nCome ci hai conosciuto: $know\n\n$msg";
 
 
 
// VALIDATION
 
if(empty($nome) || empty($cognome) || empty($datadinascita) || empty($sesso) || empty($indirizzo) || empty($cap) || empty($provincia) || empty($comune) || empty($ricarica) || empty($email) || empty($orario) || empty($data) || empty($operatore) || empty($know) || empty($msg)) {
 
echo "<center><b>La tua richiesta non e' stata inviata</b><p>Per favore compila tutti i campi</p><A href='javascript:history.back()' class='status'>[ Indietro ]</a><br><br></center>"; 
 
}
 
elseif(!ereg("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email)) {
 
echo "<center><b>La tua richiesta non e' stata inviata</b><p>L'indirizzo email non e' valido</p><A href='javascript:history.back()' class='status'>[ Indietro ]</a><br><br></center>";
 
}
 
else {
 
    mail($receiverMail, $operatore, $msgformat, "From: $nome <$email>");
 
 
 
    echo "<center><strong>La tua richiesta e' stata inviata!</strong><p>Ti ricontatteremo non appena possibile</p><A href='index.html' class='status'>[ Indietro ]</a><br><br></center>";
 
 
 
}
 
?>
 
</div>
 
</body>
 
</html>

what I need from that script php is that when it send to me the mail in the same time save all data on a db, how I can modify that script to do that?

Thank you for all reply.

Michael

[Markus]

Using a database such as MySQL(i), you would create a table that has all the fields you want saving. Then you would use an SQL INSERT query to add new data to the table.

I suggest you get to grips with MySQL first.

Tutorial: MySQL Tutorial - Introduction