PHP convert multiple strings with special chars as delimiters to array [duplicate]

Question

I have a multiple arrays with strings that comes out from a wordpress database. Its a table from a plugin that stores the data in a very strange way, like this:

    print_r($results);
    
Array 
(
    [form] => text^name14^Antony~text^secondname14^White~email^email14^[email protected]
)
Array  
(
    [form] => ......
)

I need to get the clean data, so:

foreach ($results as $result) {

    $formdata_array = explode('~',$result);
    $formdata_array_count = count($formdata_array);
    for ( $i=0 ; $i < $formdata_array_count ; $i++) {
       if ( empty( $formdata_array[$i] ) ) {
          continue;
       }
       $elemnts = explode('^',$formdata_array[$i]);

       $type = $elemnts[0];
       $element_name = $elemnts[1];
       $value = $elemnts[2];
       $value = nl2br($value);
}

And at this point I get:

print_r($value)

    Antony 
    White
    [email protected]

But I need to have an array to work with

Array
    (
        [0] => Antony
        [1] => White
        [2] => [email protected]
    )

I triede differents methods like array_merge, array_column, array_combine but I can't get the final result

PLease show us your code, add a minimal reproducible example. — 0stone0
– 0stone0, Commented Dec 30, 2022 at 15:05
My guess is that you call print_r(array($output)); three times, for the three items. We need to see the code that does that to help you. — KIKO Software
– KIKO Software, Commented Dec 30, 2022 at 15:05
Are you explode()ing your input into $output properly to make the array? — Elijah M
– Elijah M, Commented Dec 30, 2022 at 15:07

arkascha · Accepted Answer · 2022-12-30 16:08:12Z

1

This probably is what you are looking for:

<?php

$results = [
   ['form' => "text^name14^Antony~text^secondname14^White~email^email14^[email protected]"],
   ['form' => "text^name14^Georgy~text^secondname14^Black~email^email14^[email protected]"],
];

foreach ($results as $result) {
    $output = [];
    $formdata_array = explode('~',$result['form']);
    $formdata_array_count = count($formdata_array);
    for ( $i=0 ; $i < $formdata_array_count ; $i++) {
       if ( empty( $formdata_array[$i] ) ) {
          continue;
       }
       $elements = explode('^',$formdata_array[$i]);

       $output[] = [
        'type' => $elements[0],
        'name' => $elements[1],
        'value' => $elements[2],
       ];
    }
   print_r(array_column($output, 'value'));
}

The output is:

Array
(
    [0] => Antony
    [1] => White
    [2] => [email protected]
)
Array
(
    [0] => Georgy
    [1] => Black
    [2] => [email protected]
)

edited Dec 30, 2022 at 16:08

answered Dec 30, 2022 at 15:50

arkascha

43.2k8 gold badges61 silver badges97 bronze badges

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

6 Comments

uomopalese Over a year ago

It works but with a strange behavior: the 1st array it's ok, the 2nd is 1st + 2nd, the 3rd is 1st + 2nd +3rd and so on. You can try using multiple lines

arkascha Over a year ago

That is not strange at all, that is because the $output has not been reset between loop runs. I changed the code accordingly.

uomopalese Over a year ago

My output from database is the one you see on top, multiple arrays, not an array vith multiple values

arkascha Over a year ago

Please note that you really should be able to spot such things yourself. We are not here to implement a fully working solution, so to do you work for you. We are here to help you find your solution.

uomopalese Over a year ago

Yes, sorry. It works. I got it. Thank you for your time

|

Collectives™ on Stack Overflow

PHP convert multiple strings with special chars as delimiters to array [duplicate]

1 Answer 1

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Linked

Related