eine Anfangsfrage PHP mit Datenbank

Basi

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?

Marcus77

Hallo

danke

eien DB würde ich in meinem Admin erstellen und dann dem System zuordnen

oder per eigenem präfix

zb: sp_

THX4help !!!!!!

PS: kann ich das ganze auch 2 Sprachig verwenden ?? Normal schon, ich brauche ja nur das ganze ein 2tes mal in eine formular_sprache2.php geben und nur die Texte entsprechend ändern, das Formular bleibt ja gleich !

Nur ev eine eigene Projekte-Sprache2 TXT schreiben und das in der PHP Datei ändern

Basi

Das mit der dualen Sprache kann ich auch mal andeuten in der Datei, ich mach mich mal ran

Marcus77

Erneut besten Dank !

Basi

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

; 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 =

Alles anzeigen

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&ouml;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&uuml;r folgende Projekte:<br />      </label><br />    </fieldset><br />    <fieldset id="projects" style="display: none;"><br />      <legend>W&auml;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&ouml;chten sie spenden?</legend><br />      <label><br />        &euro; <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&auml;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:

Code

CREATE 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;

webmaster3000

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

Marcus77

ok, danke mal

@Basii hast du Skype ??

Dann kann ich das soweit online geben und ev kontakt aufnehmen

Marcus77

ok, also ich habe das nun soweit Anhand von Basii

<a class="postlink" href="http://ycth.alfahosting.org/form/">http://ycth.alfahosting.org/form/</a>

nur sollen gleich die Projekte stehen
also nicht diese if: select 2 else Show projekte

und dann suche ich nun Hilfe für ein Abfrage Tool

thx4help

Jetzt mitmachen!