[SOLVED] pagementation to jump menu

[saltedm8]

i am building my developers site, and i have decided to use the blog i have built, but i want to adjust it a little, this is my pagementation page

PHP: Select all

 <?php include 'config.php'; 

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); 
mysql_select_db( $dbname, $conn ); 

$perPage = 5; // number to display on per page 

// Start by counting the number of posts 

$res = mysql_query ("SELECT count(*) AS num FROM form") or die (mysql_error() . 'dying hurts'); 

$num = mysql_fetch_assoc($res); 
$num = $num['num']; 

mysql_free_result($res); 

// now work out how many pages there are, check if page has been sent via GET 

$numPages = ceil($num / $perPage); 

// Check to make sure pagenum will be 1 or greater, less than numpages and an actual number 
$pageNum  = (!empty($_GET['id']) &&  
             is_numeric($_GET['id']) &&  
             $_GET['id'] > 1)  
              
             ? ($_GET['id'] < $numPages ?  ($_GET['id']) : $numPages) : 1; // Set to 1 if not set or something dodgy 

// Okay, now we run the query and set the limits LIMIT xx, yy (x= start from , y= limit) 

$sql = "SELECT * FROM form ORDER BY date DESC LIMIT " . ($pageNum - 1) * $perPage . ", $perPage"; 
$res = mysql_query($sql, $conn) or die(mysql_error()); 

while ($row = mysql_fetch_object($res)) {          
echo '<hr></hr>';
print  $row->title ;
echo nl2br("\n");      
print strftime('%d %B %Y', $row->date); 
echo nl2br("\n");
echo nl2br("\n"); 
print $row->blog_mes;   

} 

// Some paginananananananation 

echo '<div>'; 
for ($i = 1; $i <= $numPages; $i++) 
{ 
    if ($pageNum != $i) 
    echo '<a href="index.php?id=', $i, '">', $i, '</a> '; 
    else  
    echo '<b>', $i, '</b>'; 
} 
echo '</div>'; 

?>

that displays numbers like so

1 2 3 4 5 etc

what i would like to do is to sort it by date ( month and year ), then input the month and year into a jump menu like so

jan 08
feb 08
mar 08
apr 08
may 08
june 08 etc,

then next year it will change to

jan 09
feb 09
mar 09 etc,

i still want to display the pagementation at the bottom ( as it is )

but a jump menu that will update itself whenever i post a new blog for that month, so if i miss a month, that month would not be included in the jump menu list

its just so i can always have links to each month posted ( easy access )

does anyone know enough about this to help please,

thanks

[saltedm8]

ok, seems like no-one is able to answer this for me, but i have managed to do this so far

PHP: Select all

 <?php include 'main.php';?>
       <?php $conn=mysql_connect("localhost","root","") or die(mysql_error());
      mysql_select_db("saltyblog") or die(mysql_error());

      $result=mysql_query(" SELECT * FROM form");
      $option="date";

      while($row=mysql_fetch_array($result))

      {
      $option .= "<option";
      if ($_POST['form']==$row['date']) {$option.= " selected='selected'";}
      $option .= ">" . $row['date'] . "</option>";
      }
      ?>

      <form method="post">

      <select>

      <?php echo $option; ?>
.
      </select><input type="submit" /></form>

a couple of problems though

first: Notice: Undefined index: form in C:\Program Files\EasyPHP 2.0b1\www\blog\index.php on line 204

second: it is displaying the date like so - 1201036656 ( needs also to be adjusted to show it by month and year - later )

can you help ?, attached is the image

cheers

[alexgeek]

What is line 204?

[JustinStudios]

Ok, looks like the problem you are having is sorting by and formatting date stamps. I'd recommend using this link php Dates to learn how to format the long number into a more readable date. Wherever you store the content, that is where you need to store the date as well. I'm assuming that you are using a MySQL database and I'd recommend adding a date column. You can then Sort by Date to get it to align them in that order. The drop down would be a simple select button with the options generated in a while loop (while there is a date, print it) and that should solve those issues.

If you need more info, or need some code let me know and I'll see what I can do.

[saltedm8]

Originally Posted by alexgeek

What is line 204?

PHP: Select all

if ($_POST['form']==$row['date']) {$option.= " selected='selected'";} 

JustinStudios

urrm, i am still pretty new to php, i can only do the basics, but give me five minutes and i will give you a link to the blog file so you can see everything for yourself

( link to full file blog download )

[alexgeek]

Maybe this?

PHP: Select all

      if (isset($_POST['form']) && $_POST['form'] == $row['date']) {$option.= " selected='selected'";} 

[saltedm8]

wow, thanks, error is gone -

just got to work out the date issue, oh and the submit button is not working, - its not taking me to the blog page

[alexgeek]

Check that you are telling to go to the right place in the form tag.
The date issue i think was explained above?

[JustinStudios]

Wow, I went to class and came back and found Alex fixed the bug, Yay Alex!

As far as the date goes the link above will take care of that. If you have any questions implementing it please post back. Also, I can't seem to download the blog file even in a download manager.

[saltedm8]

alexgeek - everything i tried either created errors, or had no effect

JustinStudios - i have removed tnymce from the file, and have managed to add it as an attachment ( it was too big originally )

[saltedm8]

i have tried everything to convert this date from unix, please help - all i would require is the month

[alexgeek]

Is it a mysql timestamp or a php one?

[saltedm8]

date table
date VARCHAR(25) NOT NULL,

how i recovered it last time
print strftime('%d %B %Y', $row->date);

[alexgeek]

Try:

PHP: Select all

date('F', $row->date); 

[saltedm8]

nope, sorry not working

[alexgeek]

What happens?

[saltedm8]

where did you want me to put it ? - i have tried all over, then i could tell you

[alexgeek]

Replace this for my code:

PHP: Select all

print strftime('%d %B %Y', $row->date); 

[saltedm8]

that code is what makes the date on each blog, it still is not changing in the drop down, still in unix

it was from here

PHP: Select all

<?php include 'config.php'; 

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); 
mysql_select_db( $dbname, $conn ); 

$perPage = 5; // number to display on per page 

// Start by counting the number of posts 

$res = mysql_query ("SELECT count(*) AS num FROM form") or die (mysql_error() . 'dying hurts'); 

$num = mysql_fetch_assoc($res); 
$num = $num['num']; 

mysql_free_result($res); 

// now work out how many pages there are, check if page has been sent via GET 

$numPages = ceil($num / $perPage); 

// Check to make sure pagenum will be 1 or greater, less than numpages and an actual number 
$pageNum  = (!empty($_GET['id']) &&  
             is_numeric($_GET['id']) &&  
             $_GET['id'] > 1)  
              
             ? ($_GET['id'] < $numPages ?  ($_GET['id']) : $numPages) : 1; // Set to 1 if not set or something dodgy 

// Okay, now we run the query and set the limits LIMIT xx, yy (x= start from , y= limit) 

$sql = "SELECT * FROM form ORDER BY date DESC LIMIT " . ($pageNum - 1) *