Jump to content

[SOLVED] Can get data out of DB


garethhall

Recommended Posts

Hi I am having a slight problem and I don't understand way? Here goes

 

I have 3 pages

1 index.php

2 /includes/header.php

3 /includes/publicAlbums.php

 

So I need to the Album names out of the DB Now this part and the code is in publicAlbum.php

Here is the code for publicAlbum.php

<?php 
mysql_select_db($database_content, $content);
// Sql query
$publicAlbumSQL = "SELECT albums.albumName, 
clients.clientName, 
albums.albumDesc, 
albums.albumType, 
albums.albumDate
FROM albums INNER JOIN assignElements ON albums.albumID = assignElements.albumId
 INNER JOIN clients ON assignElements.clientId = clients.clientID
WHERE clients.clientName = 'Public'";
$recordPublicAlbum = mysql_query($publicAlbumSQL, $content) or die(mysql_error());
$rowPublicAlbum = mysql_fetch_assoc($recordPublicAlbum);
?>

 

Now I know that the code above works as I am getting my album names out putted in the head.php page which is a include on the index.php page

 

Here is the code for the head.php

   <div id="head">
               <div id="menu">	
                    <ul id="mainMenu" class="mainMenu">
                    <li id="home"><a href="index.php" title="Home">Home</a></li>
                    <li id="about"><a href="about.php" title="About">About</a></li>
                    <li id="gallery"><a href="gallery.php" title="Gallery">Gallery</a>
                            <ul>
						<?php  do{?>
                                <li><a href="#" class="sub"><?php echo $rowPublicAlbum['albumName'] ?></a></li>
                                 <?php }while($rowPublicAlbum = mysql_fetch_assoc($recordPublicAlbum)) ?>
                            </ul>
                     </li>                        
                    <li id="contact"><a href="contact.php" title="Contact">Contact</a></li>                    
                    <li id="login"><a href="login.php" title="Login">Login</a></li>
                    </ul>
                </div>	
            <a href="index.php"><img src="images/logo.gif" alt="Logo" border="0" class="left"/></a>    
        </div>

 

So here is the problem I have the album name displaying on the header ie navigation bar but I also need to display it a second time some were else on the index.php page but I can not get it to work. Can any of you guys see what I am missing?

 

Code for index.php page

<?php require_once('Connections/content.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
//Get public albums
include("includes/publicAlbums.php");

mysql_select_db($database_content, $content);
$query_rs_pageDetails = "SELECT * FROM pages WHERE pageId = 1";
$rs_pageDetails = mysql_query($query_rs_pageDetails, $content) or die(mysql_error());
$row_rs_pageDetails = mysql_fetch_assoc($rs_pageDetails);
$totalRows_rs_pageDetails = mysql_num_rows($rs_pageDetails);

mysql_select_db($database_content, $content);
$query_rs_optionalData = "SELECT optionalDataKey FROM optionalData ORDER BY optionalDataId ASC";
$rs_optionalData = mysql_query($query_rs_optionalData, $content) or die(mysql_error());
$row_rs_optionalData = mysql_fetch_assoc($rs_optionalData);
$totalRows_rs_optionalData = mysql_num_rows($rs_optionalData);

if($row_rs_pageDetails['pageStatus'] <> "on"){
header("Location: construction.php");
};


?>
<!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">
<head>
<meta name="keywords" content="<?php echo $row_rs_pageDetails['pageMetaKeywords']; ?>" />
<meta name="description" content="<?php echo $row_rs_pageDetails['pageMetaDescription']; ?>" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php echo $row_rs_pageDetails['pageMetaTitle']; ?></title>
<link rel="shortcut icon" href="images/favicon.ico" />
<link href="css/sp.css" rel="stylesheet" type = "text/css" />
<script src="js/swfobject.js" type="text/javascript"></script>
<?php do {
echo $row_rs_optionalData['optionalDataKey']."\n";
} while ($row_rs_optionalData = mysql_fetch_assoc($rs_optionalData)); 
?>
</head>
<body id="home">
<div id="container">
  <!--Head and nav-->
  <?php include('includes/head.php');?>
  <!--Home Left column-->
  <div id="leftColumn"><?php echo $row_rs_pageDetails['pageContent']; ?>
    <div class="clear"></div>
    <h1 class="speciality">Speciality</h1>
    <div class="specialityPanel">
      <ul class="speciality">
        <?php  do{?>
        <li><a href="gallery.php"><?php echo $rowPublicAlbum['albumName'] ?></a></li>
        <?php }while($rowPublicAlbum = mysql_fetch_assoc($recordPublicAlbum)) ?>
        <li><a href="gallery.php">Real-estate</a></li>
      </ul>
    </div>
    <div class="clear"></div>
  </div>
  <!--Home right flash content-->
  <div id="featured">
    <div id="homefeatured"> </div>
    <script type="text/javascript">
				var so = new SWFObject("featured.swf", "homefeatured" , "630", "450", "8" , "#000000" );
				so.addParam("menu","false");
				so.addParam("wmode","transparent");		
				so.write("homefeatured");			
	</script>
  </div>
  <!--Foot-->
  <?php include('includes/foot.php');?>
</body>
</html>
<?php
mysql_free_result($rs_optionalData);

mysql_free_result($rs_pageDetails);
?>

Link to comment
https://forums.phpfreaks.com/topic/156909-solved-can-get-data-out-of-db/
Share on other sites

1. Is it really necessary to select the same DB three times? For reference:

mysql_select_db($database_content, $content);
$query_rs_pageDetails = "SELECT * FROM pages WHERE pageId = 1";
$rs_pageDetails = mysql_query($query_rs_pageDetails, $content) or die(mysql_error());
$row_rs_pageDetails = mysql_fetch_assoc($rs_pageDetails);
$totalRows_rs_pageDetails = mysql_num_rows($rs_pageDetails);

mysql_select_db($database_content, $content);
$query_rs_optionalData = "SELECT optionalDataKey FROM optionalData ORDER BY optionalDataId ASC";
$rs_optionalData = mysql_query($query_rs_optionalData, $content) or die(mysql_error());
$row_rs_optionalData = mysql_fetch_assoc($rs_optionalData);
$totalRows_rs_optionalData = mysql_num_rows($rs_optionalData);

 

There are two there + the one in the first block of code you posted.

 

2. Isn't your second file named header.php?

<?php include('includes/head.php');?>

You don't see anything wrong with that?

Ok I have carried out some more work and rewritten a lot of my code as it really needed to be streamlined :) However I still have the same problem. Anyone please.

 

