Previous/Next links as month names to sort listing by month

[misteraven]

I posted this at a different forum, but got no response, so I was hoping to get a little help from some pro's around here.

Anyhow, after some searching and struggling, I think I kinda understand the logic to previous and next buttons (thanks for all the pro's on here willing to create tutorials on the subject so I didnt have to waste a thread on it). Anyhow, I'm trying to build an event listing and realized that simply having previous and next buttons wasnt the best solution. Rather, I'd like to show the events by month and have the other month's events shown by following a link that would actually be the previous months name and next month name. Can anyone please point me to a turorial or anything that would get me on the right path. (Couldnt find anything after a forum search and didnt see any tutorials on the sites I've been checking out)

Thank you much for any help.

Here's the url to the code below:
http://www.12ozprophet.com/event_ca.../allentries.php

Here's the code I have that simply shows all the data sorted chronologically with a previous and next button allowing only three entries per page:

<?



include ("include/header.inc.php");



include("include/dbconnect.php");



$query = "SELECT COUNT(*) FROM $table";



$result = mysql_query($query);



$count = mysql_result($result,0);



if(!isset($page) || $page < 0)



{



$page = 0;



}



$per_page = 3;



$start = $page * $per_page;



if($start > $count)



{



echo "No more records<br>\n";



$page = ceil($count / $per_page);



}



else



{



$query = "SELECT * FROM $table ORDER BY fromyear,frommonth,fromday LIMIT $start,$per_page";



$result = mysql_query($query);



while($row = mysql_fetch_array($result))



{



echo "<b>{$row['eventname']}</b> {$row['frommonth']}.{$row['fromday']}.{$row['fromyear']}\n<br>{$row['headline']}\n<br>\n\n";



        echo "<a href='view.php?id={$row['id']}'>details</a><br><br>";



}



}



if($page > 0)



{



$prev = $page - 1;



echo "<a href='$PHP_SELF?page=$prev'>Prev</a> \n";



}



if($start + $per_page < $count)



{



$next = $page + 1;



echo "<a href='$PHP_SELF?page=$next'>Next</a><BR>\n";



} 


include ("include/footer.inc.php");



?> 

[jc94062]

1. The link doesn't work
2. Please don't post so much code! Just the relevant parts! (And squish it up a little more, space is good, but...)
3. All mistakes in the code below are the result oh sleep deprivation 😃 (So are all spelling mistakes)

<?
//create array of months, IN ORDER, so $months[0] will be January
$months = array("January","February","March","April","May","June","July","August","September","October","November","December");

//find current month with PHPs date function as numerical value
$current_month = date("n");

//-2, due to array starting at zero
$last_month = $months[$current_month-2];

//no need to add one for next month, due to array starting at zero
$next_month = $months[$current_month];

echo "Last month: ".$last_month;
echo "<br>Next month: ".$next_month;
?>

Proof:
http://www.eliteguard.co.uk/test.php

Hope that helps!
(There may be some php function that does this for you, I have a habit of rewriting existing functions, such as the UNIX->Normal time one 😃)

Edit
To anyone else reading this:

The link
http://www.12ozprophet.com/event_calendar/allentries.php does work, it still hides part of the URL, but it now works, odd.

[misteraven]

actually, taht did work nicely, but I'm not sure how I can use that code to display listings for the current month.

I did find some code that pretty much doews what I'm looking for, but I have no clue how or if it's very well written. I've spent the better part of the day looking up bits using the manual, but I think it's getting me even more confused. Anyone know where I can find a tutorial or snippet of code with similar functionality that I can disect and hopefully learn from?

Here's what I found. Any pro'sout there interested in breaking it down or explaining any of it... I'm all ears (eyes).

<?php

include ("include/header.inc.php");

include("include/dbconnect.php");

function fixlen($fixit) {
        if (strlen($fixit)<2) {
                return  "0$fixit";
        } else {
                return $fixit;
        }
}

function gen_month($year,$month) {
    global $pgm;

$mon_date = getdate(mktime(0,0,0,$month,1,$year));
$mon_name = $mon_date['month'];
$mon_total_days = strftime( "%d",mktime(0,0,0,$month+1,0,$year));

$prev_date = getdate(mktime(0,0,0,$month-1,1,$year));
$prev = $prev_date['year'] . fixlen($prev_date['mon']);
$next_date = getdate(mktime(0,0,0,$month+1,1,$year));
$next = $next_date['year'] . fixlen($next_date['mon']);
echo "<a href=$pgm?yyyymm=$prev><<</a>";
echo " <b>$mon_name $year</b>";
echo " <a href=$pgm?yyyymm=$next>>></a><br><br>";
   }


function show_events($year,$month) {
	global $db_table_name,$db_column_name,$db;
      global $pgm;
      $date1 = date("Y-m-d", mktime(0,0,0,$month,1,$year));
      $date2 = date("Y-m-d", mktime(0,0,0,$month+1,1,$year));

  $qrsql =  "SELECT * FROM $db_table_name WHERE ($db_column_name>='$date1' " .
	"and $db_column_name<'$date2') ORDER BY $db_column_name";
  $qr_ret = mysql_query($qrsql, $db);
  $qr_num=mysql_num_rows($qr_ret);
$lastday = 0;
while($row=mysql_fetch_array($qr_ret)) {           		$event_date = $row[$db_column_name];
	$event_year = substr($event_date,0,4);
	$event_month = substr($event_date,5,2);
	$event_day = substr($event_date,8,2);
	$event_getdate = getdate(mktime(0,0,0,$event_month,$event_day,$event_year));
	$day_of_week = $event_getdate['weekday'];
	if ($lastday != $event_day) {
		if ($lastday <> 0) {
			echo "<br>";
		}
		echo "<b>" . $event_getdate['month'] . " " . $event_getdate['mday'] . " " . $event_getdate['year'] . "</b>";
	}
	$lastday = $event_day;
	echo "<br>" . $row['description'] . "<br>";
}
if ($lastday <> 0) {
	echo "<br>";
}
}


?>

<?php
  if (isset($yyyymm)) {
	if(strlen($yyyymm) == 6) {
     	$yyyy = substr($yyyymm, 0, 4);
     	$mm = substr($yyyymm, 4, 2);
  	}
  } else {
    $today = getdate();
    $yyyy = $today['year'];
    $mm = $today['mon'];
  }

  gen_month($yyyy, $mm);
  show_events($yyyy, $mm);
?>

[jc94062]

ARGH.

It took me so long to write that (due to fixing some poll bugs elsewhere) the darned board logged me out and lost it all.

Here we go again (you'll forgive the paraphrasing, its not 4am).

"Rather, I'd like to show the events by month"

I missed that:

The easist way to do this requires your datefield be in MySQL format, yyyy-mm-dd, if it is, all is good

<?

$wanted_month = '08';

$query = mysql_query("select * from table where month(datefield)='$wanted_month'");

?>

For more information on this, http://www.mysql.com/doc/en/Date_calculations.html has loads of examples and detailed information.

If your date is not stored in yyyy-mm-dd format, you have a problem, and the only way to do it without loads of PHP calculations is to change the field format as you compare it, creating temporary fields, but I'm really not sure on the working on that - basically, unless theres a really good reason not to, make sure you use MySQL Date on the field you use for storing the date, even if it means writing a script to convert them all.

Hope that answers it now 😃

[misteraven]

actually, changing the format of the date to SQL was my next step. Now I need to read up on how to actually display it how I want. (mm.dd.yy)

Anyhow, thanks for the help, though I'm still struggling with this damn thing.

Any of veteran php guys want to help a newbie out by explaining the last block of code I posted or something with similar functionality that is coded a little more simply?

[misteraven]

anyone have a link to a tutorial that explains how to reformat a date from mySQL. The php manual is making no sense at all to me.

I think I'm in over my head with this whole thing.

[jc94062]

Extract the date, then reformat it 😃

<?

$query = mysql_query("select * from table_name");
while ($rows = mysql_fetch_array($query))
{
   $mysql_date = $rows["name_of_date_field"];
}

//reformat date, yyyy-mm-dd to mm.dd.yy, using php substr format

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

$wanted_date = $month.".".$day.".".$year;

?>

I posted up the code you needed to get all entries for a month, just integrate that into you current code.