色老大影院,玖玖精品,亚洲国产精品久久久

本文介紹了PHP 代碼 (mysqli) 查詢在特定代碼后不起作用的處理方法，對大家解決問題具有一定的參考價值，需要的朋友們下面隨著小編來一起學習吧！

問題描述

我有 PHP 代碼，我們可以將此代碼稱為 BLOCKONE:

$maker = "從視頻信息中選擇 vidMaker";如果 ($result = mysqli_query($con, $maker)) {而 ($row = mysqli_fetch_row($result)) {$values = expand(',',$row[0]);foreach($values as $v)如果 (!empty($v)) {printf ("<img class="makerImg" src="addVid/maker/%s.jpg">", $v);}}mysqli_free_result($result);}別的{echo "PM 管理員出錯";}

我有很大的 PHP 代碼，例如:

 <頭><身體><?php>............塊...........?>

問題是BLOCKONE 之前 BLOCKONE 所有的mysqli 查詢都在工作，我可以顯示信息、圖像等，但是AFTER BLOCKONE 沒有任何查詢在工作.

為什么我知道這個問題正是在這段代碼中?因為如果刪除它......完整的代碼工作正常.而且我不確定要解決它.

這是完整的代碼:

<頭><meta http-equiv="content-type" content="text/html; charset=utf-8"><?php 包含 'BSH.php' ?><link rel="stylesheet" type="text/css" href="CSS/ldvid.css"><script type="text/javascript" src="java/FWDUVPlayer.js"></script><!-- 設置視頻播放器--><script type="text/javascript"><?php 包含 'video/settings.php';?><身體><?php include_once 'userPages/check_login_status.php';?><?php include_once 'incIndex/headerTop.php';?><?php include_once 'incIndex/footer.php';?><?php//這里我們得到傳入的視頻 ID (videoinfo.php?id=123)$video_id = $_GET['id'];//建立一個數據庫查詢來選擇視頻信息//這里我們使用WHERE來選擇我們想要的video_id$query = 'SELECT newsvid.id, videoinformation.id, videomain.id, newsvid.vidTitle, newsvid.imgCover, videoinformation.vidLD, videoinformation.vidYear, videoinformation.vidCity, videoinformation.vidZanr, videoinformation.vidZanr2,videoinformation.vidZanr3,videoinformation.vidQuality, videoinformation.vidTranslated, videoinformation.vidMaker, videoinformation.vidRoles, videoinformation.vidTime, videoinformation.imgShot1, videoinformation.imgShot2, videoinformation.imgShot3, videomain.vidMUrl from newsvid, videomain, videoinformation WHERE newsvid.id = videoinformation.id AND newsvid.id = videomain.id AND newsvid.id = '.$video_id ;//讓我們連接并執行查詢包括'connect/con.php';$result = mysqli_query($con, $query);echo "";while($row = mysqli_fetch_array($result)) {echo "<div class="panel panel-default"><div class="panel-heading">";回聲<div><strong><h3>".$row['id'].|".$row['vidTitle'] ."</h3></strong></div>";echo "</div><div class="panel-body">";echo "<div class="imgCover"><img style="width:200;height:320px" class="img-thumbnail"src="upload/videoCover/" . $row['imgCover'] . ""></div>";echo "
<表格><tr><td class="tdBR"><strong>年份:</strong></td><td>" . $row['vidYear'] . "</td></tr><tr><td class="tdBR"><strong>城市:</strong></td><td>".$row['vidCity']."</td></tr><tr><td class="tdBR"><strong>Zanr: </strong></td><td >". $row['vidZanr'] .", ". $row['vidZanr2'] .", ". $row['vidZanr3'] . "</td></tr><tr><td class="tdBR"><strong>質量:</strong></td><td>". $row['vidQuality'] ."</td></tr><tr><td class="tdBR"><strong>翻譯:</strong></td><td>". $row['vidTranslated'] ."</td></tr><tr><td class="tdBR"><strong>視頻時間:</strong></td><td>".$row['vidTime']."</td></tr></table>" . $row['vidLD'] . "</div></div>";echo "<div class="panel-body" style="border-top: 1px solid;邊框底部:1px 實心；邊框顏色:#ddd"><div class="vidDesc">
";echo "<div><strong>制造商:</strong>" . $row['vidMaker'] . "</div><div>";$maker = "SELECT vidMaker FROM videoinformation WHERE id=".$row['id'];如果 ($result = mysqli_query($con, $maker)) {而 ($row = mysqli_fetch_row($result)) {$values = expand(',',$row[0]);foreach($values as $v)如果 (!empty($v)) {printf ("<img class="makerImg img-circle" src="addVid/maker/%s.jpg">", $v);}}mysqli_free_result($result);}別的{echo "PM 管理員出錯";}回聲</div><div><strong>角色:</strong>".$row['vidRoles'] .</div><div><表格>";$role = "從視頻信息中選擇 vidRoles WHERE id=".$row['id'];如果 ($result = mysqli_query($con, $role)) {而 ($row = mysqli_fetch_row($result)) {$values = expand(',',$row[0]);foreach($values as $v)如果 (!empty($v)) {printf ("<img class="roleImg img-circle" src="addVid/roles/%s.jpg">", $v);}}mysqli_free_result($result);}別的{echo "PM 管理員出錯";}echo "</table></div></div></div>";echo"<div class="panel-body"><div class="screenshots">";echo "<div class="imgShot1"><img style="width:245px;height:140px" class="img-thumbnail" src="upload/" . $row['imgShot1'] . ""></div>";echo "<div class="imgShot2"><img style="width:245px;height:140px" class="img-thumbnail" src="upload/" . $row['imgShot2'] . ""></div>";echo "<div class="imgShot3"><img style="width:245px;height:140px" class="img-thumbnail" src="upload/" . $row['imgShot3'] . ""></div>";回聲"</div>";echo "</div><div class="panel-footer">";echo "
<div id="myDiv"></div><ul id="playlists" style="display:none;"><li data-source="playlist1" data-playlist-name="MY HTML PLAYLIST" data-thumbnail-path="content/thumbnails/large1.jpg"></li></ul><ul id="playlist1" style="display:none;"><li data-thumb-source="content/thumbnails/small-fwd.jpg" data-video-source="".$row['vidMUrl'] ."" data-poster-source="upload/videoCover/" .$row['imgCover'] ."" 數據可下載="是"></li></ul>";回聲</div></div></div>";}mysqli_close($con);?>

