Re: [PHP] 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/
.

Relevant Pages

  • Re: [PHP] Database abstraction?
    ... 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 ... "Some men are born to greatness, some achieve greatness, ...
    (php.general)
  • Re: Control structures
    ... {echo 'more error messages';} ... I need to NOT execute anything within 'CONTAINER' when the if/elseif ... closing div, so the rest of the page displays normally. ...
    (comp.lang.php)
  • Re: Control structures
    ... {echo 'more error messages';} ... I need to NOT execute anything within 'CONTAINER' when the if/elseif ... closing div, so the rest of the page displays normally. ...
    (comp.lang.php)
  • Re: Extract Content Between Style Tags with Preg and PHP
    ... foreach($matchas $div) { ... echo $div; ... All I am trying to do, is simply throw the $div into a database. ... is more than one instance of the style tag. ...
    (alt.php)