-1

i get this warning when i try post data from a checked input to database

Warning: Undefined array key "Days" in C:\xampp\htdocs\oramexhomes\backend\authController.php on line 668

Fatal error: Uncaught TypeError: implode(): Argument #1 ($pieces) must be of type array, string given in

if(isset($_POST['appointment'])){

        $_SESSION['agentid']= 'ueuyy763';
        $checkBox = implode(',', $_POST['Days']);
        $_POST['Days']= array();

        $sql = "INSERT INTO appointment ( Property_number_fk, agent_id, monday, tuesday, wednesday, thursday, friday, saturday, sunday, 8am_9am, 9am_10am, 10am_11am, 11am_12noon, 12noon_1pm, 1pm_2pm, 2pm_3pm, 3pm_4pm, 4pm_5pm, 5pm_6pm, Meetingaddress)
        VALUES (:Property_number, :agent_id, :monday, :tuesday, :wednesday, :thursday, :friday, :saturday, :sunday, :8am-9am, :9am-10am, :10am-11am, :11am-12noon, :12noon-1pm, :1pm-2pm, :2pm-3pm, :3pm-4pm, :4pm-5pm, :5pm-6pm, :Meetingaddress)";
        $stmt = $pdo->prepare($sql);
        $stmt->execute(array(
        ':Property_number' =>  "SELECT Property_number FROM property WHERE agent_id = :agentid",
        ':agent_id' => $_SESSION['agentid'],
        ':monday' => $_POST['Days'][0],
        ':tuesday' => $_POST['Days'][1],
        ':wednesday' => $_POST['Days'][2],
        ':thursday' => $_POST['Days'][3],
        ':friday' => $_POST['Days'][4],
        ':saturday' => $_POST['Days'][5],
        ':sunday' => $_POST['Days'][6],
        ':8am-9am' => $_POST['8am-9am'],
        ':9am-10am' => $_POST['9am-10am'],
        ':10am-11am' => $_POST['10am-11am'],
        ':11am-12noon' => $_POST['11am-12noon'],
        ':12noon-1pm' => $_POST['12noon-1pm'],
        ':1pm-2pm' => $_POST['1pm-2pm'],
        ':2pm-3pm' => $_POST['2pm-3pm'],
        ':3pm-4pm' => $_POST['3pm-4pm'],
        ':4pm-5pm' => $_POST['4pm-5pm'],
        ':5pm-6pm' => $_POST['5pm-6pm'],
        ':Meetingaddress' => $_POST['meeting'],
        )); }

enter code here

html code

enter code here`enter code here`
`enter code here`

Days and Time available for inspection

Please, select days and dates you are sure you will be available for inspection. Bear in mind that not keeping to these selected appointment will make our client unhappy.

       <table class="table table-striped">
        <thead>   
        <tr>
    <th> Days</th>
    <th> Time</th>
            </tr>
        </thead>
        <tbody>

            <tr>
        <td>
    
            <label for="Monday">Monday</label>
        <input type="checkbox" id="Monday" name= "Days[]" value="1">
        
        </td>
        <td>
        <label for="8am-9am">8am-9am</label>
        <input type="checkbox" id="8am-9am" name="8am-9am" value="1"><br>
        </td>
            </tr>
           
            <tr>
                <td>
                <label for="Tuesday">Tuesday</label>
                <input type="checkbox" id="Tuesday" name="Days[]" value="1">
                </td>

                <td>
                <label for="9am-10am">9am-10am</label>
                <input type="checkbox" id="9am-10am" name="9am-10am" value="1">
                </td>
            </tr>

            <tr>
                <td>
                <label for="Wednesday">Wednesday</label>
                <input type="checkbox" id="Wednesday" name="Days[]" value="1">
                </td>

                <td>
                <label for="10am-11am">10am-11am</label>
                <input type="checkbox" id="10am-11am" name="10am-11am" value="1">
                </td>
            </tr> <tr>
                <td>
                <label for="Thursday">Thursday</label>
                <input type="checkbox" id="Thursday" name="Days[]" value="1">
                </td>

                <td>
                <label for="11am-12noon">11am-12noon</label>
                <input type="checkbox" id="11am-12noon" name="11am-12noon" value="1">
                </td>
            </tr> <tr>
                <td>
                <label for="Friday">Friday</label>
                <input type="checkbox" id="friday" name="Days[]" value="1">
                </td>

                <td>
                <label for="12noon-1pm">12noon-1pm</label>
                <input type="checkbox" id="12noon-1pm" name="12noon-1pm" value="1">
                </td>
            </tr> <tr>
                <td>
                <label for="Saturday">Saturday</label>
                <input type="checkbox" id="Saturday" name="Days[]" value="1">
                </td>

                <td>
                <label for="1pm-2pm">1pm-2pm</label>
                <input type="checkbox" id="1pm-2pm" name="1pm-2pm" value="1">
                </td>
            </tr> <tr>
                <td>
                <label for="Sunday">Sunday</label>
                <input type="checkbox" id="Sunday" name="Days[]" value="1">
        
                </td>

                <td>
                <label for="2pm-3pm">2pm-3pm</label>
                <input type="checkbox" id="2pm-3pm" name="2pm-3pm" value="1">
                </td>
            </tr>
Stephen
  • 11
  • 5

0 Answers0