Passing variable to another php file: http://localhost/story.php?id=1

iHenrik

The script below (list.php) retrieves data from a database to list article titles. By clicking the hyperlink, the article text is supposed to appear when accessing story.php based on the $id variable passed through to the file "story.php". However I get this error msg when loading story.php.:

"Notice: Undefined variable: id in c:\easyphp\www\story.php on line 12."

Address line shows: http://localhost/story.php?id=1
It does not recognize the id variable, why ?

Please help. This script has worked before. However, I have recently installed php version 4."something" on my computer and run Apache.
Thanks for any help.

list.php:

include("conf.php");
//include("functions.php");

$connection = mysql_connect($host,$user,$pass) or die ("db feil");

mysql_select_db($db) or die ("Uanble to select database");

$query = "SELECT id, slug, timestamp FROM news ORDER BY timestamp DESC LIMIT 0,5";
$result = mysql_query($query) or die ("Error in query");

// if records present
if (mysql_num_rows($result) > 0)
{
while ($row = mysql_fetch_object($result))
{

   <li><font size="-1"><b><a href="story.php?id=<? echo $row->id; ?>"><? echo $row->slug; ?></a></b></font> 


    <br>
    <font size="-2"> <? echo $row->timestamp; ?></font>
    <p>

<?
}
}

// if no records present
else

{

?>
 No press releases currently available 
<?
}

// close database connection
mysql_close($connection);
?>

story.php

include("conf.php");
include("functions.php");

$connection = mysql_connect($host,$user,$pass) or die ("db feil");

mysql_select_db($db) or die ("Uanble to select database");

$query = "SELECT slug, content, contact, timestamp FROM news WHERE id = '$id'";

$result = mysql_query($query) or die ("Error in query");

$row = mysql_fetch_object($result);

// print details
if($row)
{
?>

<? echo $row->slug; ?>

<? echo nl2br($row->content); ?>

This press release was published on <? echo $row->timestamp; ?>.
For more information, please contact <? echo $row->contact; ?>
<?
}
else
{
?>

That press relase could not be located. 
<?
}

// close database connection
mysql_close($connection);
?>

badgoat

instezd of this

try this

<a href="story.php?id='.$row['id'].'"">'.$row['slug'].'</a>

?>

iHenrik

😕 Thanks, but I didn't get that to work. However, the error doesn't seem to be in the list.php script. since the passing variable "$id" actually get the correct id number from the database table, but the file which receives this variable does not recognize the value. I have tested the script without involving any database, and the $id variable does not carry over to story.php.

It is strange, and I wondering if there is some php settings which are causing this. The installation I have is based upon the EasyPHP program , which by the way saved me a lot of trouble.

Thanks for your effort, and I hope you or somebody else have further explainations to what is causing the error msg I listed above.

Take care.

Rodney_H_

I don't see you 'getting' the id variable from the url string anywhere in your story.php.

<?php
// get id from url or use default
if (isset($_GET['id'])){
$id = $_GET['id'];
} else {
$id = "1"; // default
}

include("conf.php");
//include("functions.php");

$connection = mysql_connect($host,$user,$pass) or die ("db feil");

mysql_select_db($db) or die ("Uanble to select database"); 

// then your query would be
$query = "SELECT slug, content, contact, timestamp FROM news WHERE id = '$id'";

// OR, you could just try this...
$query = "SELECT slug, content, contact, timestamp FROM news WHERE id = '" . $_GET['id'] . "'"; 
?>

So, maybe for your sql statement try this...

wempy

Maybe, as you have just upgraded to php 4.something (if it is greater than 4.23 I think) then the ini variable register_globals is turned off.

try looking in php.ini

iHenrik

Thanks for all your help. Wempy, you were right, the register_globals is turned off. I choose to have it turned off since it is recommended, and I will continue using the script Rodney provided me.