Forums

I need to take data from the database and display it in a list that if based on a search/filter box.
then I need to display the data VERY specifically and HOPEFULLY have a button they can push that will copy the data to the clipboard.
This shows a typical data return
D7170 C2016 05 06.07433 08 38 24.05 +46 51 03.5 16.1 R H45 D7170 C2016 05 06.07517 08 38 24.37 +46 51 03.2 16.1 R H45 D7170 C2016 05 06.07633 08 38 24.81 +46 51 03.1 16.3 R H45 D7170 C2016 05 06.07708 08 38 25.08 +46 51 02.8 16.1 R H45 D7170 C2016 05 06.07798 08 38 25.41 +46 51 02.4 16.2 R H45 D7170 C2016 05 06.07891 08 38 25.77 +46 51 02.1 16.2 R H45 O8590 C2016 05 06.07976 08 13 20.63 +62 47 47.5 18.3 R H45 O8590 C2016 05 06.08055 08 13 20.93 +62 47 49.4 18.4 R H45 O8590 C2016 05 06.08129 08 13 21.21 +62 47 51.7 18.5 R H45 O8590 C2016 05 06.08205 08 13 21.57 +62 47 54.6 18.3 R H45 O8590 C2016 05 06.08312 08 13 22.22 +62 47 57.6 18.4 R H45 O8590 C2016 05 06.08413 08 13 22.64 +62 47 59.6 18.2 R H45 B5916 C2016 05 06.08508 08 17 02.10 +31 39 33.7 17.2 R H45 B5916 C2016 05 06.08612 08 17 02.29 +31 39 33.6 17.3 R H45 B5916 C2016 05 06.08782 08 17 02.64 +31 39 33.2 17.2 R H45 B5916 C2016 05 06.08918 08 17 02.90 +31 39 33.0 17.2 R H45 B5916 C2016 05 06.09033 08 17 03.14 +31 39 32.7 17.4 R H45 B5916 C2016 05 06.09166 08 17 03.39 +31 39 32.7 17.4 R H45 K13W45T C2016 05 06.09353 09 48 53.64 +07 50 09.3 19.1 R H45 K13W45T C2016 05 06.09585 09 48 55.00 +07 49 53.0 19.1 R H45 K13W45T C2016 05 06.09839 09 48 56.65 +07 49 32.2 19.2 R H45 K13W45T C2016 05 06.09927 09 48 57.19 +07 49 26.1 19.3 R H45 K13W45T C2016 05 06.10017 09 48 57.78 +07 49 18.3 19.2 R H45 K13W45T C2016 05 06.10112 09 48 58.31 +07 49 11.8 19.0 R H45 K03K02O C2016 05 06.10245 10 33 40.82 +28 49 59.3 18.3 R H45 K03K02O C2016 05 06.10330 10 33 41.22 +28 50 01.1 18.2 R H45 K03K02O C2016 05 06.10414 10 33 41.66 +28 50 03.0 18.4 R H45 K03K02O C2016 05 06.10483 10 33 42.00 +28 50 04.2 18.4 R H45 K03K02O C2016 05 06.10567 10 33 42.37 +28 50 05.9 18.4 R H45 K03K02O C2016 05 06.10663 10 33 42.85 +28 50 07.6 18.4 R H45 K03K02O C2016 05 06.10754 10 33 43.28 +28 50 09.0 18.5 R H45 K03K02O C2016 05 06.10842 10 33 43.68 +28 50 10.6 18.5 R H45 K09D46L C2016 05 06.10997 10 45 49.18 +57 31 14.0 18.7 R H45 K09D46L C2016 05 06.11091 10 45 49.29 +57 31 12.5 18.8 R H45 K09D46L C2016 05 06.11210 10 45 49.50 +57 31 10.6 18.8 R H45 K09D46L C2016 05 06.11332 10 45 49.60 +57 31 08.2 18.7 R H45 K09D46L C2016 05 06.11430 10 45 49.82 +57 31 06.3 18.7 R H45 K09D46L C2016 05 06.11517 10 45 49.93 +57 31 05.0 19.0 R H45 K09D46L C2016 05 06.11614 10 45 50.06 +57 31 03.5 19.0 R H45 K09D46L C2016 05 06.11724 10 45 50.18 +57 31 01.1 18.8 R H45 K16EF6E C2016 05 06.11815 10 20 47.28 +59 47 57.6 19.8 R H45 K16EF6E C2016 05 06.12001 10 20 46.78 +59 47 58.3 19.6 R H45 K16EF6E C2016 05 06.12155 10 20 46.50 +59 47 58.7 19.9 R H45 K16EF6E C2016 05 06.12268 10 20 46.16 +59 47 58.9 19.8 R H45 K16EF6E C2016 05 06.12393 10 20 45.94 +59 47 59.2 19.8 R H45 K16EF6E C2016 05 06.12527 10 20 45.62 +59 47 59.5 19.7 R H45 K15TE3X C2016 05 06.12658 10 46 20.41 +35 28 08.8 19.5 R H45 K15TE3X C2016 05 06.12784 10 46 21.11 +35 28 04.2 19.7 R H45 K15TE3X C2016 05 06.12888 10 46 21.60 +35 28 00.7 19.7 R H45 K15TE3X C2016 05 06.12998 10 46 22.18 +35 27 57.0 19.8 R H45 K15TE3X C2016 05 06.13102 10 46 22.74 +35 27 53.7 19.7 R H45 K15TE3X C2016 05 06.13201 10 46 23.26 +35 27 50.4 19.7 R H45 23187 C2016 05 06.13363 10 40 15.54 +56 18 13.8 18.5 R H45 23187 C2016 05 06.13476 10 40 15.73 +56 18 13.4 18.6 R H45 23187 C2016 05 06.13578 10 40 15.94 +56 18 12.7 18.4 R H45 23187 C2016 05 06.13678 10 40 16.10 +56 18 12.2 18.3 R H45 23187 C2016 05 06.13869 10 40 16.46 +56 18 10.9 18.5 R H45 23187 C2016 05 06.13988 10 40 16.67 +56 18 10.2 18.5 R H45 K16G02S C2016 05 06.37371 14 32 10.04 +10 09 30.9 18.0 R H45 K16G02S C2016 05 06.37472 14 32 10.02 +10 09 33.7 18.1 R H45 K16G02S C2016 05 06.37556 14 32 09.97 +10 09 36.3 18.0 R H45 K16G02S C2016 05 06.37639 14 32 09.90 +10 09 39.1 18.0 R H45 K16G02S C2016 05 06.37714 14 32 09.85 +10 09 41.3 18.1 R H45 K16G02S C2016 05 06.37811 14 32 09.80 +10 09 43.9 18.0 R H45 K05J46C C2016 05 06.37896 15 20 52.84 +22 44 17.0 18.7 R H45 K05J46C C2016 05 06.37982 15 20 52.74 +22 44 16.1 18.6 R H45 K05J46C C2016 05 06.38083 15 20 52.64 +22 44 15.2 18.7 R H45 K05J46C C2016 05 06.38183 15 20 52.52 +22 44 14.3 18.8 R H45 K05J46C C2016 05 06.38274 15 20 52.43 +22 44 13.4 18.8 R H45 K05J46C C2016 05 06.38373 15 20 52.29 +22 44 12.6 18.6 R H45 K16B13U C2016 05 06.38580 16 39 39.91 -08 05 18.1 16.7 R H45 K16B13U C2016 05 06.38695 16 39 39.86 -08 05 09.4 16.8 R H45 K16B13U C2016 05 06.38785 16 39 39.81 -08 05 02.6 16.8 R H45 K16B13U C2016 05 06.38877 16 39 39.77 -08 04 55.5 16.8 R H45 K16B13U C2016 05 06.38967 16 39 39.73 -08 04 48.5 16.8 R H45 K16B13U C2016 05 06.39041 16 39 39.68 -08 04 43.0 16.9 R H45 K16E86P C2016 05 06.39175 16 34 23.30 -01 30 32.1 19.4 R H45 K16E86P C2016 05 06.39322 16 34 23.47 -01 30 31.5 19.4 R H45 K16E86P C2016 05 06.39422 16 34 23.54 -01 30 31.3 19.2 R H45 K16E86P C2016 05 06.39504 16 34 23.61 -01 30 31.2 19.2 R H45 K16E86P C2016 05 06.39695 16 34 23.77 -01 30 30.1 19.4 R H45 K16E86P C2016 05 06.39795 16 34 23.92 -01 30 29.8 19.3 R H45 K16H00M C2016 05 06.39936 16 03 36.48 +46 14 02.2 20.0 R H45 K16H00M C2016 05 06.40075 16 03 36.11 +46 13 57.7 20.1 R H45 K16H00M C2016 05 06.40182 16 03 35.75 +46 13 54.1 19.9 R H45 K16H00M C2016 05 06.40276 16 03 35.43 +46 13 51.0 20.0 R H45 K16H00M C2016 05 06.40384 16 03 35.00 +46 13 46.4 19.9 R H45 K16H00M C2016 05 06.40487 16 03 34.75 +46 13 42.9 19.9 R H45 K11O24P C2016 05 06.40606 16 17 03.53 +48 23 35.9 19.9 R H45 K11O24P C2016 05 06.40716 16 17 03.12 +48 23 32.4 19.8 R H45 K11O24P C2016 05 06.40845 16 17 02.61 +48 23 28.5 19.8 R H45 K11O24P C2016 05 06.40943 16 17 02.25 +48 23 24.5 19.9 R H45 K11O24P C2016 05 06.41049 16 17 01.87 +48 23 21.9 19.7 R H45 K11O24P C2016 05 06.41165 16 17 01.43 +48 23 18.0 19.6 R H45 K16H19D C2016 05 06.41271 16 13 17.41 +38 00 32.1 19.3 R H45 K16H19D C2016 05 06.41385 16 13 17.19 +38 00 34.2 19.5 R H45 K16H19D C2016 05 06.41491 16 13 17.00 +38 00 35.8 19.4 R H45 K16H19D C2016 05 06.41613 16 13 16.67 +38 00 39.1 19.5 R H45 K16H19D C2016 05 06.41732 16 13 16.46 +38 00 41.1 19.4 R H45 K16H19D C2016 05 06.41845 16 13 16.17 +38 00 43.9 19.4 R H45 K16B14Z C2016 05 06.42087 18 34 59.46 +63 21 55.2 19.3 R H45 K16B14Z C2016 05 06.42201 18 34 59.26 +63 21 53.2 19.3 R H45 K16B14Z C2016 05 06.42311 18 34 58.98 +63 21 51.9 19.5 R H45 K16B14Z C2016 05 06.42428 18 34 58.71 +63 21 49.4 19.6 R H45 K16B14Z C2016 05 06.42538 18 34 58.50 +63 21 48.0 19.4 R H45 K16B14Z C2016 05 06.42651 18 34 58.30 +63 21 45.8 19.5 R H45 K10N01W C2016 05 06.42840 18 24 51.15 +56 27 36.5 19.2 R H45 K10N01W C2016 05 06.42972 18 24 51.31 +56 27 37.6 19.2 R H45 K10N01W C2016 05 06.43071 18 24 51.45 +56 27 38.2 19.3 R H45 K10N01W C2016 05 06.43167 18 24 51.45 +56 27 38.7 19.3 R H45 K10N01W C2016 05 06.43276 18 24 51.65 +56 27 39.1 19.1 R H45
so, I think the display would be something like [code]
<div class="well">
<pre>D7170 C2016 05 06.07433 08 38 24.05 +46 51 03.5 16.1 R H45
D7170 C2016 05 06.07517 08 38 24.37 +46 51 03.2 16.1 R H45
D7170 C2016 05 06.07633 08 38 24.81 +46 51 03.1 16.3 R H45
D7170 C2016 05 06.07708 08 38 25.08 +46 51 02.8 16.1 R H45
D7170 C2016 05 06.07798 08 38 25.41 +46 51 02.4 16.2 R H45
D7170 C2016 05 06.07891 08 38 25.77 +46 51 02.1 16.2 R H45
O8590 C2016 05 06.07976 08 13 20.63 +62 47 47.5 18.3 R H45
O8590 C2016 05 06.08055 08 13 20.93 +62 47 49.4 18.4 R H45
O8590 C2016 05 06.08129 08 13 21.21 +62 47 51.7 18.5 R H45
O8590 C2016 05 06.08205 08 13 21.57 +62 47 54.6 18.3 R H45
O8590 C2016 05 06.08312 08 13 22.22 +62 47 57.6 18.4 R H45
O8590 C2016 05 06.08413 08 13 22.64 +62 47 59.6 18.2 R H45
B5916 C2016 05 06.08508 08 17 02.10 +31 39 33.7 17.2 R H45
B5916 C2016 05 06.08612 08 17 02.29 +31 39 33.6 17.3 R H45
B5916 C2016 05 06.08782 08 17 02.64 +31 39 33.2 17.2 R H45
B5916 C2016 05 06.08918 08 17 02.90 +31 39 33.0 17.2 R H45
B5916 C2016 05 06.09033 08 17 03.14 +31 39 32.7 17.4 R H45
B5916 C2016 05 06.09166 08 17 03.39 +31 39 32.7 17.4 R H45
K13W45T C2016 05 06.09353 09 48 53.64 +07 50 09.3 19.1 R H45
K13W45T C2016 05 06.09585 09 48 55.00 +07 49 53.0 19.1 R H45
K13W45T C2016 05 06.09839 09 48 56.65 +07 49 32.2 19.2 R H45
K13W45T C2016 05 06.09927 09 48 57.19 +07 49 26.1 19.3 R H45
K13W45T C2016 05 06.10017 09 48 57.78 +07 49 18.3 19.2 R H45
K13W45T C2016 05 06.10112 09 48 58.31 +07 49 11.8 19.0 R H45
K03K02O C2016 05 06.10245 10 33 40.82 +28 49 59.3 18.3 R H45
K03K02O C2016 05 06.10330 10 33 41.22 +28 50 01.1 18.2 R H45
K03K02O C2016 05 06.10414 10 33 41.66 +28 50 03.0 18.4 R H45
K03K02O C2016 05 06.10483 10 33 42.00 +28 50 04.2 18.4 R H45
K03K02O C2016 05 06.10567 10 33 42.37 +28 50 05.9 18.4 R H45
K03K02O C2016 05 06.10663 10 33 42.85 +28 50 07.6 18.4 R H45
K03K02O C2016 05 06.10754 10 33 43.28 +28 50 09.0 18.5 R H45
K03K02O C2016 05 06.10842 10 33 43.68 +28 50 10.6 18.5 R H45
K09D46L C2016 05 06.10997 10 45 49.18 +57 31 14.0 18.7 R H45
K09D46L C2016 05 06.11091 10 45 49.29 +57 31 12.5 18.8 R H45
K09D46L C2016 05 06.11210 10 45 49.50 +57 31 10.6 18.8 R H45
K09D46L C2016 05 06.11332 10 45 49.60 +57 31 08.2 18.7 R H45
K09D46L C2016 05 06.11430 10 45 49.82 +57 31 06.3 18.7 R H45
K09D46L C2016 05 06.11517 10 45 49.93 +57 31 05.0 19.0 R H45
K09D46L C2016 05 06.11614 10 45 50.06 +57 31 03.5 19.0 R H45
K09D46L C2016 05 06.11724 10 45 50.18 +57 31 01.1 18.8 R H45
K16EF6E C2016 05 06.11815 10 20 47.28 +59 47 57.6 19.8 R H45
K16EF6E C2016 05 06.12001 10 20 46.78 +59 47 58.3 19.6 R H45
K16EF6E C2016 05 06.12155 10 20 46.50 +59 47 58.7 19.9 R H45
K16EF6E C2016 05 06.12268 10 20 46.16 +59 47 58.9 19.8 R H45
K16EF6E C2016 05 06.12393 10 20 45.94 +59 47 59.2 19.8 R H45
K16EF6E C2016 05 06.12527 10 20 45.62 +59 47 59.5 19.7 R H45
K15TE3X C2016 05 06.12658 10 46 20.41 +35 28 08.8 19.5 R H45
K15TE3X C2016 05 06.12784 10 46 21.11 +35 28 04.2 19.7 R H45
K15TE3X C2016 05 06.12888 10 46 21.60 +35 28 00.7 19.7 R H45
K15TE3X C2016 05 06.12998 10 46 22.18 +35 27 57.0 19.8 R H45
K15TE3X C2016 05 06.13102 10 46 22.74 +35 27 53.7 19.7 R H45
K15TE3X C2016 05 06.13201 10 46 23.26 +35 27 50.4 19.7 R H45
23187 C2016 05 06.13363 10 40 15.54 +56 18 13.8 18.5 R H45
23187 C2016 05 06.13476 10 40 15.73 +56 18 13.4 18.6 R H45
23187 C2016 05 06.13578 10 40 15.94 +56 18 12.7 18.4 R H45
23187 C2016 05 06.13678 10 40 16.10 +56 18 12.2 18.3 R H45
23187 C2016 05 06.13869 10 40 16.46 +56 18 10.9 18.5 R H45
23187 C2016 05 06.13988 10 40 16.67 +56 18 10.2 18.5 R H45
K16G02S C2016 05 06.37371 14 32 10.04 +10 09 30.9 18.0 R H45
K16G02S C2016 05 06.37472 14 32 10.02 +10 09 33.7 18.1 R H45
K16G02S C2016 05 06.37556 14 32 09.97 +10 09 36.3 18.0 R H45
K16G02S C2016 05 06.37639 14 32 09.90 +10 09 39.1 18.0 R H45
K16G02S C2016 05 06.37714 14 32 09.85 +10 09 41.3 18.1 R H45
K16G02S C2016 05 06.37811 14 32 09.80 +10 09 43.9 18.0 R H45
K05J46C C2016 05 06.37896 15 20 52.84 +22 44 17.0 18.7 R H45
K05J46C C2016 05 06.37982 15 20 52.74 +22 44 16.1 18.6 R H45
K05J46C C2016 05 06.38083 15 20 52.64 +22 44 15.2 18.7 R H45
K05J46C C2016 05 06.38183 15 20 52.52 +22 44 14.3 18.8 R H45
K05J46C C2016 05 06.38274 15 20 52.43 +22 44 13.4 18.8 R H45
K05J46C C2016 05 06.38373 15 20 52.29 +22 44 12.6 18.6 R H45
K16B13U C2016 05 06.38580 16 39 39.91 -08 05 18.1 16.7 R H45
K16B13U C2016 05 06.38695 16 39 39.86 -08 05 09.4 16.8 R H45
K16B13U C2016 05 06.38785 16 39 39.81 -08 05 02.6 16.8 R H45
K16B13U C2016 05 06.38877 16 39 39.77 -08 04 55.5 16.8 R H45
K16B13U C2016 05 06.38967 16 39 39.73 -08 04 48.5 16.8 R H45
K16B13U C2016 05 06.39041 16 39 39.68 -08 04 43.0 16.9 R H45
K16E86P C2016 05 06.39175 16 34 23.30 -01 30 32.1 19.4 R H45
K16E86P C2016 05 06.39322 16 34 23.47 -01 30 31.5 19.4 R H45
K16E86P C2016 05 06.39422 16 34 23.54 -01 30 31.3 19.2 R H45
K16E86P C2016 05 06.39504 16 34 23.61 -01 30 31.2 19.2 R H45
K16E86P C2016 05 06.39695 16 34 23.77 -01 30 30.1 19.4 R H45
K16E86P C2016 05 06.39795 16 34 23.92 -01 30 29.8 19.3 R H45
K16H00M C2016 05 06.39936 16 03 36.48 +46 14 02.2 20.0 R H45
K16H00M C2016 05 06.40075 16 03 36.11 +46 13 57.7 20.1 R H45
K16H00M C2016 05 06.40182 16 03 35.75 +46 13 54.1 19.9 R H45
K16H00M C2016 05 06.40276 16 03 35.43 +46 13 51.0 20.0 R H45
K16H00M C2016 05 06.40384 16 03 35.00 +46 13 46.4 19.9 R H45
K16H00M C2016 05 06.40487 16 03 34.75 +46 13 42.9 19.9 R H45
K11O24P C2016 05 06.40606 16 17 03.53 +48 23 35.9 19.9 R H45
K11O24P C2016 05 06.40716 16 17 03.12 +48 23 32.4 19.8 R H45
K11O24P C2016 05 06.40845 16 17 02.61 +48 23 28.5 19.8 R H45
K11O24P C2016 05 06.40943 16 17 02.25 +48 23 24.5 19.9 R H45
K11O24P C2016 05 06.41049 16 17 01.87 +48 23 21.9 19.7 R H45
K11O24P C2016 05 06.41165 16 17 01.43 +48 23 18.0 19.6 R H45
K16H19D C2016 05 06.41271 16 13 17.41 +38 00 32.1 19.3 R H45
K16H19D C2016 05 06.41385 16 13 17.19 +38 00 34.2 19.5 R H45
K16H19D C2016 05 06.41491 16 13 17.00 +38 00 35.8 19.4 R H45
K16H19D C2016 05 06.41613 16 13 16.67 +38 00 39.1 19.5 R H45
K16H19D C2016 05 06.41732 16 13 16.46 +38 00 41.1 19.4 R H45
K16H19D C2016 05 06.41845 16 13 16.17 +38 00 43.9 19.4 R H45
K16B14Z C2016 05 06.42087 18 34 59.46 +63 21 55.2 19.3 R H45
K16B14Z C2016 05 06.42201 18 34 59.26 +63 21 53.2 19.3 R H45
K16B14Z C2016 05 06.42311 18 34 58.98 +63 21 51.9 19.5 R H45
K16B14Z C2016 05 06.42428 18 34 58.71 +63 21 49.4 19.6 R H45
K16B14Z C2016 05 06.42538 18 34 58.50 +63 21 48.0 19.4 R H45
K16B14Z C2016 05 06.42651 18 34 58.30 +63 21 45.8 19.5 R H45
K10N01W C2016 05 06.42840 18 24 51.15 +56 27 36.5 19.2 R H45
K10N01W C2016 05 06.42972 18 24 51.31 +56 27 37.6 19.2 R H45
K10N01W C2016 05 06.43071 18 24 51.45 +56 27 38.2 19.3 R H45
K10N01W C2016 05 06.43167 18 24 51.45 +56 27 38.7 19.3 R H45
K10N01W C2016 05 06.43276 18 24 51.65 +56 27 39.1 19.1 R H45
</pre></div>
the search box needs to be simliar to only we can use calendar and time instead.
Then lastly at the bottom of the displayed view I need to add a field from the user->plugin->parameter.

