Webpage title using PHP and MySQL?

**luxuri** · Nov 24, 2012 21:45

Hi all,

I have a page where if you visit the example www.site.com/eg.php?id=5, then it will bring you to the page with row 5 details.

However is it possible to put it in the title? I want the title to show the $rows['name'] of the database with the id from the link. I did some research and it says to include this <title><?php echo $page_title; ?></title>, however it does not display properly. Any ideas?

**guido2004** · Nov 25, 2012 01:13

How about

PHP Code:


 <title><?php echo $rows['name']; ?></title>

If you want to display $rows['name'], echoing the value of another variable won't do you no good, unless in your script you put the value of $rows['name'] in that other variable.

**luxuri** · Nov 25, 2012 02:23

Hi, I've tried this and it still returns nothing

thanks for the suggestion though, I'm dumb enough to not think of that. By the way, does using PDO to connect to the database have anything to do with returning the info?

**guido2004** · Nov 25, 2012 04:41

Originally Posted by luxuri

Hi, I've tried this and it still returns nothing

thanks for the suggestion though, I'm dumb enough to not think of that. By the way, does using PDO to connect to the database have anything to do with returning the info?

If you use PDO to connect to the database, then you'll use PDO to retrieve the data.
Please post your code.

**luxuri** · Nov 25, 2012 06:13

Here is what I use to connect:

<?php
$id = $_GET['id'];

// Connect to db
try
{
$pdo = new PDO('mysql:host=localhost;dbname=eugechin_restaurants', 'eugechin', 'eugenechin21');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->exec('SET NAMES "utf8"');
}
catch (PDOException $e)
{
echo "Unable to connect to the database server!<br>" . $e;
exit();
}
?>

**guido2004** · Nov 25, 2012 11:32

No not that part of the code.
The part where you retrieve the data from the database and display it.

**aaarrrggh** · Nov 25, 2012 14:23

Please post the entire script - all of the code. Cheers.

**luxuri** · Nov 26, 2012 03:00

Here's the whole code of my php page. Thanks! I took away some unnecessary bits and removed database passwords.

Code:

<?php
$id = $_GET['id'];
 
// Connect to db
try
{
  $pdo = new PDO('mysql:host=localhost;dbname=dbname', 'user', 'pw');
  $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  $pdo->exec('SET NAMES "utf8"');
}
catch (PDOException $e)
{
  echo "Unable to connect to the database server!<br>" . $e;
  exit();
}
?>
<!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 http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>fh|<?php echo $row['name']; ?></title>
<link rel="icon" type="image/png" href="favicon.png" />
<link rel="stylesheet" href="style.css" />
<link rel="stylesheet" type="text/css" href="css/resets.css" />
<link rel="stylesheet" type="text/css" href="css/jbslider.css" />
<link rel="stylesheet" type="text/css" href="css/jquery.jscrollpane.css" />
<link rel="stylesheet" type="text/css" href="custom_css.css" />
<script type="text/javascript" src="js/jquery-1.7.min.js"> </script>
<script type="text/javascript" src="js/jquery-ui-1.8.12.min.js"> </script>
<script type="text/javascript" src="js/jquery.jscrollpane.min.js"> </script>
<script type="text/javascript" src="js/jbslider.min.js"> </script>
<script type='text/javascript' src='/js/lib/mootools-core-1.3-full-compat-nc.js'></script>
<script type="text/javascript">
function Toggle(id,close,open,ms){
 var obj=document.getElementById(id),o=Toggle['zxc'+id],to;
 if (!o&&obj){
  Toggle['zxc'+id]=o={
   obj:obj,
   now:0,
   ms:500,
   ud:true
  }
 }
 if (o){
  ms=typeof(ms)=='number'?ms:o.ms;
  obj.style.display='block';
  to=o.ud?open:close;
  clearTimeout(o.dly);
  animate(o,o.now,to,new Date(),ms*Math.abs((to-o.now)/open));
  o.ud=!o.ud;
 }
}

function animate(o,f,t,srt,mS){
 var oop=this,ms=new Date().getTime()-srt,now=(t-f)/mS*ms+f;
 if (isFinite(now)){
  o.now=Math.max(now,0);
  o.obj.style.height=o.now+'px';
 }
 if (ms<mS){
  o.dly=setTimeout(function(){ oop.animate(o,f,t,srt,mS); },10);
 }
 else {
  o.now=t;
  o.obj.style.height=o.now+'px';
  if (t==0){
   o.obj.style.display='none';
  }
 }
}
</script>
<script type="text/javascript">
animatedcollapse.addDiv('jason', 'optional_attribute_string')
//additional addDiv() call...
//additional addDiv() call...
animatedcollapse.init()
</script>
<link href='http://fonts.googleapis.com/css?family=PT+Sans' rel='stylesheet' type='text/css'>
</head>

