snipt

Ctrl+h for KB shortcuts

PHP

Backup and send all post vars from a form

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

$admin = ""; // mail
$to = $admin.", ".base64_decode($_POST['responsabile']);
$mailSubject = "Rubelli Resellers | Nuova richiesta da confermare per ".ucfirst($_POST['nome']);
$not_capitalized = array("email", "responsabile", "website");

$mailBody = "Ciao! :)
Un nuovo rivenditore ha richiesto di essere inserito nel sito.
A seguire i dati inseriti:

-

";
$dataString = "";

foreach($_POST as $key => $value) {
	if ($key == "brands"){
		$value = implode (", ", $value);
	}
	if (!in_array($key, $not_capitalized)){
		$value = ucfirst($value);
	}
$mailBody .= strtoupper($key).": ".$value."
"; 
$dataString .= "'".$value."', ";
}

try {
	$columns = implode(", ",array_keys($_POST));
	
    $dbh = new PDO('mysql:host=localhost;dbname=common', 'root', 'mysqelle563_');
	$query = "INSERT INTO resellers (".$columns.", active) VALUES (".$dataString." FALSE)";
    $sth = $dbh->exec($query);
	$id = $dbh->lastInsertId();
    $dbh = null;
} catch (PDOException $e) {
    print "Attention: " . $e->getMessage() . "<br>";
    die();
}

$mailBody .= "
-

Se i dati sono corretti e vuoi pubblicare il rivenditore, clicca qui:
http://www.rubelli.com/resellers/confirm.php?id=".$id."

Se i dati invece contengono degli errori, inoltra questa mail ricorretta a [email protected] sottolineando le correzioni.

Grazie mille!
";

