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:
and this is the php code:
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
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:
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> </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> </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">
<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> </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:
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 = "info@ricarica-gratis.com";
$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
Comment