php fetch column values from database and display in html table column

Question

I have a table in database name Accounts in which i have many rows and many columns, i want to show a column Account (all values) in my html table. I have tried many method to show a specific column values without using index in html using php and I am using MySql.

$storeArray = Array();
while($rowval = mysql_fetch_array($whole, MYSQL_ASSOC))
{ 
$storeArray[] =  $rowval['Account'];  
$status= $rowval['status'];
$ph1= $rowval['Phone1'];
$ph2= $rowval['Phone2'];
}

by using <?php echo $storeArray[0]; ?> and <?php echo $storeArray[1]; ?> in <td> i got the solution. My question is there any way, it automatically show all values without providing any index?

Even a simple search on this site would have turned out hundreds of examples... — Mihai
– Mihai, Commented Jan 7, 2015 at 8:20
you can extract $rowval so that you can use table field name as variable name like $Account — Vivek Aasaithambi
– Vivek Aasaithambi, Commented Jan 7, 2015 at 9:41

Mohammad Towhidul Islam · Accepted Answer · 2015-01-07 08:39:45Z

2

$conn=new mysqli("localhost","root","","your_db");

$rows=$conn->query("select username from User");

echo "<table border='1'>";
echo "<tr><th>Username</th></tr>";
while(list($username)=$rows->fetch_row()){
  echo "<tr><td>$username</td></tr>";
}
echo "</table>";

answered Jan 7, 2015 at 8:39

Mohammad Towhidul Islam

2541 gold badge2 silver badges12 bronze badges

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

1 Comment

Ajmal Jamil Over a year ago

Thanks, can you tell me is there any way if click on $username then it fetch the whole row related to that username?

Marc van Nieuwenhuijzen · Accepted Answer · 2015-01-07 08:31:26Z

1

This is a pretty elaborate question. I think the best I can do is point you in the right direction. There is a good tutorial for this on w3schools.com. You should at least read these:

PHP - Connect to MySQL

PHP - Select Data From MySQL

and maybe

PHP - Limit Data Selections From MySQL

answered Jan 7, 2015 at 8:31

Marc van Nieuwenhuijzen

1,6671 gold badge14 silver badges23 bronze badges

1 Comment

Ajmal Jamil Over a year ago

Thanks for your help. without giving index means automatically takes all the values from Accounts column and display in my html table

Mohammad Towhidul Islam · Accepted Answer · 2015-01-08 08:09:42Z

1

**file user.php**
<?php
$conn=new mysqli("localhost","root","","your_db");

$rows=$conn->query("select id,username from User");

echo "<table border='1'>";
echo "<tr><th>Username</th></tr>";
while(list($id,$username)=$rows->fetch_row()){
  echo "<tr>";
  echo "<td>";
  echo "<form action='user_details.php' target='_blank' method='post'>";
  echo "<input type='hidden' name='txtId' value='$id' />";
  echo "$id - $username";
  echo "<input type='submit' name='btnView' value='View' />";
  echo "</form>";
  echo "</td>";
  echo "</tr>";
}
echo "</table>";
?>

**file user_details.php**
<?php 

 if(isset($_POST["btnView"])){

   $id=$_POST["txtId"];

   $conn=new mysqli("localhost","root","","your_db");

   $row=$conn->query("select id,username,email,phone from User where id='$id'");

   list($id,$username,$email,$phone)=$row->fetch_row();

   echo $id," ",$username," ",$email," ",$phone;

 }



?>

answered Jan 8, 2015 at 8:09

Mohammad Towhidul Islam

2541 gold badge2 silver badges12 bronze badges

2 Comments

Ajmal Jamil Over a year ago

Thanks. imgur.com/6QsvYrK Here is the link of image, I want whenever user click on name its details shows in above boxes, the details are associated to that specific name which is clicked.

Mohammad Towhidul Islam Over a year ago

If you want to a show the details above of the name list then include the user_details.php file at the top of user.php

Ajmal Jamil · Accepted Answer · 2015-01-08 19:38:21Z

1

if you want to fetch more than one database column in your html table column.

$conn=new mysqli("localhost","root","","your_db");

$rows=$conn->query("select col1,col2 from Tablename");

echo "<table border='1'>";
echo "<tr><th>col1</th><th>col2</th></tr>";
while(list($col1, $col2)=$rows->fetch_row())
{
  echo "<tr><td>$col1</td><td>$col2</tr>";
}
echo "</table>";

answered Jan 8, 2015 at 19:38

community wiki

Ajmal Jamil

Collectives™ on Stack Overflow

php fetch column values from database and display in html table column

4 Answers 4

1 Comment

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related