Select from SQL single row and set to php array [duplicate]

Question

I want to select a single row names news_images which contains record like this :

name.jpg,image.jpg,randomimagerame.jpg

These pictures does not have similar names, so I want to set them in array, here is my code :

$info = array($row['news_image']);
print_r($info);
echo  $info[0] . ", " . $info[1] . " and " . $info[2] . ".";

I got error :

Array ( [0] => name.jpg,image.jpg,randomimagerame.jpg ) Notice: Undefined offset: 1 in D:\PORTAL\htdocs\KARGI\news.php on line 84

Notice: Undefined offset: 2 in D:\PORTAL\htdocs\KARGI\news.php on line 84 name.jpg,image.jpg,randomimagerame.jpg, and .

How can I make this work ? I want result to be like this :

$info[0] = name.jpg
$info[1] = image.jpg
$info[2] = randomimagerame.jpg

Do NOT store delimiter separated lists into the DB! read over "db normalization" . — B001ᛦ
– B001ᛦ, Commented Jul 30, 2019 at 12:51
i'll change it... Perfect! You'll have a much easier life :) — B001ᛦ
– B001ᛦ, Commented Jul 30, 2019 at 13:06

Rakesh Jakhar · Accepted Answer · 2019-07-30 12:51:31Z

0

You can use explode : explode()

 $info = explode(',',$row['news_image']);
 print_r($info);

answered Jul 30, 2019 at 12:51

Rakesh Jakhar

6,4082 gold badges13 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Select from SQL single row and set to php array [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related