Auf Thema antworten 2026

JavaScript ist deaktiviert. Für eine bessere Darstellung aktiviere bitte JavaScript in deinem Browser, bevor du fortfährst.

Beitrag: <blockquote data-quote="redbull2906" data-source="post: 912608" data-attributes="member: 121682"><p><strong>AW: Bundesliga Tippspiel</strong></p><p></p><p>Hallo,</p><p></p><p>ich hab dein Code mal so eingebaut aber so bekommen ich auch in jeder Spalte den Usernamen mit ausgegeben - was mach ich falsch? Im ersten array hab ich ja die Partien soweit komm ich noch mit naja und im zweiten array hab ich doch dann meine ergebnisse oder?</p><p></p><p></p><p>PHP-Code:</p><p style="text-align: left"><span style="color: #000000"><span style="color: #0000bb"><?</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #0000bb"></span><span style="color: #ff8000">// Erst die Tabellenspalten aus der Datenbank lesen</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #ff8000">  // also: welche Spielbegegnungen gab es</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #ff8000">  </span><span style="color: #0000bb">$query </span><span style="color: #007700">= </span><span style="color: #dd0000">'SELECT heim, gast FROM spieltag WHERE spieltag = 1'</span><span style="color: #007700">;</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">  </span><span style="color: #0000bb">$cols </span><span style="color: #007700">= array();</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">  if (</span><span style="color: #0000bb">$result </span><span style="color: #007700">= </span><span style="color: #0000bb">mysql_query</span><span style="color: #007700">(</span><span style="color: #0000bb">$query</span><span style="color: #007700">))</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">    while (</span><span style="color: #0000bb">$row </span><span style="color: #007700">= </span><span style="color: #0000bb">mysql_fetch_assoc</span><span style="color: #007700">(</span><span style="color: #0000bb">$result</span><span style="color: #007700">))</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">      </span><span style="color: #0000bb">array_push</span><span style="color: #007700">(</span><span style="color: #0000bb">$cols</span><span style="color: #007700">, </span><span style="color: #0000bb">$row</span><span style="color: #007700">);</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700"></span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">  </span><span style="color: #ff8000">// Tabellenkopf ausgeben</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #ff8000">  </span><span style="color: #007700">echo </span><span style="color: #dd0000">'<table><tr>'</span><span style="color: #007700">;</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">  foreach (</span><span style="color: #0000bb">$cols </span><span style="color: #007700">as </span><span style="color: #0000bb">$col</span><span style="color: #007700">) echo </span><span style="color: #dd0000">'<th>'</span><span style="color: #007700">.</span><span style="color: #0000bb">$col</span><span style="color: #007700">[</span><span style="color: #dd0000">'heim'</span><span style="color: #007700">].</span><span style="color: #dd0000">'</th><th>'</span><span style="color: #007700">.</span><span style="color: #0000bb">$col</span><span style="color: #007700">[</span><span style="color: #dd0000">'gast'</span><span style="color: #007700">].</span><span style="color: #dd0000">'</th>'</span><span style="color: #007700">;</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">  echo </span><span style="color: #dd0000">'</tr>'</span><span style="color: #007700">;</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700"></span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">  </span><span style="color: #ff8000">// Dann die Tipp-Daten aus der Datenbank lesen</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #ff8000">  // also: wer hat was auf die Begegnungen getippt.</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #ff8000">  // und zwar mit LEFT JOIN statt JOIN</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #ff8000">  </span><span style="color: #0000bb">$query </span><span style="color: #007700">= </span><span style="color: #dd0000">'SELECT `user`.`name`, `tipps`.`tipph`, `tipps`.`tippg`</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #dd0000">  FROM `tipps`</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #dd0000">  LEFT JOIN `user` ON `tipps`.`tipper_id` = `user`.`id`</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #dd0000">  LEFT JOIN `spieltag` ON `tipps`.`spiel_id`= `spieltag`.`spiel_id`</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #dd0000">  WHERE `spieltag`.`spieltag` = 1</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #dd0000">  ORDER BY `spieltag`.`spiel_id` ASC'</span><span style="color: #007700">;</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">  if (</span><span style="color: #0000bb">$result </span><span style="color: #007700">= </span><span style="color: #0000bb">mysql_query</span><span style="color: #007700">(</span><span style="color: #0000bb">$query</span><span style="color: #007700">)) {</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">    while (</span><span style="color: #0000bb">$row </span><span style="color: #007700">= </span><span style="color: #0000bb">mysql_fetch_assoc</span><span style="color: #007700">(</span><span style="color: #0000bb">$result</span><span style="color: #007700">)) {</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">      </span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">      echo </span><span style="color: #dd0000">'<tr>'</span><span style="color: #007700">;</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">      foreach (</span><span style="color: #0000bb">$cols </span><span style="color: #007700">as </span><span style="color: #0000bb">$col</span><span style="color: #007700">) {</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">        echo </span><span style="color: #dd0000">'<td>'</span><span style="color: #007700">;</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">        </span><span style="color: #ff8000">// Für jede Spalte prüfen, ob es in der Zeile einen Eintrag gibt und ggf. ausgeben</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #ff8000">        </span><span style="color: #007700">if (</span><span style="color: #0000bb">$col </span><span style="color: #007700">!= </span><span style="color: #dd0000">''</span><span style="color: #007700">) echo </span><span style="color: #0000bb">$row</span><span style="color: #007700">[</span><span style="color: #dd0000">'name'</span><span style="color: #007700">];</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">        echo </span><span style="color: #dd0000">'</td>'</span><span style="color: #007700">;</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">      }</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">      echo </span><span style="color: #dd0000">'</tr>'</span><span style="color: #007700">.</span><span style="color: #dd0000">"\r\n"</span><span style="color: #007700">;</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">    }</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">    echo </span><span style="color: #dd0000">'</table>'</span><span style="color: #007700">;</span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700">  }    </span></span></p> <p style="text-align: left"><span style="color: #000000"><span style="color: #007700"></span><span style="color: #0000bb">?></span> </span></p></blockquote><p></p> Bilder bitte hier hochladen und danach über das Bild-Icon (Direktlink vorher kopieren) platzieren.

Authentifizierung: Wenn ★ = 12, ◇ = 4 und die Hälfte von ★ zu ◇ addiert wird, was ist das Ergebnis?

Oben