Jquery只返回PHP while循环的最后结果


jquery only returning last result of php while loop

下面的代码只抓取PHP while循环中最后一个结果的值。任何/所有的帮助,不胜感激。谢谢!

PHP/HTML/JS:

        <section id="info">
            <?php
                $user = $session->username;
                $q = sprintf("SELECT * FROM mail WHERE UserTo = '%s' ORDER BY SentDate DESC",
                      mysql_real_escape_string($user));
                $getMail = mysql_query($q, $link) or die(mysql_error());
                if(mysql_num_rows($getMail) == 0) {
                    echo "<p>you have no mail</p>";
                }
                else {
                ?>
            <form id="inbox" class="mail">
                <fieldset>
                    <ul>
                        <li style="border: 2px solid purple; width: 100%;">
                            <span style="width: 8%; margin-left: 13%;">Status</span>
                            <span style="width: 15%;">From</span>
                            <span style="width: 45%;">Subject</span>
                            <span style="width: 16%;">Time</span>
                        </li>
                <?php
                        while($mail = mysql_fetch_object($getMail)) {
                            $status         =       $mail->status;
                            $mailId     =       $mail->mail_id;
                            $from           =       $mail->UserFrom;
                            $subject        =       $mail->Subject;
                            $received       =       $mail->SentDate;
                            $theMessage =       $mail->Message;
                        ?>
                        <li class="outerDiv" style="border: 2px dotted purple;">
                            <button style="display: inline;" class="viewButton">View</button>
                            <button style="display: inline;">Delete</button>
                            <?php
                            echo "<span>" . $mail_id . "</span>";
                            echo "<span style="display: inline-block; width: 8%; border: 1px solid red;'>" . $status . "</span>";
                            echo "<span style='display: inline-block; width: 15%; border: 1px solid red;'>" . $from . "</span>";
                            echo "<span style='display: inline-block; width: 45%; border: 1px solid red;'>" . $subject . "</span>";
                            echo "<span style='display: inline-block; font-size: x-small; width: 17%; border: 1px solid red;'>" . $received . "</span>";                    
                            ?>
                        </li>
                <?php   }
                    } ?>
                    </ul>
                </fieldset>
            </form>
        </section>
        <section id="details">
            <div class="theMessage" style="display: none;"><?php echo $theMessage; ?></div>
            <script type="text/javascript">
                $(document).ready(function() {
                    $(".outerDiv").click(function(e) {
                        if($(e.target).is(".viewButton")) {
                        $(".theMessage").fadeIn(1000);
                        }
                    });
                    return false;
                });
            </script>
        </section>

当您说"抓取最后一个结果的值"时,我猜您正在谈论以下行?

<div class="theMessage" style="display: none;"><?php echo $theMessage; ?></div>

它在while()循环之外,所以是的,$theMessage将只保留循环的最后一个值。

看到你如何在else块内开始<form>,但在else块外关闭</form>,我猜你过早地结束了whileif-else

首先你的代码中有一个语法错误。HTML中转义双引号或使用单引号

你使用的是什么javascript库?看起来可能是JQuery?

如果期望选择器返回一个数组,则需要使用迭代器对每个元素进行操作。试试每个迭代器函数:http://api.jquery.com/each/

$('.outerDiv').each(function() {
    this.click( function(e) {....