Hi Bear,

Given the previous post you have this data in a database table. Seeing this post I might be inclined to parse it before saving (you can also include a column with the complete string). Parsing would make the filtering and searching simpler as you can save e,g the date as tyel DATE or DATETIME and use the MySQL functions to filter a time period.

I'd probably use ChronoConnectivity for this as it is designed to display, sort and filter list of database records.

Bob

yeah, I just read about chronoconnectivity a tiny bit so I'm sure thats what I need...
but they will enter the search criteria each run time. If it helps/matters, I can get the date from the entry ( its coded in ) &/or I can convert their weird date to a precision datetime(5) if really needed though by the entry form I"m shown that exact is not needed...
using one of the examples above

K16B14Z C2016 05 06.42311 18 34 58.98 +63 21 51.9 19.5 R H45

the date would be

2016 05 06 as in May 6th 2016

So, i know I'd have to use $date = intval(substr($seed, begin,end) ); to fetch out the date.. I THINK...

This is how I pull the data from a single entry
function decimal_to_time($time, $precision = '5') { $DoW = sprintf("%02d", $time); $time = $time - $DoW; $time = bcmul($time, '24', $precision); $hours = sprintf("%02d", $time); $time = bcmul($time - $hours, '60', $precision); $minutes = sprintf("%02d", $time); $seconds = bcmul($time - $minutes, '60', $precision); return $DoW . ' ' . $hours . ':' . $minutes . ':' . $seconds; } /* make sure we have a 4 digit year */ $year = substr($entry, 15, 4); /* make sure we have a 2 digit month */ $month = sprintf("%02d", substr($entry, 20, 2)); /* get designation & strip the spaces, we dont' need / want them for searches */ $desg = trim(substr($entry, 0, 14), " "); /* we need 8 chars for DD.nnnnn ( n = decimal hours ) */ $day = substr($entry, 23, 8); /* only get the magnitude itself */ $mag = substr($entry, 65, 4); /* get the observatory identifer */ $observatory = substr($entry, 77, 3); /* lets get the day date & time in "standard" format */ $dayTime = decimal_to_time($day); /* date in system useable format, YYYY-MM-DD HH:MM:SS.sssss, like we are used to */ $humanDate = $year . '-' . $month . '-' . $dayTime; /* 2 digit singular day */ $day = sprintf("%02d", $day);

