PHP/MySQL - unix timestamp converted to table

[Reiners]

Hi all!
I am trying to code a website with php4 which shows a table. the table should show a list of timestamps which are saved in unix timestamp format (like "1087368085") in a mysql database.
but how can i display those unix timestamps in "readable" timestamps (such as "15.05.04 5:30pm").
i got a sourcecode from the internet but dont know how to use it 🙂

link[/URL

so the question is: how to use this script? or is there maybe an better solution?

thx 4 help, sry 4 worse english 😉 !

edit: maybe its quite important for u to know: the database gets updatet every minute and i want to display every timestamp (after a refresh of the webpage)

if you dont understand something or need more details feel free to ask 🙂

[devinemke]

[man]date[/man]

[Reiners]

thx for your post 🙂 !!
but i just decided not to use a mysql database and to use only php for displaying the arp.dat content.
and i just dont get it (even with your link) to get those unix timestamps from the arp.dat - file in my table as a "normal" timestamp :glare:

plz help again :bemused:

[devinemke]

what do you mean "normal" timestamp? a UNIX timestamp is simply an integer (the number of seconds since 1970-01-01 00:00:00 GMT). the [man]date[/man] function converts that into any format you want. for example:

$current_timestamp = time();
$date = date('Y-m-d h:i:s', $current_timestamp);
echo 'the current time is ' . $date;

[Reiners]

well, in my arp.dat file is a unix timestamp like :
11091231
and i want to display this one in normal time in my table, like:
5:30 pm 21.11.04
(just for an example)

will try your code again but i dont think this will work if i put a timestamp into the current_timestamp variable, does it?

[devinemke]

Originally posted by Reiners
well, in my arp.dat file is a unix timestamp like :
11091231
and i want to display this one in normal time in my table, like:
5:30 pm 21.11.04
(just for an example)

that is precisely what the [man]date[/man] function is for

[Reiners]

okay thx!!!! i got it.
but now i want to include a searchoption and an order-option. the order - option is quite difficult for me because i dont know how to order it like this:

table not ordered:
2a 2b 2c 2d
3a 3b 3c 3d
1a 1b 1c 1d
4a 4b 4c 4d

table ordered:
1a 1b 1c 1d
2a 2b 2c 2d
3a 3b 3c 3d
4a 4b 4c 4d

but NOT like this (compare to "table not ordered" - i always order everything in line "a", but b,c und d want order like "a" too):
1a 2b 2c 2d
2a 3b 3c 3d
3a 1b 1c 1d
4a 4b 4c 4d

i really looked up through the internet, but didnt found exactly my problem. sry!! plz help again :glare:

edit: plz remember that i dont want to use MySQL or sth like this, only PHP!

[devinemke]

how/where is this data stored? in a database? in a text file?

[Reiners]

in a file called arp.dat (php can display the content in my table, i just want to include a button to order a,b,c and d.

[devinemke]

spool the file in to an array using [man]file[/man] then use [man]sort[/man]

[Reiners]

that's how the "arp.dat file" is looking like (for example):

0🅱b🅱b:b 192.168.1.2 1087368085 pc2
0🅰a🅰a:a 192.168.1.1 1095850759 pc1
0:c:c:c:c:c 192.168.1.3 1097679853 pc3
0:d:d:d:d:d 192.168.1.4 1096280091 pc4

(edit: one space = 4 space's ... the forum just dont display this)

that's how my script is looking like now:

echo '<table border="1" cellpadding="1" cellspacing="0" align="center">

 <!-- Head of my table -->
 <tr>
 <td><b><a href="index.php?order=NAME">Name</a></b></td>
 <td><b><a href="index.php?order=IP">IP-Adress</a></b></td>
 <td><b><a href="index.php?order=MAC">MAC-Adress</a></b></td>
 <td><b><a href="index.php?order=TIME">Time</a></b></td>
 </tr>';

// opening the file arp.dat

$fp = fopen('arp.dat', 'r');

 while (!feof($fp)) 
 {
   // get data
   $line = fgets($fp,1000);

   // devide data after "four space's"
   $data = explode("    ", $line);

   $timestamps = date('H:i:s - d.m.y', $data[2]);

   // display the row's in correct order
   echo "<tr><td>$data[3]</td>
   <td>$data[1]</td>
   <td>$data[0]</td>
   <td>$timestamps</td></tr>";
 }

// End of my table
echo '</table>';

// closing the file "arp.dat"
fclose($fp);

It actually works fine and displays the content of the arp.dat file in a nice table with the "human" timestamp and ordered like
Name|IP|MAC|Time
as you can see in my sourcecode. But now i want to order this table-content for example by "Name" by clicking on the table-headline "Name". Therefor I am sending a variable called "order" to same page. But now i dont know how to write the
if ($order == "NAME") - clause
which could order my table-content by "Name". But here it is very important (and thats what my last post with a,b,c,d should show) that the hole content gets ordered by clicking on the "Name-headline".
e.g.:
"pc1" has got the IP adress "192.168.1.1" which are both in the second line of the table!
by clicking on "Name", the table gets ordered and "pc1" moves to the first line. but with it, the IP-adress "192.168.1.1" has to move up to the first line too (!!) because this IP adress belongs to pc1 ! The same with "Mac-Adress" and "time".
I am sry that it's so complicated (well, for me 🙂) but plz give me an example for my sourecode how i could order it. by including the arp.dat-content into an array, it always want work or it just displays one single line of the content.
plz help (hope it is not to much work for you. if it is, just post it)
and sry again for my worse english :glare:

[Bunkermaster]

Originally posted by Reiners
[FONT=courier new]0🅱b🅱b:b    192.168.1.2    1087368085    pc2
0🅰a🅰a:a    192.168.1.1    1095850759    pc1
0:c:c:c:c:c    192.168.1.3    1097679853    pc3
0:d:d:d:d:d    192.168.1.4    1096280091    pc4[/FONT]

<table border="1" cellpadding="1" cellspacing="0" align="center">

 <!-- Head of my table -->
 <tr>
 <td><b><a href="index.php?order=NAME">Name</a></b></td>
 <td><b><a href="index.php?order=IP">IP-Adress</a></b></td>
 <td><b><a href="index.php?order=MAC">MAC-Adress</a></b></td>
 <td><b><a href="index.php?order=TIME">Time</a></b></td>
 </tr>
<?
// opening the file arp.dat

$fp = file('arp.dat');
foreach( $fp as $Myline ){
       list( $IP, $MACID , $timestamps , $name) = explode("    ", $Myline);

   $timestamps = date('H:i:s - d.m.y', $timestamps);

   // display the row's in correct order
   echo "<tr><td>$name</td>
   <td>$IP</td>
   <td>$MACID</td>
   <td>$timestamps</td></tr>";
}
?>
</table>

Try that on for size

[Reiners]

hm, i dont think i will get it with that on anyway ... your one doesnt make any big difference to mine, does it? well it works ... but still without a possibility to order my table ...

thx anyway ... will try again to get it on my own with your code, but would be great if anyone else could give me a final hint 🙂

[Bunkermaster]

ok, use the code above, load the data in 4 arrays indexed the same way then use [MAN]array_multisort[/MAN] with a switch on which array is the reference and sort your table.
then loop on a for( $i=0; $i < sizeof( $oneofyourarrays ; $i++ ) ) etc.

[Reiners]

ok thx so far.
will try to get it with your idea's on my own
😉

thx for help both of you 🙂

[Reiners]

omg, i am really sry ... but i really need your help. i just dont get it on my own.
i tried to do it as you said, Bunkermaster, but I dont understand the last part of your hint

then loop on a for( $i=0; $i < sizeof( $oneofyourarrays ; $i++ ) ) etc.

my script looks like this atm, but it just displayes the word "Array" in every line of my table:

list( $MAC, $IP , $timestamps , $name) = explode("	", $Myline);

   $timestamps = date('H:i:s - d.m.y --> vor x \M\i\n.', $timestamps);

   $ar = array (array ($IP), array ($MAC), array ($name), array ($timestamps));
   array_multisort ($ar[0], SORT_ASC,
                    $ar[1],
                    $ar[2],
                    $ar[3]);

  // creating the table-lines with ordered content
   echo "<tr><td>$ar[0]</td>
   <td>$ar[1]</td>
   <td>$ar[2]</td>
   <td>$ar[3]</td></tr>";

 }

I know that the last part is not ok, but i didnt know how to do it :glare: :glare:
what did I wrong? it actually should order it by IP-adress ($ar[0])

many many thx for help in advance

[Bunkermaster]

Originally posted by Reiners

list( $MAC, $IP , $timestamps , $name) = explode("	", $Myline);

   $timestamps = date('H:i:s - d.m.y --> vor x \M\i\n.', $timestamps);

   $ar = array (array ($IP), array ($MAC), array ($name), array ($timestamps));
   array_multisort ($ar[0], SORT_ASC,
                    $ar[1],
                    $ar[2],
                    $ar[3]);

  // creating the table-lines with ordered content
   echo "<tr><td>$ar[0]</td>
   <td>$ar[1]</td>
   <td>$ar[2]</td>
   <td>$ar[3]</td></tr>";

 }

[/B]

ok here is the thing, $ar[0] holds the array containing all the IP addresses. so to display the first IP you would have to go with $ar[0][0]. You probably need a loop on all 4 arrays to display their contents which brings us to...
The loop!

       echo "<tr><td>$ar[0][0]</td>
       <td>$ar[1][0]</td>
       <td>$ar[2][0]</td>
       <td>$ar[3][0]</td></tr>";

will display the first line. We need them all. So create a loop incrementing the 0 index.

Voila 🆒

[Reiners]

well there is something wrong!

$ar[0] holds the array containing all the IP addresses

that's right, but they are all at one piece like 123.23.456.678.123.234.546.56.123.13.6.67
and NOT like
123.23.456.678 123.234.546.56 123.13.6.67
that's what i can see if I try

echo $ar[0];

it just display one long row of numbers with points but not cut into ipadresses!

now if i use

echo $ar[0][0];

it just displayes:

Array[0]

my code looks like this now:

$fp = file('arp.dat');

foreach( $fp as $Myline ){
       list( $MAC, $IP , $timestamps , $name) = explode("	", $Myline);

   $timestamps = date('H:i:s - d.m.y --> vor x \M\i\n.', $timestamps);

   $ar = array (array ($IP), array ($MAC), array ($name), array ($timestamps));
   array_multisort ($ar[0], SORT_ASC,
                    $ar[1],
                    $ar[2],
                    $ar[3]);


   for ($i=0; $i < sizeof($ar[0]); $i++)
      {
      echo "<tr><td>$ar[1][$i]</td>
                <td>$ar[0][$i]</td>
                <td>$ar[3][$i]</td>
                <td>$ar[2][$i]</td></tr>";
      }

but in every table line is just

Array[0]

displayed.
So whats wrong? 😕
thx for help in advanced again
:bemused:

[Bunkermaster]

$fp = file('arp.dat'); 
$allMAC = array();
$allIP = array();
$allstamp = array();
$allname = array();

foreach( $fp as $Myline ){ 
       list( $MAC, $IP , $timestamps , $name) = explode("    ", $Myline); 
       $timestamps = date('H:i:s - d.m.y --> vor x Mi\n.', $timestamps); 
       $allMAC[] = $MAC;
       $allIP[] = $IP;
       $allstamp[] = $timestamps;
       $allname[] = $name;
}
       array_multisort ($allIP, SORT_ASC, 
                        $allname, 
                        $allMAC, 
                        $allstamp); 
       for ($i=0; $i < sizeof($ar[0]); $i++) 
          { 
          echo "<tr><td>$allIP[$i]</td> 
                    <td>$allname</td> 
                    <td>$allMAC</td> 
                    <td>$allstamp</td></tr>"; 
          }

or something close

[Reiners]

well what can i say ... it does not work. but i dont know why ... i changed it alot but it wont work ...
the script just displays nothing ...
thank you very much for trying to help any way! 😉

any body else an idea why bunkermaster's script does not work?