PHP MySql Database Array update

Question

I am trying to update one row in my database like this.

if (isset($_POST['submit'])) {
$sizes = array($_POST['size_king'], 
               $_POST['size_queen'],
               $_POST['size_double']
              );

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

Can anyone please help me?

I want this data to only update one row, and the data must be separated by a comma.

I am thinking maybe a FOR loop, but I'm not quite sure.

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

3

just use implode() function .

if (isset($_POST['submit'])) {
$sizes = array($_POST['size_king'], 
               $_POST['size_queen'],
               $_POST['size_double']
              );
$sizes=implode(",",$sizes);
mysqli_query($con, "UPDATE beds 
                SET `Available Sizes` = '$sizes' 
                WHERE ID = '$prod_id' " 
            );
}

edited Nov 17, 2023 at 19:52

CommunityBot

11 silver badge

answered Mar 3, 2014 at 12:03

Rajeev Ranjan

4,1523 gold badges30 silver badges42 bronze badges

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

2 Comments

Rajiv Pingale Over a year ago

Implode is a good solution as long as he/she wants add CSV values in database.

Rajeev Ranjan Over a year ago

@RajivPingale what we code just depends upon requirements.

Community · Accepted Answer · 2023-11-17 19:55:19Z

0

The PHP implode function will serve your purpose.

implode joins array elements into a string separated by the glue we specify. The syntax is:

string implode ( string $glue , array $pieces )

Refer to: https://www.php.net/manual/en/function.implode.php

Example:

<?php

$array = array('lastname', 'email', 'phone');
$comma_separated = implode(",", $array);

echo $comma_separated; // lastname,email,phone

// Empty string when using an empty array:
var_dump(implode('hello', array())); // string(0) ""

?>

edited Nov 17, 2023 at 19:55

CommunityBot

11 silver badge

answered Mar 3, 2014 at 12:04

user3374689

Comments

Shehroz Asmat · Accepted Answer · 2014-03-03 12:11:37Z

-1

there is a catch when you create database never name your table as "Available Beds" i mean don't use space try using "AvailabaleSizes" or Available_Sizes or "availableSizes" after this change write your query like below.

($con, "UPDATE `beds`   SET Available_Sizes = '$sizes' WHERE ID = '$prod_id'");

answered Mar 3, 2014 at 12:11

Shehroz Asmat

1611 silver badge14 bronze badges

Collectives™ on Stack Overflow

PHP MySql Database Array update

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related