PHP - 同时更新所有字段并单独删除每个字段的图像

I am currently creating a basic CMS for practice purposes and I can't seem to figure out:

  • How to Update all fields at once AND delete (or upload new) images for each independent record

Any help would be appreciated :)

Updating All Fields Code:

if (isset($_POST['submit'])) {
    $id = $_POST['id'];

    $sql = "UPDATE services SET page_title=:pageTitle, event_title=:eventTitle, event_content=:eventContent WHERE id=:id";

    foreach ($id as $key => $value) {
        $query = $connect->prepare($sql);
        $query->bindValue(':pageTitle', $_POST['page_title'], PDO::PARAM_STR);
        $query->bindValue(':eventTitle', $_POST['event_title'][$key], PDO::PARAM_STR);
        $query->bindValue(':eventContent', $_POST['event_content'][$key], PDO::PARAM_STR);
        $query->bindValue(':id', $id[$key], PDO::PARAM_STR);


        if ($query->execute()) {
            $message = 'Records updated.';
        } else {
            $message = "Failed to update records. Please contact Administrator.";
        }

    }
}

PHP/HTML Code:

 <form method="post" action="">

            <?php 
                $sql = "SELECT * FROM services";
                $query = $connect->prepare($sql);
                $query->execute();

                $i = 1;
                while($results = $query->fetch(PDO::FETCH_ASSOC)) { ?>

                    <?php if ($i === 1) { ?>
                        <input type="text" value="<?php echo $results['page_title'] ?>" name="page_title">
                    <?php } ?>

                    <div class="service">
                        <input type="hidden" value="<?php echo $results['id'] ?>" name="id[]">
                        <input type="text" value="<?php echo $results['event_title'] ?>" name="event_title[]"/>
                        <?php
                            if ($results['event_imgSrc'] == '') { ?>
                                <img src='' style="width:100px; height:100px;">
                            <?php } else { ?>
                                <img src="<?php echo '../'.$results['event_imgSrc'] ?>" name="event_imgSrc">
                            <?php }
                        ?>
                        <input type="file" name="image">
                        <input type="submit" name="del_img" value="Delete Image">
                        <input type="submit" name="upload_new" value="Upload New Image">
                        <textarea name="event_content[]"><?php echo $results['event_content'] ?></textarea>
                    </div>

                <?php $i++; } ?>
                    <input type="submit" name="submit" value="Update"/>
                    <?php if (isset($message)) { ?>
                        <p><?php echo $message ?></p>
                    <?php } ?>
                </form>