<body>
<div id="contain">
<div id="header">
<div id="hwrapper">
		<a href="/index.php" id="logo"><img src="flogo.png" alt="Logo" width="460px" height="140px"/></a>
  </div>
</div>

<div id="container">
	<div id="line">
</div>
<div id="navbar">
    <div id="nav">
    	<ul>
        	<li><a href="index.php">Home</a></li>
            <li><a href="list.php">Restaurant List</a></li>
            <li><a href="submit.php">Submit a Restaurant</a></li>
            <li><a href="about.php">About</a></li>
            <li><a href="#"><div class="button open-button" onMouseUp="Toggle('page-split-wrap',0,250,500);"><span style="font-style:italic; font-size:19px;">Restaurant Search</span></div></a>

</li>
        </ul>
    </div>
 
    <div id="body">
     <div id="page-split-wrap">
  <div class="page-split-head"> </div>
  <div class="page-split-content">
    <p class="inside">
<form method="get" action="/search1/search.php">
<div>

  <input type=  "text" name=     "q" value="Search"  class="inputtext" onFocus="this.value=''"/>
  <input type="hidden" name=   "cat" value=""  class="inputtext"/>
  <input type="hidden" name=  "time" value="0" class="inputtext"/>
  <input type="hidden" name="letter" value=""  class="inputtext"/>
  <input type="hidden" name="offset" value="0" class="inputtext"/>
  <input type="hidden" name=  "type" value="quick"  class="inputtext"/>
  <br />
  <br />
  <div id="submitsearch">
  <input type="submit" style="font-size:16px;" value="Search" class="sbutton"/>
</div>
</div>
</form>

</p>
  </div>
 </div>
    <div id="wrapperb"> 
    <?php
// The query
$id = (int) $_GET['id'];
$sql= $pdo->prepare('SELECT * FROM review WHERE id = :id');
$sql->execute(array(':id' => $id));
if ($sql->rowCount() === 0)
{
	echo '<br>Sorry, but the id did not match anything in the database.
}
else
{
foreach ($sql as $row) {
  echo '<div id="infobar"><span class="restaurantname"><div id="namealign">'.$row['name'].'</div></span><div id="inforight">'.$row['cuisine'].'<br><span class="address">'.$row['address'].'<br>'.$row['phone'].'</div></div><br>'
  
</div>
<div id="footer">
<div id="wrapperb">
		<div id="footerlinks">
        <img src="about.png" width="220" height="207" />
        <img src="contact.png" width="220" height="207" />
        <img src="terms.png" width="220" height="207" />
        <img src="holder.png" width="220" height="207" />
        </div>
    	                <?php include 'footer.php'; ?>

        
        <img src="http://hitwebcounter.com/counter/counter.php?page=4612375&style=0007&nbdigits=5&type=page&initCount=0" title="" Alt=""   border="0" >
</body>
</html>

**mildfoam** · Nov 26, 2012 18:27

I'm usually fetch all data from mysql in the top of my script so i can done with dynamic title based on selected page.

but, based on your script above i just see you fetch data from mysql in middle of html tag so

PHP Code:


<title>fh|<?php echo $row['name']; ?></title>

would not work as well : undefined index: name?

**dresden_phoenix** · Nov 26, 2012 18:44

granted I just gave the code a cursory glance, but I dont see where you sent a query to $pdo (BEFORE) you use it output the title. Worse still there is no iteration ( so there is actually no $row, and thus no $row['name'], from the already EMPTY $pdo.

a lot more strategic thinking needs to be done here. I mean if your query resulted in 20 articles, all which will display on a single page WHAT would be your title? The headline of the first article? the category where it comes from? part of the query string???

once you decide that you can do your query even before your <html> tag and use the retrieved information to build the title string accordingly. then you just output it as suggested above

**14u2ponder** · Nov 26, 2012 18:59

First of all, you need to store $row['name'] in a variable and put that in your controller. Also make sure that it is BELOW your foreach. Currently your foreach statement is at the very bottom of your script. Therefore your varaible needs to be below that or else you will get an undefined variable.

PHP Code:


<?php



$retrieverow = $row['name'];

Once you do this, then you can pass that varaible to your html title page like this:

PHP Code:


<title><?php echo htmlspecialchars($retrieverow, ENT_QUOTES, 'utf-8'); ?></title>

User Tag List

Thread: Webpage title using PHP and MySQL?

Thread Tools

Display

Webpage title using PHP and MySQL?

Bookmarks

Bookmarks

Posting Permissions