My latest project involves creating a basic CMS for a website. This is my first time working with MySQL and one of my early experiences with PHP, so I see it as a learning opportunity. Despite consulting numerous resources, the code I've written only results in displaying an empty <h1></h1> tag. I've double-checked all aspects of my database and table setup, ensuring that the column names are correct. At this stage, I'm not attempting to add anything to the database; I simply want to be able to read from it. Even a simple proof-of-concept seems out of reach at the moment.
For hosting, I've opted for 000webhost.
<?php
$mysql_host = "****";
$mysql_database = "****";
$mysql_user = "sql_blog";
$mysql_password = "*****";
$link = mysql_connect($mysql_host, $mysql_user, $mysql_password);
if (!mysql_select_db($mysql_database, $link)) {
echo 'Database error';
exit;
}
$sql_statement = ('SELECT * FROM Blog_Entries');
$result = mysql_query($sql_statement);
while ($curr_row = mysql_fetch_assoc($result)) {
echo '<h1>' . $result['Title'] . '</h1>';
}
mysql_free_result($result);
?>
I borrowed most of this code from , and everything appears to be in order...