Time limit

[mindeekv]

Hi,
I have "form to sample.txt" script. If i send info in sample.txt looks:

aaaa:aaaaaa:aaaaa

Full sample.txt file (with 3 sended forms) looks:

bbbbb:bbbbb:bbbbb
aaaaa:aaaaa:aaaaa
ssssss:sssss:ssssss

How to make auto delete one form info (one line) after 30 days (1 month)?

Sample if i send form with bbbbb:bbbbb:bbbbb info 2009-01-10, that line auto deleted on 2009-02-01?

[dagon]

use a db, its a thousand times easier for maintaining such data.

[mindeekv]

Ok, i use db, how to make it on db?

[dagon]

http://www.freewebmasterhelp.com/tutorials/phpmysql there is a tutorial to start with

[wtg21_org]

you need put numbers for each row: count rows, put numbers, .....

first you need to make rows look like

1 => aaaa:aaaa:aaaa
2 => bbbb:bbbb:bbbb

after you process that array "testarray" ...

foreach ($testarray as $id => $your_data_in_rows)

then you can work with that array

example drop down menu SELECT CITY:
1 => "city1",
2 => "city2",
3 => "city3",
.......

$selectcity = "<select name=\"city\">";
foreach ($city as $id => $name)
	$selectcity .= "<option value=\"$id\">$name</option>";
$selectcity .= "</select>";
print($selectcity);

but as is written .... you better use database!!!

[wtg21_org]

get_elapsed_time(sql_timestamp_to_unix_timestamp($creationdate)) 

[wtg21_org]

function get_elapsed_time($ts) {
	global $lang_main;
  $mins = floor((time() - $ts) / 60);
  $hours = floor($mins / 60);
  $mins -= $hours * 60;
  $days = floor($hours / 24);
  $hours -= $days * 24;
  $weeks = floor($days / 7);
  $days -= $weeks * 7;
  $t = "";
  if ($weeks > 0)
    return "$weeks ".$lang_main['week_']."" . ($weeks > 1 ? "".$lang_main['week_2']."" : "".$lang_main['week_1']."");
  if ($days > 0)
    return "$days ".$lang_main['day_']."" . ($days > 1 ? "".$lang_main['day_2']."" : "".$lang_main['day_1']."");
  if ($hours > 0)
    return "$hours ".$lang_main['hour_']."" . ($hours > 1 ? "".$lang_main['hour_2']."" : "".$lang_main['hour_1']."");
  if ($mins > 0)
    return "$mins ".$lang_main['minute_']."" . ($mins > 1 ? "".$lang_main['minute_2']."" : "".$lang_main['minute_1']."");
  return "< 1 ".$lang_main['minute']."";
}

?>

[wtg21_org]

function sql_timestamp_to_unix_timestamp($s) {
  return mktime(substr($s, 11, 2), substr($s, 14, 2), substr($s, 17, 2), substr($s, 5, 2), substr($s, 8, 2), substr($s, 0, 4));
}

[djjjozsi]

if youu make it with database,
you can use datediff in sql to delete the "old" entries.

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_datediff