I am sending a few telnet cmds to a device and reading back its result values in a array.
I need to filter the data, but I’m not sure if preg_split() or preg_match() is better suited.
After isolating the desired rows of text, I need to store several portions of text in a mysql table — for each row.
All the results that need to be stored are formatted like: 0/0 x x xx:xx:xx:xx:xx:xx x x x x x.
Below is the code that I am using, but it’s just filtering the first array column.
$show_pon[0] = "show ont info 1 all";
$show_pon[1] = "show ont info 2 all";
$show_pon[2] = "show ont info 3 all";
$show_pon[3] = "show ont info 4 all";
$show_pon[4] = "show ont info 5 all";
$show_pon[5] = "show ont info 6 all";
$show_pon[6] = "show ont info 7 all";
$show_pon[7] = "show ont info 8 all";
$show_pon[8] = "show ont info 9 all";
$show_pon[9] = "show ont info 10 all";
$show_pon[10] = "show ont info 11 all";
$show_pon[11] = "show ont info 12 all";
$show_pon[12] = "show ont info 13 all";
$show_pon[13] = "show ont info 14 all";
$show_pon[14] = "show ont info 15 all";
$show_pon[15] = "show ont info 16 all";
$telnet->DoCommand($show_pon, $data_response);
$sections = preg_split('/-{50,}s*r?n/s', $data_response);
Its actually sending 16 different cmds.. and the output reply to array $sections
the output below is..
Array ( [0] => show ont info 1 all [1] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [2] => 0/0 1 1 AC:4E:91:A6:CF:F5 active online success match VILERMINA-. [3] => Total: 1, online 1 OLT(config-interface-epon-0/0)# show ont info 2 all [4] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [5] => 0/0 2 1 E0:E8:E6:4E:62:58 active online success match CLOVES-NAV. [6] => Total: 1, online 1 OLT(config-interface-epon-0/0)# show ont info 3 all [7] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [8] => 0/0 3 1 E0:67:B3:93:F1:97 active online success match 0/0 3 2 18:C5:8A:B0:19:4F active online success match [9] => Total: 2, online 2 OLT(config-interface-epon-0/0)# show ont info 4 all [10] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [11] => 0/0 4 1 E0:67:B3:A6:45:E1 active online success match Jessica-Si. 0/0 4 2 E0:67:B3:7E:20:05 active online success match onu-id-2 0/0 4 3 E0:67:B3:7D:F8:F9 active online success match onu-id-3 0/0 4 4 E0:E8:E6:4E:69:B8 active online success match onu-id-4 [12] => Total: 4, online 4 OLT(config-interface-epon-0/0)# show ont info 5 all [13] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [14] => 0/0 5 1 C4:70:0B:26:B9:38 active online success match 0/0 5 2 E0:67:B3:88:33:E2 active online success match 0/0 5 3 E0:E8:E6:4E:70:B8 active powerdown initial initial 0/0 5 4 C4:70:0B:26:5C:28 active online success match 0/0 5 5 E0:E8:E6:4E:75:C8 active online success match 0/0 5 6 E0:E8:E6:4E:69:C0 active online success match 0/0 5 7 E0:67:B3:93:EF:D5 active online success match [15] => Total: 7, online 6 OLT(config-interface-epon-0/0)# show ont info 6 all [16] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [17] => 0/0 6 1 E0:67:B3:88:3D:57 active online success match 0/0 6 2 E0:E8:E6:4E:71:08 active online success match 0/0 6 3 E0:E8:E6:4E:74:78 active online success match [18] => Total: 3, online 3 OLT(config-interface-epon-0/0)# show ont info 7 all [19] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [20] => 0/0 7 1 00:6D:61:59:D8:48 active online success match 0/0 7 2 E0:E8:E6:4E:55:20 active online success match [21] => Total: 2, online 2 OLT(config-interface-epon-0/0)# show ont info 8 all [22] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [23] => 0/0 8 1 E0:E8:E6:4E:69:E0 active online success match 0/0 8 2 E0:E8:E6:4E:70:08 active online success match [24] => Total: 2, online 2 OLT(config-interface-epon-0/0)# show ont info 9 all [25] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [26] => 0/0 9 1 E0:E8:E6:4E:62:78 active online success match 0/0 9 2 E0:67:B3:A6:58:0F active online success match 0/0 9 3 9C:28:EF:01:AE:99 active online success match [27] => Total: 3, online 3 OLT(config-interface-epon-0/0)# show ont info 10 all [28] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [29] => 0/0 10 1 E0:67:B3:35:CE:9B active online success match 0/0 10 2 E0:67:B3:A6:56:71 active online success match 0/0 10 3 E0:67:B3:A6:25:33 active online success match [30] => Total: 3, online 3 OLT(config-interface-epon-0/0)# show ont info 11 all [31] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [32] => 0/0 11 1 E0:67:B3:7D:F3:E0 active online success match [33] => Total: 1, online 1 OLT(config-interface-epon-0/0)# show ont info 12 all [34] => F/S P ONT MAC Control Run Config Match Desc ID flag state state state [35] => 0/0 12 1 E0:67:B3:93:F9:11 active online success match [36] => Total: 1, online 1 OLT(config-interface-epon-0/0)# show ont info 13 all Error: There is no ONT available. OLT(config-interface-epon-0/0)# show ont info 14 all Error: There is no ONT available. OLT(config-interface-epon-0/0)# show ont info 15 all Error: There is no ONT available. OLT(config-interface-epon-0/0)# show ont info 16 all Error: There is no ONT available. OLT(config-interface-epon-0/0)# OLT(config-interface-epon-0/0)# )
and now i need to filter this arrays, and just extract or store in a different array just the arrays starting with
0/0 x x xxxxxxxxxx x x x x x
which basicaly are the cmds replys, which i have requested the 16 cmds which are 16 different ports on the device, and each port replied devices connected on that port with the data of that device
0/0 1 1 00:00:00:00:00 xxxxx xxxxx xxxx xxxx xxxx
and below update the full telnet cmd reply log for better understanding
OLT(config-interface-epon-0/0)# show ont info 1 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 1 1 AC:4E:91:A6:CF:F5 active online success match VILERMINA-.
-----------------------------------------------------------------------------
Total: 1, online 1
OLT(config-interface-epon-0/0)# show ont info 2 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 2 1 E0:E8:E6:4E:62:58 active online success match CLOVES-NAV.
-----------------------------------------------------------------------------
Total: 1, online 1
OLT(config-interface-epon-0/0)# show ont info 3 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 3 1 E0:67:B3:93:F1:97 active online success match
0/0 3 2 18:C5:8A:B0:19:4F active online success match
-----------------------------------------------------------------------------
Total: 2, online 2
OLT(config-interface-epon-0/0)# show ont info 4 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 4 1 E0:67:B3:A6:45:E1 active online success match Jessica-Si.
0/0 4 2 E0:67:B3:7E:20:05 active online success match onu-id-2
0/0 4 3 E0:67:B3:7D:F8:F9 active online success match onu-id-3
0/0 4 4 E0:E8:E6:4E:69:B8 active online success match onu-id-4
-----------------------------------------------------------------------------
Total: 4, online 4
OLT(config-interface-epon-0/0)# show ont info 5 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 5 1 C4:70:0B:26:B9:38 active online success match
0/0 5 2 E0:67:B3:88:33:E2 active online success match
0/0 5 3 E0:E8:E6:4E:70:B8 active powerdown initial initial
0/0 5 4 C4:70:0B:26:5C:28 active online success match
0/0 5 5 E0:E8:E6:4E:75:C8 active online success match
0/0 5 6 E0:E8:E6:4E:69:C0 active online success match
0/0 5 7 E0:67:B3:93:EF:D5 active online success match
-----------------------------------------------------------------------------
Total: 7, online 6
OLT(config-interface-epon-0/0)# show ont info 6 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 6 1 E0:67:B3:88:3D:57 active online success match
0/0 6 2 E0:E8:E6:4E:71:08 active online success match
0/0 6 3 E0:E8:E6:4E:74:78 active online success match
-----------------------------------------------------------------------------
Total: 3, online 3
OLT(config-interface-epon-0/0)# show ont info 7 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 7 1 00:6D:61:59:D8:48 active online success match
0/0 7 2 E0:E8:E6:4E:55:20 active online success match
-----------------------------------------------------------------------------
Total: 2, online 2
OLT(config-interface-epon-0/0)# show ont info 8 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 8 1 E0:E8:E6:4E:69:E0 active online success match
0/0 8 2 E0:E8:E6:4E:70:08 active online success match
-----------------------------------------------------------------------------
Total: 2, online 2
OLT(config-interface-epon-0/0)# show ont info 9 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 9 1 E0:E8:E6:4E:62:78 active online success match
0/0 9 2 E0:67:B3:A6:58:0F active online success match
0/0 9 3 9C:28:EF:01:AE:99 active online success match
-----------------------------------------------------------------------------
Total: 3, online 3
OLT(config-interface-epon-0/0)# show ont info 10 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 10 1 E0:67:B3:35:CE:9B active online success match
0/0 10 2 E0:67:B3:A6:56:71 active online success match
0/0 10 3 E0:67:B3:A6:25:33 active online success match
-----------------------------------------------------------------------------
Total: 3, online 3
OLT(config-interface-epon-0/0)# show ont info 11 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 11 1 E0:67:B3:7D:F3:E0 active online success match
-----------------------------------------------------------------------------
Total: 1, online 1
OLT(config-interface-epon-0/0)# show ont info 12 all
-----------------------------------------------------------------------------
F/S P ONT MAC Control Run Config Match Desc
ID flag state state state
----------------------------------------------------------------------------
0/0 12 1 E0:67:B3:93:F9:11 active online success match
-----------------------------------------------------------------------------
Total: 1, online 1
OLT(config-interface-epon-0/0)# show ont info 13 all
Error: There is no ONT available.
OLT(config-interface-epon-0/0)# show ont info 14 all
Error: There is no ONT available.
OLT(config-interface-epon-0/0)# show ont info 15 all
Error: There is no ONT available.
OLT(config-interface-epon-0/0)# show ont info 16 all
Error: There is no ONT available.
Advertisement
Answer
Don’t bother using preg_split() to cut your text into sections. It looks like you are saving the data regardless of what section it is in.
Use preg_match_all() with an optional last capture group.
^ means “match the start of a line” because of the m pattern modifier.
h* means “match zero or more whitespace characters that do not represent a newline / line break”.
h+ means the same as above except it requires one or more occurrences.
The final horizontal space and visible characters are optional — this is what the non-capturing group with ? does.
Code: (Demo)
var_export(
preg_match_all(
'~^h*(d+/d+)h+(d+)h+(d+)h+([A-Fd]{2}(?::[A-Fd]{2}){5})h+(S+)h+(S+)h+(S+)h+(S+)(?:h+(S+))?~m',
$response,
$m,
PREG_SET_ORDER
)
? $m
: 'no matches'
);
See the demo for the sample text and output.