Transforming the output from fetchAll() into a well-

Question

Transforming the output from fetchAll() into a well-

Currently, I'm utilizing fetchAll(PDO::FETCH_ASSOC) to query my self-made database using an SQL statement. In order to visualize the retrieved data, I am employing print_r(). The values returned by print_r() look like this:

Array ( [0] => Array ( [Type] => Poison, Invicibility, Heals [First_Name] => Acton [Last_Name] => Mooney ) 
        [1] => Array ( [Type] => Telepathy, Mind-Control [First_Name] => Adam [Last_Name] => Warlock )

To present this information in a well-organized table format, I aim to use a loop. For instance, I desire the following output:

         Type                          First_Name    Last_Name
Poison, Invincibility, Heals              Acton         Mooney
Telepathy, Mind-Control                  Adam          Warlock

However, I'm currently facing a challenge in implementing this. Although I understand that it involves some form of loop, the query is dynamic and can contain more than three rows of data, which complicates matters.

php pdo

Answer 1

Answer №1

When reading the results, it is recommended to use a while loop instead of fetchAll();

$stmnt = $db->prepare($sql);
$stmnt->execute($aParams);
while($row = $stmnt->fetch()) {
    // Custom code goes here....
}
$stmnt = null;

Edit : To address the issue regarding column number and name retrieval, especially when the query can be applied to any table:

// Retrieve all results using fetchAll method
$aResults = $stmnt->fetchAll(PDO::FETCH_ASSOC)

// Check if there are any results
$numResults = count($aResults);
if (count($numResults) > 0) {
    // Output the table header
    echo '<table><tr>';
    foreach ($aResults[0] as $fieldName=>$value) {
        echo '<th>' . htmlspecialchars($fieldName) . '</th>';
    }
    echo '</tr>';

    // Output all the results
    foreach($aResults as $row) {
        echo '<tr>';
        foreach ($row as $fieldName=>$value) {
            echo '<td>' . htmlspecialchars($value) . '</td>';
        }
        echo '</tr>';
    }

    // Close the table
    echo '</table>';
} else {
    echo 'No results';
}

Answer 2

When reading the results, it is recommended to use a while loop instead of fetchAll();

$stmnt = $db->prepare($sql);
$stmnt->execute($aParams);
while($row = $stmnt->fetch()) {
    // Custom code goes here....
}
$stmnt = null;

Edit : To address the issue regarding column number and name retrieval, especially when the query can be applied to any table:

// Retrieve all results using fetchAll method
$aResults = $stmnt->fetchAll(PDO::FETCH_ASSOC)

// Check if there are any results
$numResults = count($aResults);
if (count($numResults) > 0) {
    // Output the table header
    echo '<table><tr>';
    foreach ($aResults[0] as $fieldName=>$value) {
        echo '<th>' . htmlspecialchars($fieldName) . '</th>';
    }
    echo '</tr>';

    // Output all the results
    foreach($aResults as $row) {
        echo '<tr>';
        foreach ($row as $fieldName=>$value) {
            echo '<td>' . htmlspecialchars($value) . '</td>';
        }
        echo '</tr>';
    }

    // Close the table
    echo '</table>';
} else {
    echo 'No results';
}

Answer 3

Answer №2

In a similar manner,

<?php 

$data = array ( 0 => array ( 'Ability' => 'Poison, Invincibility, Healing', 'First_Name' => 'Anderson', 'Last_Name' => 'Moon' ) ,
        1 => array ( 'Ability' => 'Telepathy, Mind Control', 'First_Name' => 'Adrian', 'Last_Name' => 'Willow' )) ;

echo "<table><tr><th>Ability</th><th>Ability</th><th>Ability</th></tr>";

foreach ($data as $k=>$v) {
    echo "<tr>";
    echo "<td>".$v['Ability']."</td>";
    echo "<td>".$v['First_Name']."</td>";
    echo "<td>".$v['Last_Name']."</td>";
    echo "</tr>";
}        
echo "</table>";

Answer 4

In a similar manner,

<?php 

$data = array ( 0 => array ( 'Ability' => 'Poison, Invincibility, Healing', 'First_Name' => 'Anderson', 'Last_Name' => 'Moon' ) ,
        1 => array ( 'Ability' => 'Telepathy, Mind Control', 'First_Name' => 'Adrian', 'Last_Name' => 'Willow' )) ;

echo "<table><tr><th>Ability</th><th>Ability</th><th>Ability</th></tr>";

foreach ($data as $k=>$v) {
    echo "<tr>";
    echo "<td>".$v['Ability']."</td>";
    echo "<td>".$v['First_Name']."</td>";
    echo "<td>".$v['Last_Name']."</td>";
    echo "</tr>";
}        
echo "</table>";

Transforming the output from fetchAll() into a well-

Answer №1

Answer №2

Similar questions

Unable to decode JSON string, returning null

Mastering Regular Expressions with PHP

How can a variable be passed to route.php from middleware in Laravel 5.2?

Can PHP be utilized to convert an XML file to UTF-8 encoding?

Minor login form mishap

The comparison between AJAX and JSON passing and PHP generating HTML versus returning it

The AJAX request to send data to PHP is not functioning correctly

Unlocking the Potential of MySQL SELECT: Step-by-Step Guide to Crafting

Can the .htaccess files be merged together?

Switch between selecting every group of 3 items and every group of 4 items

Implementing Ajax image upload functionality in Symfony2 framework

PHP Function - rounding numbers to two decimal places

unable to access submitted data

Indentation differences between PHP and JavaScript

A search form utilizing prepared statements in mysqli

Display a message after serializing JSON in my cakePHP application

Setting up Opencart version 1.5.x using PHP 7

Issue with adding to lightbox feature when loading content dynamically using AJAX PHP is not functioning as expected

Kartik's gridview in yii2 has a unique feature where the floating header in the thead and tbody are

PHP is unable to detect the query string when using RewriteRule