Php echo in table and with css

Question

I have the following code:

<div id="Container">
<div class="tester">
<table>
<tr><th class="links"><span style="color: #ffd100">MYSQL DATA</span></th></tr>
<tr><th class="links">MYSQL DATA</th></tr>
<tr><th class="links">MYSQL DATA</th></tr>
<tr><th class="links">MYSQL DATA</th></tr>
</table>
</div>

I want the variables "MYSQL DATA" out of my mysql with php echo. I have the conncetion to the database but i don´t know where to insert the echo $row->name; etc.

<?php 

    mysql_connect("localhost", "XXXXX","XXXXXX") or die ("Verbindung nicht möglich");
    mysql_select_db("XXXXXX") or die ("Datenbank existiert nicht");

  $abfrage = "SELECT `name` FROM `TEST`"; 
  $ergebnis = mysql_query($abfrage); 
  while($row = mysql_fetch_object($ergebnis)) 
    { 

    echo $row->name; 
    echo $row->id; 

 }

}
?>

Possible duplicate of How to echo out table rows from the db (php) Or Display mysql data in formatted table — FirstOne
– FirstOne, Commented Dec 23, 2015 at 23:15
Depends on the structure, you could generate the tables via the while-loop that fetches data from the database. None the less, mysql_* functions are deprecated since PHP 5.5 (and removed entirely in PHP 7) and you shoud stop using them if you can. — Qirel
– Qirel, Commented Dec 23, 2015 at 23:30

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

Example with mysqli and echo th with php:

<div id="Container">
    <div class="tester">
        <table>
<?php 
$link = mysqli_connect("localhost", "XXXXX","XXXXXX") or die ("Verbindung nicht möglich");
mysqli_select_db($link, "XXXXXX") or die ("Datenbank existiert nicht");

$abfrage = "SELECT `name` FROM `TEST`"; 
$ergebnis = mysqli_query($link, $abfrage);
$i=0; 
while($row = mysqli_fetch_object($ergebnis)) 
{
    if ($i === 0) { ?>
<tr>
    <th class="links">
        <span style="color: #ffd100"><?php echo $row->name; ?></span>
    </th>
</tr>
<?php } else { ?>
<tr>
    <td class="links"><?php echo $row->name; ?></td>
</tr>
<?php
    }
    $i++;
}
?>
        </table>
    </div>
</div>

Documentation (english and german):

mysqli connect (en)

mysqli select db (de)

mysqli query (de)

mysqli fetch object

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Dec 24, 2015 at 0:19

mrroot5

2,0013 gold badges29 silver badges33 bronze badges

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

1 Comment

Hertus Over a year ago

Same as above. The mysql data doesn´t appear. If i do a normal query without table and styles it works.

Alaa M. Jaddou · Accepted Answer · 2015-12-24 00:03:41Z

0

UPDATED

<div id="Container">
<div class="tester">
<table>
<tr>
<th>
name
</th>
<?php 
mysql_connect("localhost", "XXXXX","XXXXXX") or die ("Verbindung nicht möglich");
mysql_select_db("XXXXXX") or die ("Datenbank existiert nicht");

$abfrage = "SELECT `name` FROM `TEST`"; 
$ergebnis = mysql_query($abfrage); 
while($row = mysql_fetch_object($ergebnis)) 
{ ?>
    <tr>
        <td class="links"><?php echo $row->name; ?></td>
    </tr>
<?php }
?>
</table>
</div>
</div>

edited Dec 24, 2015 at 0:03

answered Dec 23, 2015 at 23:42

Alaa M. Jaddou

1,1891 gold badge11 silver badges30 bronze badges

8 Comments

FirstOne Over a year ago

This creates all rows as table header cells. (I know the op's code is like that, but it's worth mentioning ^^)

Alaa M. Jaddou Over a year ago

just change the th to td and add row before the while with table headers that you want

Alaa M. Jaddou Over a year ago

i edit it to make them td :) with th before thanks for mention FirstOne

Hertus Over a year ago

Thanks for this code. I tried it out, but the mysql data doesn´t appear for some reason.

Hertus Over a year ago

Nothing, just the <th>name</th> and the div container.

|

Webber Depor · Accepted Answer · 2015-12-24 14:04:43Z

0

You should save this as .php not .html

<div id="Container">
<div class="tester">
<table>
<?php 

    mysql_connect("localhost", "XXXXX","XXXXXX") or die ("Verbindung nicht möglich");
    mysql_select_db("XXXXXX") or die ("Datenbank existiert nicht");

  $abfrage = "SELECT `name` FROM `TEST`"; 
  $ergebnis = mysql_query($abfrage); 
  while($row = mysql_fetch_array($ergebnis)){ 
   if($row[0])
      echo '<tr><th class="links"><span style="color: #ffd100">'.$row->name.'</span></span></th></tr>';
   else
       echo '<tr><th class="links">'.$row->name.'</span></th></tr>';
  }

?>
</table>
</div>

edited Dec 24, 2015 at 14:04

answered Dec 24, 2015 at 13:42

Webber Depor

1985 silver badges16 bronze badges

Collectives™ on Stack Overflow

Php echo in table and with css

3 Answers 3

1 Comment

8 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related