Re: Database abstraction?

On 17 Apr 2008, at 13:33, Jason Pruim wrote:

Maybe I'm showing my ignorance here in programming... Maybe it's because I delt with a kid who decided to scream for a good share of the night and I'm sleep deprived :) But in my current system I have this: echo <<<HTML <div> <table border="1"> <tr> <td><a href="?order=a">First Name</a></td> <td><a href="?order=b">Last Name</a></td> <td><a href="?order=c">Address 1</a></td> <td><a href="?order=d">Address 2</a></td> <td><a href="?order=e">City</a></td> <td><a href="?order=f">State</a></td> <td><a href="?order=g">Zip</a></td> <td><a href="?order=h">Code</a></td> <td><a href="?order=i">ID #</a></td> HTML; while($row = mysqli_fetch_assoc($result)) { //display the info using heredoc syntac echo <<<HTML <tr> <td>{$row['FName']}</td> <td>{$row['LName']}</td> <td>{$row['Add1']}</td> <td>{$row['Add2']}</td> <td>{$row['City']}</td> <td>{$row['State']}</td> <td>{$row['Zip']}</td> <td>{$row['XCode']}</td> <td>{$row['Record']}</td> HTML; } What I want to do is take that first block of code, the one with the links for sorting, and instead of this: "<td><a href="?order=a">First Name</a></td>" I want to put something more like this: "<td><a href="?order=a">$FIELDNAMES[$field{$id}]</a></td>" So I can grab the field names from the database, instead of hardcoding them into my program. I think I am sleep deprived because the more I tried to clarify it... the harder it got for me to understand :)

echo <<<HTML <div> <table border="1">\ HTML; $first = true; while ($row = mysqli_fetch_assoc($result)) { if ($first) { echo '<tr>'; foreach (array_keys($row) as $field) { echo '<td>'.htmlentities($field).'</td>'; } echo '</tr>'; $first = false; } // Output the row here as above } -Stut -- http://stut.net/