PHP/MySQL Hyperlinks

[cdherold]

Fellow PHPbuilders,

I am a novice to PHP. I am having press releases dynamically written to a MySQL database. The title of each press release is under the row "header", the body is under row "body". I am trying to get PHP to retrieve only (and all of) those press releases that are <24hrs old and put the "header" for each on the mainpage with an active link to a following page which contains the "body". Each press release has a given id and a given time of entry. TIme of entry is in standard MySQL format (00:00:00).

This little piece of code is all I have, but it is not complete and I'm not sure exactly how to finish it off

<?
$conn = mysql_connect('localhost', user, pass);
mysql_select_db("database");

$query = "select body from press_releases where id='$id'";

echo $QUERY_STRING."<BR>";
?>

Can anyone help?

thanks,

cdherold

[Anon]

And I don't know your table definition, so bear with me.

$days = 1;
$query = "SELECT * from press_releases WHERE TO_DAYS(NOW()) - TO_DAYS(date_added) <= ".$days." ORDER BY name";

Additionally, it appears you have a typo in your dbconnect statement. if the user and pass values are variables, you'll need the dollar sign on them.

[brandonschnell]

here is some example code:

CREATE TABLE press_releases
(id INT AUTO_INCREMENT PRIMARY KEY, date DATETIME, headers TEXT, body TEXT);

headers.php

<?
#place the below in an include file not accessible under the web root
$database = "database_name";
$server = "localhost";
$username = "username";
$password = "password";

$conn = mysql_connect($server, $username, $password);

$query = "SELECT id, date, headers FROM press_releases WHERE date < NOW() AND date > DATE_SUB(NOW(), INTERVAL 24 HOUR) ORDER BY DATE DESC";

$query_results = mysql_db_query("$database","$query");

while($row = mysql_fetch_object($query_results))
{
echo "<A HREF=\"details.php?id=$row->id\">$row->date $row->headers</A><BR>";
}

?>

details.php

<?
#place the below in an include file not accessible under the web root
$database = "database_name";
$server = "localhost";
$username = "username";
$password = "password";

if(!isset($id) || $id == "")
{
echo "Error! No id was specified!";
exit;
}

$conn = mysql_connect($server, $username, $password);

$query = "SELECT date, headers, body FROM press_releases WHERE id = '$id'";

$query_results = mysql_db_query("$database","$query");

while($row = mysql_fetch_object($query_results))
{
echo $row->date,"\n<BR>";
echo $row->headers,"\n<BR>\n<BR>";
echo $row->body,"\n<BR>";
}

?>

[cdherold]

hi--

Right now I'm just trying to get an accurate hyperlink of the header for the press releases. To do so I put together a modified version of the code you sent me ...

<?
#place the below in an include file not accessible under the web root
$database = "database";
$server = "db.server.com";
$username = "user";
$password = "pass";

$conn = mysql_connect($server, $username, $password);

$query = "SELECT date,header,id FROM press_releases";

$query_results = mysql_db_query("$database","$query");

while($row = mysql_fetch_array($query_results))
{
echo "<A HREF=\"press_release.php?id=$row->id\">$row->date<br>$row->header</A><BR>";
}

?>

but all it gave me was this (the first two rows were hyperlinked)...

id\">$row->date
$row->header
"; } ?>

Any idea what I might have done wrong?

I think the ">" in the $row->id part of the code inadvertantly closed the linking constructor. I would've thought the backslashes would have taken care of this, but I'm no PHP programmer so I couldn't really say.

Do I need to activate $conn somehow to open the database?

thanks very much for your help,

Chris Herold

[brandonschnell]

to access the variable in the array $row using php function mysql_fetch_array() you'll need to refer to the offset or the element name:

$row[0]; #first item in array $row
$row["id"]; #element name "id" in array $row. note, this can confuse php when its in strings.

or if you use the php function mysql_fetch_object() to get a row of data, you can use an object oriented like approach to access the array $row. example:

$row->id;

if the OO approach fails, see if $row[0] works.

[cdherold]

hi--

I've reverted back to the object oriented approach, but am still unable to get the code to work properly.

There seems to be a problem with the ->'s near the last lines of the code as they interfere with the link constructor. When executed the code shows the active link as "id\">$row->date $row->header".

Relevant code:

echo "<A HREF=\"press_release.php?id=$row->id\">$row->date $row->header</A><BR>";

any tips?

The total code I have at the moment is below:

---

include ("db.php")

$conn = mysql_connect('$localhost', $username, $password);
mysql_select_db($database);

$query = "SELECT date,header,id FROM press_releases WHERE date < NOW() AND date > DATE_SUB(NOW(), INTERVAL 24 HOUR) ORDER BY DATE DESC";

$query_results = mysql_db_query("$database","$query");

while($row = mysql_fetch_object($query_results))
{
echo "<A HREF=\"press_release.php?id=$row->id\">$row->date $row->header</A><BR>";
}

?>

thanks,

chris herold

[brandonschnell]

time for an ugly workaround.

A)
while($row = mysql_fetch_object($query_results))
{
$id = $row->id;
$date = $row->date;
$header = $row->header;
echo "<A HREF=\"press_release.php?id=$id\">$date $header</A><BR>";
}

or:
😎
while($row = mysql_fetch_object($query_results))
{
echo "<A HREF=\"press_release.php?id=", $row->id, "\">", $row->date, " ", $row->header, "</A><BR>";
}