9999 Posted August 30, 2006 Share Posted August 30, 2006 Hi, I'm using a delimiteed text file as a database. It contains 4 fieds: $day, $month, $year, and $info. I have a search script that searches the $info field against keywords a user can input then displays the results SORTED by $year. Everything works fine except for any record that contains a $year value before 1970 (the epoch) it treats it as December 31, 1969 and wrecks my sort order. Given the following script, what can I do to fix this?[code]if($_REQUEST['usersearch'] == '1') // Display Keyword Search Results{ $file = file('data.txt'); $search = $_GET['search']; $file = file('data.txt'); $keys = preg_split('/[\s,]+/', preg_replace('/([^a-z0-9\s])/i', '', trim($search) ) ); if (sizeof($keys) > 5) { die("Please enter less keywords."); } else if (empty($keys[0])) { die("Please enter a valid keyword."); } $pattern = '/('. implode('|', $keys) .')/i'; $matches = array(); $matchcount = 0; foreach (array_values($file) AS $data) { list($month, $day, $year, $info) = explode('|', trim($data) ); if (preg_match($pattern, $info)) { $matches[strtotime("$day $month $year")][] = preg_replace($pattern, '<span style="color:red;">$1</span>', $info); $matchcount++; } } if (sizeof($matches) > 0) { ksort($matches); $count = 0; printf('<center><b><p>%d match%s found.</p></b></center>', $matchcount, $matchcount == 1 ? NULL : 'es'); foreach ($matches AS $days => $event) { foreach ($event AS $result) { list($month, $day, $year) = explode('-', date('F-j-Y', $days) ); $count++; echo '<b><font face="Times New Roman">' . $count . '--' . $month . ' ' . $day . ', ' . $year . '--' .'</font></b>'; echo '<font face="Times New Roman" size="2px">' . $result .'</font>'; echo "<p>"; if ($count >= 200) { break; } } if ($count >= 200) { break; } } printf('<center><b><p>%d match%s found.</p></b></center>', $matchcount, $matchcount == 1 ? NULL : 'es'); } else { echo '<p><center><b>No results were found for your search--Please try again.</b></center></p>'; }}[/code]Thanks in advance Quote Link to comment Share on other sites More sharing options...
9999 Posted August 30, 2006 Author Share Posted August 30, 2006 Is there a few lines of code that might make it recognize dates before 1970? Quote Link to comment Share on other sites More sharing options...
Barand Posted August 30, 2006 Share Posted August 30, 2006 try strtotime ("$year-$month-$day") Quote Link to comment Share on other sites More sharing options...
9999 Posted August 30, 2006 Author Share Posted August 30, 2006 That didn't work. It just changed all my values to two-thousand and something.This is the line from my above code that I am refering to:[code]$matches[strtotime("$day $month $year")][] = preg_replace($pattern, '<span style="color:red;">$1</span>', $info);[/code] Quote Link to comment Share on other sites More sharing options...
Barand Posted August 30, 2006 Share Posted August 30, 2006 I tried[code]echo date ('jS F, Y', strtotime ('1949-01-22'));[/code]and got --> 22nd January, 1949 Quote Link to comment Share on other sites More sharing options...
9999 Posted August 30, 2006 Author Share Posted August 30, 2006 Thanks, I am a newbie and have had help with my code. Given my code above, what changes would I make to make this work for me? Quote Link to comment Share on other sites More sharing options...
Barand Posted August 30, 2006 Share Posted August 30, 2006 What does your data look like?When you say day, month, year, is that1, January, 1969or 01, Jan, 69oror 1,1,1969and how are keywords input? Quote Link to comment Share on other sites More sharing options...
9999 Posted August 30, 2006 Author Share Posted August 30, 2006 I use F j Y format so todays date would looklike this: August 30, 2006 and the date you mentioned would look this this: January 1, 1969 Quote Link to comment Share on other sites More sharing options...
9999 Posted August 30, 2006 Author Share Posted August 30, 2006 This is the form where the keyword are inputted[code]<form action="search.php" method="get"> <input type="text" name="search" size="20"> <input type="hidden" name="usersearch" value="1"/> <input type="submit" value="Search"/></form>[/code] Quote Link to comment Share on other sites More sharing options...
Barand Posted August 30, 2006 Share Posted August 30, 2006 It worked as it was with with PHP5 as that supooerts dates pre 1970 but for version 4 I had to convert month names numbers for the sort, then back again for output[code]<?php$months = array ( 'January' => '01', 'February' => '02', 'March' => '03', 'April' => '04', 'May' => '05', 'June' => '06', 'July' => '07', 'August' => '08', 'September' => '09', 'October' => '10', 'November' => '11', 'December' => '12',);if($_REQUEST['usersearch'] == '1') // Display Keyword Search Results{# $file = file('data.txt'); $search = $_GET['search']; $file = file('data.txt'); $keys = preg_split('/[\s,]+/', preg_replace('/([^a-z0-9\s])/i', '', trim($search) ) ); if (sizeof($keys) > 5) { die("Please enter less keywords."); } else if (empty($keys[0])) { die("Please enter a valid keyword."); } $pattern = '/('. implode('|', $keys) .')/i'; $matches = array(); $matchcount = 0; foreach (array_values($file) AS $data) { list($month, $day, $year, $info) = explode('|', trim($data) ); if (preg_match($pattern, $info)) { $matches["$year {$months[$month]} $day"][] = preg_replace($pattern, '<span style="color:red;">$1</span>', $info); $matchcount++; } } if (sizeof($matches) > 0) { ksort($matches); $count = 0; printf('<center><b><p>%d match%s found.</p></b></center>', $matchcount, $matchcount == 1 ? NULL : 'es'); $months = array_flip($months); // flip array toconvert months back to names foreach ($matches AS $days => $event) { foreach ($event AS $result) { list($year, $month, $day ) = explode(' ', $days ); $month = $months[$month]; // convert back to month name $count++; echo '<b><font face="Times New Roman">' . $count . '--' . $month . ' ' . $day . ', ' . $year . '--' .'</font></b>'; echo '<font face="Times New Roman" size="2px">' . $result .'</font>'; echo "<p>"; if ($count >= 200) { break; } } if ($count >= 200) { break; } } printf('<center><b><p>%d match%s found.</p></b></center>', $matchcount, $matchcount == 1 ? NULL : 'es'); } else { echo '<p><center><b>No results were found for your search--Please try again.</b></center></p>'; }}?><form action="" method="get"> <input type="text" name="search" size="20"> <input type="hidden" name="usersearch" value="1"/> <input type="submit" value="Search"/></form>[/code] Quote Link to comment Share on other sites More sharing options...
9999 Posted August 31, 2006 Author Share Posted August 31, 2006 The output line:[code]echo '<b><font face="Times New Roman">' . $count . '--' . $month . ' ' . $day . ', ' . $year . '--' .'</font></b>';[/code]still shows, December 31, 1969 for all records that have a year value less than 1970. I am using PHP 4.3.11Do you think any other lines of code should be changed? How does changing the months affect the script? Quote Link to comment Share on other sites More sharing options...
Barand Posted August 31, 2006 Share Posted August 31, 2006 I've tested the amended script that I posted using v4 and v5 and it works with both; at least it does with this data in "data.txt"[pre]January|22|1984|Barand 1January|2|1949|Barand 2March|1|1980|Barand 3July|4|2006|Independence Day[/pre]Entering "ran" as search string gave[pre]1--January 2, 1949--Barand 22--March 1, 1980--Barand 33--January 22, 1984--Barand 1[/pre] Quote Link to comment Share on other sites More sharing options...
9999 Posted August 31, 2006 Author Share Posted August 31, 2006 Intersting. Let me double check everything I have snd I will get back with you.Thanks Quote Link to comment Share on other sites More sharing options...
9999 Posted August 31, 2006 Author Share Posted August 31, 2006 Thank you. It works well. I did not copy and paste very well - lol. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.