mardi 4 août 2015

insert data into database from array

i need to add data to database from array(table). but this POST.php is not working properly. so can you guys please give me any solution for this.

this is the error that it give.

Illegal string offset 'h_name' in C:\wamp\www\confirm\post.php on line 11

line 11 is: VALUES ('$row[h_name]', '$row[room]', '$row[nors]', '$row[nights]', '$row[euro]', '$row[date]', '09090')";

all inserted value give that error. Array to string conversion Thank you.

                    </br>
                    <h4 id="italic">Hotel Details :</h4>
                    </br>

                        <div class="reqtable">
                            <table>
                                <tr ><td>Hotel Name</td><td>Room Type</td><td>Number of Rooms</td><td>Nights</td><td>EURO</td><td>Date</td></tr>
                                <tr><td><?php
                                    include "conn.php";
                                    $query = "SELECT h_id, h_name FROM hotels";
                                    $result = mysqli_query($conn, $query) or die(mysqli_error($conn)); // Run your query

                                    echo '<select name="list[h_name]" id="h_name"  ">';

                                    echo '<option value=""> Choose a Hotel </option>';
                                    while($row = mysqli_fetch_assoc($result)) {
                                        echo '<option value="'.$row['h_id'].'">'.$row['h_name'].'</option>';
                                    }

                                    echo '</select>';/

                                        ?>
                                </td>

                                <td>
                                    <?php echo '
                                                <select name="list[room]" id="room"  >
                                                    <option value="">Choose a Room Type</option>
                                                    <option value="1">Single Room</option>
                                                    <option value="2">Double Room</option>         
                                                    <option value="3">Triple Room</option>
                                                    <option value="4">Family Room</option>
                                                    <option value="5">Custom Room</option>
                                                </select>';
                                    ?>
                                </td>
                                <td><input type="text" name="list[nors]" placeholder="Number of Rooms"></td>
                                <td> <input type="text" class="zxc" nname="list[nights]" placeholder="Nights"></td>
                                <td><input type="text" name="list[euro]" placeholder="euro"></td>
                                <td><input type="date" name="list[date]" placeholder="Date"></td>
                                <td><pre>    </pre></td>
                                <td><input type='button' class='AddNew' value='Add new item'></td></tr>
                                <tr><td>Total</td><td></td><td></td><td><input name="result" id="result"></td><td></td><td></td></tr>
                            </table>    
                        </div>
                            </br>

                            <input type="submit" id="submit" name="submit" value="Register" color="red" style="width: 77px; height: 50px"></div>

                </form>





post.php(php process)





<?php
    include "conn.php";
    print_r($_POST['list']);





        foreach ($_POST as $row) {
            $query = "INSERT INTO reqhotels (reqh_h_name, reqh_rtype, reqh_nor, reqh_nights, reqh_euro, reqh_date, reqh_req_no) 
                    VALUES ('$row[h_name]', '$row[room]', '$row[nors]', '$row[nights]', '$row[euro]', '$row[date]', '09090')";

            $result = mysqli_query($conn, $query) or die(mysqli_error($conn)); 

            if($result > 0) {
                echo"successfull";
            }
            else {
                echo"fail";
            }
        }
?>



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire