PHP Titles?

luxuri · 02-18-2013, 12:49 PM

Hi all,

I have a page, where named example.php?id=5 then the code will retrieve the rows from id 5, which then the rest of the code puts them out. For example, id 5 may be the person John and then id 4 may be Jane.

The mysql retrieving works when i try to display the info. However, is it possible to use these to set my <title></title>?
I've tried many ways,

PHP Code:


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

where $retrieverow was set at the bottom of the page(someone told me so) and others like $_GET. However, the title still remained blank.

Is there a solution to this? Many thanks

Fou-Lu · 02-18-2013, 02:19 PM

Did you put it between your <title> elements?
You can do this of course. It simply means restructuring so your processing ends up before your HTML output. Ultimately this is what you should do in PHP anyways.
A really simple example:

PHP Code:


			
<?php

// Do whatever to get these records.  I'll just pretend that I have a function for it.
$record = fetchMaRecord($_GET['id']);
// now $record has what it need, and presumably only one result.
?>
<Doctype. . .>
<html>
    <head>
        <title><?php echo $record['name'];?></title>
    </head>
    <body>
....

Simple as that. Just make sure that you don't output the head and title until after you've retrieved your results.

luxuri · 02-19-2013, 04:47 AM

Hi

Yes, I have put it between <title>. However, it still doesn't work.
I've tried something similar to your suggestions before. However, nothing still appears. Does it matter of I am using PDO to connect to the database?

Arcticwarrio · 02-19-2013, 01:37 PM

can you post what you have now?

luxuri · 02-20-2013, 02:17 PM

Hi Arcticwarrio and Fou-Lu,

Thanks a bunch for attempting to help, but I've solved it myself by simply moving this

PHP Code:


			
foreach ($sql as $row)

statement at the top of the page, and everything worked.

Many thanks!

Arcticwarrio · 02-21-2013, 01:51 PM

if you find the first row from each query missing you can reset it without a new query too:

PHP Code:


			

db('open'); 
$Results = query("SELECT * FROM table");
db('close');

while ($Row = mysql_fetch_array($Results)) {

//script

}

mysql_data_seek($Results, 0); // resets the query back to the first row

while ($Row = mysql_fetch_array($Results)) {

//another script

}