0

I have a fairly simple MySQL database at present. Clearly each field in each records has a name.

I then have a tiny php script to deliver a webpage

    <?php
include_once 'includes/dbh.inc.php';
?>
<! DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<?php
$sql="SELECT * FROM income_tax;";
$result=mysqli_query($conn,$sql);
$resultCheck=mysqli_num_rows($result);
if ($resultCheck>0) {
echo "<table border ='1')>";
echo "<tr>";
echo "<td>".Year."</td>";
echo "<td>".BRB."</td>";
echo "<td>".BR."</td>";
echo "<td>".HRB."</td>";
echo "<td>".HR."</td>";
echo "<td>".S_BR."</td>";
echo "</tr>";
while ($row=mysqli_fetch_assoc($result)){ // any way to simply rad through all fields?
echo "<tr>";
echo "<td>".$row['year']."</td>";
echo "<td>".$row['BRB']."</td>";
echo "<td>".$row['BR']."</td>";
echo "<td>".$row['HRB']."</td>";
echo "<td>".$row['HR']."</td>";
echo "<td>".$row['S_BR']."</td>";
echo "</tr>";
}
echo "</table>";
}
?>
</body>
</html>

The database is about to get a lot bigger. What I would like to do,m instead of putting in the header rows in the table manually, is to read the names of the fields into it. As I am a total newbie to php I have no idea how to do it. Can anyone help out?

TIA

Malc
  • 13
  • 5
  • 2
    Note: The object-oriented interface to `mysqli` is significantly less verbose, making code easier to read and audit, and is not easily confused with the obsolete `mysql_query` interface. Before you get too invested in the procedural style it’s worth switching over. Example: `$db = new mysqli(…)` and `$db->prepare("…")` The procedural interface is an artifact from the PHP 4 era when `mysqli` API was introduced and should not be used in new code. – tadman Mar 12 '18 at 17:02
  • 2
    Note: Try and get out of the habit of declaring SQL statements in throw-away variables that are used only once. It's a lot easier to follow code where the query is supplied directly to the function, and there's no longer a chance of messing up and sending in `$sql3` instead of the visually similar `$sql8`. – tadman Mar 12 '18 at 17:02

0 Answers0