Remove duplicate from foreach php












0















I have already tried array_unique but not getting the desired results.



Here is the db structure:



enter image description here



Here is what i have tried but getting the same 'user 1' two times it should be one .



$stmt = $db_con->query("SELECT sender,recipient, content, sending_time
FROM messages AS sender
WHERE (sender='admin' OR recipient='admin')
GROUP BY sender,recipient
ORDER BY sending_time DESC
");

$stmt->execute();
foreach ($stmt as $key => $value) {

if ($value['sender'] == 'admin') {
$my = $value['recipient'];
} else if ($value['recipient'] == 'admin') {
$my = $value['sender'];
} else {
$my = $value['sender'];
}
if (!in_array($my, explode(' ', $my))) {
echo '<a href="javascript:void(0)" class="list-group-item p10 b0 b-rad-0">
<div class="online-users pull-left mr5">
<img src="../uploads/userprofile/default/avatar.jpg" onerror="this.onerror=null;imgDefault(this);" alt="avatar" class="online-users-img">
<span title="online"></span>
</div>
<strong class="text-primary h4 mb2">' . $my . '<small class="pull-right">OCT 23</small></strong>
<div><small class="text-muted">asdasdajkasdhjgjhgjhgjhgjghjgjgggggggggggggsdfsdf...</small></div>
</a>';

}
}


here is the data from db using the following:



$sddsf = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($sddsf);

Array ( [0] => Array (
[sender] => 2224
[recipient] => admin
[content] => sad
[sending_time] => 1536513903 )
[1] => Array (
[sender] => admin
[recipient] => user1
[content] => def
[sending_time] => 1536513874 )
[2] => Array (
[sender] => user1
[recipient] => admin
[content] => abc
[sending_time] => 1536513532 ) ))