解決方案

你假設得到不止一行，但你總是重寫:

while ($row = mysqli_fetch_array($result)) {

在你的主循環中，你總是重寫你的 $result 和 $row 變量.

在while循環內，使用$result2和$row2.

I have PHP code we can call this code BLOCKONE:

$maker = "SELECT vidMaker FROM videoinformation";
if ($result = mysqli_query($con, $maker)) {
    while ($row = mysqli_fetch_row($result)) {
        $values = explode(',',$row[0]);
        foreach($values as $v)
        if (!empty($v)) {
           printf ("<img class="makerImg" src="addVid/maker/%s.jpg">", $v);
        }
    }
    mysqli_free_result($result);

}
else{
    echo"PM administrator with an error";
}

I have big PHP code like:

    <!DOCTYPE html>
    <head>
    </head>

    <body>
    <?php>
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    BLOCKONE
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    ?>
    </body>

</html>

The question is BEFORE BLOCKONE all the mysqli queries are working, I can display information, images and so on, but AFTER BLOCKONE none of the queries are working.

Why I know that the problem exactly in this code? Because if delete it... full code working fine. And I'm not sure hot to solve it.

This is full code:

<!DOCTYPE html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<?php include 'BSH.php' ?>
<link rel="stylesheet" type="text/css" href="CSS/ldvid.css">
<script type="text/javascript" src="java/FWDUVPlayer.js"></script>

        <!-- Setup video player-->
        <script type="text/javascript">
        <?php include 'video/settings.php'; ?>
        </script>

</head>
<body>


<?php include_once 'userPages/check_login_status.php';?>
<?php include_once 'incIndex/headerTop.php'; ?>
<?php include_once 'incIndex/footer.php'; ?>

<?php

// here we get the incomming video id (videoinfo.php?id=123)
$video_id = $_GET['id'];

// build a database query to select the videoInformation
// here we use WHERE to select the video_id we want
$query = 'SELECT newsvid.id, videoinformation.id, videomain.id, newsvid.vidTitle, newsvid.imgCover, videoinformation.vidLD, videoinformation.vidYear, videoinformation.vidCity, videoinformation.vidZanr, videoinformation.vidZanr2,videoinformation.vidZanr3,videoinformation.vidQuality, videoinformation.vidTranslated, videoinformation.vidMaker, videoinformation.vidRoles, videoinformation.vidTime, videoinformation.imgShot1, videoinformation.imgShot2, videoinformation.imgShot3, videomain.vidMUrl FROM newsvid, videomain, videoinformation WHERE newsvid.id = videoinformation.id AND newsvid.id = videomain.id AND newsvid.id = '. $video_id ;

// lets connect and do the query
include 'connect/con.php';
$result = mysqli_query($con, $query);


echo "<div class="ldCover">"; 

while($row = mysqli_fetch_array($result)) {

echo "<div class="panel panel-default"><div class="panel-heading">";
echo "<div><strong><h3>" . $row['id']. " | " . $row['vidTitle'] . "</h3></strong></div>";

echo "</div><div class="panel-body">";
echo "<div class="imgCover"><img style="width:200; height:320px" class="img-thumbnail"src="upload/videoCover/" . $row['imgCover'] . ""></div>";
echo "<div class="vidLD">
<table>
<tr><td class="tdBR"><strong> Years: </strong></td><td >" . $row['vidYear'] . "</td></tr>
<tr><td class="tdBR"><strong> City: </strong></td><td >". $row['vidCity'] . "</td></tr>
<tr><td class="tdBR"><strong> Zanr: </strong></td><td >". $row['vidZanr'] ." , ". $row['vidZanr2'] ." , ". $row['vidZanr3'] . "</td></tr>
<tr><td class="tdBR"><strong> Quality: </strong></td><td >". $row['vidQuality'] . "</td></tr>
<tr><td class="tdBR"><strong> Translated: </strong></td><td >". $row['vidTranslated'] . "</td></tr>
<tr><td class="tdBR"><strong> Video time: </strong></td><td >". $row['vidTime'] .  "</td></tr>

</table>" . $row['vidLD'] . "</div></div>";


 echo "<div class="panel-body" style="border-top: 1px solid; border-bottom: 1px solid; border-color:#ddd"><div class="vidDesc">
 </div>";


 echo "<div class="vidMR">
<div><strong> Maker: </strong>" . $row['vidMaker'] . "</div><div>";

$maker = "SELECT vidMaker FROM videoinformation WHERE id=".$row['id'];
if ($result = mysqli_query($con, $maker)) {
    while ($row = mysqli_fetch_row($result)) {
        $values = explode(',',$row[0]);
        foreach($values as $v)
        if (!empty($v)) {
           printf ("<img class="makerImg img-circle" src="addVid/maker/%s.jpg">", $v);
        }
    }
    mysqli_free_result($result);

}
else{
    echo"PM administrator with an error";
}

echo"</div><div><strong> Roles: </strong>". $row['vidRoles'] . "</div>
<div><table>";
$role = "SELECT vidRoles FROM videoinformation WHERE id=".$row['id'];
if ($result = mysqli_query($con, $role)) {
    while ($row = mysqli_fetch_row($result)) {
        $values = explode(',',$row[0]);
        foreach($values as $v)
        if (!empty($v)) {
           printf ("<img class="roleImg img-circle" src="addVid/roles/%s.jpg">", $v);
        }
    }
    mysqli_free_result($result);

}
else{
    echo"PM administrator with an error";
}
echo "</table></div></div></div>";

echo"<div class="panel-body"><div class="screenshots">";
 echo "<div class="imgShot1"><img style="width:245px; height:140px" class="img-thumbnail" src="upload/" . $row['imgShot1'] . ""></div>";
 echo "<div class="imgShot2"><img style="width:245px; height:140px" class="img-thumbnail" src="upload/" . $row['imgShot2'] . ""></div>";
 echo "<div class="imgShot3"><img style="width:245px; height:140px" class="img-thumbnail" src="upload/" . $row['imgShot3'] . ""></div>";
echo"</div>";


echo "</div><div class="panel-footer">";
echo "<div class="vidMUrl"> 

 <div id="myDiv"></div>

<ul id="playlists" style="display:none;">
<li data-source="playlist1" data-playlist-name="MY HTML PLAYLIST" data-thumbnail-path="content/thumbnails/large1.jpg">
</li></ul>

<ul id="playlist1" style="display:none;">
<li data-thumb-source="content/thumbnails/small-fwd.jpg" data-video-source="". $row['vidMUrl'] . "" data-poster-source="upload/videoCover/" . $row['imgCover'] . "" data-downloadable="yes">
</li></ul>

 </div>";


echo "</div></div></div>";
}
mysqli_close($con);

?>








</body>
</html>

解決方案

You are assuming to get more than one row, but you are always rewriting that:

while ($row = mysqli_fetch_array($result)) {

In your main loop, you are always rewrite your $result and $row variable.

Inside the while loop, use $result2, and $row2.

這篇關于PHP 代碼 (mysqli) 查詢在特定代碼后不起作用的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！

【網站聲明】本站部分內容來源于互聯網,旨在幫助大家更快的解決問題，如果有圖片或者內容侵犯了您的權益，請聯系我們刪除處理，感謝您的支持！

pbootcms网站模板|日韩1区2区|织梦模板||网站源码|日韩1区2区|jquery建站特效-html5模板网

PHP 代碼 (mysqli) 查詢在特定代碼后不起作用

問題描述

相關文檔推薦