[RESOLVED] parse exploded value

SupermanInNY

Hi All,

I'm not very proficient with PHP and need your assistance getting the follwoing:

$sock->query('/CMD_API_ALL_USER_USAGE');
echo "<b>ALL_USER_USAGE</b>\n<br>";
$lines = explode("\n", $sock->fetch_body());
foreach ($lines as $line)
{
$username = strtok($line, '=');
$data = strstr($line, '=');

echo "\n<br><br>found data for $username<br>";
echo $data;
}
echo "<b>=== end of ALL_USER_USAGE ===</b>";
echo "<br><br>";

The return entry from this code is:

found data for mjhkj
=bandwidth=0.0000 / 5000&creator=admin&default=ding.com&ip=1.10.18.28&ips=&list=ding.com
&quota=0.1875 / 1000&suspended=No&type=reseller&vdomains=1 / 10

I need to extract the 'type' from that string.
The sample above is showing the value reseller
Any coding pointers on how to extract it from that string and echo it ?

basically parsing $data.

Thanks for any pointers.

-Sup.

bradgrafelman

If you strip off the first '=' character, then you could simply use [man]parse_str/man to parse the "key=value" pairs in the string.

SupermanInNY

I can't get it work 🙁.
I don't understand exactly how utilize the parse_str() function.
I tried to use the samples in the PHP Man pages, but I'm spinning my wheels going nowhere.

First, I'm not sure of how to strip off the first '=' char.
Second, I didn't understand how the parsing process works with that function. what's the delimiter in that function? I could use some guidance with that.

Thanks for the very quick response.

-Sup.

SupermanInNY

Sorry for the double-post.

Here is the output I'm getting from the run:

found data for admin
=bandwidth=29.2 / unlimited&creator=root&default=&ip=10.20.30.238&ips=&list=&quota=0.2617 / unlimited&suspended=No&type=reseller&vdomains=0 / unlimited
MynameIs

found data for bing
=bandwidth=0.0000 / 1000&creator=admin&default=bing33.com&ip=10.20.30.238&ips=10.20.30.238
&list=bing33.com
&quota=0.1250 / 100&suspended=No&type=user&vdomains=1 / 1
MynameIs

found data for mjhkj
=bandwidth=0.0000 / 5000&creator=admin&default=ding.com&ip=10.20.30.238&ips=&list=ding.com
&quota=0.1875 / 1000&suspended=No&type=reseller&vdomains=1 / 10
MynameIs

found data for test2222
=bandwidth=0.0000 / 1000&creator=admin&default=dddo.com&ip=10.20.30.238&ips=10.20.30.238
&list=dddo.com
&quota=0.1211 / 100&suspended=No&type=user&vdomains=1 / 1
MynameIs

If this helps,. I would parse / use the delimiter of the same fields in all of them and just utilize the specific field that I need.

Again, I don't know how to run the parsing on this to actually make it happen.

bradgrafelman

SupermanInNY wrote:
First, I'm not sure of how to strip off the first '=' char.

For that bit, you could probably use [man]ltrim/man to strip off any '=' characters on the left-hand side of the string. Alternatively, if you know the first character is always going to be a '=' character, you could simply use [man]substr/man to retrieve everything after the first character.

SupermanInNY wrote:
Second, I didn't understand how the parsing process works with that function. what's the delimiter in that function? I could use some guidance with that.

Well I suppose the answer to that question would be that '&' and '=' are both used as delimiters. It's essentially just taking what would appear to be any query string in a URL and parsing it into variables.

Since I don't like functions that generate random variables in the current scope, I prefer to use the second parameter of [man]parse_str/man and use the resulting array. This is what the second part of Example #1 in the PHP manual is doing.

SupermanInNY



foreach ($lines as $line)
{
        $username       = strtok($line, '=');
        $data           = strstr($line, '=');
        echo "\n<br><br>found data for $username<br>";
        $sdata = ltrim($data,'=');
        echo $sdata;

parse_str($sdata,$output);
echo "<br>";
echo "output is: ";
echo $output[type];
echo " end of output";

Yey... I got it working 🙂))

Thank you very much for the assistance with this function.

-Sup.