Cant display mysql data
Posted on
16th Feb 2014 07:03 pm by
admin
Hey all,
I am learning php and my first goal is to create a simple CMS. At the moment I am stuck on not being able to pull page names and their id`s from my DB and combine them into a list of links (like so/manage_pages.php?page_id=1) so I could grab id`s later for update and delete pages. Problem is when I load the page none of the links are displayed. My php5 is set up so that I could see all of the errors but there are none displayed nor is there anything in the log.
Here are the function I am using:
Code: [Select]<?php
function confirm_query($result_set) {
if (!$result_set) {
die("Database query failed: " . mysql_error());
}
}
function get_all_pages() {
global $connection;
mysql_select_db("content_MS", $connection);
$query = "SELECT *
FROM pages
ORDER BY id ASC";
$result_set = mysql_query($query, $connection);
confirm_query($result_set);
return $result_set;
}
function list_pages(){
global $connection;
$result = get_all_pages();
$output = "<div>";
$output .= "<p>Select the page you would like to edit:</p>";
while($row = mysql_fetch_array($result))
{
$output .="<ul>";
$output .= "<li>";
$output .= "<a href="manage_pages.php?page=" . urlencode($row["id"]) ."">{$row["page_name"]}</a></li>";
$output .="</ul>";
}
$output .="</div>";
return $output;
}
?>
Then I simply echo list_pages function on a page:
Code: [Select]<?php include ("includes/header.php"); ?>
<div id="content">
<div class="in">
<h2>This is the main content</h2>
<?php list_pages();?>
</div>
</div>
<?php include ("includes/footer.php"); ?>
And below is the html code I see when I load the page:
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<title>Content Manager - Manage Pages</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="css/back_css.css" media="screen" />
</head>
<body>
<div id="wrapper">
<div id="header">
<div class="in">
<h1>Welcome To Your Content Manager!</h1>
</div>
</div>
<div id="content-wrapper"> <div id="content">
<div class="in">
<h2>This is the main content</h2>
</div>
</div>
</div>
<div id="left"><div class="in">
<h2>Menu</h2>
<ul>
<li><a href="manage_pages.php?name=Manage Pages"> Manage Pages </a></li>
<li><a href="manage_menu.php?name=Manage Menu"> Manage Menu </a></li>
<li><a href="manage_albums.php?name=Manage Albums"> Manage Albums </a></li>
<li><a href="manage_videos.php?name=Manage Videos"> Manage Videos</a></li>
<li><a href="manage_gigs.php?name=Manage Gigs"> Manage Gigs </a></li>
<li><a href="manage_news.php?name=Manage News"> Manage News</a></li>
</ul>
</div></div>
<div id="footer"><span>by AB</span></div>
</div>
</body>
</html>
Any ideas ?
Thanks in advance !
No comments posted yet
Your Answer:
Login to answer
187 
16 
Other forums
Placing and array within an array then sorting it!
I have a page that runs two large mysql queries and saves the results into arrays, in php I then per
Libraries in C++
Hi all,
I have two libraries. one is based targeted on linux platform and uses another li
remove trailing slash from array
I have the following array which contains trailing slashes I need to remove. What is the best way to
Displaying image pathname instead of image
Hello
Im trying to upload and then display images from a mysql database - Its only basic and
Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?
defining website tags
Hi,
What would be the best way to define tags for my site, such as website title, url etc.Populate drop down list from table??
Lets say for arguments sake that i have a table which contains the numbers 1 to 10.
How can i get
Need help Updating SQL Server Express DB from c# :(
Please can anyone help with:-
1 How to sructure the strSelect statement.
2 How to instruct
please fix the error
What is the error in the below code ???
Line number On/Off | Expand/Contract <?php
unserialize help, getting errors
hi all ,
I got a form with 6 fields (2 input and 4 select box), when the page loads one block is
