<html> 
<header>
<meta charset="utf-8">
<link rel="stylesheet" href="css/style.css">
 <div class="col-md-12 banner-area">
            <div><img src="images/mdi_3.png" alt="MDI-DE">- Quellen -<div> 
</div>
</header>
    <body> 
        <table>  
                <th>ID</th>		
		<th>Autor</th>
		<th>Datum</th> 
                <th>Titel</th>
		<th>Medien</th>
		<th>Ort</th>  
        <?php 
//        $db = pg_connect('host=http://mdi-dienste.baw.de port=5432 dbname=gaz16 user=postgres password=quadral'); 
	$conn = "host=10.140.96.28 port=5432 dbname=gaz16 user=postgres password=quadra1";
	$db = pg_connect($conn);

        $query = "SELECT * FROM quellen"; 

        $result = pg_query($query); 
        if (!$result) { 
            echo "Problem with query " . $query . "<br/>"; 
            echo pg_last_error(); 
            exit(); 
        } 

        while($myrow = pg_fetch_assoc($result)) { 
            printf ("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>", $myrow['verweis'], htmlspecialchars($myrow['autor']), htmlspecialchars($myrow['datum']), htmlspecialchars($myrow['titel']), htmlspecialchars($myrow['media']), htmlspecialchars($myrow['ort'])); 
        } 
        ?> 
        </table> 
    </body> 
</html> 
