PHP - Filter For Todays Date And Sort By Name

ok so my problem is i need my data to be sorted by date which comes first.. how do i do it..can someone help me..if possible elaborate some codes? thxx..

so this is my program

Code: [Select]

<?
$b=$_GET['b'];
$m=$_GET['m'];
$y=$_GET['y'];

if  ($b <> '' && $m <> '' && $y <> '') {

$branch=$b;
$leavemonth=$m;
$leaveyear=$y;
}
else
{
$branch=$_POST['branch'];
$leavemonth=$_POST['leavemonth'];
$leaveyear=$_POST['leaveyear'];
}



$connection=mysql_connect("$server", "$username", "$password")
or die("Could not establish connection");
mysql_select_db($database_name, $connection)
or die ("Could not select database");


   
    $query="SELECT * from tblworkgroup";
    $result=mysql_query($query);?>


        &nbsp;&nbsp;Branch&nbsp;
        <select name="branch" >
<option value="all">ALL Branches</option>       
        <? while($row=mysql_fetch_array($result)) { ?>       
    <option value= "<?=$row['WorkGroupID']?>" <? if ($branch==$row['WorkGroupID']){ echo 'selected'; } ?> ><?=$row['WorkGroupName']?></option>
     <? } ?>
        </select>
           </td>
          </tr>
       <br><br><br>
  &nbsp;&nbsp;Month &nbsp;&nbsp;
<select name="leavemonth" >
<option value = "1" <? if ($leavemonth==1){ echo 'selected'; } ?>>January</option>
<option value = "2" <? if ($leavemonth==2){ echo 'selected'; } ?>>February</option>
<option value = "3" <? if ($leavemonth==3){ echo 'selected'; } ?>>March</option>
<option value = "4" <? if ($leavemonth==4){ echo 'selected'; } ?>>April</option>
<option value = "5" <? if ($leavemonth==5){ echo 'selected'; } ?>>May</option>
<option value = "6" <? if ($leavemonth==6){ echo 'selected'; } ?>>June</option>
<option value = "7" <? if ($leavemonth==7){ echo 'selected'; } ?>>July</option>
<option value = "8" <? if ($leavemonth==8){ echo 'selected'; } ?>>August</option>
<option value = "9" <? if ($leavemonth==9){ echo 'selected'; } ?>>September</option>
<option value = "10" <? if ($leavemonth==10){ echo 'selected'; } ?>>October</option>
<option value = "11" <? if ($leavemonth==11){ echo 'selected'; } ?>>November</option>
<option value = "12" <? if ($leavemonth==12){ echo 'selected'; } ?>>December</option>
</select>

&nbsp;&nbsp;
Year &nbsp;&nbsp;
<select name="leaveyear" >
<option value = "2010" <? if ($leaveyear==2010) { echo 'selected';} ?>>2010</option>
<option value = "2011" <? if ($leaveyear==2011) { echo 'selected';} ?>>2011</option>
<option value = "2012" <? if ($leaveyear==2012) { echo 'selected';} ?>>2012</option>
<option value = "2013" <? if ($leaveyear==2013) { echo 'selected';} ?>>2013</option>
<option value = "2014" <? if ($leaveyear==2014) { echo 'selected';} ?>>2014</option>
<option value = "2015" <? if ($leaveyear==2015) { echo 'selected';} ?>>2015</option>
<option value = "2016" <? if ($leaveyear==2016) { echo 'selected';} ?>>2016</option>
<option value = "2017" <? if ($leaveyear==2017) { echo 'selected';} ?>>2017</option>

</select>


  &nbsp;&nbsp;

<input type='submit' name='submit' value='Preview' Class="button" onclick='return validate()'>
   
   </div>

</form>


<br /><br />

<div id="box" valign="top">
                <h3>&nbsp;<strong>Leave Application Details</strong>&nbsp;&nbsp</h3>
<br><br>

                <table width="80%" align="center" >
<thead>
<tr>
<th width="700px" align="left">Name</a></th>
                           
<th width="800px" align="center"></a>Application Date</th>
                           