Hi Bear,

Once you have a valid data array you can process it like this:<?php function decimal_to_time($time, $precision = '5') { $DoW = sprintf("%02d", $time); $time = $time - $DoW; $time = bcmul($time, '24', $precision); $hours = sprintf("%02d", $time); $time = bcmul($time - $hours, '60', $precision); $minutes = sprintf("%02d", $time); $seconds = bcmul($time - $minutes, '60', $precision); return $DoW . ' ' . $hours . ':' . $minutes . ':' . $seconds; } foreach ($form->data['valid'] as $k => $entry ) { /* make sure we have a 4 digit year */ $year = substr($entry, 15, 4); /* make sure we have a 2 digit month */ $month = sprintf("%02d", substr($entry, 20, 2)); /* get designation & strip the spaces, we dont' need / want them for searches */ $desg = trim(substr($entry, 0, 14), " "); /* we need 8 chars for DD.nnnnn ( n = decimal hours ) */ $day = substr($entry, 23, 8); /* only get the magnitude itself */ $mag = substr($entry, 65, 4); /* get the observatory identifier */ $observatory = substr($entry, 77, 3); /* lets get the day date & time in "standard" format */ $dayTime = decimal_to_time($day); /* date in system useable format, YYYY-MM-DD HH:MM:SS.sssss, like we are used to */ $humanDate = $year . '-' . $month . '-' . $dayTime; /* 2 digit singular day */ $day = sprintf("%02d", $day); $form->data['entries'][$k] = array( 'humanDate' => $humanDate, 'year' => $year, 'month' => $month, 'day' => $day, 'desg' => $desg, 'mag' => $mag, 'observatory' => $observatory, 'source_data' => $entry, ); } ?>
If you then have a table with an auto-incremented primary key - say cf_id - and the column names above* (plus any others you might need). Then the data should be savable into multiple records from the $form->data['entries'] sub-array.

Bob

* The humanDate column should I think be DATETIME - that will accept the fractional seconds.