PHP Split string at certain points

Question

I have a database with a column named images

it looks like:

[image1.jpg],[image2.jpg],[image3.jpg] etc

how can i extract this information and display each image using PHP like:

$sql="SELECT * from table ";
$rs=mysql_query($sql,$conn);
$result=mysql_fetch_array($rs);

echo '<img src="image1.jpg" />';
echo '<img src="image2.jpg" />';
echo '<img src="image3.jpg" />';

explode on `,` loop eanch array entry trimming `[]`.... and then consider normalizing your database — Mark Baker, Oct 10 '13 at 20:44
this question might make your path :http://stackoverflow.com/questions/8075323/mysql-with-comma-separated-values — xkeshav, Oct 10 '13 at 20:50

score 5 · Answer 1 · answered Oct 10 '13 at 20:45

5

foreach(explode(',',$result['column']) as $image){
    echo '<img src='.strtr($image,'[]','""').' />';
}

answered Oct 10 '13 at 20:45

Lajos Veres

13,595
7
43
56

Think you're missing an ending `)` on the strtr call – immulatin Oct 10 '13 at 20:47
$images = explode(',',$result['column']); echo ''; – Lajos Veres Oct 10 '13 at 21:17
how can i get the img src to display like – user2710234 Oct 10 '13 at 21:33
Sorry, but I don't understand. My previous comment prints out exactly this. I don't see any difference. – Lajos Veres Oct 11 '13 at 07:45

score 0 · Answer 2 · answered Oct 10 '13 at 20:45

0

The easiest way will be regexp.

preg_match_all('/\[(.*?)\]/', $field, $images);
$images = $images[1];

Now $images will contain array of all found images.

answered Oct 10 '13 at 20:45

Elon Than

9,603
4
27
37

Probably not easier, and certainly too heavyweight for the requirement. – Oct 10 '13 at 21:01
1

@MikeW You can test it but I don't think it'll be much slower than other solutions in that case. If of course any difference will be noticeable. – Elon Than Oct 10 '13 at 21:05

score 0 · Answer 3 · answered Oct 10 '13 at 20:48

You should use str_replace() & explode() functions to deal with this situation and avoid using regex:

<?php

$data = "[image1.jpg],[image2.jpg],[image3.jpg]";

$data = str_replace("]","", str_replace("[", "", $data));

$exploded = explode("," $data);

?>

The array will contain the images each in an element without the "[" and "]", now all you have to do is loop throught it and echo it.

PHP Split string at certain points

3 Answers3