index.php

<?php require_once('Connections/content.php'); ?>
<?php
mysql_select_db($database_content, $content);
//Get public albums
include("includes/publicAlbums.php");
include("includes/getPageDetails.php");

$pageDetailsSQL = "SELECT * FROM pages WHERE pageId = 1";
$recordPageDetails = mysql_query($pageDetailsSQL, $content) or die(mysql_error());
$rowPageDetails = mysql_fetch_assoc($recordPageDetails);
//check if page is ative
if($rowPageDetails['pageStatus'] <> "on"){
header("Location: construction.php");
};
?>
<!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">
<head>
<meta name="keywords" content="<?php echo $rowPageDetails['pageMetaKeywords']; ?>" />
<meta name="description" content="<?php echo $rowPageDetails['pageMetaDescription']; ?>" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php echo $rowPageDetails['pageMetaTitle']; ?></title>
<link rel="shortcut icon" href="images/favicon.ico" />
<link href="css/sp.css" rel="stylesheet" type = "text/css" />
<script src="js/swfobject.js" type="text/javascript"></script>
<?php do {
echo $rowOptionalData['optionalDataKey']."\n";
} while ($rowOptionalData = mysql_fetch_assoc($recordOptionalData)); 
?>
</head>
<body id="home">
<div id="container" >
  <!--Head and nav-->
  <?php include('includes/head.php');?>
  <!--Home Left column-->
  <div id="leftColumn"><?php echo $rowPageDetails['pageContent']; ?>
    <div class="clear"></div>
    <h1 class="speciality">Speciality</h1>
    <div class="specialityPanel">
      <ul class="speciality">
        <?php  do{?>
        <li><a href="gallery.php"><?php echo $rowPublicAlbum['albumName'] ?></a></li>
        <?php }while($rowPublicAlbum = mysql_fetch_assoc($recordPublicAlbum)) ?>
        <li><a href="gallery.php">Real-estate</a></li>
      </ul>
    </div>
    <div class="clear"></div>
  </div>
  <!--Home right flash content-->
  <div id="featured">
    <div id="homefeatured"> </div>
    <script type="text/javascript">
				var so = new SWFObject("featured.swf", "homefeatured" , "630", "450", "8" , "#000000" );
				so.addParam("menu","false");
				so.addParam("wmode","transparent");		
				so.write("homefeatured");			
	</script>
  </div>
  <!--Foot-->
  <?php include('includes/foot.php');?>
  </div>
</body>
</html>

 

head.php

   <div id="head">
               <div id="menu">	
                    <ul id="mainMenu" class="mainMenu">
                    <li id="home"><a href="index.php" title="Home">Home</a></li>
                    <li id="about"><a href="about.php" title="About">About</a></li>
                    <li id="gallery"><a href="gallery.php" title="Gallery">Gallery</a>
                            <ul>
						<?php  do{?>
                                <li><a href="#" class="sub"><?php echo $rowPublicAlbum['albumName'] ?></a></li>
                                 <?php }while($rowPublicAlbum = mysql_fetch_assoc($recordPublicAlbum)) ?>
                            </ul>
                     </li>                        
                    <li id="contact"><a href="contact.php" title="Contact">Contact</a></li>                    
                    <li id="login"><a href="login.php" title="Login">Login</a></li>
                    </ul>
                </div>	
            <a href="index.php"><img src="images/logo.gif" alt="Logo" border="0" class="left"/></a>    
        </div>

 

publiclAlbums.php

<?php 
// Sql query
$publicAlbumSQL = "SELECT albums.albumName, 
clients.clientName, 
albums.albumDesc, 
albums.albumType, 
albums.albumDate
FROM albums INNER JOIN assignElements ON albums.albumID = assignElements.albumId
 INNER JOIN clients ON assignElements.clientId = clients.clientID
WHERE clients.clientName = 'Public'";
$recordPublicAlbum = mysql_query($publicAlbumSQL, $content) or die(mysql_error());
$rowPublicAlbum = mysql_fetch_assoc($recordPublicAlbum);
?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.