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.
CodePudding user response：
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-F\d]{2}(?::[A-F\d]{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.
CodePudding user response：
as an update the following array code filters the data i need
$res = array_filter($sections, function ($var) { return (strpos($var, ' 0/0 ') == true);});
which outputs the final result filtered
Array
(
[2] => 0/0 1 1 AC:4E:91:A6:CF:F5 active online success match VILERMINA-.
[5] => 0/0 2 1 E0:E8:E6:4E:62:58 active online success match CLOVES-NAV.
[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
[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
[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
[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
[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
[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
[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
[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
[32] => 0/0 11 1 E0:67:B3:7D:F3:E0 active online success match
[35] => 0/0 12 1 E0:67:B3:93:F9:11 active online success match )
now i just need to split the rest of the data to prepare the arrays to forward to the query mysql
The arrays need to be split into new arrays
[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
[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
to output
[1] => 0/0 3 1 E0:67:B3:93:F1:97 active online success match
[2] => 0/0 3 2 18:C5:8A:B0:19:4F active online success match
[3] => 0/0 4 1 E0:67:B3:A6:45:E1 active online success match Jessica-Si.
[4] => 0/0 4 2 E0:67:B3:7E:20:05 active online success match onu-id-2
[5] => 0/0 4 3 E0:67:B3:7D:F8:F9 active online success match onu-id-3
[6] =>0/0 4 4 E0:E8:E6:4E:69:B8 active online success match onu-id-4