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
Multiple websites question.
Hi, does php have any functionality that enables a programmer to extract information from a website
Dynamic links in an include file
I am working on a small piece of code that counts records from a database and displays the result to
Problem assigning value to variable in "IF" function
Does this script makes sense? I am trying to take the value that is set to "authenticat" a
How to add advertisment on top of videos
Hello,
I was told that i should find the answer for this problem in this forums.
I searched a
CHECH A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a
Grouping and sorting results
Please help with this query.
I have 2 tables in a database, countires and cities. states look
need help in creating captcha
hi i have a problem creating captcha system. i create some basic script for image displaying but it
Is it possible to stop reservation creation in PM Order?
Hi All,
Is it possible to stop reservation creation in PM Order?
Thanks in adv
help with multi-update
Now sure how to ask this really....
10g database if that matters.
I have a customer
Greek characters in php
Hi,
I'm making a script and I m using for first time greek characters.
I started to write
