Cant display mysql data

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
bass_avb
Forum Newbie
Posts: 3
Joined: Thu Oct 15, 2009 2:17 am

Cant display mysql data

Post by bass_avb »

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 nothing is displayed. My php5 is set up so that I could see all of the error but there are none displayed nor is there anything in the log.

Here are the function I am using:

Code: Select all

 
function confirm_query($result_set) {
        if (!$result_set) {
            die("Database query failed: " . mysql_error());
        }
}
 

Code: Select all

 
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;
               
}
 

Code: Select all

 
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 all

 
<?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"); ?>
 
Any ideas ?

Thanks in advance !

--best
A
guosheng1987
Forum Newbie
Posts: 24
Joined: Thu Oct 15, 2009 3:03 am

Re: Cant display mysql data

Post by guosheng1987 »

click right button in the recent page
select "view of source code" item

Are there any html codes displayed?
bass_avb
Forum Newbie
Posts: 3
Joined: Thu Oct 15, 2009 2:17 am

Re: Cant display mysql data

Post by bass_avb »

Hi,

Its displaying html from the include files but not from the function

Code: Select all

 
 
<!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 AvB </span></div>
</div>
</body>
</html>
 
 
Post Reply