<th width="500x" align="right"></a>Reason</th>
</tr>
</thead>
<tbody>
<?
/*echo "branch:".$branch.'<br />';
echo "leavemonth:".$leavemonth.'<br />';
echo "leaveyear:".$leaveyear.'<br />';*/
//--------------------------------------------------
if ($leavemonth =='' ||  $leaveyear =='' || $branch == '') {
// one value missing, so don't display
}
else
{
// start display data
$branchtracker = '';

if ($branch=='all'){
$branch = '%';
}

$rs = mysql_query( " call vwleavereport('$leavemonth', '$leaveyear', $branch, 0);");
$query="SELECT *,
MONTH(tblleaveapplication.DateFrom) as DFMonth,
MONTH(tblleaveapplication.DateTo) as DTMonth,
YEAR(tblleaveapplication.DateFrom) as DFYear
FROM `tblleaveapplication`
LEFT JOIN `tblemployee`
ON tblleaveapplication.employeeid = tblemployee.id
WHERE WorkGroupID LIKE '".$branch."'
AND (
(MONTH(tblleaveapplication.DateFrom)=".$leavemonth." AND YEAR(tblleaveapplication.DateFrom)=".$leaveyear.")
OR
(MONTH(tblleaveapplication.DateTo)=".$leavemonth." AND YEAR(tblleaveapplication.DateFrom)=".$leaveyear.")
)
ORDER BY WorkGroupID
";

$result = mysql_query($query);
if ((mysql_num_rows($result))>0){
?>
<FORM name="printbutton" method="post" align="left" action="report_print.php" target="_blank">
<input type="hidden" name="leavemonth" value="<?php echo $leavemonth; ?>">
<input type="hidden" name="leaveyear" value="<?php echo $leaveyear; ?>">
<input type="hidden" name="branch" value="<?php echo $branch;?>">
<Input type = "Submit" Name = "Submit1" Class="button" VALUE = "Print Leave Details">
</form>
<?
while($row=mysql_fetch_array($result))
{
if ($branchtracker<>$row['WorkGroupID']){
echo '<tr><td colspan=4 style="background-color: #e8e8e8; font-weight: bold;">'.$row['WorkGroupID'].'</td></tr>';
$branchtracker = $row['WorkGroupID'];
}
echo '<tr>';
echo '<td>'.$row['EmployeeName'].'</td>';
echo '<td>'.$row['DateFrom'].'  -  '.$row['DateTo'].'</td>';
echo '<td>'.$row['Purpose'].'</td>';
echo '</tr>';
}
}
}
?>

Hello everyone,
This is my first post and i have a question that im sure is easy to answer, im a beginner in PHP and i know how to submit a form and so on into mysql, now my question is, for everything i submit i would like for it to organize by date just like www.WorldStarHipHop.com, but not sure on how to do it. Any Clue? how do i get each indivual form i submit to automatically appear with the correct date untop? and how do i make the date appear untop of each section? Thanks for your time!

Hey all,
I just joined this forum so thank you! I am a regular contributor over at CssCreator.com, but i got stuck at a php problem and so came here to seek some guidance from you folks!

I am working on a new site project at foliageoutdoors.com/newsite.
This site is a travel company that i work for and its got fixed departure tours to different destination. 1 destination can i have multiple departures (batch).
So i have split my table structure like this -
Destination
id, title, description, etc
Batch
id, destination_id, datefrom, dateto, charges, etc
Here is my problem :

When i go to a listing, I want to show all destinations with batches starting from tomorrow+.
I have written the sql queries, but they are not doing what i want. It would really help if someone can help me out with this! I want someone to look at the complete code, so please PM / reply me and i will share the file.

Code: [Select]
<?php
$todaysdate = date("Y-m-d H:i:s");
$category = $_GET['title'];
        $getcategory = "SELECT destination.*, batch.* FROM `destination` LEFT JOIN batch ON destination.id = batch.destination_id WHERE destination.category = '".$category."' GROUP BY batch.destination_id";
        $result = mysql_query($getcategory);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Foliage Outdoors.com | <?php echo $category; ?></title>
<link rel="stylesheet" href="http://<? echo $topsiteurl; ?>/css/structure.css" type="text/css"/>
<link rel="stylesheet" href="http://<? echo $topsiteurl; ?>/css/category.css" type="text/css"/>

</head>

<body>
<div id="maincontainer">
<div id="header">
<?php include_once($_SERVER['DOCUMENT_ROOT'].'/newsite/includes/header.php') ?>
        </div>
        <div id="bodycontainer">
       
