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" />';
foreach(explode(',',$result['column']) as $image){
echo '<img src='.strtr($image,'[]','""').' />';
}
) on the strtr call
The easiest way will be regexp.
preg_match_all('/\[(.*?)\]/', $field, $images);
$images = $images[1];
Now $images will contain array of all found images.
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.
,loop eanch array entry trimming[].... and then consider normalizing your database