PHP Array input name to database

Question

I am working on a hotel feature page.

the peice of code I am stuck on is the following:

<?php 
$result = mysqli_query($conn, "select * from facilities_type");
while($row = mysqli_fetch_assoc($result))
{
?>
 <tr>
    <th scope="row">
        <input class="form-check-input" type="checkbox" id="blankCheckbox" name="room_feature_cb[]" value="<?php echo $row["facilitiestype_id"]; ?>">
    </th>
    <td>
        <?php echo $row["room_facilities"] ?>
    </td>
    <td>
        <img src="upload-img/icon/<?php echo $row["facilities_icon"]; ?>" width="25">
    </td>
 </tr>
<?php
}
?>

I want to save the data by using the array, but i cannot get the name to save into the database

if (isset($_POST["room_feature_savebtn"])) 
{
    $feature = $_POST['room_feature_cb'];
    for($result=0;$result>$feature;$result++)
    {
    mysqli_query($conn,"insert into facilities_details(facilitiestype_id) value ('$feature')");
    }
}

kip · Accepted Answer · 2017-09-17 04:10:09Z

1

You can use the foreach, is a better option in this case:

if (isset($_POST["room_feature_savebtn"])) 
{
    $features = $_POST['room_feature_cb'];
    foreach ($features as $feature) {
        mysqli_query($conn, "insert into facilities_details(facilitiestype_id) value ('$feature')");
    }
}

Your error is when make a for you dont use the index of array ($result) that create in this, try with:

if (isset($_POST["room_feature_savebtn"])) 
{
    $feature = $_POST['room_feature_cb'];
    for($result=0; $result < $feature; $result++)   {
        mysqli_query(
            $conn,
            "insert into facilities_details(facilitiestype_id) value ('" . $feature[$result] . "')"
        );
    }

}

I recomend the foreach

edited Sep 17, 2017 at 4:10

answered Sep 17, 2017 at 4:03

kip

1,1407 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

PHP Array input name to database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related