Using foreach loop inside a while loop and echo the values

Question

I have a website where people can upload their videos and if a user uploads a video it makes a new folder called videos in their folder e.g. user/Someone/videos/videoname and in the videos folder there are all the videos that the user uploaded. Then it inserts the video into the database. That works fine, but when I try to echo these videos in an HTML video tag I have problems. Since a user can upload more videos I created an array called $url. Then I select those videos that belong to that user ($sql = "SELECT * FROM videos WHERE user=?";). Then I push every video item to that $url array and I echo the videos with a foreach loop. And here is something wrong. There're duplicates, so one video will be echoed more times and there're missing urls.

Code:

$echo_videos = "";
$items = "";
$url = array();
$sql = "SELECT * FROM videos WHERE user=?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s",$u);
$stmt->execute();
$result = $stmt->get_result();
while($row = $result->fetch_assoc()){
    $name = $row["video_file"];
    $items .= "user/$u/videos/$name";
    array_push($url, $items);
    foreach ($url as $key) {
        $echo_videos .= '<video width="400" controls><source src="'.$key.'"></video>';
    }
}

PS: Maybe the $items variable also should be an array but then I won't be able to push an array to another.

ScaisEdge · Accepted Answer · 2017-09-10 14:51:45Z

1

why not you simply echo the filename

while($row = $result->fetch_assoc()){
   echo '<video width="400" controls><source src="user/'.$u.'/videos/'. $row["video_file"].'">
         </video>';
}

edited Sep 10, 2017 at 14:51

answered Sep 10, 2017 at 14:46

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

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

5 Comments

squancy Over a year ago

Almost good solution, but I'd correct your answer to this:

while($row = $result->fetch_assoc()){ 	   echo '<video width="400" controls><source src="user/'.$u.'/videos/'. $row["video_file"].'"> 	         </video>'; 	}

squancy Over a year ago

And I don't know why but the first video does not appear.

squancy Over a year ago

When I comment out that line the $row["video_file"] will be equal to nothing.

ScaisEdge Over a year ago

i don't understand you last comment .. don't tell you of comment the line with the $row["video_file"]

squancy Over a year ago

You wrote I should comment out line $result = $stmt->get_result(); but you've already changed that comment and deleted that part... but when I comment out the code will not work.

Collectives™ on Stack Overflow

Using foreach loop inside a while loop and echo the values

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related