Also gut, dann werde ich das mal eben machen, dauert aber kurz 
Hast du schon eine Datenbank? Wie sieht die aus? Wie ist die strukturiert?
eine Anfangsfrage PHP mit Datenbank
-
-
Das mit der dualen Sprache kann ich auch mal andeuten in der Datei, ich mach mich mal ran
-
Zuerst habe ich mich mal um die Sprachen gekümmert, dazu habe ich eine lang.ini Datei erstellt in der sämtliche Texte und die gewünschte Sprache definiert werden:
Code
Alles anzeigen; Hier einfach "en" für Englisch, oder "de" für Deutsch, du kannst auch z.B. "jp" für Japanisch einfügen, ; dann musst du ganz unten aber alle Elemente noch mal aufführen! [cnfg] lang = de [de] title = Spendenformular headline = Unser Spendenformular legendForWhat = Wofür möchten sie spenden? referencePriority_a = Verwenden sie meine Spende wo sie am dringensten benötigt wird referencePriority_b = Verwenden sie meine Spende für folgende Projekte: legendChooseProjects = Wählen sie die Projekte aus donationHowMuch = Wie viel möchten sie spenden? currency = € donationHowMuchInfo = (Bitte nur ganze Zahlen) [en] title = headline = legendForWhat =Diese wird in der Hauptdatei so eingebunden: (ganz am Anfang)
PHP<span class="syntaxdefault"><?php<br /> </span><span class="syntaxcomment">// language script<br /></span><span class="syntaxdefault"> $lang </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> parse_ini_file</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"lang.ini"</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> true</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> $language </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> $lang</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cnfg'</span><span class="syntaxkeyword">][</span><span class="syntaxstring">'lang'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">?><br /></span>Dann musst du in der Datei alle Textstellen ersetzen, ein Beispiel:
PHP<span class="syntaxhtml"> <title><span class="syntaxdefault"><?php print $lang</span><span class="syntaxkeyword">[</span><span class="syntaxdefault">$language</span><span class="syntaxkeyword">][</span><span class="syntaxstring">'title'</span><span class="syntaxkeyword">];</span><span class="syntaxdefault"> ?></span></title><br /></span>Ändern tust du nur das letzte Array Element, das was hier ['title'] heißt, heißt in der Überschrift natürlich ['headline'], so wie es in der lang.ini benannt ist (headline = Unser Spendenformular).
Ich habe mal nicht alle benannt damit du auch noch was zu tun hast
Hier nun deine Datei:
PHP<span class="syntaxhtml"><br /><span class="syntaxdefault"><?php<br /><br /> </span><span class="syntaxcomment">// language script<br /></span><span class="syntaxdefault"> $lang </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> parse_ini_file</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"lang.ini"</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> true</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> $language </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> $lang</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cnfg'</span><span class="syntaxkeyword">][</span><span class="syntaxstring">'lang'</span><span class="syntaxkeyword">];<br /><br /></span><span class="syntaxdefault"> $dbCon </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_connect</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"127.0.0.1"</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">"BENUTZER!"</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">"PASSWORT!"</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> $dbSel </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"!TABELLENNAME"</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault"> function getProjects</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$file</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(!isset(</span><span class="syntaxdefault">$file</span><span class="syntaxkeyword">))<br /></span><span class="syntaxdefault"> return false</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault"> $handler </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> fopen</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$file</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'rb'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> while</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$line </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> fgets</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$handler</span><span class="syntaxkeyword">))<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> $a </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> $line</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> $return</span><span class="syntaxkeyword">[]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> explode</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'|'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> $a</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">/* debug: */</span><span class="syntaxdefault"> </span><span class="syntaxcomment"># print_r($return);<br /></span><span class="syntaxdefault"> return $return</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault"> $projects </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> getProjects</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'projects.txt'</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault">?><br /></span><!DOCTYPE html><br /><head><br /> <title><span class="syntaxdefault"><?php print $lang</span><span class="syntaxkeyword">[</span><span class="syntaxdefault">$language</span><span class="syntaxkeyword">][</span><span class="syntaxstring">'title'</span><span class="syntaxkeyword">];</span><span class="syntaxdefault"> ?></span></title><br /><br /> <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" /><br /> <meta name="description" content="" /><br /> <meta name="author" content="" /><br /> <meta name="keywords" content="" /><br /><br /><script><br /><br /> function changeStyle(id, style, value)<br /> {<br /> if(document.getElementById)<br /> document.getElementById(id).setAttribute('style', style+': '+value);<br /> else<br /> document.all.id.setAttribute('style', style+': '+value);<br /> return true;<br /> }<br /><br /></script><br /></head><br /><br /><body><br /> <h1><span class="syntaxdefault"><?php print $lang</span><span class="syntaxkeyword">[</span><span class="syntaxdefault">$language</span><span class="syntaxkeyword">][</span><span class="syntaxstring">'headline'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> ?></span></h1><br /><span class="syntaxdefault"><?php<br /> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'submit'</span><span class="syntaxkeyword">]))<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> true</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'reference'</span><span class="syntaxkeyword">]))</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'reference'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> trim</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'reference'</span><span class="syntaxkeyword">]));<br /></span><span class="syntaxdefault"> else $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'referenceProjects'</span><span class="syntaxkeyword">]))</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'referenceProjects'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> $_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'referenceProjects'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'amount'</span><span class="syntaxkeyword">]))</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'amount'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> trim</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'amount'</span><span class="syntaxkeyword">]));<br /></span><span class="syntaxdefault"> else $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'hiddenField'</span><span class="syntaxkeyword">]))</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'mail'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> trim</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'hiddenField'</span><span class="syntaxkeyword">]));<br /></span><span class="syntaxdefault"> else $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cardOwner'</span><span class="syntaxkeyword">]))</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cardOwner'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> trim</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cardOwner'</span><span class="syntaxkeyword">]));<br /></span><span class="syntaxdefault"> else $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cardNumber'</span><span class="syntaxkeyword">]))</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cardNumber'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> trim</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cardNumber'</span><span class="syntaxkeyword">]));<br /></span><span class="syntaxdefault"> else $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireMonth'</span><span class="syntaxkeyword">]))</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireMonth'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> trim</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireMonth'</span><span class="syntaxkeyword">]));<br /></span><span class="syntaxdefault"> else $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireYear'</span><span class="syntaxkeyword">]))</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireYear'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> trim</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireYear'</span><span class="syntaxkeyword">]));<br /></span><span class="syntaxdefault"> else $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'verification'</span><span class="syntaxkeyword">]))</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'verification'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> trim</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'verification'</span><span class="syntaxkeyword">]));<br /></span><span class="syntaxdefault"> else $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'submit'</span><span class="syntaxkeyword">]))</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'submit'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> trim</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'submit'</span><span class="syntaxkeyword">]));<br /></span><span class="syntaxdefault"> else $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault"> if<br /> </span><span class="syntaxkeyword">(<br /></span><span class="syntaxdefault"> </span><span class="syntaxstring">'priority_a'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'reference'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> AND<br /> </span><span class="syntaxstring">'priority_b'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'reference'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> OR<br /> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault">is_numeric</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'amount'</span><span class="syntaxkeyword">])</span><span class="syntaxdefault"> OR<br /> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault">filter_var</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'mail'</span><span class="syntaxkeyword">],</span><span class="syntaxdefault"> FILTER_VALIDATE_EMAIL</span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> OR<br /> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault">is_numeric</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cardNumber'</span><span class="syntaxkeyword">])</span><span class="syntaxdefault"> OR<br /> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault">is_numeric</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireMonth'</span><span class="syntaxkeyword">])</span><span class="syntaxdefault"> OR<br /> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault">is_numeric</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireYear'</span><span class="syntaxkeyword">])</span><span class="syntaxdefault"> OR<br /> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault">is_numeric</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'verification'</span><span class="syntaxkeyword">])<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault"> foreach</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'referenceProjects'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> as $f</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(!</span><span class="syntaxdefault">preg_match</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'/project_[1-'</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> sizeof</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">getProjects</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'projects.txt'</span><span class="syntaxkeyword">))</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">']/'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> $f</span><span class="syntaxkeyword">))<br /></span><span class="syntaxdefault"> $success </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// ausrechnen wie viel pro projekt gespendet werden soll:<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(isset(</span><span class="syntaxdefault">$formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'referenceProjects'</span><span class="syntaxkeyword">]))<br /></span><span class="syntaxdefault"> $formdata</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'donationPerProject'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> round</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'amount'</span><span class="syntaxkeyword">]/</span><span class="syntaxdefault">sizeof</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'referenceProjects'</span><span class="syntaxkeyword">]),</span><span class="syntaxdefault"> 2</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$success</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'priority_b'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">==</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'reference'</span><span class="syntaxkeyword">])<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// datensätze erstellen:<br /></span><span class="syntaxdefault"> foreach</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'referenceProjects'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> as $f</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> $sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"INSERT INTO `!TABELLENNAME`<br /> (<br /> `id`, `cardNumber`, `cardOwner`, `expire`, `cardVerification`, `project`<br /> )<br /> VALUES<br /> (<br /> NULL, '"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cardNumber'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"', '"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cardOwner'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"', '"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireMonth'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">" / "</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireYear'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"', '"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'verification'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"', '"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $f </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"'<br /> );"</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> else<br /> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> $sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"INSERT INTO `TABELLENNAME`<br /> (<br /> `id`, `cardNumber`, `cardOwner`, `expire`, `cardVerification`, `project`<br /> )<br /> VALUES<br /> (<br /> NULL, '"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cardNumber'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"', '"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'cardOwner'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"', '"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireMonth'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">" / "</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'expireYear'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"', '"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $formData</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'verification'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"', 'nach bedarf'<br /> );"</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(!</span><span class="syntaxdefault">$sql</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> print mysql_error</span><span class="syntaxkeyword">();</span><span class="syntaxdefault"> </span><span class="syntaxcomment">// ausgabe wenn das Ganze nicht geklappt hat<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> else<br /> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">?><br /></span> <form action="" method="post"><br /> <fieldset><br /> <legend><span class="syntaxdefault"><?php print $lang</span><span class="syntaxkeyword">[</span><span class="syntaxdefault">$language</span><span class="syntaxkeyword">][</span><span class="syntaxstring">'legendForWhat'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> ?></span></legend><br /> <label><br /> <input type="radio" name="reference" value="priority_a" onclick="changeStyle('projects', 'display', 'none');" /> Verwenden sie meine Spende wo sie am dringensten benötigt wird<br /> </label><br /> <label><br /> <input type="radio" name="reference" value="priority_b" onclick="changeStyle('projects', 'display', 'block');" /> Verwenden sie meine Spende für folgende Projekte:<br /> </label><br /> </fieldset><br /> <fieldset id="projects" style="display: none;"><br /> <legend>Wählen sie die Projekte aus</legend><br /><span class="syntaxdefault"><?php<br /><br /> foreach</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$projects as $f</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> print </span><span class="syntaxstring">'<label><input type="checkbox" name="referenceProjects[]" value="project_'</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $f</span><span class="syntaxkeyword">[</span><span class="syntaxdefault">0</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">'" /> '</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $f</span><span class="syntaxkeyword">[</span><span class="syntaxdefault">1</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">', <em>'</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $f</span><span class="syntaxkeyword">[</span><span class="syntaxdefault">2</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">'</em></label>'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault">?><br /></span> </fieldset><br /> <fieldset><br /> <legend>Wie viel möchten sie spenden?</legend><br /> <label><br /> € <input type="number" name="amount" /> (Bitte nur ganze Zahlen)<br /> </label><br /> </fieldset><br /> <fieldset><br /> <legend>Ihre Daten</legend><br /> <label><br /> E-Mailadresse <input type="text" name="hiddenField" /><br /> </label><br /> <label><br /> Karteninhaber <input type="text" name="cardOwner" /><br /> </label><br /> <label><br /> Kartennummer <input type="text" name="cardNumber" /><br /> </label><br /> <p><br /> Ablaufdatum der Kreditkarte (Monat/Jahr)<br /> <select name="expireMonth"><br /> <option value="1">Januar</option><br /> <option value="2">Februar</option><br /> <option value="3">März</option><br /> <option value="4">April</option><br /> <option value="5">Mai</option><br /> <option value="6">Juni</option><br /> <option value="7">Juli</option><br /> <option value="8">August</option><br /> <option value="9">September</option><br /> <option value="10">Oktober</option><br /> <option value="11">November</option><br /> <option value="12">Dezember</option><br /> </select><br /> <input type="number" name="expireYear" min="2012" max="3000" value="2012" /><br /> </p><br /> <label><br /> CVC/CVV <input type="text" name="verification" /><br /> </label><br /> </fieldset><br /> <fieldset><br /> <input type="submit" value="Spenden" name="submit" /><br /> </fieldset><br /> </form><br /><span class="syntaxdefault"><?php </span><span class="syntaxkeyword">}</span><span class="syntaxdefault"> ?><br /></span></body><br /></html><br /></span>Und die SQL Datei die du in deinem PHPMyAdmin eingeben kannst:
CodeCREATE TABLE `tabellenName` ( `id` INT( 12 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `cardNumber` INT( 32 ) NOT NULL , `cardOwner` VARCHAR( 128 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL , `expire` VARCHAR( 32 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL , `cardVerification` INT( 32 ) NOT NULL , `project` INT( 32 ) NOT NULL ) ENGINE = INNODB; -
Ich misch mich nochmal ein., denn ich hab einen Vorschlag für eine Funktion zum escapen:
PHP<span class="syntaxdefault"><?php<br />function escpaen</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$nichtEscaped</span><span class="syntaxkeyword">){<br /></span><span class="syntaxdefault"> if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">is_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$nichtEscaped</span><span class="syntaxkeyword">)){<br /></span><span class="syntaxdefault"> $returnValue </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> array</span><span class="syntaxkeyword">();<br /></span><span class="syntaxdefault"> foreach</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$nichtEscaped as $index </span><span class="syntaxkeyword">=></span><span class="syntaxdefault"> $wert</span><span class="syntaxkeyword">){<br /></span><span class="syntaxdefault"> $returnValue</span><span class="syntaxkeyword">[</span><span class="syntaxdefault">$index</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> nl2br</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">trim</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$wert</span><span class="syntaxkeyword">))));<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> else </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> $returnValue </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> nl2br</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">trim</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$wert</span><span class="syntaxkeyword">))));<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> return $returnValue</span><span class="syntaxkeyword">;<br />}<br /></span><span class="syntaxdefault">?></span>
Der Funktion ist es egal, ob ein ganzes Array oder ein einzelner Wert übergeben wird, sodass sowohl
escapen($_GET);
als auch
escpaen($_GET["feldname"]);
funktioniert.Gruß,
webmaster3000
Jetzt mitmachen!
Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!