how to store array values into single cell in mysql table using php?

Question

My question is how to store string or integer array values into mysql table. inside a table all values are store into single cell, the values are separated by comma.

ex:

<input type="text" name="product[]" value="rose">
<input type="text" name="product[]" value="garlands">
<input type="text" name="product[]" value="marigold">
<input type="text" name="product[]" value="jasmine">
<input type="text" name="product[]" value="jasmine garlands">

The above values are inserted into mysql table

$sql=mysql_query(" insert into product_sale(product_name) values (?)");

how to store all values and separated by comma, the stored values like

(rose,garlands,marigold,jasmine,jasmine garlands) in a single cell.

Leandro Papasidero · Accepted Answer · 2015-02-21 05:43:28Z

2

This is just a demo. Then, you can bind $product_name into your insert query.

<?php
if(isset($_REQUEST['save'])) {
    $product_name = implode(",", $_REQUEST["product"]);
    print $product_name;

}
$query="insert into product (product_name) values('".$product_name."')";
$sql=mysql_query($query);
if($sql)
    echo "success";
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<form name="myform" method="post">
    <input type="text" name="product[]" value="rose">
    <input type="text" name="product[]" value="garlands">
    <input type="text" name="product[]" value="marigold">
    <input type="text" name="product[]" value="jasmine">
    <input type="text" name="product[]" value="jasmine garlands">
    <input type="submit" name="save" value="Save">
</form>

</body>
</html>

edited Feb 21, 2015 at 5:43

answered Feb 21, 2015 at 5:09

Leandro Papasidero

3,7381 gold badge20 silver badges33 bronze badges

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

4 Comments

karthik Over a year ago

I wrote query for insert values. @Lea Tano

Leandro Papasidero Over a year ago

you can up-vote (up arrow) and/or you can click the check mark (for answered question) (next to my answer - left)

karthik Over a year ago

Lea Tano: How retrieve these values and display into table each product_name display into each row

Leandro Papasidero Over a year ago

@karthik, for new questions,you need to create post. Unfortunately, I can not post here the solution for the new question, since it will conflict with stackoverflow standards. But if you open a new question, I will be more than happy to do it.

Nishant Solanki · Accepted Answer · 2015-02-21 05:15:38Z

0

comma separated values in a single table cell is not a good practice, Do take an another table with fields id and product_id,

if you want to fetch this data than it will be easy to fetch and display, comma separated values will be very messy

answered Feb 21, 2015 at 5:15

Nishant Solanki

2,1283 gold badges19 silver badges32 bronze badges

3 Comments

karthik Over a year ago

I have table for product details (sno, product_name, item_code, rate) fetch product details from product table, but if i going to sale product to customer means the all product name should be store in one cell and same as quantity of products, rate of products and total for each produts. I know little bit English .

Nishant Solanki Over a year ago

@karthik no no, you are doing it wrong, you cant save quantity, rate as comma separated values.

karthik Over a year ago

Nishant Solanki: The above code is work fine. Thanks for rply.

karthik · Accepted Answer · 2015-02-21 05:46:03Z

<?php
include 'connection/db_connection.php';
if(isset($_REQUEST['save'])) {
$product_name = implode(",", $_REQUEST["product"]);
print $product_name;
}
$query="insert into product (product_name) values('".$product_name."')";
$sql=mysql_query($query);
if($sql) 
echo "success";
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<form name="myform" method="post">
<input type="text" name="product[]" value="rose">
<input type="text" name="product[]" value="garlands">
<input type="text" name="product[]" value="marigold">
<input type="text" name="product[]" value="jasmine">
<input type="text" name="product[]" value="jasmine garlands">
<input type="submit" name="save" value="Save">
</form>

</body>
</html>

Collectives™ on Stack Overflow

how to store array values into single cell in mysql table using php?

3 Answers 3

4 Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related