I am trying to display some values from my SQL database using PHP. I want to connect to my database with the following code:
<?php
mysql_connect('localhost', 'root', 'mypassword');
mysql_select_db('mysql'); //Enter your database name here
// Retrieve all records and display them
$result = mysql_query("SELECT * FROM data ORDER BY id DESC");
?>
<html>
<head>
<title>Raspberry Pi Weather Log</title>
<style type="text/css">
.table_titles, .table_cells_odd, .table_cells_even {
padding-right: 20px;
padding-left: 20px;
color: #000;
}
.table_titles {
color: #FFF;
background-color: #666;
}
.table_cells_odd {
background-color: #CCC;
}
.table_cells_even {
background-color: #FAFAFA;
}
table {
border: 2px solid #333;
}
body { font-family: "Trebuchet MS", Arial; }
</style>
</head>
<body>
<h1>Raspberry Pi Weather Log</h1>
<table border="0" cellspacing="0" cellpadding="4">
<tr>
<td class="table_titles">ID</td>
<td class="table_titles">Date and Time</td>
<td class="table_titles">Temperature</td>
<td class="table_titles">Humidity</td>
<td class="table_titles">Pressure</td>
</tr>
<?php
// Used for row color toggle
$oddrow = true;
// process every record
while( $row = mysql_fetch_array($result) )
{
if ($oddrow)
{
$css_class=' class="table_cells_odd"';
}
else
{
$css_class=' class="table_cells_even"';
}
$oddrow = !$oddrow;
echo '<tr>';
echo ' <td'.$css_class.'>'.$row["id"].'</td>';
echo ' <td'.$css_class.'>'.$row["date"].'</td>';
echo ' <td'.$css_class.'>'.$row["temperature"].'</td>';
echo ' <td'.$css_class.'>'.$row["humidity"].'</td>';
echo ' <td'.$css_class.'>'.$row["pressure"].'</td>';
echo '</tr>';
}
?>
</table>
</body>
</html>
But all it causes is to kill my page, which only shows "currently unable to handle this request HTTP ERROR 500"
What am I missing? Do I have to add a port forward? Or something else? I have been looking for an answer online but couldn't get any :(
Aucun commentaire:
Enregistrer un commentaire