<?
        while ($db_row = mysql_fetch_assoc($result)) {
$id = $db_row['id'];
$desc = $db_row['desc'];           
$siteurl = $_SERVER['SERVER_NAME'];
$title = $db_row['title'];
$url = $db_row['url'];
$photo = $db_row['photo'];

$highlights = $db_row['highlights'];
            echo("<div class='camp'><div class='title'><img src='http://".$topsiteurl.'/images/destinations/'.$photo.".jpg' class='Destination Images' alt = '".$photo."' />
<a href=http://".$topsiteurl.'/destinations/destinations.php?id='.$id.">".$title."</a></div>
<div class='description'>".$highlights."</div>");


$getbatch ="SELECT * FROM batch WHERE destination_id = ".$id." AND date_from > '".$todaysdate."'";
$result2 = mysql_query($getbatch);
echo ("<div class='dates'>Batch Dates:<br />");
while ($db_row=mysql_fetch_assoc($result2)){
$batchfrom = $db_row['date_from'];
$newDate = date("j-F-Y", strtotime($batchfrom));
$batchto = $db_row['date_to'];
$EndwDate = date("j-F-Y", strtotime($batchto));
$code = $db_row['code'];
$campfor = $db_row['campfor'];

$diff = abs(strtotime($EndwDate) - strtotime($newDate));
$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));

if ($newDate != '') {
echo ("".$newDate." - ".$EndwDate."||".$days."(days)<br />"); }
else {
echo ("<div>Sorry! There are no batches scheduled currently! Contact us for a custom tour</div>");
}};
       echo ("</div><div class='gallery'>Photo-Gallery | Video Gallery</div></div>");}
 
        mysql_close();
 ?>
 </div>
 </div>
</div>
</body>
</html>

Regards,
Mihir.

I'm trying to pull data from a mysql db. I've stored data on the mysql with the date/time property. So How can I pull the mysql data by date/time?

G'day again. I've been looking up the php function on sorting, and to be totally honest I have no idea on how to implement it into my existing script which looks at a directory/sub directories and displays images.

The files are named 2010-01.jpg, 2010-02.jpg etc (so another words yyyy-mm format)
Can anybody help me? The script work perfectly otherwise, just doesn't put things into an order. Below is the code:
<? 
$dir = "images";
$text = "images.txt";
$cols = 3;
$colswidth = 33;
$fh=fopen($text, "r"); 

while(!feof($fh)) 
{ 
  $temp = explode("|", $line); 
  $title[$temp[0]] = $temp[1];
  $line=fgets($fh); 
  unset($temp); 
} 

function ListFiles($dir) {

   if($dh = opendir($dir)) 
   {
        $last_cat = '';
        $files = Array();
        $inner_files = Array();
        while($file = readdir($dh)) 
        {
            if($file != "." && $file != ".." && $file[0] != '.') 
           {
                if(is_dir($dir . "/" . $file)) 
               {
                    $inner_files = ListFiles($dir . "/" . $file);
                    if(is_array($inner_files)) $files = array_merge($files, $inner_files); 
               } 
               else 
              {
                     array_push($files, $dir . "/" . $file);
               }
         }
    }
        closedir($dh);
        return $files;
    }
}

foreach (ListFiles($dir) as $key=>$file){

      if (preg_match("/.jpg/", $file)) {
                    if($last_cat != $category[$file] && $category[$file]<>"")
                    {
                           echo "<h2>$category[$file]</h2>";
                           $last_cat = $category[$file];
                    }

    if ($title[$file]<>"") { echo "<a href=\"$file\" rel=\"lightbox\" title=\"$title[$file]\"><img src=\"gallery-thumbs.php?file=$file\"></a> "; } else 
echo "<a href=\"$file\" rel=\"lightbox\"><img src=\"gallery-thumbs.php?file=$file\"></a> ";
} 
} 
  
?>

Hi, i have an issue to sort gallery photos by date. Right now its sort by Value (Name).   here is the code    index.php contains :  

