php - 我在 foreach 里面的 foreach 中得到一个空表：php

Question

当用户在一个表单中添加多个学校时，例如 3 个，会出现另一个表单，其中包含 3 行包含这 3 个学校的信息，最后我将两个表单的内容添加到两个表中。

首先，wp_mairie_details我添加了用户的信息。在第二个表中，我添加了学校的信息。

我想在表单中显示最后添加的学校的用户列表。我的第一个循环显示正确，但第二个循环显示正确的学校数量，但我得到一个空表。

        <?php               
            foreach ( $dump_ecoles_classes_1 as $i => $ecoles_classe ) {
        ?>
        <div class="abonn_style">
            <span class="span_abonn_style">Nomde la mairie :</span><br>
            <input type="text" name="nom_mairie" value="<?php echo  $dump_ecoles_classes_1[$i]['nom_mairie']; ?>" disabled class="span_abonn_style"> 
            <br>
            <span class="span_abonn_style">Adresse:</span><br>
            <textarea rows="4" cols="50" name="adress"  value="<?php echo   $dump_ecoles_classes_1[$i]['adress']; ?>" disabled class="span_abonn_style">
                </textarea>
            <br> 
            <span class="span_abonn_style">Responsable du projet:</span><br>
            <input type="text" class="span_abonn_style" name="responsable" value="<?php echo    $dump_ecoles_classes_1[$i]['responsable']; ?>" disabled>

            <br>
            <span class="span_abonn_style">E-mail:</span><br>
            <input type="email" class="span_abonn_style" name="email" value="<?php echo $dump_ecoles_classes_1[$i]['email']; ?>" disabled>   
            <br>
            <span class="span_abonn_style">Nombre de ecoles:</span><br>
            <input type="number" name="ecoles" class="span_abonn_style" value="<?php echo   $dump_ecoles_classes_1[$i]['ecoles']; ?>" disabled >

            <br>


            <?php 

            $i_var = $dump_ecoles_classes_1[$i]['ecoles'];

            $mairie_ecoles_row = $wpdb->get_results("SELECT DISTINCT me.nom_ecole_mairie,me.responsable_mairie,me.email_mairie,me.nbr_classes_mairie,me.nbr_eleves_mairie,me.id_user FROM wp_mairie_ecoles me 
            INNER JOIN wp_mairie_details md ON md.id_user = me.id_user 
            INNER JOIN wp_pmpro_membership_orders mo ON mo.user_id = md.id_user 
            where me.id_user = '".$dump_ecoles_classes_1[$i]['id_user']."'
            order by md.id_user");


            $row_mairie_ecoles = objectToArray($mairie_ecoles_row);



            foreach ( $row_mairie_ecoles as $k => $row_mairie_ecole ) {
            ?>
            <table class="trios_table">
            <tr class="trios_tr_style">
                <th style="border: 2px solid black!important;background: #e4e4e4;">Nom de l’école
                </th>                                       
                <th style="border: 2px solid black!important;background: #e4e4e4;">responsable
                </th>                                     
                <th style="border: 2px solid black!important;background: #e4e4e4;">email
                </th>                                       
                <th style="border: 2px solid black!important;background: #e4e4e4;">Nbre/classes
                </th> 
                <th style="border: 2px solid black!important;background: #e4e4e4;">Nbre/élèves
                </th> 
            </tr>

            <tr class="trios_tr_style">
                <td class="trios_td_style trios_td_style_1 ">
                <?php   
                echo    $row_mairie_ecoles[$k]['nom_ecole_mairie'];

                ?>
                </td>
                <td class="trios_td_style trios_td_style_1 ">
                <?php 
                    echo    $row_mairie_ecoles[$k]['responsable_mairie'];

                ?>
                </td>
                <td class="trios_td_style trios_td_style_1 ">
                <?php 
                    echo    $row_mairie_ecoles[$k]['email_mairie'];
                ?>
                </td>
                <td class="trios_td_style trios_td_style_1 ">
                <?php 
                    echo    $row_mairie_ecoles[$k]['nbr_classes_mairie'];
                ?>
                </td>
                <td class="trios_td_style trios_td_style_1 ">
                <?php 
                    echo    $row_mairie_ecolesrow_mairie_ecoles[$k]['nbr_eleves_mairie'];
                    ?>
                </td>
            </tr>

        </table>
        <?php   // } ?>

        </div>
        <?php } ?>
    </div>

标签： phpmysql

Answer 1

尝试这个

<?php               
            foreach ( $dump_ecoles_classes_1 as $i => $ecoles_classe ) {
        ?>
        <div class="abonn_style">
            <span class="span_abonn_style">Nomde la mairie :</span><br>
            <input type="text" name="nom_mairie" value="<?php echo  $dump_ecoles_classes_1[$i]['nom_mairie']; ?>" disabled class="span_abonn_style"> 
            <br>
            <span class="span_abonn_style">Adresse:</span><br>
            <textarea rows="4" cols="50" name="adress"  value="<?php echo   $dump_ecoles_classes_1[$i]['adress']; ?>" disabled class="span_abonn_style">
                </textarea>
            <br> 
            <span class="span_abonn_style">Responsable du projet:</span><br>
            <input type="text" class="span_abonn_style" name="responsable" value="<?php echo    $dump_ecoles_classes_1[$i]['responsable']; ?>" disabled>

            <br>
            <span class="span_abonn_style">E-mail:</span><br>
            <input type="email" class="span_abonn_style" name="email" value="<?php echo $dump_ecoles_classes_1[$i]['email']; ?>" disabled>   
            <br>
            <span class="span_abonn_style">Nombre de ecoles:</span><br>
            <input type="number" name="ecoles" class="span_abonn_style" value="<?php echo   $dump_ecoles_classes_1[$i]['ecoles']; ?>" disabled >

            <br>


            <?php 

            $i_var = $dump_ecoles_classes_1[$i]['ecoles'];

            $mairie_ecoles_row = $wpdb->get_results("SELECT DISTINCT me.nom_ecole_mairie,me.responsable_mairie,me.email_mairie,me.nbr_classes_mairie,me.nbr_eleves_mairie,me.id_user FROM wp_mairie_ecoles me 
            INNER JOIN wp_mairie_details md ON md.id_user = me.id_user 
            INNER JOIN wp_pmpro_membership_orders mo ON mo.user_id = md.id_user 
            where me.id_user = '".$dump_ecoles_classes_1[$i]['id_user']."'
            order by md.id_user");


            $row_mairie_ecoles = objectToArray($mairie_ecoles_row);

            foreach ( $row_mairie_ecoles as $k => $row_mairie_ecole ) {
            ?>
            <table class="trios_table">
            <tr class="trios_tr_style">
                <th style="border: 2px solid black!important;background: #e4e4e4;">Nom de l’école
                </th>                                       
                <th style="border: 2px solid black!important;background: #e4e4e4;">responsable
                </th>                                     
                <th style="border: 2px solid black!important;background: #e4e4e4;">email
                </th>                                       
                <th style="border: 2px solid black!important;background: #e4e4e4;">Nbre/classes
                </th> 
                <th style="border: 2px solid black!important;background: #e4e4e4;">Nbre/élèves
                </th> 
            </tr>

            <tr class="trios_tr_style">
                <td class="trios_td_style trios_td_style_1 ">
                <?php   
                echo    $row_mairie_ecoles[$k]['nom_ecole_mairie'];
                ?>
                </td>
                <td class="trios_td_style trios_td_style_1 ">
                <?php 
                    echo    $row_mairie_ecoles[$k]['responsable_mairie'];

                ?>
                </td>
                <td class="trios_td_style trios_td_style_1 ">
                <?php 
                    echo    $row_mairie_ecoles[$k]['email_mairie'];
                ?>
                </td>
                <td class="trios_td_style trios_td_style_1 ">
                <?php 
                    echo    $row_mairie_ecoles[$k]['nbr_classes_mairie'];
                ?>
                </td>
                <td class="trios_td_style trios_td_style_1 ">
                <?php 
                    echo    $row_mairie_ecolesrow_mairie_ecoles[$k]['nbr_eleves_mairie'];
                    ?>
                </td>
            </tr>

        </table>
        <?php    } ?>

        </div>
        <?php } ?>
    </div>