update MySql Database with Array

Question

Okay, I'm completely lost...

What I am trying to do is update one row in my database.

$sizes = array($_POST['size_0'],
               $_POST['size_1'],
               $_POST['size_2'],
               $_POST['size_3'],
               $_POST['size_4']);

$sizes_upd = implode(", ", $sizes);

mysqli_query($con, "UPDATE beds 
                    SET `Available Sizes` = '$sizes_upd' " .
                    "WHERE ID = '$prod_id' ");

My Problem is that not all of my $_POST[] contain data. So let us say for instance $sizes[0] && $sizes[1] contain data, the following string is returned:

value1, value2, , , ,

How do I prevent this so that only the $_POST[] with data returns a value?

You should build the query while looping array checking if data is set, also your code is vulnerable to mysql injection — Fabio
– Fabio, Commented Mar 4, 2014 at 12:01

Community · Accepted Answer · 2023-11-17 19:52:31Z

6

Use array_filter to clean up your array,

$sizes_upd = implode(", ", array_filter($sizes));

edited Nov 17, 2023 at 19:52

CommunityBot

11 silver badge

answered Mar 4, 2014 at 12:01

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

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

5 Comments

Najzero Over a year ago

+ bobby-tables, oh for the love of the spaghetti monster... sanitize database inserts

Realitätsverlust Over a year ago

Could you PLS stop stealing all of my answers before i press this damn "Post your Answer" Button? xD Still +1 :P

Ravinder Reddy Over a year ago

@YUNOWORK: May be he is reading your mind in advance you post it.

Realitätsverlust Over a year ago

I i think so. Im scared now. Time that i start to wear one of these aluminum hats so im protected from mental attacks.

manneJan89 Over a year ago

Awesome! Simple Solution. Thank you!

Collectives™ on Stack Overflow

update MySql Database with Array

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related