<div>

	<?php foreach($categories_array as $photo_category=>$photos_array){?>
    
    	<?php 
		$category_thumbnail = $gallery_url."/layout/pixel.gif";
		if(file_exists('files/'.$photo_category.'/thumbnail.jpg')){
			$category_thumbnail = $gallery_url.'/'.$photo_category.'/thumbnail.jpg';
		}
		
		$category_url = $gallery_url.'/'.$photo_category;
		?>
        
  		<span class="category_thumbnail_span" style="width:<?php echo $settings_thumbnail_width;?>px; height:<?php echo $settings_thumbnail_height+20;?>px;">
        <a class="category_thumbnail_image" href="<?php echo $category_url;?>" style="width:<?php echo $settings_thumbnail_width;?>px; height:<?php echo $settings_thumbnail_height;?>px; background-image:url('<?php echo $gallery_url;?>/layout/lens_48x48.png');" title="<?php echo htmlentities(ucwords(str_replace('-', ' ', $photo_category)));?>">
        <img src="<?php echo $category_thumbnail;?>" width="<?php echo $settings_thumbnail_width;?>" height="<?php echo $settings_thumbnail_height;?>" alt="<?php echo htmlentities(ucwords(str_replace('-', ' ', $photo_category)));?>" />
        </a>
        <a class="category_thumbnail_title" href="<?php echo $category_url;?>" title="<?php echo htmlentities(ucwords(str_replace('-', ' ', $photo_category)));?>">
        <?php echo htmlentities(str_replace('-',' ', truncate_by_letters($photo_category, 16, '..')), ENT_QUOTES, "UTF-8");?> (<?php echo count($photos_array);?>)
        </a>
        </span>
    

	<?php } ?>

</div>

the sort function :

ksort($categories_array);

I am retrieving data using AJAX. I would like to sort them from newest to oldest date. Currently they show from oldest to newest.

How do I do that?

<div id="output"></div>
<script>
  $(document).ready(function(){
    $.ajax ({
      type: 'GET',
      url: "https://3rdpartywebsite.com/api/getcustomers",
      dataType: 'json',
      success: function(data) {
       $.each(data, function(i, v) {

         var customerId 		   = v.customerId;
         var firstName 			   = v.firstName;
         var lastName  			   = v.lastName;
         var createdDateTime 	   = v.createdDateTime;

          $('#output').append('<ul class="output-ul">' + '<li>' + customerId + '</li>' + '<li>' + firstName + '</li>' + '<li>' + lastName + '</li>' +   '<li>' + createdDateTime + '</li>' + '</ul>');
       });
      }
    });
  });
</script>

 

Hello I am using a DOMDocument to retrieve information from an XML file. The information is setup like so:

<person>
<name>John Smith</name>
<born>March 15th, 1987</born>
</person>
<person>
<name>Eric Lee</name>
<born>July 18th, 1949</born>
</person>
<person>
<name>Michael Arnold</name>
<born>April 2nd, 2003</born>
</person>

At the moment I am displaying just the names of each of these groups on the page. How would I display the names of each of these people according to when they were born? (Youngest to oldest or oldest to youngest)

I believe it has something to do with strtotime() and sort() but can someone explain or give an example?

Hello,

I'm making a imagegallery and when someone upload a new image that image has to appear as first picture of the gallery.
I'm using an array for the files, but how can I sort the files on date, newest first.?

<?php
$n = 0;
$pathToThumbs = "images/tekeningen/";
$dir = opendir( $pathToThumbs );
while (false !== ($fname = readdir($dir))){
      
      // strip the . and .. entries out
     if ($fname != '.' && $fname != '..'){
     $tekeningen[$n] = $fname;
    } echo $tekeningen[$n]."<br />"; 
     $n = $n +1;
}
   closedir( $dir );
?>


I found solutions with ksort and filemtime, but I don't understand them and/or they didn't work for me.

Hi,
I've done a search and cant find anything related to my problem.
I have a newsfeed on my site and i want it to display with the latest news at the top.
I have this code:
Code: [Select]
$get_news = "SELECT title, text, DATE_FORMAT(datetime, '%e %b %Y at %T') AS datetime FROM newsfeed ORDER BY datetime DESC";
This works fine on one of my sites but on another i've just hit a problem. It seems to sort only by the day, not the rest of the date.
I made a news post today with date and time of "27 Mar 2011 at 12:54:02" but a post from "28 Jan 2011 at 19:59:52" is above it.

Any ideas why this is happening?

