Show If Before current time.

firegurl

I have a site now that requires it to be updated everyhour with a new story. So times this isn't possible so if i could submit three at a time and have it as "datetime" in the database and for the php to only display it if the time has past i could achieve all this without being there.

I'm sure its possible i just don't know enough of the code to figure it out myself....

here is my current code

<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <?php do { ?>
  <?php
if ($row_callinfo['date'] <> $current_date){
$current_date = $row_callinfo['date'];
echo "<br>";
?><span class="dailyheadings"><?php


$year = substr($row_callinfo['date'], 0, 4); 
$month = substr($row_callinfo['date'], 8, 2); 
$day = substr($row_callinfo['date'], 5, 2); 


$unix_time = mktime(0, 0, 0, $day, $month, $year); 

$date = date("d-m-Y", $unix_time); 
  if ($unix_time<mktime()) {?>
  <tr>
    <td>&nbsp;</td>
    <td colspan="2" align="left">

<?php echo "Daily Link For The "; 
echo $date;}


echo "</span>"; 
echo "<br>"; 
?><br></td>
  </tr>
  <tr>
    <td width="5%">&nbsp;</td>
    <?php if ($unix_time<mktime()) {?><td width="10%">
      <div align="left"><a href="<?php echo $row_callinfo['link']; ?>" target="_blank"><img src="<?php echo $row_callinfo['picurl']; ?>"></a> </div></td>
    <td width="85%"><div align="left"><?php echo $row_callinfo['comment']; ?><?php echo "<br>";
?> <?php ;} ?></div></td><?php ;} ?>
  </tr><?php 
   } while ($row_callinfo = mysql_fetch_assoc($callinfo)); ?>
<?php
mysql_free_result($callinfo);
?>
</table>

I only want it used for sorting purposes, so that say i put an article in for 17:00 and its currently 13:00 it won't show for another 4 hours, then after 17:00 it will turn up.

The code is currently kind of working but is only using the date of the entry as a filter not the time like i want it to.

any ideas guru's?

barand

Suppose your table is something like

[code]story

id | show_at | title | etc |
---|---------------------|---------------|-------------|
1 | 2006-06-22 13:00:00 | story 1 | ... |
2 | 2006-06-22 14:00:00 | story 2 | ... |
3 | 2006-06-22 15:00:00 | story 3 | ... |
4 | 2006-06-22 16:00:00 | story 4 | ... |
5 | 2006-06-22 17:00:00 | story 5 | ... |
6 | 2006-06-22 18:00:00 | story 6 | ... |[/code]

On loading the page

<?php
$time_now = date ('Y-m-d H:i:s');


// get the story to be shown in current hour
$sql = "SELECT id, title FROM story
		WHERE show_at <= '$time_now'
		ORDER BY show_at DESC
		LIMIT 1";

?>

firegurl

well i ended up getting it but not quite the way i originally thought i would.

i set up another table in my database called 'show' and thats a datetime field and i did the code you gave.

I keept a field called date because in the grouping code, it wasn't grouping the entries as it did before i made all these changes because when i use a datetime as the entries are no longer 'the same'

just out of curiosity is there a way that you can tell php to strip the date down to compare it against something else?

for example the data (2006-06-22 22:19:02) can you get php to only look at (2006-06-22) and ignore the rest? if yes how can i do this?

barand

$dbDate = '2006-06-22 22:19:02';

$datePart = substr($dbdate, 0,10);

// or

$datePart = date('Y-m-d', strtotime($dbDate));

The latter is more flexible as allows reformatting of the date and time portions or extraction of just a single element. eg.

$hourPart = date('H', strtotime($dbDate));

firegurl

ok that works for the grouping of them but the date reads 01-01-1970

<?php

$dbDate = $row_callinfo['date'];
$datePart = date('Y-m-d', strtotime($dbDate));

if ($datePart <> $current_date){
$current_date = $datePart;
echo "<br>";
?><span class="dailyheadings"><?php
echo "Daily Articles For The ";

$year = substr($datePart, 0, 4); 
$month = substr($datePart, 8, 2); 
$day = substr($datePart, 5, 2); 

$date = date("d-m-Y", $today); 

echo $date; ?>

any ideas?

barand

if $today contains 0 then

echo date("d-m-Y", $today); // --> 01-01-1970

for todays date

echo date("d-m-Y");

firegurl

got it

$unix_time = mktime(0, 0, 0, $day, $month, $year); 

$date = date("d-m-Y", $unix_time);

thanks tons for all the help, your a credit to the site 😉

barand

Just a note

if $datePart contains '2006-06-22'

then your code (below) has the month and day positions switched

$year = substr($datePart, 0, 4);
$month = substr($datePart, 8, 2);
$day = substr($datePart, 5, 2);

You could also use

$displayDate = date ('d-m-Y', strtotime($dbDate));

firegurl

thanks...

i just realised i have one glitch in my site, even if they are not displayed, if the user uses the search function the items not meant to show are in the results how can i get this to work?

"SELECT * FROM article WHERE comment like '%%%s%%' ORDER BY `date` DESC"

to something like

"SELECT * FROM article WHERE comment like '%%%s%%' &  date <= '$time_now' ORDER BY `date` DESC"

barand

$s = 'something';

$sql = "SELECT * FROM article WHERE comment like '%$s%' AND  date <= '$time_now' ORDER BY `date` DESC";

firegurl

got it.... thanks 😉