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

include("connect.php");$sql = "SELECT * FROM sp_tickets WHERE user_id='foo'";$sqlresult = mysqli_query($connect, $sql);如果 (mysqli_num_rows($sqlresult) > 0) {而 ($row = mysqli_fetch_array($sqlresult)) {$sqlStore = "SELECT * FROM transactions WHERE order_id='".$row['order_id']."'";$connectToStore = mysqli_connect("localhost", "root", "root", "root_db");$sqlStoreDBResult = mysqli_query($connectToStore, $sqlStore);而 ($rowTr = mysqli_fetch_array($sqlStoreDBResult)) {$id_str_array = $rowTr['items'];$id_str_array = rtrim($id_str_array, ",");$id_str_array =explode(',', $id_str_array);foreach ($id_str_array as $key => $value) {$id_quantity_pair = expand("-", $value);//使用連字符(-) 作為分隔符將產品 ID 與其數量分開$product_id = $id_quantity_pair[0];//獲取產品ID$sqlProduct = "SELECT * FROM products WHERE id='$product_id'";$sqlresult = mysqli_query($connectToStore, $sqlProduct);而 ($pp_row = mysqli_fetch_array($sqlresult)) {$tickets .='
<div data-ticket="' . $ticket . '" class="ticket"><div class="ticket-left"><span class="product-ticket left-span">'.$pp_row['product_name'] .' ' .$pp_row['product_platform'] .' ' .$pp_row['product_type'] .' ' .$pp_row['product_region'] .'</span><span class="ticket-no left-span">票號' .$row['ticket_id'] .'</span><span class="order-no left-span">訂單號' .$row['order_id'] .'</span><span class="left-span">交易號' .$rowTr['txn_id'] .'</span><span class="product-region left-span">區域:' .$pp_row['product_region'] .'</span>
<div class="ticket-right"><span class="created">Created: ' .$row['date'] .'</span>

include("connect.php");$sql = "SELECT * FROM sp_tickets WHERE user_id='foo'";$sqlresult = mysqli_query($connect, $sql);$connectToStore = mysqli_connect("localhost", "root", "root", "root_db");如果 (mysqli_num_rows($sqlresult) > 0) {而 ($row = mysqli_fetch_array($sqlresult)) {$sqlStore = "SELECT * FROM transactions WHERE order_id='".$row['order_id']."'";$sqlStoreDBResult = mysqli_query($connectToStore, $sqlStore);而 ($rowTr = mysqli_fetch_array($sqlStoreDBResult)) {$id_str_array = $rowTr['items'];$id_str_array = rtrim($id_str_array, ",");$id_str_array =explode(',', $id_str_array);foreach ($id_str_array as $key => $value) {$id_quantity_pair = expand("-", $value);//使用連字符(-) 作為分隔符將產品 ID 與其數量分開$product_id = $id_quantity_pair[0];//獲取產品ID$sqlProduct = "SELECT * FROM products WHERE id='$product_id'";$sqlresult2 = mysqli_query($connectToStore, $sqlProduct);而 ($pp_row = mysqli_fetch_array($sqlresult2)) {$tickets .='
<div data-ticket="' . $ticket . '" class="ticket"><div class="ticket-left"><span class="product-ticket left-span">'.$pp_row['product_name'] .' ' .$pp_row['product_platform'] .' ' .$pp_row['product_type'] .' ' .$pp_row['product_region'] .'</span><span class="ticket-no left-span">票號' .$row['ticket_id'] .'</span><span class="order-no left-span">訂單號' .$row['order_id'] .'</span><span class="left-span">交易號' .$rowTr['txn_id'] .'</span><span class="product-region left-span">區域:' .$pp_row['product_region'] .'</span>
<div class="ticket-right"><span class="created">Created: ' .$row['date'] .'</span>

<div class="ticket-bottom"><div class="bottom-holder"><span class="details"><span class="subject-txt">類別:</span>'.$row['category'] .'</span><span class="details"><span class="subject-txt">主題:</span>'.$row['subject'] .'</span><span class="details desc">"' . $row['description'] . '"</span>

<div class="removeticketcontainer"><span class="removeticket">X</span>

';}}}}}

Nested "while" loop runs only one time, only one div is displayed, can't find any mistakes, 0 errors in "error_log". Feel free to suggest.

I need second sql connection, because $connectToStore makes mysqli connection with separate database.

$items looks like 1-2,2-5,9-1

I've checked and div that's displayed uses data which is in the first row of the table

PHP

include("connect.php");

$sql = "SELECT * FROM sp_tickets WHERE user_id='foo'";
$sqlresult = mysqli_query($connect, $sql);
if (mysqli_num_rows($sqlresult) > 0) {
    while ($row = mysqli_fetch_array($sqlresult)) {

    $sqlStore = "SELECT * FROM transactions WHERE order_id='".$row['order_id']."'";
    $connectToStore = mysqli_connect("localhost", "root", "root", "root_db");
    $sqlStoreDBResult = mysqli_query($connectToStore, $sqlStore);

    while ($rowTr = mysqli_fetch_array($sqlStoreDBResult)) {

        $id_str_array = $rowTr['items'];
        $id_str_array = rtrim($id_str_array, ",");
        $id_str_array = explode(',', $id_str_array);
        foreach ($id_str_array as $key => $value) {
            $id_quantity_pair = explode("-", $value); // Uses Hyphen(-) as delimiter to separate product ID from its quantity
            $product_id = $id_quantity_pair[0]; // Get the product ID

            $sqlProduct = "SELECT * FROM products WHERE id='$product_id'";
            $sqlresult = mysqli_query($connectToStore, $sqlProduct);
            while ($pp_row = mysqli_fetch_array($sqlresult)) {

                $tickets .= '<div class="holder">
                <div data-ticket="' . $ticket . '" class="ticket">
                    <div class="ticket-left">
                        <span class="product-ticket left-span">' . $pp_row['product_name'] . ' ' . $pp_row['product_platform'] . ' ' . $pp_row['product_type'] . ' ' . $pp_row['product_region'] . '</span>
                        <span class="ticket-no left-span">Ticket No. ' . $row['ticket_id'] . '</span>
                        <span class="order-no left-span">Order No. ' . $row['order_id'] . '</span>
                        <span class="left-span">Transaction No. ' . $rowTr['txn_id'] . '</span>
                        <span class="product-region left-span">Region: ' . $pp_row['product_region'] . '</span>
                    </div>
                    <div class="ticket-right">
                        <span class="created">Created: ' . $row['date'] . '</span>
                    </div>
                    <div class="ticket-bottom">
                        <div class="bottom-holder">
                            <span class="details"><span class="subject-txt">Category: </span>' . $row['category'] . '</span>
                            <span class="details"><span class="subject-txt">Subject: </span>' . $row['subject'] . '</span>
                            <span class="details desc">"' . $row['description'] . '"</span>
                        </div>
                    </div>
                </div>
                <div class="removeticketcontainer">
                    <span class="removeticket">X</span>
                </div>
             </div>';
                }
            }
        }
    }
}

Solved it. Answer belongs to @ckimbrell. "The problem looks like you are overwriting the variable $sqlresult with a new result that only returns 1 row. Try to change that in the nested loop."

include("connect.php");

$sql = "SELECT * FROM sp_tickets WHERE user_id='foo'";
$sqlresult = mysqli_query($connect, $sql);

$connectToStore = mysqli_connect("localhost", "root", "root", "root_db");

if (mysqli_num_rows($sqlresult) > 0) {
while ($row = mysqli_fetch_array($sqlresult)) {

$sqlStore = "SELECT * FROM transactions WHERE order_id='".$row['order_id']."'";
$sqlStoreDBResult = mysqli_query($connectToStore, $sqlStore);

while ($rowTr = mysqli_fetch_array($sqlStoreDBResult)) {

    $id_str_array = $rowTr['items'];
    $id_str_array = rtrim($id_str_array, ",");
    $id_str_array = explode(',', $id_str_array);
    foreach ($id_str_array as $key => $value) {
        $id_quantity_pair = explode("-", $value); // Uses Hyphen(-) as delimiter to separate product ID from its quantity
        $product_id = $id_quantity_pair[0]; // Get the product ID

        $sqlProduct = "SELECT * FROM products WHERE id='$product_id'";
        $sqlresult2 = mysqli_query($connectToStore, $sqlProduct);
        while ($pp_row = mysqli_fetch_array($sqlresult2)) {

            $tickets .= '<div class="holder">
            <div data-ticket="' . $ticket . '" class="ticket">
                <div class="ticket-left">
                    <span class="product-ticket left-span">' . $pp_row['product_name'] . ' ' . $pp_row['product_platform'] . ' ' . $pp_row['product_type'] . ' ' . $pp_row['product_region'] . '</span>
                    <span class="ticket-no left-span">Ticket No. ' . $row['ticket_id'] . '</span>
                    <span class="order-no left-span">Order No. ' . $row['order_id'] . '</span>
                    <span class="left-span">Transaction No. ' . $rowTr['txn_id'] . '</span>
                    <span class="product-region left-span">Region: ' . $pp_row['product_region'] . '</span>
                </div>
                <div class="ticket-right">
                    <span class="created">Created: ' . $row['date'] . '</span>
                </div>
                <div class="ticket-bottom">
                    <div class="bottom-holder">
                        <span class="details"><span class="subject-txt">Category: </span>' . $row['category'] . '</span>
                        <span class="details"><span class="subject-txt">Subject: </span>' . $row['subject'] . '</span>
                        <span class="details desc">"' . $row['description'] . '"</span>
                    </div>
                </div>
            </div>
            <div class="removeticketcontainer">
                <span class="removeticket">X</span>
            </div>
         </div>';
            }
        }
    }
}
}

這篇關于嵌套 while 循環只運行一次的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！

• 上一篇：循環時我無法在里面創建 num 行 下一篇：找出數字序列中第一個缺失的數字