Thanks,
Alex

Hello all!   I have this array of objects:

Array
(
    [0] => stdClass Object
        (
            [first_name] => test
            [last_name] => test
            [title] => test
            [id] => 34
            [type] => 4
            [manager] => 4
            [email] => p@yahoo.com
            [date] => 2014-09-21 07:23:12
            [status] => 2
            [approval_date] => 2014-09-21 07:31:10
            [assessment_id] => 1
            [supervisor_approval] => 1
            [manager_approval_date] => 2014-09-21 07:31:27
            [mainmanger] => 3
        )

    [1] => stdClass Object
        (
            [first_name] => test
            [last_name] => test
            [title] => test
            [id] => 34
            [type] => 4
            [manager] => 4
            [email] => p@yahoo.com
            [date] => 2014-09-20 07:39:55
            [status] => 2
            [approval_date] => 2014-09-20 07:40:41
            [assessment_id] => 3
            [supervisor_approval] => 1
            [manager_approval_date] => 2014-09-20 07:41:07
            [mainmanger] => 3
        )

    [2] => stdClass Object
        (
            [first_name] => jimmy john john
            [last_name] => john
            [title] => Lorad and Master
            [id] => 32
            [type] => 4
            [manager] => 3
            [email] => j@j.com
            [date] => 2014-09-21 07:38:50
            [status] => 2
            [approval_date] => 2014-09-19 07:39:25
            [assessment_id] => 2
            [supervisor_approval] => 1
            [manager_approval_date] => 2014-09-19 07:39:25
            [mainmanger] => 0
        )

)

Where "id" = the user ID.    If there are two or more entries for a user, I want to remove all but the most recent by the "approval_date",... So for the above example it would return:

Array
(
    [0] => stdClass Object
        (
            [first_name] => test
            [last_name] => test
            [title] => test
            [id] => 34
            [type] => 4
            [manager] => 4
            [email] => piznac@yahoo.com
            [date] => 2014-09-21 07:23:12
            [status] => 2
            [approval_date] => 2014-09-21 07:31:10
            [assessment_id] => 1
            [supervisor_approval] => 1
            [manager_approval_date] => 2014-09-21 07:31:27
            [mainmanger] => 3
        )

    [1] => stdClass Object
        (
            [first_name] => jimmy john john
            [last_name] => john
            [title] => Lorad and Master
            [id] => 32
            [type] => 4
            [manager] => 3
            [email] => j@j.com
            [date] => 2014-09-21 07:38:50
            [status] => 2
            [approval_date] => 2014-09-19 07:39:25
            [assessment_id] => 2
            [supervisor_approval] => 1
            [manager_approval_date] => 2014-09-19 07:39:25
            [mainmanger] => 0
        )

)

I'm having a hard time wrapping my head around this concept, so I don't have any example code. And I don't really need or expect someone to code this for me,. just a push in the right direction would be awesome.

Hi All

i am wanting a column list like this

http://extensions.joomla.org/extensions

basically the database is set up as
(id, category, parent)

I want the parent to group the category section and list like the the joomla example in three columns

search various threads throughout the internet but none seem to cover this entirely

can any one please help?????

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=330163.0

Hey,

I'm using a script which allows you to click on a calendar to select the date to submit to the database.

The date is submitted like this: 2014-02-08

Is there a really simple way to prevent rows showing if the date is in the past?

Something like this:
if($currentdate < 2014-02-08 || $currentdate == 2014-02-08) {

}

Thanks very much,
Jack

Hello. I'm new to pHp and I would like to know how to get my $date_posted to read as March 12, 2012, instead of 2012-12-03.
Here is the code:
Code: [Select]
<?php

$sql = " SELECT id, title, date_posted, summary FROM blog_posts ORDER BY date_posted ASC LIMIT 10 ";

$result = mysql_query($sql);

while($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$title = $row['title'];
$date_posted = $row['date_posted'];
$summary = $row['summary'];

echo "<h3>$title</h3>\n";
echo "<p>$date_posted</p>\n";
echo "<p>$summary</p>\n";
echo "<p><a href=\"post.php?id=$id\" title=\"Read More\">Read More...</a></p>\n";
}

?>
I have tried the date() function but it always updates with the current time & date so I'm a little confused on how I get this to work.