Question

你好,我试图在php中循环时发挥功能,但无法在这里获得写入是我的代码

 function mail_detail($mail_detail){

    $data= mysql_query("select * from messages where messages.to =  $mail_detail  and to_viewed = 0 ORDER BY messages.id DESC");
    while ($result= mysql_fetch_array($data)){
    return $result;
    }

}

并公布,

$mail_detail= mail_detail($userid)
echo  <li class="read">

               <a href="#">
                 <span class="message"> . $mail_detail[ title ]. </span>
                    <span class="time">
                       January 21, 2012
                   </span>
                                </a>
        </li> ;

i am not getting all values just getting one value please help thx

Answer 1

return 语句正在终止您的循环并退出函数。

要获取全部值,请将其加入循环中的数组,然后返回数组。像这样:

$results = array();

while ($result = mysql_fetch_array($data)) {
    $results[] = $result;   
}

return $results;

接收数组的侧面

$msgArray = mail_detail($mail_detail);

foreach($msgArray as $msg) {
    //use $msg
}

添加一个函数时,函数只能返回一次(除了一些你不应担心的特殊情况之外)。因此,当你的函数第一次遇到一个返回语句时,它返回了数值和退出。

return 的此功能通常可用于您的利益。例如 :

function doSomething($code = NULL) 
{
    if ($code === NULL) {
        return false;
    }

    //any code below this comment will only be reached if $code is not null
    // if it is null, the above returns statement will prevent control from reaching 
    // this point

    writeToDb($code);
}

Answer 2

function mail_detail($mail_detail){
    $returnArr = array();
    $data= mysql_query("select * from messages where messages.to =  $mail_detail  and to_viewed = 0 ORDER BY messages.id DESC");
    while ($result= mysql_fetch_array($data)){
        $returnArr[] = $result;
    }
    return $returnArr;

}

这样您就可以返回所有返回的东西, 因为您将它推入一个数组, 随着循环结束, 整个数组的 wil 将被返回。正如 xbones 所说, 返回会打破您的循环!

Answer 3

harinder,Function(mysql_fetch_array($data)) return an array. That means your $result is an array, so when you recevie the $result at view page you have to extract it using foreach look like this:

foreach($result as $item)
 {
   echo $item->user(<-here you have to write the column name ,that you want to retrieve)
 }

因此您可以在数组中获得全部结果。

友情链接