// salva i dati su dbS
if(mail($to, $mailSubject, $mailBody)==true){
	$myFile = "db.txt";
	$fh = fopen($myFile, 'a') or die("Attention: write error on the backup file");
	fwrite($fh, $dataString." FALSE
");
	fclose($fh);
	echo "Form sent successfully! Thanks a lot";		
}
else {
	echo "Attention: something wrong happened. Please contact your person of reference.";
}
?>
https://snipt.net/embed/8b35e780d6974dc41537aa4b8798d01a/
/raw/8b35e780d6974dc41537aa4b8798d01a/
8b35e780d6974dc41537aa4b8798d01a
php
PHP
67
2019-06-18T09:15:19
True
False
False
Jun 15, 2016 at 06:26 AM
/api/public/snipt/147198/
backup-and-send-all-post-vars-from-a-form
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a> <a href="#L-13">13</a> <a href="#L-14">14</a> <a href="#L-15">15</a> <a href="#L-16">16</a> <a href="#L-17">17</a> <a href="#L-18">18</a> <a href="#L-19">19</a> <a href="#L-20">20</a> <a href="#L-21">21</a> <a href="#L-22">22</a> <a href="#L-23">23</a> <a href="#L-24">24</a> <a href="#L-25">25</a> <a href="#L-26">26</a> <a href="#L-27">27</a> <a href="#L-28">28</a> <a href="#L-29">29</a> <a href="#L-30">30</a> <a href="#L-31">31</a> <a href="#L-32">32</a> <a href="#L-33">33</a> <a href="#L-34">34</a> <a href="#L-35">35</a> <a href="#L-36">36</a> <a href="#L-37">37</a> <a href="#L-38">38</a> <a href="#L-39">39</a> <a href="#L-40">40</a> <a href="#L-41">41</a> <a href="#L-42">42</a> <a href="#L-43">43</a> <a href="#L-44">44</a> <a href="#L-45">45</a> <a href="#L-46">46</a> <a href="#L-47">47</a> <a href="#L-48">48</a> <a href="#L-49">49</a> <a href="#L-50">50</a> <a href="#L-51">51</a> <a href="#L-52">52</a> <a href="#L-53">53</a> <a href="#L-54">54</a> <a href="#L-55">55</a> <a href="#L-56">56</a> <a href="#L-57">57</a> <a href="#L-58">58</a> <a href="#L-59">59</a> <a href="#L-60">60</a> <a href="#L-61">61</a> <a href="#L-62">62</a> <a href="#L-63">63</a> <a href="#L-64">64</a> <a href="#L-65">65</a> <a href="#L-66">66</a> <a href="#L-67">67</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="cp">&lt;?php</span> </span><span id="L-2"><a name="L-2"></a><span class="nb">error_reporting</span><span class="p">(</span><span class="k">E_ALL</span><span class="p">);</span> </span><span id="L-3"><a name="L-3"></a><span class="nb">ini_set</span><span class="p">(</span><span class="s1">&#39;display_errors&#39;</span><span class="p">,</span> <span class="mi">1</span><span class="p">);</span> </span><span id="L-4"><a name="L-4"></a> </span><span id="L-5"><a name="L-5"></a><span class="nv">$admin</span> <span class="o">=</span> <span class="s2">&quot;&quot;</span><span class="p">;</span> <span class="c1">// mail</span> </span><span id="L-6"><a name="L-6"></a><span class="nv">$to</span> <span class="o">=</span> <span class="nv">$admin</span><span class="o">.</span><span class="s2">&quot;, &quot;</span><span class="o">.</span><span class="nb">base64_decode</span><span class="p">(</span><span class="nv">$_POST</span><span class="p">[</span><span class="s1">&#39;responsabile&#39;</span><span class="p">]);</span> </span><span id="L-7"><a name="L-7"></a><span class="nv">$mailSubject</span> <span class="o">=</span> <span class="s2">&quot;Rubelli Resellers | Nuova richiesta da confermare per &quot;</span><span class="o">.</span><span class="nb">ucfirst</span><span class="p">(</span><span class="nv">$_POST</span><span class="p">[</span><span class="s1">&#39;nome&#39;</span><span class="p">]);</span> </span><span id="L-8"><a name="L-8"></a><span class="nv">$not_capitalized</span> <span class="o">=</span> <span class="k">array</span><span class="p">(</span><span class="s2">&quot;email&quot;</span><span class="p">,</span> <span class="s2">&quot;responsabile&quot;</span><span class="p">,</span> <span class="s2">&quot;website&quot;</span><span class="p">);</span> </span><span id="L-9"><a name="L-9"></a> </span><span id="L-10"><a name="L-10"></a><span class="nv">$mailBody</span> <span class="o">=</span> <span class="s2">&quot;Ciao! :)</span> </span><span id="L-11"><a name="L-11"></a><span class="s2">Un nuovo rivenditore ha richiesto di essere inserito nel sito.</span> </span><span id="L-12"><a name="L-12"></a><span class="s2">A seguire i dati inseriti:</span> </span><span id="L-13"><a name="L-13"></a> </span><span id="L-14"><a name="L-14"></a><span class="s2">-</span> </span><span id="L-15"><a name="L-15"></a> </span><span id="L-16"><a name="L-16"></a><span class="s2">&quot;</span><span class="p">;</span> </span><span id="L-17"><a name="L-17"></a><span class="nv">$dataString</span> <span class="o">=</span> <span class="s2">&quot;&quot;</span><span class="p">;</span> </span><span id="L-18"><a name="L-18"></a> </span><span id="L-19"><a name="L-19"></a><span class="k">foreach</span><span class="p">(</span><span class="nv">$_POST</span> <span class="k">as</span> <span class="nv">$key</span> <span class="o">=&gt;</span> <span class="nv">$value</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-20"><a name="L-20"></a> <span class="k">if</span> <span class="p">(</span><span class="nv">$key</span> <span class="o">==</span> <span class="s2">&quot;brands&quot;</span><span class="p">){</span> </span><span id="L-21"><a name="L-21"></a> <span class="nv">$value</span> <span class="o">=</span> <span class="nb">implode</span> <span class="p">(</span><span class="s2">&quot;, &quot;</span><span class="p">,</span> <span class="nv">$value</span><span class="p">);</span> </span><span id="L-22"><a name="L-22"></a> <span class="p">}</span> </span><span id="L-23"><a name="L-23"></a> <span class="k">if</span> <span class="p">(</span><span class="o">!</span><span class="nb">in_array</span><span class="p">(</span><span class="nv">$key</span><span class="p">,</span> <span class="nv">$not_capitalized</span><span class="p">)){</span> </span><span id="L-24"><a name="L-24"></a> <span class="nv">$value</span> <span class="o">=</span> <span class="nb">ucfirst</span><span class="p">(</span><span class="nv">$value</span><span class="p">);</span> </span><span id="L-25"><a name="L-25"></a> <span class="p">}</span> </span><span id="L-26"><a name="L-26"></a><span class="nv">$mailBody</span> <span class="o">.=</span> <span class="nb">strtoupper</span><span class="p">(</span><span class="nv">$key</span><span class="p">)</span><span class="o">.</span><span class="s2">&quot;: &quot;</span><span class="o">.</span><span class="nv">$value</span><span class="o">.</span><span class="s2">&quot;</span> </span><span id="L-27"><a name="L-27"></a><span class="s2">&quot;</span><span class="p">;</span> </span><span id="L-28"><a name="L-28"></a><span class="nv">$dataString</span> <span class="o">.=</span> <span class="s2">&quot;&#39;&quot;</span><span class="o">.</span><span class="nv">$value</span><span class="o">.</span><span class="s2">&quot;&#39;, &quot;</span><span class="p">;</span> </span><span id="L-29"><a name="L-29"></a><span class="p">}</span> </span><span id="L-30"><a name="L-30"></a> </span><span id="L-31"><a name="L-31"></a><span class="k">try</span> <span class="p">{</span> </span><span id="L-32"><a name="L-32"></a> <span class="nv">$columns</span> <span class="o">=</span> <span class="nb">implode</span><span class="p">(</span><span class="s2">&quot;, &quot;</span><span class="p">,</span><span class="nb">array_keys</span><span class="p">(</span><span class="nv">$_POST</span><span class="p">));</span> </span><span id="L-33"><a name="L-33"></a> </span><span id="L-34"><a name="L-34"></a> <span class="nv">$dbh</span> <span class="o">=</span> <span class="k">new</span> <span class="nx">PDO</span><span class="p">(</span><span class="s1">&#39;mysql:host=localhost;dbname=common&#39;</span><span class="p">,</span> <span class="s1">&#39;root&#39;</span><span class="p">,</span> <span class="s1">&#39;mysqelle563_&#39;</span><span class="p">);</span> </span><span id="L-35"><a name="L-35"></a> <span class="nv">$query</span> <span class="o">=</span> <span class="s2">&quot;INSERT INTO resellers (&quot;</span><span class="o">.</span><span class="nv">$columns</span><span class="o">.</span><span class="s2">&quot;, active) VALUES (&quot;</span><span class="o">.</span><span class="nv">$dataString</span><span class="o">.</span><span class="s2">&quot; FALSE)&quot;</span><span class="p">;</span> </span><span id="L-36"><a name="L-36"></a> <span class="nv">$sth</span> <span class="o">=</span> <span class="nv">$dbh</span><span class="o">-&gt;</span><span class="na">exec</span><span class="p">(</span><span class="nv">$query</span><span class="p">);</span> </span><span id="L-37"><a name="L-37"></a> <span class="nv">$id</span> <span class="o">=</span> <span class="nv">$dbh</span><span class="o">-&gt;</span><span class="na">lastInsertId</span><span class="p">();</span> </span><span id="L-38"><a name="L-38"></a> <span class="nv">$dbh</span> <span class="o">=</span> <span class="k">null</span><span class="p">;</span> </span><span id="L-39"><a name="L-39"></a><span class="p">}</span> <span class="k">catch</span> <span class="p">(</span><span class="nx">PDOException</span> <span class="nv">$e</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-40"><a name="L-40"></a> <span class="k">print</span> <span class="s2">&quot;Attention: &quot;</span> <span class="o">.</span> <span class="nv">$e</span><span class="o">-&gt;</span><span class="na">getMessage</span><span class="p">()</span> <span class="o">.</span> <span class="s2">&quot;&lt;br&gt;&quot;</span><span class="p">;</span> </span><span id="L-41"><a name="L-41"></a> <span class="k">die</span><span class="p">();</span> </span><span id="L-42"><a name="L-42"></a><span class="p">}</span> </span><span id="L-43"><a name="L-43"></a> </span><span id="L-44"><a name="L-44"></a><span class="nv">$mailBody</span> <span class="o">.=</span> <span class="s2">&quot;</span> </span><span id="L-45"><a name="L-45"></a><span class="s2">-</span> </span><span id="L-46"><a name="L-46"></a> </span><span id="L-47"><a name="L-47"></a><span class="s2">Se i dati sono corretti e vuoi pubblicare il rivenditore, clicca qui:</span> </span><span id="L-48"><a name="L-48"></a><span class="s2">http://www.rubelli.com/resellers/confirm.php?id=&quot;</span><span class="o">.</span><span class="nv">$id</span><span class="o">.</span><span class="s2">&quot;</span> </span><span id="L-49"><a name="L-49"></a> </span><span id="L-50"><a name="L-50"></a><span class="s2">Se i dati invece contengono degli errori, inoltra questa mail ricorretta a [email protected] sottolineando le correzioni.</span> </span><span id="L-51"><a name="L-51"></a> </span><span id="L-52"><a name="L-52"></a><span class="s2">Grazie mille!</span> </span><span id="L-53"><a name="L-53"></a><span class="s2">&quot;</span><span class="p">;</span> </span><span id="L-54"><a name="L-54"></a> </span><span id="L-55"><a name="L-55"></a><span class="c1">// salva i dati su dbS</span> </span><span id="L-56"><a name="L-56"></a><span class="k">if</span><span class="p">(</span><span class="nb">mail</span><span class="p">(</span><span class="nv">$to</span><span class="p">,</span> <span class="nv">$mailSubject</span><span class="p">,</span> <span class="nv">$mailBody</span><span class="p">)</span><span class="o">==</span><span class="k">true</span><span class="p">){</span> </span><span id="L-57"><a name="L-57"></a> <span class="nv">$myFile</span> <span class="o">=</span> <span class="s2">&quot;db.txt&quot;</span><span class="p">;</span> </span><span id="L-58"><a name="L-58"></a> <span class="nv">$fh</span> <span class="o">=</span> <span class="nb">fopen</span><span class="p">(</span><span class="nv">$myFile</span><span class="p">,</span> <span class="s1">&#39;a&#39;</span><span class="p">)</span> <span class="k">or</span> <span class="k">die</span><span class="p">(</span><span class="s2">&quot;Attention: write error on the backup file&quot;</span><span class="p">);</span> </span><span id="L-59"><a name="L-59"></a> <span class="nb">fwrite</span><span class="p">(</span><span class="nv">$fh</span><span class="p">,</span> <span class="nv">$dataString</span><span class="o">.</span><span class="s2">&quot; FALSE</span> </span><span id="L-60"><a name="L-60"></a><span class="s2">&quot;</span><span class="p">);</span> </span><span id="L-61"><a name="L-61"></a> <span class="nb">fclose</span><span class="p">(</span><span class="nv">$fh</span><span class="p">);</span> </span><span id="L-62"><a name="L-62"></a> <span class="k">echo</span> <span class="s2">&quot;Form sent successfully! Thanks a lot&quot;</span><span class="p">;</span> </span><span id="L-63"><a name="L-63"></a><span class="p">}</span> </span><span id="L-64"><a name="L-64"></a><span class="k">else</span> <span class="p">{</span> </span><span id="L-65"><a name="L-65"></a> <span class="k">echo</span> <span class="s2">&quot;Attention: something wrong happened. Please contact your person of reference.&quot;</span><span class="p">;</span> </span><span id="L-66"><a name="L-66"></a><span class="p">}</span> </span><span id="L-67"><a name="L-67"></a><span class="cp">?&gt;</span><span class="x"></span> </span></pre></div> </td></tr></table>
form, php, post, save, vars
--- 
+++ 
@@ -1,30 +1,67 @@
 <?php
-$to = ""; // Da compilare
-$mailSubject = "";  // Da compilare
-$mailBody = "";
+error_reporting(E_ALL);
+ini_set('display_errors', 1);
+
+$admin = ""; // mail
+$to = $admin.", ".base64_decode($_POST['responsabile']);
+$mailSubject = "Rubelli Resellers | Nuova richiesta da confermare per ".ucfirst($_POST['nome']);
+$not_capitalized = array("email", "responsabile", "website");
+
+$mailBody = "Ciao! :)
+Un nuovo rivenditore ha richiesto di essere inserito nel sito.
+A seguire i dati inseriti:
+
+-
+
+";
 $dataString = "";
 
-foreach($_POST as $key => $value) { 
-	if (substr($key, 0, 4)!="email"){
+foreach($_POST as $key => $value) {
+	if ($key == "brands"){
+		$value = implode (", ", $value);
+	}
+	if (!in_array($key, $not_capitalized)){
 		$value = ucfirst($value);
 	}
 $mailBody .= strtoupper($key).": ".$value."
 "; 
-$dataString .= $value."; "; 
-  $_POST[$key] = mysql_escape_string($_POST[$key]);
+$dataString .= "'".$value."', ";
 }
-$dataString .= "
+
+try {
+	$columns = implode(", ",array_keys($_POST));
+	
+    $dbh = new PDO('mysql:host=localhost;dbname=common', 'root', 'mysqelle563_');
+	$query = "INSERT INTO resellers (".$columns.", active) VALUES (".$dataString." FALSE)";
+    $sth = $dbh->exec($query);
+	$id = $dbh->lastInsertId();
+    $dbh = null;
+} catch (PDOException $e) {
+    print "Attention: " . $e->getMessage() . "<br>";
+    die();
+}
+
+$mailBody .= "
+-
+
+Se i dati sono corretti e vuoi pubblicare il rivenditore, clicca qui:
+http://www.rubelli.com/resellers/confirm.php?id=".$id."
+
+Se i dati invece contengono degli errori, inoltra questa mail ricorretta a [email protected] sottolineando le correzioni.
+
+Grazie mille!
 ";
 
-// salva i dati su db
+// salva i dati su dbS
 if(mail($to, $mailSubject, $mailBody)==true){
 	$myFile = "db.txt";
-	$fh = fopen($myFile, 'a') or die("Errore di scrittura nel file di backup");
-	fwrite($fh, $dataString);
+	$fh = fopen($myFile, 'a') or die("Attention: write error on the backup file");
+	fwrite($fh, $dataString." FALSE
+");
 	fclose($fh);
-	echo "Modulo inviato con successo! Grazie mille.";		
+	echo "Form sent successfully! Thanks a lot";		
 }
 else {
-	echo "Attenzione, si &egrave; verificato un errore nell'invio. Si prega di riprovare pi&ugrave; tardi. Grazie.";
+	echo "Attention: something wrong happened. Please contact your person of reference.";
 }
 ?>
--- 
+++ 
@@ -0,0 +1,30 @@
+<?php
+$to = ""; // Da compilare
+$mailSubject = "";  // Da compilare
+$mailBody = "";
+$dataString = "";
+
+foreach($_POST as $key => $value) { 
+	if (substr($key, 0, 4)!="email"){
+		$value = ucfirst($value);
+	}
+$mailBody .= strtoupper($key).": ".$value."
+"; 
+$dataString .= $value."; "; 
+  $_POST[$key] = mysql_escape_string($_POST[$key]);
+}
+$dataString .= "
+";
+
+// salva i dati su db
+if(mail($to, $mailSubject, $mailBody)==true){
+	$myFile = "db.txt";
+	$fh = fopen($myFile, 'a') or die("Errore di scrittura nel file di backup");
+	fwrite($fh, $dataString);
+	fclose($fh);
+	echo "Modulo inviato con successo! Grazie mille.";		
+}
+else {
+	echo "Attenzione, si &egrave; verificato un errore nell'invio. Si prega di riprovare pi&ugrave; tardi. Grazie.";
+}
+?>