Present data extracted from MySQL

Question

Present data extracted from MySQL

Currently, my code retrieves data from a MySQL table and displays it on the page in a single line. However, I want to present this information in separate blocks. Is there a way to split the line and create distinct blocks of information that can be placed anywhere on the webpage?

<?php
while ($row = mysql_fetch_array($query)) {
echo $row['Column A'] . " " . $row['Column B'] . " " . $row['Column C'] . " ";
} ?>

php mysql output line

Answer 1

Answer №1

Firstly, it's important to update your mysql_* functions to more modern alternatives like PDO & mysqli.

Now, let's discuss how you can generate HTML from your database data. There are several approaches you can take:

One possible method is as follows:

<?php
while ($row = mysql_fetch_array($query)) {
?>
<h1><?php echo $row['columnA']; ?></h1>
<div class="myclass"><?php echo $row['columnb']; ?></div>
<img src="<?php echo $row['columnC']; ?>">
<?php
} ?>

Another approach could be:

<?php
    while ($row = mysql_fetch_array($query)) {
    $str = ""; 
    $str .= "<h1>".$row['columnA']."</h1>"; 
    $str .= '<div class="myclass">'.$row['columnb'].'</div>'; 
    $str .= '<img src="'.$row['columnC'].'">'; 
    echo $str; 
    <?php
    } ?>

Alternatively, you can simplify the process by using a framework that handles this for you.

If you prefer not to use a framework, you can utilize a templating library which offers the best solution.

I recommend checking out mustache https://github.com/bobthecow/mustache.php for this purpose.

You have the flexibility to modify the HTML structure based on your requirements.

I hope these suggestions prove helpful in resolving your query. Happy coding!

Answer 2

Firstly, it's important to update your mysql_* functions to more modern alternatives like PDO & mysqli.

Now, let's discuss how you can generate HTML from your database data. There are several approaches you can take:

One possible method is as follows:

<?php
while ($row = mysql_fetch_array($query)) {
?>
<h1><?php echo $row['columnA']; ?></h1>
<div class="myclass"><?php echo $row['columnb']; ?></div>
<img src="<?php echo $row['columnC']; ?>">
<?php
} ?>

Another approach could be:

<?php
    while ($row = mysql_fetch_array($query)) {
    $str = ""; 
    $str .= "<h1>".$row['columnA']."</h1>"; 
    $str .= '<div class="myclass">'.$row['columnb'].'</div>'; 
    $str .= '<img src="'.$row['columnC'].'">'; 
    echo $str; 
    <?php
    } ?>

Alternatively, you can simplify the process by using a framework that handles this for you.

If you prefer not to use a framework, you can utilize a templating library which offers the best solution.

I recommend checking out mustache https://github.com/bobthecow/mustache.php for this purpose.

You have the flexibility to modify the HTML structure based on your requirements.

I hope these suggestions prove helpful in resolving your query. Happy coding!

Answer 3

Answer №2

A possible solution for your needs could be a table implementation... (Keep in mind to switch over to mysqli* as suggested by @Sedz)

<table border="1">
    <?php
        while ($row = mysqli_fetch_array($query)) {
            echo '<tr>';
                echo '<td>' . $row['Column A'] . '</td>';
                echo '<td>' . $row['Column B'] . '</td>';
            echo '</tr>';
            echo '<tr>';
                echo '<td></td>';
                echo '<td>' . $row['Column C'] . '</td>';
            echo '</tr>';
        };
    ?>
</table>

Adjust the display layout according to your preferences...

Answer 4

A possible solution for your needs could be a table implementation... (Keep in mind to switch over to mysqli* as suggested by @Sedz)

<table border="1">
    <?php
        while ($row = mysqli_fetch_array($query)) {
            echo '<tr>';
                echo '<td>' . $row['Column A'] . '</td>';
                echo '<td>' . $row['Column B'] . '</td>';
            echo '</tr>';
            echo '<tr>';
                echo '<td></td>';
                echo '<td>' . $row['Column C'] . '</td>';
            echo '</tr>';
        };
    ?>
</table>

Adjust the display layout according to your preferences...

Answer 5

Answer №3

One possible approach is to store the results in an array:

$resultArray = array(); 

while ($row = mysql_fetch_assoc($results)) {
    $resultArray[] = $row;
}

To address the issue you mentioned:

foreach ($resultArray as $item) {
    echo "$item<br>";
}

