Home / Questions / 251361
Accepted
Lou
Asked: 2020-04-04 10:16:16 +0800 CST 2020-04-04 10:16:16 +0800 CST

How to get the corresponding title of the video in the foreach?

  • 772

This way I store the data $data[$type_format][] = $url;and by using the foreach ($data['video'] as $url)I get all the URLs mp4of the video.

From the following table:

id    title    type_format    url    detail_text
1    title1       video      1.mp4     NULL
1    title2       video      2.mp4     NULL
1    title3       video      3.mp4     NULL
1    title1       text        NULL     detalle1

Getting the following printout:

<a class="link" href="1.mp4"></a>
<a class="link" href="2.mp4"></a>
<a class="link" href="3.mp4"></a>

Using the following code:

    $stmt->bind_result($title, $type_format, $url, $detail_text);

    $data = [
      'text'  => [],
      'video' => [],
    ];

    while ($stmt->fetch()) {
        $data[$type_format][] = $url;
    }

    echo '<nav id="enlaces" class="vids">';
    foreach ($data['video'] as $url) {
      echo '<a class="link" href="'.$url.'">'.$title.'</a>';
    }
    echo '</nav>';

Now my question is: How to send more data to the foreach in order to print its respective title of each link?

to get the following result

<a class="link" href="1.mp4">title1</a>
<a class="link" href="2.mp4">title2</a>
<a class="link" href="3.mp4">title3</a>

Update

            $stmt = $con->prepare("SELECT title,type_format,url,detail_text FROM videos");
            $stmt->execute();
            $stmt->store_result();

            $stmt->bind_result($title, $type_format,$url,$detail_text);

            $i = 1;
            while ($stmt->fetch()) {
                echo '<nav id="enlaces" class="vids">';
                echo '<a class="link" href="'.$url.'">'.$title.'</a>';
                echo '</nav>';

                echo '<div id="ocultado" style="display: none">';
                echo '<div class="cuadro" id="c_link_'.$i.'" >'.$detail_text.'</div>';
                echo '</div>';

            $i++;

            }
php

2 Answers

  1. Best Answer

    You do not need:

    • read the data with the fetchto save it (1 loop while)
    • read again the same data saved with a forto create thenav
    • read again the same data with another forto create the div...

    The data is going to end up messy and you are wasting resources on the server.

    Using this code you could reproduce exactly the structure that you show in the fiddle of your comment:

            $stmt = $con->prepare("SELECT title,type_format,url,detail_text FROM videos");
        $stmt->execute();
        $stmt->store_result();

        $stmt->bind_result($title, $type_format,$url,$detail_text);

        $i = 1;
        $mNav="<nav id=\"enlaces\" class=\"vids\">";
        $mDivs="<div id=\"ocultado\" style=\"display: none;\">";
        while ($stmt->fetch()) {
            $mNav.="<a class=\"link\" href=\"$url\">$title</a>";
            $mDivs.="<div class=\"cuadro\" id=\"c_link_$i\">$detail_text</div>";
        $i++;
        }
        $mDivs.="</div>";
        $mNav.="</nav>";

        echo $mNav;
        echo $mDivs;

    The key is in opening and closing the containers navand divbefore and after the loop.

    • 2

  2. You can create an associative array like so:

    while ($stmt->fetch()) {
    $data[$type_format][] = Array("url" => $url, "title" => $title);
}

echo '<nav id="enlaces" class="vids">';
foreach ($data['video'] as $url) {
  echo '<a class="link" href="'.$url['url'].'">'.$url['title'].'</a>';
}
echo '</nav>';
    • 1