Archief - PHP : tabellen oproepen

<table width="676" border="1" bordercolor="#000000" align="center" background="images/table01.jpg">

  <br>

  <tr>

    <td width="100"><div align="center">tabel1 </div></td>

    <td width="100"><div align="center">tabel2</div></td>

    <td width="100"><div align="center">tabel3</div></td>

    <td width="100"><div align="center">tabel4</div></td>

     </tr>

  <?php







					$dbh=mysql_connect("localhost","login","pass");



					if (!$dbh) {

					$variabele = mysql_query(); 

					echo mysql_num_rows($variabele);

					

    			    echo "<br><br>";



    				echo "<font color=\"#FF0000\"> ERROR ! Ik kan geen verbinding maken met de $db database.</font><br>\n";



    				echo "</body></html>";



    				exit;



					}



					











					$res=mysql_db_query("dbnaam","select * from gamer ;",$dbh);



					$fout=mysql_errno($dbh);



					if ($fout != 0) {



    				$fout=mysql_error($dbh);



    				echo "<font color=\#FF0000\">$fout</font>";



    				mysql_close($dbh);



    				echo "</body></html>";



    				exit;



    				}







					$aantal_lijnen=mysql_num_rows($res);



					for($i=0;$i<$aantal_lijnen;$i++) 



					{



					$row=mysql_fetch_row($res);



					echo"<tr><td>";



					echo $row[2]; 



					echo"</td><td>";



					echo $row[3]; echo"</td><td>"; echo $row[8]; echo"</td><td>";  echo $row[10]; echo"</td><td>"; 



					echo"</td></tr></table";



						}





			?>

for($i=0;$i<=$aantal_lijnen;$i++)

<table>
<?php
while ($row=mysql_fetch_array($res))
	{
	?>
	<tr><td>
		<$=$row['veldnaam van rij 2']?>
	</td><td>
		<$=$row['veldnaam van rij 3']?>
	</td><td>
		<$=$row['veldnaam van rij 8']?>
	</td><td>
		<$=$row['veldnaam van rij 10']?>
	</td></tr>
	<?php
	}
?>
</table>

<table>
    <tr>
        <td>veldnaam1</td>
        <td>veldnaam2</td>
        <td>veldnaam3</td>
        <td>veldnaam4</td>
    </tr>
    <?
    $res=mysql("dbnaam","SELECT veld1,veld2,veld3,veld4 FROM gamer");
    // Het is natuurlijk vanzelfsprekend dat je in de bovenstaande regel, je eigen veldnamen invult ;)
    while($row=mysql_fetch_assoc($res))
    {
        echo "    <tr>\n";
        foreach($row as $key=>$value) echo "        <td>$value ($key)</td>\n";
        echo "    </tr>\n";
    }
    ?>
</table>