Array and substring php

Question

     //array data                          
   {
    $results[] = $result;

    $SiteID=$result["site_id"];
    $pay_sale_id=$result["pay_sale_id"];
    $pay_payment_info=$result["pay_payment_info"];
    $payNo= substring_index(substring_index('$result["pay_payment_info"]', '$USER=', -1), '~$TAGROLE', 1);

 }

The content of pay_payment_info is as follows

#$TAG=6F0000173~$USER=james~$TAGROLE=0

I want to extract only the user info, but i get error:

Fatal error: Call to undefined function substring_index() in line

You are mixing MySQL code with PHP code... those are totally different languages. — Flash Thunder
– Flash Thunder, Commented Jan 8, 2018 at 16:26

Muntashir Akon · Accepted Answer · 2018-01-08 17:08:20Z

1

Considering the user info always begins with ~$USER= and ends with a ~ we can get the result using simple regex:

preg_match('/\~\$USER=(?<user>[^~]+)/', $pay_payment_info, $match);
var_dump($match['user']);

answered Jan 8, 2018 at 17:08

Muntashir Akon

9,5112 gold badges32 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tomasz Buczeń · Accepted Answer · 2018-01-08 16:33:42Z

0

As previous comments said - there is no such function like substring_index in core PHP

This question is possible duplicate of following Php get string between tags topic

Here is working example with usage of strpos http://php.net/manual/pl/function.strpos.php

and substr http://php.net/manual/pl/function.substr.php

$var = '$TAG=6F0000173~$USER=james~$TAGROLE=0';
$m = substr($var, strpos($var, '~$USER=')+7);
var_dump($m); //returns string(16) "james~$TAGROLE=0"
$m = substr($m, 0, strpos($m, '~$'));
var_dump($m); //returns string(5) "james"

answered Jan 8, 2018 at 16:33

Tomasz Buczeń

18813 bronze badges

1 Comment

Rushikumar Over a year ago

Note: the above will fail, if OP decides to name $USER to say, $USERINFO or $USERNAME etc. (i.e. anything >7 chars)

NappingRabbit · Accepted Answer · 2018-01-08 16:34:47Z

0

it seems that the problem is you have no substring_index() function or method, yet you attempt to invoke it twice.

I am not sure why you use the ~ as a delimiter but that should be ok, although using a , would have resulted in less work; each of the attributes of your querystring would have been able to be addressed directly then.

what you want to do is use the php version of split() which is explode() here is a link to the manual.

what you want to do is split the inc string:

$aUserInfo = explode('~', $result['pay_payment_info']);

now you have an array. loop through it and make it like you want:

$result = array();
foreach($aUserInfo as $v){
  $aTmp = explode('=',$v);
  $result[$aTmp[0]] = $aTmp[1];
}

at the end of this you have an array with keys as keys and their respective values as values, i.e.

$result = array( 'tag' => '6F0000173',
                 'user'=> 'James',
                 'tagrole'=> 0    );

answered Jan 8, 2018 at 16:34

NappingRabbit

1,9191 gold badge13 silver badges18 bronze badges

4 Comments

user1430825 Over a year ago

how about if use substring in sql like this $sql="INSERT INTO payments_data(site_id, Pay_sale_id, Pay_paymnet_type, Pay_payment_info) VALUES ('00','0','0', substring_index(substring_index('$pay_payment_info', '$USER=', -1), '~$TAGROLE', 1) )";

NappingRabbit Over a year ago

what is this substring_index() you keep wanting to invoke? it is not a built in function. I am not sure if you are attempting to concatenate a string and store it, but that seems the most likely. ... you should restructure your data, but if that isnt possible, spit the string into there, leave out that other method, or let me know what it is supposed to do and I can likely emulate it

user1430825 Over a year ago

I am trying to store only a portion of data, I want to extract user name and store it in a database

NappingRabbit Over a year ago

ahh ok, $result["user"] should be that value

Rushikumar · Accepted Answer · 2018-01-08 16:48:17Z

0

The error tells you exactly why it is an error: substring_index is not a valid/native PHP function... you can define your own function of substring_index, though.

However, given the string:

$TAG=6F0000173~$USER=james~$TAGROLE=0

to get the $USER=james part, you can use explode as follows--

$payNo = explode("~", $result["pay_payment_info"])

Now, you have the $USER info in $payNo[1]

If you want to go even further and just get the value of what $USER value is, then you can use PHP's native substr function:

$justUserPart = substr($payNo[1], strpos($payNo[1], "=")+1);
echo $justUserPart;

Please Note: The above assumes that you will always have the string in the format of

$TAG=...~$USER=...~$TAGROLE=...

edited Jan 8, 2018 at 16:48

answered Jan 8, 2018 at 16:26

Rushikumar

1,8305 gold badges22 silver badges28 bronze badges

Collectives™ on Stack Overflow

Array and substring php

4 Answers 4

Comments

1 Comment

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related