share|improve this question

























  • You need to tell us what consitutes "unique". Reading your code, it looks like it might be the sender but that seems a bit weird. There is a lot wrong with this code. It looks as if you intended to use $sddsf to track which records you wrote out - but you never assign any values to the array.

    – symcbean
    Nov 21 '18 at 11:14











  • @symcbean thanks for pointing that out basically i am getting two 'user1' and i want to show only one of them (does 't matter which one ) .I have updated the code please take a look.

    – MR_AMDEV
    Nov 21 '18 at 11:26











  • The problem is if i place to remove 'user1' it removes all of the results related with user1 but on placing $my1 it removes all

    – MR_AMDEV
    Nov 21 '18 at 11:28











  • You'll also make it a lot easier for people to help you if you use a recognisable code style. PSR-2 for preference.

    – symcbean
    Nov 21 '18 at 12:46
















0















I have already tried array_unique but not getting the desired results.



Here is the db structure:



enter image description here



Here is what i have tried but getting the same 'user 1' two times it should be one .



$stmt = $db_con->query("SELECT sender,recipient, content, sending_time
FROM messages AS sender
WHERE (sender='admin' OR recipient='admin')
GROUP BY sender,recipient
ORDER BY sending_time DESC
");

$stmt->execute();
foreach ($stmt as $key => $value) {

if ($value['sender'] == 'admin') {
$my = $value['recipient'];
} else if ($value['recipient'] == 'admin') {
$my = $value['sender'];
} else {
$my = $value['sender'];
}
if (!in_array($my, explode(' ', $my))) {
echo '<a href="javascript:void(0)" class="list-group-item p10 b0 b-rad-0">
<div class="online-users pull-left mr5">
<img src="../uploads/userprofile/default/avatar.jpg" onerror="this.onerror=null;imgDefault(this);" alt="avatar" class="online-users-img">
<span title="online"></span>
</div>
<strong class="text-primary h4 mb2">' . $my . '<small class="pull-right">OCT 23</small></strong>
<div><small class="text-muted">asdasdajkasdhjgjhgjhgjhgjghjgjgggggggggggggsdfsdf...</small></div>
</a>';

}
}


here is the data from db using the following:



$sddsf = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($sddsf);

Array ( [0] => Array (
[sender] => 2224
[recipient] => admin
[content] => sad
[sending_time] => 1536513903 )
[1] => Array (
[sender] => admin
[recipient] => user1
[content] => def
[sending_time] => 1536513874 )
[2] => Array (
[sender] => user1
[recipient] => admin
[content] => abc
[sending_time] => 1536513532 ) ))









share|improve this question

























  • You need to tell us what consitutes "unique". Reading your code, it looks like it might be the sender but that seems a bit weird. There is a lot wrong with this code. It looks as if you intended to use $sddsf to track which records you wrote out - but you never assign any values to the array.

    – symcbean
    Nov 21 '18 at 11:14











  • @symcbean thanks for pointing that out basically i am getting two 'user1' and i want to show only one of them (does 't matter which one ) .I have updated the code please take a look.

    – MR_AMDEV
    Nov 21 '18 at 11:26











  • The problem is if i place to remove 'user1' it removes all of the results related with user1 but on placing $my1 it removes all

    – MR_AMDEV
    Nov 21 '18 at 11:28











  • You'll also make it a lot easier for people to help you if you use a recognisable code style. PSR-2 for preference.

    – symcbean
    Nov 21 '18 at 12:46














0












0








0








I have already tried array_unique but not getting the desired results.



Here is the db structure:



enter image description here



Here is what i have tried but getting the same 'user 1' two times it should be one .



$stmt = $db_con->query("SELECT sender,recipient, content, sending_time
FROM messages AS sender
WHERE (sender='admin' OR recipient='admin')
GROUP BY sender,recipient
ORDER BY sending_time DESC
");

$stmt->execute();
foreach ($stmt as $key => $value) {

if ($value['sender'] == 'admin') {
$my = $value['recipient'];
} else if ($value['recipient'] == 'admin') {
$my = $value['sender'];
} else {
$my = $value['sender'];
}
if (!in_array($my, explode(' ', $my))) {
echo '<a href="javascript:void(0)" class="list-group-item p10 b0 b-rad-0">
<div class="online-users pull-left mr5">
<img src="../uploads/userprofile/default/avatar.jpg" onerror="this.onerror=null;imgDefault(this);" alt="avatar" class="online-users-img">
<span title="online"></span>
</div>
<strong class="text-primary h4 mb2">' . $my . '<small class="pull-right">OCT 23</small></strong>
<div><small class="text-muted">asdasdajkasdhjgjhgjhgjhgjghjgjgggggggggggggsdfsdf...</small></div>
</a>';

}
}


here is the data from db using the following:



$sddsf = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($sddsf);

Array ( [0] => Array (
[sender] => 2224
[recipient] => admin
[content] => sad
[sending_time] => 1536513903 )
[1] => Array (
[sender] => admin
[recipient] => user1
[content] => def
[sending_time] => 1536513874 )
[2] => Array (
[sender] => user1
[recipient] => admin
[content] => abc
[sending_time] => 1536513532 ) ))









share|improve this question
















I have already tried array_unique but not getting the desired results.



Here is the db structure:



enter image description here



Here is what i have tried but getting the same 'user 1' two times it should be one .



$stmt = $db_con->query("SELECT sender,recipient, content, sending_time
FROM messages AS sender
WHERE (sender='admin' OR recipient='admin')
GROUP BY sender,recipient
ORDER BY sending_time DESC
");

$stmt->execute();
foreach ($stmt as $key => $value) {

if ($value['sender'] == 'admin') {
$my = $value['recipient'];
} else if ($value['recipient'] == 'admin') {
$my = $value['sender'];
} else {
$my = $value['sender'];
}
if (!in_array($my, explode(' ', $my))) {
echo '<a href="javascript:void(0)" class="list-group-item p10 b0 b-rad-0">
<div class="online-users pull-left mr5">
<img src="../uploads/userprofile/default/avatar.jpg" onerror="this.onerror=null;imgDefault(this);" alt="avatar" class="online-users-img">
<span title="online"></span>
</div>
<strong class="text-primary h4 mb2">' . $my . '<small class="pull-right">OCT 23</small></strong>
<div><small class="text-muted">asdasdajkasdhjgjhgjhgjhgjghjgjgggggggggggggsdfsdf...</small></div>
</a>';

}
}


here is the data from db using the following:



$sddsf = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($sddsf);

Array ( [0] => Array (
[sender] => 2224
[recipient] => admin
[content] => sad
[sending_time] => 1536513903 )
[1] => Array (
[sender] => admin
[recipient] => user1
[content] => def
[sending_time] => 1536513874 )
[2] => Array (
[sender] => user1
[recipient] => admin
[content] => abc
[sending_time] => 1536513532 ) ))






php mysql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 21 '18 at 16:51









Nesku

4231412




4231412










asked Nov 21 '18 at 10:58









MR_AMDEVMR_AMDEV

166112




166112













  • You need to tell us what consitutes "unique". Reading your code, it looks like it might be the sender but that seems a bit weird. There is a lot wrong with this code. It looks as if you intended to use $sddsf to track which records you wrote out - but you never assign any values to the array.

    – symcbean
    Nov 21 '18 at 11:14











  • @symcbean thanks for pointing that out basically i am getting two 'user1' and i want to show only one of them (does 't matter which one ) .I have updated the code please take a look.

    – MR_AMDEV
    Nov 21 '18 at 11:26











  • The problem is if i place to remove 'user1' it removes all of the results related with user1 but on placing $my1 it removes all

    – MR_AMDEV
    Nov 21 '18 at 11:28











  • You'll also make it a lot easier for people to help you if you use a recognisable code style. PSR-2 for preference.

    – symcbean
    Nov 21 '18 at 12:46



















  • You need to tell us what consitutes "unique". Reading your code, it looks like it might be the sender but that seems a bit weird. There is a lot wrong with this code. It looks as if you intended to use $sddsf to track which records you wrote out - but you never assign any values to the array.

    – symcbean
    Nov 21 '18 at 11:14











  • @symcbean thanks for pointing that out basically i am getting two 'user1' and i want to show only one of them (does 't matter which one ) .I have updated the code please take a look.

    – MR_AMDEV
    Nov 21 '18 at 11:26











  • The problem is if i place to remove 'user1' it removes all of the results related with user1 but on placing $my1 it removes all

    – MR_AMDEV
    Nov 21 '18 at 11:28











  • You'll also make it a lot easier for people to help you if you use a recognisable code style. PSR-2 for preference.

    – symcbean
    Nov 21 '18 at 12:46

















You need to tell us what consitutes "unique". Reading your code, it looks like it might be the sender but that seems a bit weird. There is a lot wrong with this code. It looks as if you intended to use $sddsf to track which records you wrote out - but you never assign any values to the array.

– symcbean
Nov 21 '18 at 11:14





You need to tell us what consitutes "unique". Reading your code, it looks like it might be the sender but that seems a bit weird. There is a lot wrong with this code. It looks as if you intended to use $sddsf to track which records you wrote out - but you never assign any values to the array.

– symcbean
Nov 21 '18 at 11:14













@symcbean thanks for pointing that out basically i am getting two 'user1' and i want to show only one of them (does 't matter which one ) .I have updated the code please take a look.

– MR_AMDEV
Nov 21 '18 at 11:26





@symcbean thanks for pointing that out basically i am getting two 'user1' and i want to show only one of them (does 't matter which one ) .I have updated the code please take a look.

– MR_AMDEV
Nov 21 '18 at 11:26













The problem is if i place to remove 'user1' it removes all of the results related with user1 but on placing $my1 it removes all

– MR_AMDEV
Nov 21 '18 at 11:28





The problem is if i place to remove 'user1' it removes all of the results related with user1 but on placing $my1 it removes all

– MR_AMDEV
Nov 21 '18 at 11:28













You'll also make it a lot easier for people to help you if you use a recognisable code style. PSR-2 for preference.

– symcbean
Nov 21 '18 at 12:46





You'll also make it a lot easier for people to help you if you use a recognisable code style. PSR-2 for preference.

– symcbean
Nov 21 '18 at 12:46












1 Answer
1






active

oldest

votes


















0














//Find duplicates 

$arr_data = array(
'one',
'two',
'Three',
'Four',
'Five',
'Six',
'Seven',
'Eight',
'Nine'
);
$unique_data = array_unique($arr_data);
$dup= array_diff_key( $arr_data, $unique_data);
array_count_values($dup);





share|improve this answer























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53410646%2fremove-duplicate-from-foreach-php%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    //Find duplicates 

    $arr_data = array(
    'one',
    'two',
    'Three',
    'Four',
    'Five',
    'Six',
    'Seven',
    'Eight',
    'Nine'
    );
    $unique_data = array_unique($arr_data);
    $dup= array_diff_key( $arr_data, $unique_data);
    array_count_values($dup);





    share|improve this answer




























      0














      //Find duplicates 

      $arr_data = array(
      'one',
      'two',
      'Three',
      'Four',
      'Five',
      'Six',
      'Seven',
      'Eight',
      'Nine'
      );
      $unique_data = array_unique($arr_data);
      $dup= array_diff_key( $arr_data, $unique_data);
      array_count_values($dup);





      share|improve this answer


























        0












        0








        0







        //Find duplicates 

        $arr_data = array(
        'one',
        'two',
        'Three',
        'Four',
        'Five',
        'Six',
        'Seven',
        'Eight',
        'Nine'
        );
        $unique_data = array_unique($arr_data);
        $dup= array_diff_key( $arr_data, $unique_data);
        array_count_values($dup);





        share|improve this answer













        //Find duplicates 

        $arr_data = array(
        'one',
        'two',
        'Three',
        'Four',
        'Five',
        'Six',
        'Seven',
        'Eight',
        'Nine'
        );
        $unique_data = array_unique($arr_data);
        $dup= array_diff_key( $arr_data, $unique_data);
        array_count_values($dup);






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 21 '18 at 11:13









        sharad shindesharad shinde

        11




        11
































            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53410646%2fremove-duplicate-from-foreach-php%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Guess what letter conforming each word

            Port of Spain

            Run scheduled task as local user group (not BUILTIN)