php - based on mysql exclude key from array and echo rest

Question

In mysql table i got entries with those keys should be exclude from the array.

How to echo all array keys without those specifed in mysql table?

<?php
    $a = array("1","2","3","4","5","6","7","8");
?>

In table i have entries with key that should be exlude from array

<?php
    $query=mysql_query("SELECT key FROM table");
    while($get=mysql_fetch_array($query)) {
        $k=$get['key'];
    }
?>

Now i need each $k exclude from $a array and echo all others array keys.

Thank you in advance.

Simhachalam Gulla · Accepted Answer · 2015-11-18 14:35:12Z

2

<?php

    $a = array("1","2","3","4","5","6","7","8");

    $query=mysql_query("SELECT key FROM table");
    while($get=mysql_fetch_array($query)) {
        $k=$get['key'];
        // check $k exists in $a array or not
        if(in_array($k, $a)){
            //get array index here
            $i = array_search($k, $a);
            unset($a[$i]); 
        }
    }
    print_r($a);

?>

It will print array values which are not found in table

answered Nov 18, 2015 at 14:35

Simhachalam Gulla

9881 gold badge7 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kristian Vitozev · Accepted Answer · 2015-11-18 14:31:18Z

0

You can use PHP's in_array function to check if current key exists in array.

if( in_array($get['key'], $a) ) {
    continue; // if key exists in $a, skip current iteration
}

answered Nov 18, 2015 at 14:31

Kristian Vitozev

5,9716 gold badges38 silver badges56 bronze badges

Collectives™ on Stack Overflow

php - based on mysql exclude key from array and echo rest

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related