Question

I m building a php notification system (kinda like facebook s).

It works as should, listing all events the way i want it. but i m trying to get it to understand that if it gets 3+ events on the same post, it will join these events into one notification.

我们现在看着这一点:

User 1 wrote on article-x
User 2 wrote on article-x
user 3 wrote on article-x
user 1 wrote on article-y

instead i want it to be printed like this :

user 1 and  2 others wrote on article-x

Been trying to read up on what i need to do this, but no luck. any pointers greatly appreciated. It s being queried like this:

随附全代码<>。

$sesname = $_SESSION[ user_name ];
$sesid = $_SESSION[ full_name ];
$dbh = new PDO("mysql:host=$hostname;dbname=$db", $username, $password);
$stmt = $dbh->prepare("select * from comments WHERE full_name =  $sesid  and checked = 1  ");
$stmt->bindParam( :full_name , $safe_name, PDO::PARAM_INT, 5);

$stmt->execute();
$result = $stmt -> fetchAll();
foreach( $result as $row ) {
$name = $row[ name ];
$pid = $row[ pid ];
$commentid = $row[ id ];
$fullink = $row[ fullink ];
$datetime = $row[ dt ];

if ($name == $sesname){
} else {
echo "<div id= commentnote ><a href= http://{$fullink} >{$name}</a>kommenterte ditt <a href= {$fullink} >blogginnlegg</a><br><div class= updentry  style= color: red ! important; cursor: pointer; margin-top: -35px; position: absolute; right: 8px; >x</div></div>";
}

}

Tried using your answers underneath, but without luck. Thanks for answering though, i really appreciate it :)

Answer 1

将该条变成一个多层面阵容? (例如,结构并不理想,因为我不知道你拥有和需要什么数据)。)

if(count($post[ comments ]) >= 3) {
   echo $post[ user ][0] ."and". (count($post[ comments ])-1). " others wrote on ..";
} else {
   //Just one 
}

Answer 2

也许你可以建立这样两维阵:

Array
(
    [article-x] => Array
                   (
                       [0] => User1
                       [1] => User2
                   )
    [article-y] => Array
                   (
                       [0] => User1
                   )
)

Answer 3

如果你想在公共卫生和社会福利部中这样做的话,就这样做:

$events = array();
foreach( $result as $row ) {
    if( isset($events[$row[ article ]) ){
        $events[$row[ article ]][ counter ]++;
    }else{
        $row[ counter ] = 0;
        $events[$row[ article ]] = $row;
    }
}

foreach( $events as $event ){
    echo "<div id= commentnote >{$event[ user ]}".($event[ counter ]?  and  .$event[ counter ].  others :  )." wrote on {$event[ article ]}</div>";
}

友情链接