I have a text field that is being inserted into the same phones in this format:
11 2222-3333;12 9 1111-2222;18 1111-2222;11 2222-3333
I need to list these fields as if it were a simple select in line and column . the result I need is this:
11 2222-3333
12 9 1111-2222
18 1111-2222
11 2222-3333
You swallow the data in your SQL and put in a variable the part of the phones, in my example it was in $str and I follow the code below:
<?php
$str = '11 2222-3333;12 9 1111-2222;18 1111-2222;11 2222-3333';
$strs = explode(';', $str);
foreach($strs as $st){
echo $st;
echo PHP_EOL;
}
Example: ideone
Obs: do the conversions in PHP, which is the best solution
There are several ways to do it, one option would be to make a explode () and then implode () , example:
$str = '11 2222-3333;12 9 1111-2222;18 1111-2222;11 2222-3333';
echo implode('<br/>',explode(';',$str));
$str = '11 2222-3333;12 9 1111-2222;18 1111-2222;11 2222-3333';
echo str_replace(';','<br/>',$str);
I would use str_replace:
$str = '11 2222-3333;12 9 1111-2222;18 1111-2222;11 2222-3333';
echo str_replace(';', '<br />', $str);