PHP Forum

**jim.thornton** · 06-21-2006, 10:26 PM

I have just converted one of my pages into a database to hopefully convert my whole site soon.

For some reason on line 73 & 74 my reference to $content_title is empty. It is very wierd because on line 67 I reference the variable and it shows correctly.

Here is a link to the page in question: http://www.moneytime.ca/products.php?pg=CASHBACK

Here is a copy of the code:

Code:

<?php
	extract($_GET);
	if(empty($pg)) {
		$pg="CASHBACK";
	}
	ob_start();	
	$host="localhost"; // Host name 
	$username="root"; // Mysql username 
	$password="password"; // Mysql password 
	$db_name="dbname"; // Database name 
	$tbl_name="pgs_products"; // Table name 

    // Connect to server and select databse.
	$curr_loc = $_SERVER['DOCUMENT_ROOT'];
		
	mysql_connect("$host", "$username", "$password")or die("Error! Please try again. <META HTTP-EQUIV=Refresh CONTENT=\"1; URL=http://www.moneytime.ca\">"); 
	mysql_select_db("$db_name")or die("Error! Please try again. <META HTTP-EQUIV=Refresh CONTENT=\"1; URL=http://www.moneytime.ca\">");  
	
	$sql = "SELECT * FROM $tbl_name WHERE pg='$pg' LIMIT 1";
	$results = mysql_query($sql);

	if(mysql_num_rows($results) == "0") {
		$pg = "CASHBACK";
		$sql = "SELECT * FROM $tbl_name WHERE pg='$pg' LIMIT 1";
		$results = mysql_query($sql);
	}
	
	while($data = mysql_fetch_array($results)) {
		extract($data);
	}
	
	mysql_close();
		
	echo <<<HEADEREND
		<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
		<html>
		<head>
		<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
		   <META NAME="description" CONTENT="$page_desc">
		   <META NAME="keywords" CONTENT="$page_keywords">
		   <META name="robots" content="index,follow">
		   <META NAME="author" CONTENT="Moneytime.ca Inc.">
		<!-- $page_keywords -->
		<!-- $page_desc -->
		<!-- $page_title -->
		
		<title>$page_title</title>
		<link rel="stylesheet" type="text/css" href="/Stylesheets/Style.css">
	</head>

<body>
HEADEREND;
	
	include("$curr_loc/banner.php");
	
	echo <<<HEADEREND
		<tr bgcolor="#D2C888">
			<td id="leftside" valign="top">
HEADEREND;
				include("$curr_loc/menus/$menu");
	echo <<<HEADEREND
			</td>		
			
			<td  valign="top" class="darkblue" style="width:78%; padding: 0px 20px 0px 10px; ">
				<img alt="$page_keywords" src="/images/$pic" style="float:right; margin-left:20px; margin-bottom:20px; width:200px; border:1px solid black;">
				<h1>$content_title</h1>
				$content
				<br>
				<br>

				<form method="post" action="/applynow">
					<input type="hidden" name="page" value="$content_title">
					<center><input type="submit" name="applynow" value="Click to inquiry about $content_title"></center>
				</form>
			</td>
		</tr>
		
		<tr>
			<td id="Footer" colspan="2">
HEADEREND;
				include("$curr_loc/footer.php"); 
				include("$curr_loc/disclaimers/mortgage.php"); 

	echo <<<HEADEREND
			</td>
		</tr>
	</table>
</body>
</html>
HEADEREND;
?>

**Skorch1** · 06-21-2006, 10:39 PM

Did you mix up $page_title and $content_title?

if not try

Code:

var_dump($page_title);
echo '<br /><br />';
var_dump($content_title);

**mgraphic** · 06-21-2006, 10:51 PM

I just viwed the source html from the sample link you gave, and there is no value in the first H1 tag either. There is three H1 tags, and only the third has a value which is indicating to me that vaule is comming from $content instead. So it looks as if $content_title was always empty.

**jim.thornton** · 06-21-2006, 11:03 PM

Thanks again mgraphic!

**pitas** · 06-22-2006, 05:45 AM

My friend i guess that there is something suspecious in ur code. There is three H1 tags, and only the third has a value which is indicating that vaule is comming from $content instead. So it looks as if $content_title was always empty. So maybe ur variable is reallt empty, that's why u have it empty in ur database.

**mgraphic** · 06-22-2006, 09:41 AM

Whoa... Deja-Vu!