Render data from PHP DB query in HTML

Question

I am a newbie to PHP but trying to learn it to enhance my programming skillset

So far i have the following PHP code in my page to return some data from my Database:

<?php
            //code missing to retrieve my data
            while($row = mysql_fetch_array($result))
            {
                echo '$row['Name']';
            }

            mysql_close($connection);
?>

This is working in that I can see the names from my database displayed on screen. I have seen as well that I can include html in the echo to format the data. However if I have the html code like below in a jQuery accordion outside my PHP code in the page - how can I dynamically place the Names in the specific h3 tags - so the first name in my table is Joe so that comes back in [0] element of array - is there a way I can reference this from my html code outside the php?

<div id="accordion">
  <h3>Joe</h3>
  <div>
    <p>
     Some blurb about Joe
    </p>
  </div>
  <h3>Jane</h3>
  <div>
    <p>
     Some blurb about Jane
    </p>
  </div>
  <h3>John</h3>
  <div>
    <p>
    Some Blurb about John.
    </p>
  </div>
</div>

note that mysql_ is deprecated. you should use PDO or mysqlli — Gert B.
– Gert B., Commented Jan 16, 2014 at 13:01

Community · Accepted Answer · 2023-11-21 15:10:29Z

1

Try something like this:

<?php while($row = mysql_fetch_array($result)) { ?>
    <h3><?php echo $row['name']; ?></h3>
    <div>
        <p>Some blurb about Joe</p>
    </div>
<?php } ?>

I'm assuming 'Some blurb about Joe' would also have to be replaced by a field in the DB, which you can accomplish in the same manner as the name.

@Gert is correct - the original mysql API is deprecated and should not be used anymore. Look into mysqli or PDO, instead.

edited Nov 21, 2023 at 15:10

CommunityBot

11 silver badge

answered Jan 16, 2014 at 13:00

Jeff Lambert

24.7k4 gold badges72 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

miltos · Accepted Answer · 2014-01-16 13:00:46Z

0

add your html in while loop like this

<?php
        //code missing to retrieve my data
        while($row = mysql_fetch_array($result))
        {
?>
<h3><?php echo $row['Name']?></h3>
  <div>
    <p>
     Some blurb about <?php echo $row['Name']?>
    </p>
  </div>
<?php
        }

        mysql_close($connection);
?>

answered Jan 16, 2014 at 13:00

miltos

1,0191 gold badge6 silver badges10 bronze badges

Comments

Harshal · Accepted Answer · 2014-01-16 13:02:05Z

0

Like this :

    <div id="accordion">
    <?php
    while($row = mysql_fetch_array($result))
    {
      <h3><?php echo $row['Name'] ?></h3>
      <div>
        <p>
         Some blurb about Joe
        </p>
      </div>
    } ?>
    </div>

answered Jan 16, 2014 at 13:02

Harshal

3,6329 gold badges40 silver badges67 bronze badges

Collectives™ on Stack Overflow

Render data from PHP DB query in HTML

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related