php - 如何通过输入从DB中获取某一行的id？

Question

我使用 php 显示与表中的值一样多的输入。

<?php foreach($videos as $videos_item): ?>
    <div class="row video-input">
        <input type="text" name="videos_inputs[]" 
           value="<?php echo 'http://www.youtube.com/watch?v=' . $videos_item['video_url']; ?>" 
           placeholder="Ссылка на видео" class="form__input">
        <a href="<?php echo BASE_URL;?>/admin/delete_video.php?id=<?php echo $videos['id']; ?>" 
           class="form_video__delete">Удалить</a>
    </div>
<?php endforeach;?>

但我还需要获取每一行的 ID。

foreach ($videos_inputs as $val) {
    $value = $val;

    $add_videos = $db->prepare(
        'UPDATE videos SET 
            video_url = :video_url 
            WHERE id = :id'
    );

    $add_videos->execute([
        'video_url' => $value,
        'id' => $video_id
    ]);
}

我该怎么做？

Answer 1

将您的表单更改为:

<?php foreach($videos as $videos_item): ?>
    <div class="row video-input">
        <input type="text" name="videos_inputs[<?php echo $videos['id'];?>]" 
           value="<?php echo 'http://www.youtube.com/watch?v=' . $videos_item['video_url']; ?>" 
           placeholder="Ссылка на видео" class="form__input">
        <a href="<?php echo BASE_URL;?>/admin/delete_video.php?id=<?php echo $videos['id']; ?>" 
           class="form_video__delete">Удалить</a>
    </div>
<?php endforeach;?>

你的 php 代码用于更新:

foreach ($videos_inputs as $video_id => $val) {
    $value = $val;

    $add_videos = $db->prepare(
        'UPDATE videos SET 
            video_url = :video_url 
            WHERE id = :id'
    );

    $add_videos->execute([
        'video_url' => $value,
        'id' => $video_id
    ]);
}