Display column name with data in MySQL

Question

How to display column name for their respective data.

$sql="SELECT * FROM <Tablename> WHERE domain_name='google.com'";
$result=mysqli_query($conn,$sql);
$row=mysqli_fetch_array($result,MYSQLI_NUM);
echo "<table>";
for ($i=0; $i <sizeof($row) ; $i++) { 
    echo "<tr>";
    echo "<td>";
    echo mysql_field_name($row,$i); // its not working.
    echo $row[$i]."<br/>";
    echo "</td>";
    echo "</tr>";
}
echo "</table>";

Please help.

You are mixing mysql_ with mysqli_ : php.net/manual/en/mysqli-result.fetch-field.php — Thamilhan
– Thamilhan, Commented Apr 17, 2017 at 8:43
mysqli_field_name() doesn't work. Could you please help? I'm kind of new to php — Siddhesh
– Siddhesh, Commented Apr 17, 2017 at 8:46

gmc · Accepted Answer · 2017-04-17 08:52:06Z

2

You can use fetch_field_direct:

for ($i=0; $i <sizeof($row) ; $i++) { 
   ...
   $finfo = $result->fetch_field_direct($i);
   echo $finfo->name;
   ...
}

answered Apr 17, 2017 at 8:52

gmc

4,0303 gold badges34 silver badges47 bronze badges

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

Comments

Ehsan Ilahi · Accepted Answer · 2017-04-17 08:57:28Z

0

Try this code

if ($result->num_rows > 0) {
    while($row = mysqli_fetch_array($result,MYSQLI_NUM)) {
    echo "<tr>";
    echo "<td>";
    echo $row[0]."<br/>";
    echo "</td>";
    echo "</tr>";
    }
    echo "</table>";
} else {
    echo "0 results";
}
$conn->close();

answered Apr 17, 2017 at 8:57

Ehsan Ilahi

2985 silver badges15 bronze badges

1 Comment

Siddhesh Over a year ago

Thanks for your efforts. Above code is working. check that out.

Akila · Accepted Answer · 2017-04-17 09:10:06Z

0

Use mysqli_fetch_assoc to fetch the column names.

$sql='SELECT * FROM mytesttable WHERE username="as"';
$result=mysqli_query($conn,$sql);
$row=mysqli_fetch_assoc($result);

header('Content-type: application/json');
echo json_encode($row);

You will get output as json response.In future this may help,if you need to output in json format. Thanks, Hope this helps for others.

answered Apr 17, 2017 at 9:10

Akila

7652 gold badges8 silver badges13 bronze badges

Collectives™ on Stack Overflow

Display column name with data in MySQL

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related