display.php

<?php
	session_start();
	require_once("connection.php");
	
	$user_id = $_SESSION["user_id"]; 
	
	$req= $dbConnect->query("SELECT * FROM produits WHERE user_id = '$user_id'");

   
	if($results = $req->fetchAll(PDO::FETCH_ASSOC)){
		 $htmlString = '<table border="1">';

		foreach ($results as $result) {
			$htmlString .= '<tr><td>' . $result["pos_nr"] .'</td></tr>';
			$htmlString .= '<tr><td>' . $result["farbe"] .'</td></tr>';
			$htmlString .= '<tr><td>' . $result["anzahl_laenge_1"] .'</td></tr>'; 
            $htmlString .= '<tr><td>' . $result["anzahl_laenge_2"] .'</td></tr>';
			$htmlString .= '<tr><td>' . $result["anzahl_laenge_3"] .'</td></tr>';
			$htmlString .= '<tr><td>' . $result["anzahl_laenge_4"] .'</td></tr>';
            $htmlString .= '<tr><td>' . $result["bemerkung"] .'</td></tr>';
            $htmlString .= '<tr><td><img src="images/' . $result["photo"] . ' "></td></tr>';			
			$htmlString .= '<tr><td>' . $result["a"] .'</td></tr>';
			$htmlString .= '<tr><td>' . $result["b"] .'</td></tr>';
			$htmlString .= '<tr><td>' . $result["c"] .'</td></tr>';
			$htmlString .= '<tr><td>' . $result["d"] .'</td></tr>';
			$htmlString .= '<tr><td>' . $result["e"] .'</td></tr>';
			$htmlString .= '<tr><td>' . $result["alpha"] .'</td></tr>';
			$htmlString .= '<tr><td>' . $result["beta"] .'</td></tr>';
			$htmlString .= '<tr><td bgcolor ="eeeeee">&nbsp;</td></tr>';
			$htmlString .= '<tr><td bgcolor ="eeeeee">new Eintrag</td></tr>';
			$htmlString .= '<tr><td bgcolor ="eeeeee">&nbsp;</td></tr>';
		}
		$htmlString .= '</table>';
		
		echo $htmlString;
	} else {
		echo "kein  Eintrag f&uuml;r diesen Benutzer";
	}
?>