PHP - Splitting string lines up into two variables

Question

Not sure how I would do this but if someone could point me in the right track that'll be great, basically I've got a lone line of text in a variable which looks like this:

Lambo 1; Trabant 2; Car 3;

Then I want to split "Lambo" to it's own variable then "1" to it's own variable, and repeat for the others. How would I go and do this? I know about explode() but not sure how I would do it to split the variable up twice etc.

As requested in the comments my desired output would be like this: $Item = "Lambo" $Quantity = 1 Then echo them out and go back to top of loop for example and do the same for the Trabant and Car

Have you considered using PHP's explode() function? or preg_split()? — Mark Baker
– Mark Baker, Commented May 22, 2016 at 18:04
@MarkBaker Hey, I've looked at it but I'm not sure how I would split it up like above, I want for example "Lambo" in one variable e.g $Item then the number after it $Quantity then I'll echo them out, and repeat for the other two etc. — PaulB3434
– PaulB3434, Commented May 22, 2016 at 18:06
You explode once to an array splitting on the ;, then walk that resulting array splitting on the space — Mark Baker
– Mark Baker, Commented May 22, 2016 at 18:06

Johann Bauer · Accepted Answer · 2016-05-22 18:08:36Z

2

<?php
$in = "Lambo 1; Trabant 2; Car 3;";
foreach (explode(";", $in) as $element) {
        $element = trim($element);
        if (strpos($element, " ") !== false ) {
                list($car, $number) = explode(" ", $element);
                echo "car: $car, number: $number";
        }
}

You can use explode to split the input on each ;, loop over the results and then split over each .

answered May 22, 2016 at 18:08

Johann Bauer

2,6162 gold badges28 silver badges44 bronze badges

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

2 Comments

PaulB3434 Over a year ago

Hey, any chance you could tell me how to put a MySQL Query into a format like $in? $result=mysqli_query($conn,$sql_query);

Johann Bauer Over a year ago

@Paul Please post your question as a new question, not as a comment to an existing question.

user3339197 · Accepted Answer · 2016-05-22 18:07:25Z

0

You can use preg_split and iterate over the array by moving twice.

$output = preg_split("/ (;|vs) /", $input);

answered May 22, 2016 at 18:07

user3339197

Comments

trincot · Accepted Answer · 2016-05-22 18:08:19Z

0

You could use preg_match_all for getting those parts:

$line = "Lambo 1; Trabant 2; Car 3;";   

preg_match_all("/[^ ;]+/", $line, $matches);
$matches = $matches[0];

With that sample data, the $matches array will look like this:

Array ( "Lambo", "1", "Trabant", "2", "Car", "3" )

answered May 22, 2016 at 18:08

trincot

357k38 gold badges282 silver badges338 bronze badges

Comments

Stephen Mudere · Accepted Answer · 2016-05-22 18:15:21Z

0

   $new_data="Lambo 1;Trabant 2;Car 3;"  ;  
   $new_array=explode(";", $new_data);
      foreach ($new_array as $key ) {
          # code...
            $final_data=explode(" ", $key);

           if(isset($final_data[0])){ echo "<pre>".$final_data[0]."</pre>";}
           if(isset($final_data[1])){echo "<pre>".$final_data[1]."</pre>";}
    }

answered May 22, 2016 at 18:15

Stephen Mudere

4553 silver badges10 bronze badges

Comments

Andreas · Accepted Answer · 2016-05-22 18:15:38Z

0

This places each word and number in a new key of the array if you need to acess them seperatly.

preg_match_all("/(\w+) (\d+);/", $input_lines, $output_array);

Click preg_match_all http://www.phpliveregex.com/p/fM8

answered May 22, 2016 at 18:15

Andreas

24k7 gold badges34 silver badges75 bronze badges

Comments

arkascha · Accepted Answer · 2016-05-22 18:18:45Z

Use a global regular expression match:

<?php
$subject = 'Lambo 1; Trabant 2; Car 3;';
$pattern = '/((\w+)\s+(\d+);\s?)+/Uu';
preg_match_all($pattern, $subject, $tokens);
var_dump($tokens);

The output you get is:

array(4) {
  [0] =>
  array(3) {
    [0] =>
    string(8) "Lambo 1;"
    [1] =>
    string(10) "Trabant 2;"
    [2] =>
    string(6) "Car 3;"
  }
  [1] =>
  array(3) {
    [0] =>
    string(8) "Lambo 1;"
    [1] =>
    string(10) "Trabant 2;"
    [2] =>
    string(6) "Car 3;"
  }
  [2] =>
  array(3) {
    [0] =>
    string(5) "Lambo"
    [1] =>
    string(7) "Trabant"
    [2] =>
    string(3) "Car"
  }
  [3] =>
  array(3) {
    [0] =>
    string(1) "1"
    [1] =>
    string(1) "2"
    [2] =>
    string(1) "3"
  }
}

In there the elements 2 and 3 hold exactly the tokens you are looking for.

Collectives™ on Stack Overflow

PHP - Splitting string lines up into two variables

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related