I need help getting the data from phpMyAdmin to display in a php table:
<?php
$con = mysqli_connect('localhost', 'root', 'root', 'music_database');
if(!$con)
{
die("Can not connect: " . mysqli_error($con));
}
if(!mysqli_select_db($con, 'music_database'))
{
echo 'Database Not Selected!';
}
$sql = "SELECT * FROM month1";
$query = mysqli_query($con, $sql);
if (!$query)
{ // add this check.
die('Invalid query: ' . mysqli_error($con));
} else{
echo "<table border=1>
<tr>
<th>Song Title</th>
<th>Song Artist</th>
<th>Song Album</th>
<th>Year Released</th>
<th>Month Played</th>
<th>Day of the Week Played</th>
<th>Date Played</th>
<th>Time Played</th>
</tr>";
while($record = mysqli_fetch_array($query))
{
echo "<tr>";
echo "<td>" . $record['songtitle'] . "</td>";
echo "<td>" . $record['songartist'] . "</td>";
echo "<td>" . $record['songalbum'] . "</td>";
echo "<td>" . $record['yearreleased'] . "</td>";
echo "<td>" . $record['monthplayed'] . "</td>";
echo "<td>" . $record['dayplayed'] . "</td>";
echo "<td>" . $record['dateplayed'] . "</td>";
echo "<td>" . $record['timeplayed'] . "</td>";
echo "</tr>";
}
echo "</table>";
}
mysqli_close($con);
?>
showrecords.php