How to add multiple input textfield values into db using php

Question

How to insert multiple textfields value into mysqldb?

<?php
      if(isset($_POST['save'])){

    foreach($_POST['color'] as $key => $value)
    {
    if($color!="")
    {
        $color = $value['code'];
        echo $color;
        $rgb = hex2rgba($color);
        $rgba = hex2rgba($color, 0.7);
        /*echo $rgba;
        echo $value['key'];
        echo $value['code'];
        echo $value['order_color'];*/
        $sql = "INSERT INTO tbl_colors values('','$rgba','".$value['key']."','".$value['code']."','".$value['order_color']."')";
        $rs = mysql_query($sql) or die("Bad Query==><br><br>$sql<br><br>".mysql_error());
     }
}
    ?>


     <form action="" method="post" name="recommend">
    <tr>
    <td><input type="text" value="" name="color[][key]" class="email" style="width:450px;font-   size:15px;font-weight:bold;"></td>
    td><input type="text"  value="" name="color[][code]" class="email"></td>
    <td><input type="text"  value="" name="color[][order_color]" class="email"     style="width:50px;"></td>
    </tr>
    <tr>
    <td colspan="5">&nbsp;</td>
   </tr>
   <tr>
    <td><input type="text" value="" name="color[][key]" class="email" style="width:450px;font-   size:15px;font-weight:bold;"></td>
    td><input type="text"  value="" name="color[][code]" class="email"></td>
    <td><input type="text"  value="" name="color[][order_color]" class="email"     style="width:50px;"></td>
    </tr>
    <tr>
    <td colspan="5">&nbsp;</td>
   </tr>

     <tr>
     <td colspan="5" align="center"><input type="submit" name="save" value="Add Color" /></td>
    </tr>
     </form>

Thanks for posting your code. Can you tell us what problem you are facing? — Patrick Hofman
– Patrick Hofman, Commented Mar 17, 2014 at 8:58
when echo $value['key']; only this field is added in db but others text field value not added so help me for that... other field take as blank field no error — Saurabh Gujarani
– Saurabh Gujarani, Commented Mar 17, 2014 at 9:00
A little bit out of the topic, but ALWAYS escape user input BEFORE database insertion! Either by mysql_real_escape_string() or better - use PDO prepared statement! — Bud Damyanov
– Bud Damyanov, Commented Mar 17, 2014 at 9:04

Saurabh Gujarani · Accepted Answer · 2014-03-17 10:15:00Z

1

{
  <?php
      if(isset($_POST['save'])){

    foreach($_POST['color'] as $key => $value)
    {

        $color = $value['code'];
        echo $color;
        $rgb = hex2rgba($color);
        $rgba = hex2rgba($color, 0.7);
        /*echo $rgba;
        echo $value['key'];
        echo $value['code'];
        echo $value['order_color'];*/
        $sql = "INSERT INTO tbl_colors values('','$rgba','".$value['key']."','".$value['code']."','".$value['order_color']."')";
        $rs = mysql_query($sql) or die("Bad Query==><br><br>$sql<br><br>".mysql_error());
     }
}
    ?>


     <form action="" method="post" name="recommend">
    <tr>
    <td><input type="text" value="" name="color[1][key]" class="email" style="width:450px;font-   size:15px;font-weight:bold;"></td>
    td><input type="text"  value="" name="color[1][code]" class="email"></td>
    <td><input type="text"  value="" name="color[1][order_color]" class="email"     style="width:50px;"></td>
    </tr>
    <tr>
    <td colspan="5">&nbsp;</td>
   </tr>
   <tr>
    <td><input type="text" value="" name="color[2][key]" class="email" style="width:450px;font-   size:15px;font-weight:bold;"></td>
    td><input type="text"  value="" name="color[2][code]" class="email"></td>
    <td><input type="text"  value="" name="color[2][order_color]" class="email"     style="width:50px;"></td>
    </tr>
    <tr>
    <td colspan="5">&nbsp;</td>
   </tr>

     <tr>
     <td colspan="5" align="center"><input type="submit" name="save" value="Add Color" /></td>
    </tr>
     </form>

}

edited Mar 17, 2014 at 10:15

answered Mar 17, 2014 at 10:09

Saurabh Gujarani

5111 gold badge7 silver badges23 bronze badges

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

2 Comments

AyB Over a year ago

What is this? If you need to add more code/information you can edit your question.

Saurabh Gujarani Over a year ago

I found the one mistake at input text in my code and it's worked

AlexanderFT · Accepted Answer · 2014-03-17 10:32:37Z

1

Row1, Row2, Row3 are your table rows you need to name them to your table row.

<?php

      if(isset($_POST['colorkey'])){
            $colorkey = $_POST['colorkey'];
                    $colorcode = $_POST['colorkcode'];
                    $colorcode = $_POST['colororder'];          



        $sql = ("INSERT INTO tbl_colors (Row1, Row2, Row3) VALUES ('$colorkey', '$colorcode', '$colorcode')");

}
    ?>


     <form action="" method="post" name="recommend">
    <tr>
    <td><input type="text" value="" name="colorkey" class="email" style="width:450px;font-   size:15px;font-weight:bold;"></td>
    td><input type="text"  value="" name="colorcode" class="email"></td>
    <td><input type="text"  value="" name="colororder" class="email"     style="width:50px;"></td>
    </tr>
    <tr>
    <td colspan="5">&nbsp;</td>
   </tr>
   <tr>
    <td><input type="text" value="" name="colorkey" class="email" style="width:450px;font-   size:15px;font-weight:bold;"></td>
    td><input type="text"  value="" name="colorcode" class="email"></td>
    <td><input type="text"  value="" name="colororder" class="email"     style="width:50px;"></td>
    </tr>
    <tr>
    <td colspan="5">&nbsp;</td>
   </tr>

     <tr>
     <td colspan="5" align="center"><input type="submit" name="save" value="Add Color" /></td>
    </tr>
     </form>

edited Mar 17, 2014 at 10:32

answered Mar 17, 2014 at 9:04

AlexanderFT

731 gold badge2 silver badges13 bronze badges

1 Comment

AlexanderFT Over a year ago

try edited post. I deleted the if statement. Just to check if it actually works

Collectives™ on Stack Overflow

How to add multiple input textfield values into db using php

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related