Dynamic Links

[john010117]

I have read the stickies/announcements, and they did say how to do this. But they didn't explain it further, and the link they've posted for further reading doesn't work. So, here's my problem.

On my index page, I have a news section. No php needed for that. But I want the website to automatically archive old news when the next day comes. So, if I type in index.php, it should automatically get the news for today (but I'm typing up the news). Sorry if this doesn't make sense. I want to have something like this (see the date at the top and the arrows?). How do you do that?

[Roger_Ramjet]

You use a database to store the news articles indexed by date.Then users can scroll back and forth from day to day and your page gets and displays the news for the given day.

[john010117]

That's exactly what I want. But how do you do that?

[john010117]

Ok, I've got it to ouput the data I want. I indexed it by date. Now, how do you output the data that's only in the specified date?

[Roger_Ramjet]

You query for it with a WHERE clause.

[john010117]

Ok, I've got that. Thanks. Now, how do you search for older posts by date using dynamic links? Here's the code I have so far.

<?php
// Connection information
$db_host = "localhost"; 
$db_user = "**"; 
$db_pass = "**"; 
$db_name = "**"; 

// Connect to server
$dbac = mysql_connect($db_host,$db_user,$db_pass); 

// Select database
mysql_select_db ($db_name) or die ("Cannot connect to database"); 

$result = mysql_query("SELECT * FROM news WHERE Date");

if ($result && mysql_num_rows($result)) {
      $numrows = mysql_num_rows($result);
      $rowcount = 1;

  while ($row = mysql_fetch_assoc($result)) {

     while(list($var, $val) = each($row)) {
        print "<B>$var</B>: $val<br />";
     }

     print "<br />";
     ++$rowcount;
  }
   }
?>

[Houdini]

WHERE Date? That is not a clause WHERE Date what? you need some sort of condition for the WHERE clause to work.

[john010117]

"Date" is a field in my table named "news". It's set to "DATE". So, in order to only show the news that has been posted for today, what code will I need to insert there?

[john010117]

I've almost figured it all out. Here's my latest code:

<?php
// Connection information
$db_host = "localhost"; 
$db_user = "**"; 
$db_pass = "**"; 
$db_name = "**"; 

// Connect to server
$dbac = mysql_connect($db_host,$db_user,$db_pass); 

// Select database
mysql_select_db ($db_name) or die ("Cannot connect to database"); 

// Change is here added [ = '{$_GET['date']}' ] to end. Which get ?date=____ from url.
$result = mysql_query("SELECT * FROM news WHERE Date = '{$_GET['date']}'");

if ($result && mysql_num_rows($result)) {
      $numrows = mysql_num_rows($result);
      $rowcount = 1;

  while ($row = mysql_fetch_assoc($result)) {

     while(list($var, $val) = each($row)) {
        print "<B>$var</B>: $val<br />";
     }

     print "<br />";
     ++$rowcount;
  }
   }
?>

All I need is when I just type in "index.php", it'll give me today's news. Can anybody help?

[parusa619]

john010117 wrote:

Ok, I've got that. Thanks. Now, how do you search for older posts by date using dynamic links? Here's the code I have so far.

<?php
// Connection information
$db_host = "localhost"; 
$db_user = "**"; 
$db_pass = "**"; 
$db_name = "**"; 

// Connect to server
$dbac = mysql_connect($db_host,$db_user,$db_pass); 

// Select database
mysql_select_db ($db_name) or die ("Cannot connect to database"); 

$result = mysql_query("SELECT * FROM news WHERE Date");

if ($result && mysql_num_rows($result)) {
      $numrows = mysql_num_rows($result);
      $rowcount = 1;

  while ($row = mysql_fetch_assoc($result)) {

     while(list($var, $val) = each($row)) {
        print [B]"<B>$var</B>: [/B] [B]$val[/B]<br />";
     }

     print "<br />";
     ++$rowcount;
  }
   }
?>

What is $var & $val? I mean is that a built-in function or just a variable?

[liquorvicar]

parusa619 - $var and $val are variables set by the list function (list()

john010117 - I'm not sure you need this line:

while(list($var, $val) = each($row)) {

Your outer while loop is already looping through the rows in the resultset, this would loop through the fields in the current row.

Also, make sure you validate ALL input coming from outside PHP. Especially, don't use $GET and $POST values directly in an sql query like this:

$result = mysql_query("SELECT * FROM news WHERE Date = '{$_GET['date']}'");

Google for PHP input validation for some reading material.