ansaurus

Question

Answer 1

+1 A:

Move the data retrieval at the top of the script, and after that use:

<title>Ultan.me - <?php echo $title; ?></title>

zerkms 2010-08-11 23:47:31

You forgot "Ultan.me"

klez 2010-08-11 23:49:08

When I attempt that the area after "Ultan.me -" is blank. I haven't opened the PHP at the very beginning of the document. Should I?

ThatMacLad 2010-08-11 23:49:17

@klez: so? he will think up this himself.

zerkms 2010-08-11 23:52:03

@ThatMacLad: we have no idea what you mean. try be more detailed.

zerkms 2010-08-11 23:53:06

I'll update the post itself with the beginning of my php document so that it can be more detailed.

ThatMacLad 2010-08-11 23:54:55

Added. The only necessary piece is the beginning of the document.

ThatMacLad 2010-08-11 23:58:06

@ThatMacLad: move the data retrieval at the top of the script.

zerkms 2010-08-11 23:59:16

Where exactly should I place the data retrieval? When I move it to the very top the page is completely blank and the title area doesn't display.

ThatMacLad 2010-08-12 00:01:46

@ThatMacLad: you have to learn how to program or to hire somebody to do that. no alternatives.

zerkms 2010-08-12 00:05:29

You're right zerkms. I'll quit pestering you.

ThatMacLad 2010-08-12 00:06:25

Oh and just FYI... I'm only 15 so you can't expect me to have a world of programming knowledge crammed into my skull. I was just looking for a small bit of help.

ThatMacLad 2010-08-12 00:10:25

Your age is not a justification. If you are learning - then try to learn on a simple code samples, and if you're working - then it is an issue that you've got a work you know nothing about

zerkms 2010-08-12 00:15:07

Answer 2

+3 A:

You parse the field from the database as usual.

Then let's say you put it in a variable called $title, you just

<html>
<head>
<title>Ultan.me <?echo $title;?></title>
</head>

EDIT:

I see your problem. You have to set $title BEFORE using it. That is, you should query the database before <title>...

klez 2010-08-11 23:48:16

When I attempt that the area after "Ultan.me -" is blank. I haven't opened the PHP at the very beginning of the document. Should I?

ThatMacLad 2010-08-11 23:52:33

short tags is weird practice

zerkms 2010-08-11 23:52:39

What zerkms is trying to say, is you should use <?php echo $myvar;?> instead of <? echo....

Matt Williamson 2010-08-12 00:04:35

@Matt Williamsonah, now I get it. BTW I didn't know.

klez 2010-08-12 00:05:53

Answer 3

A:

The problem is that $title is being referenced on line 5 before it's being assigned on line 58. Rearranging your code isn't easy, because the data is both retrieved and output at the same time. Just to test, how does something like this work?

Because you're only retrieving one row, you don't need to use a while loop, but I left it with hopes that it'll make it easier for you to relate to your current code. All I've done is removed the actual output from your data retrieval, and added variables for category and category name which are then referred to as usual later on. Also, I haven't tested this. :)

nilved 2010-08-12 00:31:37

Answer 4

+1 A:

It'll be tricky to rearrange your code to make this work, but I'll try :)

So, put this at the top of your code:

<?php require_once('mysql.php'); ?>

The top of the file should look like:

<?php require_once('mysql.php'); ?>
<html>
    <head>

    <meta name="keywords" content="Mac user Ultan Casey TheCompuGeeks UltanKC">
    <title>Ultan.me - <?php echo $title; ?> </title>

Then, create a file called mysql.php in the same directory that the file which contains the code you quoted is in.

Put this is mysql.php:

<?php
mysql_connect ('localhost', 'root', 'root');
mysql_select_db ('ultankc');

if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    die("Invalid ID specified.");
}

$id = (int)$_GET['id'];
$sql = "SELECT * FROM php_blog WHERE id='$id' LIMIT 1";

$result = mysql_query($sql) or print ("Can't select entry from table php_blog.<br />" .       $sql . "<br />" . mysql_error());

$res = mysql_fetch_assoc($result); 

$date = date("l F d Y", $res['timestamp']);
$title = $res['title'];
$entry = $res['entry'];
$get_categories = mysql_query("SELECT * FROM php_blog_categories WHERE `category_id` = $res['category']");
$category = mysql_fetch_array($get_categories);

?>

Well, hope that helped :)

James Eggers 2010-08-12 01:00:20

ansaurus

tags:

views:

answers:

Set Page Title using PHP.

related questions