Answer 6

One possible approach is to store the results in an array:

$resultArray = array(); 

while ($row = mysql_fetch_assoc($results)) {
    $resultArray[] = $row;
}

To address the issue you mentioned:

foreach ($resultArray as $item) {
    echo "$item<br>";
}

Answer 7

Answer №4

Hello user2619310!

Here's what you can do to solve your issue:

You need to insert the newline character "\n" into your code.

<?php
while ($row = mysql_fetch_array($query)) {
      echo $row['Column X'] . " " . $row['Column Y'] . " " . $row['Column Z'] . "\n";

} 
?>

Good luck! :-)

Answer 8

Hello user2619310!

Here's what you can do to solve your issue:

You need to insert the newline character "\n" into your code.

<?php
while ($row = mysql_fetch_array($query)) {
      echo $row['Column X'] . " " . $row['Column Y'] . " " . $row['Column Z'] . "\n";

} 
?>

Good luck! :-)

Answer 9

Answer №5

There are various ways to format the lines depending on your goals and where you plan to use them. These are some methods for organizing information on separate lines:

Add a line break (br) tag at the end of each field.
Enclose each row in DIVs.
Create a table for each row.

If you need compatibility across different browsers and efficient sizing, using DIVs would be the optimal choice. However, tables can also be easily implemented for specific purposes.

Here is an example of how I would organize the rows using tables:

<table>
    <?php while ($row = mysql_fetch_array($query)): ?>
    <tr>
        <td>Label for Column A</td>
        <td><?php echo $row['ColumnA']; ?></td>
    </tr>
    <tr>
        <td>Label for Column B</td>
        <td><?php echo $row['ColumnB']; ?></td>
    </tr>
    <tr>
        <td>Label for Column C</td>
        <td><?php echo $row['ColumnC']; ?></td>
    </tr>
    <?php endwhile; ?>
</table>

I am not familiar with your specific database table structure, but based on the information provided, I have included an example. Please note that this is untested but should work.

Additionally, take note of the alternative PHP syntax for the while loop.

Answer 10

There are various ways to format the lines depending on your goals and where you plan to use them. These are some methods for organizing information on separate lines:

Add a line break (br) tag at the end of each field.
Enclose each row in DIVs.
Create a table for each row.

If you need compatibility across different browsers and efficient sizing, using DIVs would be the optimal choice. However, tables can also be easily implemented for specific purposes.

Here is an example of how I would organize the rows using tables:

<table>
    <?php while ($row = mysql_fetch_array($query)): ?>
    <tr>
        <td>Label for Column A</td>
        <td><?php echo $row['ColumnA']; ?></td>
    </tr>
    <tr>
        <td>Label for Column B</td>
        <td><?php echo $row['ColumnB']; ?></td>
    </tr>
    <tr>
        <td>Label for Column C</td>
        <td><?php echo $row['ColumnC']; ?></td>
    </tr>
    <?php endwhile; ?>
</table>

I am not familiar with your specific database table structure, but based on the information provided, I have included an example. Please note that this is untested but should work.

Additionally, take note of the alternative PHP syntax for the while loop.

Present data extracted from MySQL

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Similar questions

What is the process for updating a collection in MongoDB database with PHP?

saving data from database for future utilization in php

Enhancing a php SOAP complex datatype by incorporating an XML wrapper

Ask the controller for information, then send it to the appropriate route before displaying it in

Save array in JSON format to a file using PHP

Is there a concept similar to HTTP_GET_RESPONSE out there?

Cross-class function retrieval results in failure of database interactivity

Tips for showcasing an array in PHP with either JSON or XML structure?

Synchronize the Android database with a remote server database

Determine the remaining load time in PHP after submitting a task

Looking to utilize PHP's foreach loop to generate XML elements and attributes based on information from another XML file

Extracting Data from JSON Objects Using PHP

Data from Ajax calls is only available upon refreshing the page

Error in PHP class: Wikipedia - index out of bounds

Combining ID's from two MySQL tables to generate results from one table into the other

Enter a number into a text box and increase the value in several text boxes created with jQuery in PHP

Handling PHP forms: verifying data, submitting entries, and presenting information

Using the WordPress function wp_mail along with Ajax and ValidationEngine to perform database insertion through the $wpdb object

Articulate junction table featuring distinct column titles

Verify the presence of the promotion code and redirect accordingly