Dynamic title with from db

jeffafd

I need help coding a dynamic title.

I use a header.php page and a content.php page.

The header.php is of course just the header, the content.php is database driven.

I want the article title on the content.php page to display in the Title bar.

++++++++++++++++++++++++++++++++++++++++++++++++++

The header.php page is written as so...

+++++++++++++++++++++++++++++++++++++++++++++++++++++

But I'm not sure how to get the article title from the database on the content.php page to transfer to the header.php.

The page in quetion is - http://www.everythinghousehold.com/tipcontent.php?id=18

On the Title bar I want it to read - "16 Lawn Mower Safety Tips" which is the article title in the database.

I hope i made this clear.

Houdini

Well since I have no code to see then I am going to give a rough example of how to do it

while($row=mysql_fetch_assoc($result){
echo "<title>{$row['title']}</title>";

jeffafd

Houdini below is the scripts.

I want to get rid of the
"<?php $page_title = 'Household Tips, Advice, Recipes, Shopping and More...';?>"

and have the title display the "title" field.

+++++++++++++++++++++++++++++++++++
content.php

<?php $page_title = 'Household Tips, Advice, Recipes, Shopping and More...';?>

<?php include_once ("headertipcatswhite.php"); ?>

<?php
// editing/adding script

// get the id from the URL request
$id = $_REQUEST['id'];

if( $id )
{

//Database Connection
include $_SERVER['DOCUMENT_ROOT'] . '/db.inc.php';

// retrieve the row from the database
$query = "SELECT * FROM tips WHERE id='$id'";

  $result = mysql_query( $query );

  if( $result && $contact = mysql_fetch_object( $result ) )
  {
     // set our variables
     $id = $contact -> id;
     $title = $contact -> title;
     $author = $contact -> author;
     $content = $contact -> content;
     $category = $contact -> category;



  }
  }

<center><table class="mytable1" width="800" border="0" cellspacing="1" cellpadding="5" bgcolor="dcdcdc">
<tr>
<td width="250" valign="top">
<?php include_once ("tipcategories.php"); ?>
</td><td width="430" bgcolor="ffffff">
<?php

echo "<h3><b>$title</b></h3>";
echo "<b>By:</b> &nbsp;<font color='blue'>$author</font><hr>";
echo $content

</td>

<?php include_once $_SERVER['DOCUMENT_ROOT'] . '/footer.php'; ?>

+++++++++++++++++++++++++++++++++++++++++++++++++++

++++++++++++++++++++++++++++++++++++++++++++++++++
header.php

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Eric_T

Do the DB stuff before your anything else then it's just

Houdini

OK then your header.php has the variable $page_title, so how and where are you including it, if you want to pull a title from the database then what you will need to do is first query the database to get the title from it then apply the title in a manner as I showed above.

So you would start the page with opening the database making the connection and selecting the database and then getting the title from criteria possibly set by either the URL or a $_POST variable taken from a form.

When posting code in these forums if you do not mind please enclose the code in PHP BB Code as can be seen how to do in my signature.

jeffafd

Eric -

thanks for your answer but I need to get the title from the content.php to the header.php

The content.php is pulling the "title" from the database.

Houdini

OK then set the variable taken from the database to something like

$page_title=$row['title'];

then include the header and voila it is changed.

jeffafd

Let me see if I can describe this better.

I need to get the Title of the article which is in a database and being called to the content.php page in which it is displayed to dynamically show in the title bar.

I currently have a static page title "Household Tips, Advice, Recipes, Shopping and More..." and I want it replaced with the title of the article.

So at the top of this page - http://www.everythinghousehold.com/tipcontent.php?id=18 it will say "16 Lawn Mower Safety Tips" not "Household Tips, Advice, Recipes, Shopping and More..."

I'm just not sure how to code it.

Here is the complete header.php-

<html>
<head>
<title><?php echo $page_title;?></title>
<link rel="stylesheet" type="text/css" href="http://www.everythinghousehold.com/mystyles.css">
<meta http-equiv="Content-Type" content="text/html; charset=Replace With Your Charset">
<meta name="Description" content="EverythingHousehold has everything you need to keep your house running smooth. You can get helpful tips, recipes, shopping information and DIY advice.">
<meta name="Keywords" content="how to fix lawnmower, cleaning products advice, grad gifts, submit your health articles here, free online recipes, homeowner supplies, diy heating">

</head>

<body background="images/lgrey.jpg">

<center>
<!-- ImageReady Slices (hhhlogo.psd) -->
<table id="Table_01" width="800" height="100" border="0" cellpadding="0" cellspacing="0">
	<tr><td>
			<a href="http://www.everythinghousehold.com/index.php">
				<img src="hhhlogo_01.jpg" width="264" height="100" border="0" alt="Everything Household Homepage"></a></td>
		<td>
			<a href="http://www.everythinghousehold.com/articlecats.php">
				<img src="hhhlogo_02.jpg" width="92" height="100" border="0" alt="Articles to help make your home a better place"></a></td>
		<td>
			<a href="http://www.everythinghousehold.com/tipcats.php">
				<img src="hhhlogo_03.jpg" width="68" height="100" border="0" alt="Useful household tips"></a></td>
		<td>
			<a href="http://www.everythinghousehold.com/shopindex.php">
				<img src="hhhlogo_04.jpg" width="107" height="100" border="0" alt="Great shopping deals and ideas"></a></td>
		<td>
			<a href="http://www.everythinghousehold.com/recipecats.php">
				<img src="hhhlogo_05.jpg" width="104" height="100" border="0" alt="Tasty Recipes for any occassion"></a></td>
		<td>
			<a href="http://everythinghousehold.com/blog/index.php">
				<img src="hhhlogo_06.jpg" width="72" height="100" border="0" alt="What's new at Everything Household"></a></td>
		<td>
			<a href="http://www.everythinghousehold.com/submit.php">
				<img src="hhhlogo_07.jpg" width="93" height="100" border="0" alt="Submit your article, tip or recipe"></a></td>
	</tr>
</table>
<!-- End ImageReady Slices -->
</center>

<center><table class="mytable2" width="790" border="0" bgcolor="ffffff">
<tr><td> 

<table class="mytable3" width="220" height="200" border="0">
<tr><td>
<a href="newsletter.php"><img src="images/newsletter.gif" width="210" height="25" border="0"></a>
</td></tr>
<tr><td>
<ul>
<li><a href="articlecats.php"><b>Articles</b></a>
<li><a href="tipcats.php"><b>Tips</b></a>
<li><a href="shopindex.php"><b>Shopping</b></a>
<li><a href="recipecats.php"><b>Recipes</b></a>
<li><a href="links.php"><b>Links</b></a>
</ul>
<center><a href="allstores.php"><font color="00008B"><h3>All Places to Shop</h3></font></a></center>
</td></tr>
</table>

</td><td>

<table class="mytable3" width="300" height="200" border="0">
<tr><td>
<b>Most Recent Tips:</b><br><br>
<center><?php include_once("last3tips.php"); ?></center>
</td></tr>
</table>

</td><td>

<table class="mytable3" width="264" height="200" border="0">
<tr><td>
<center><?php include_once ("googlewhite.php"); ?></center>

</td></tr>
</table>

</td></tr>
</table>


</td></tr>
</table></center>


</td></tr>
</table>
</center>

and here is the complete content.php -

<?php $page_title = 'Household Tips, Advice, Recipes, Shopping and More...';?>

<?php include_once ("headertipcatswhite.php"); ?>

<?php
   // editing/adding script

   // get the id from the URL request
   $id = $_REQUEST['id'];		

   if( $id )
   {   

//Database Connection
   include $_SERVER['DOCUMENT_ROOT'] . '/db.inc.php';


   // retrieve the row from the database
      $query = "SELECT * FROM `tips` WHERE `id`='$id'";

  $result = mysql_query( $query );

  if( $result && $contact = mysql_fetch_object( $result ) )
  {
     // set our variables
     $id = $contact -> id;
     $title = $contact -> title;
     $author = $contact -> author;
     $content = $contact -> content;
     $category = $contact -> category;



  }
  }  


 ?>


<center><table class="mytable1" width="800" border="0" cellspacing="1" cellpadding="5" bgcolor="dcdcdc">
<tr>
<td width="250" valign="top">
<?php include_once ("tipcategories.php"); ?>
</td><td width="430" bgcolor="ffffff">
<?php

echo "<h3><b>$title</b></h3>";
echo "<b>By:</b> &nbsp;<font color='blue'>$author</font><hr>";
echo $content


?>

<hr>
<?php include("referfriend.php"); ?>

</td>

<td width="120" valign="top">
<?php include_once $_SERVER['DOCUMENT_ROOT'] . '/amazonbook.php'; ?>
<br><br>
<?php include_once $_SERVER['DOCUMENT_ROOT'] . '/googleskyscraper.php'; ?>
</td>
</tr>
</table></center>

<?php include_once $_SERVER['DOCUMENT_ROOT'] . '/footer.php'; ?>

It seems to me that the "<title><?php echo $page_title;?></title>" in the header could stay the same

and I would need to do something like - "<?php $page_title = ['$title'];?>" to the content.php page.

jeffafd

Houdini wrote:
OK then set the variable taken from the database to something like
$page_title=$row['title'];
then include the header and voila it is changed.

Houdini - I'm not sure where you mean to use this? I assume the content.php page but not sure where.