File: groceries-display2.php
<!-- File: groceries-display2.php. Read grocery data from groceries.mdb database. Display data in an HTML table. --> <html> <head> <title>Groceries Display2 Example Example</title> <link rel="stylesheet" type="text/css" href="../styles.css" /> </head> <body> <h2>Groceries Display2 Example</h2> <table border="1" cellpadding="5"> <tr> <th>Name</th> <th>Code</th> <th>Price</th> <th>Quantity</th> <th>OnSale</th> </tr> <?php // Set connection string. $cs = 'DRIVER=Microsoft Access Driver (*.mdb);DBQ=D:/ectserver/sjost/Database/groceries.mdb'; // Create connection. $c = odbc_connect($cs, '', ''); // Define SQL SELECT statement. $sql = 'SELECT * FROM GroceryList'; // If connection was successful, execute SQL statement. if ($c) { $result_set = odbc_exec($c, $sql); } else { die("Connection not successful.<br />"); } // Obtain and display result set table using SQL statement. if($result_set) { while(odbc_fetch_row($result_set)) { echo "<tr> "; for($col = 2; $col <= 6; $col++) { echo "<td>" . odbc_result($result_set, $col) . "</td> "; } echo "</tr>\n"; } } else { die("Could not form result set.<br />"); } ?> </table> </body> </html>