PHP get the strings separate to store in the array

Question

I am working on my PHP to fetch the data from the mysql database. I have got a problem with storing the filename in the array using the values when I have stored both filenames in a database.

Here is what I have stored in the blob:

draft_attachment.rar
draft_attachment - Copy.rar

Here is the code:

$mailbox = $link->prepare("SELECT * FROM draft WHERE id = ?");
$mailbox->execute([$id]);

// set the resulting array to associative
$row = $mailbox->fetch(PDO::FETCH_ASSOC);
$attachments = array();

if($mailbox->rowCount() == 1)
{
    $attachment = array();
    $draft_to = htmlspecialchars($row['to_email']);
    $draft_subject = quoted_printable_decode($row['subject']);
    $draft_message = $row['message'];
    $attach[] = $row['attachments'];
}
?>

When I try this:

$attach[] = $row['attachments'];

It will store both strings in the array:

Array
{
   [0] => draft_attachment.rar
draft_attachment - Copy.rar
}

So I have tried this:

$attachments = array();  
$i = 0;

if($mailbox->rowCount() == 1) {
    $attachments[$i] = $row['attachments'];
    $i++;
}

It wont store the strings separate so I dont know what to do.

Here is what I want to achieve:

Array
{
   [0] => draft_attachment.rar
   [1] => draft_attachment - Copy.rar
}

Can you please show me an example how I could get both strings to go separate so I could be able to store them in the array using the value?

Thank you.

Are you actually storing any binary data in that blob? If not, you need a better approach. If you were to use a lookup table (varchar) that would provide the one => many relationships you appear to need. Then no need to separate any strings. — EternalHour
– EternalHour, Commented Sep 23, 2019 at 23:17
"'s are valid chars in an email address, htmlspecialchars is going to bork it, XSS is not a thing with to address, instead you should be preventing header injection, which htmlspecialchars wont prevent. — Lawrence Cherone
– Lawrence Cherone, Commented Sep 23, 2019 at 23:28

Nick · Accepted Answer · 2019-09-23 23:04:05Z

1

You can split the string using preg_split on \R (any sequence of new line characters) (explode can also work if you know the exact line ending characters):

$attachments = preg_split('/\R/', $row['attachments']);

Demo on 3v4l.org

answered Sep 23, 2019 at 23:04

Nick

147k23 gold badges67 silver badges106 bronze badges

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

1 Comment

Robert Jones Over a year ago

Thank you very much for this as this is what I am looking for exactly.

Mohan Bade · Accepted Answer · 2019-09-23 23:21:42Z

0

you can use explode function, something like explode("\n", $row['attachments'])

answered Sep 23, 2019 at 23:21

Mohan Bade

262 bronze badges

Collectives™ on Stack Overflow

PHP get the strings separate to store in the array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related