How to compare associative array with result_array in PHP

Question

Need to bind Page drop-down conditionally on base of 'Content' table. Page titles are stored in an associative array and 'Content' table have page code stored in it. Here is the code

Function which return page titles

    public function getPageTitles(){    
     $pageTitles = array("Home"=> "Home", 
              "AboutUs"=> "About Us", //AboutUs will save in database as pageCode
              "Features"=> "Features",
              "ContactUs"=> "Contact Us");

     return $pageTitles;
  }

Function which checks if page have content or not:

public function getPageTitlesWithNoContent()
{
    $pageTitles = $this->getPageTitles();

    $this->db->distinct('pageCode');
        $this->db->select('pageCode');
        $this->db->from('content');
    $this->db->where('status', 1);      
    $data = $this->db->get();

    $queryResult = $data ? $data->result_array() : 0 ;

    $emptyPageTitle = array();

    foreach($pageTitles as $x => $x_value)
    {
        $hasContent = in_array($x, $queryResult);

        if (!$hasContent){ 
         $emptyPageTitle[$x] = $x_value;
        }
    }

    return $emptyPageTitle;
}

This function is returning all page titles.. new to php no idea what is wrong

well how to print it? .. first time working on php code .. not even able to setup a debugger :( — NMathur
– NMathur, Commented Sep 27, 2018 at 16:35
when I used this .. browser is not able to open the page "This site can’t be reached The webpage at localhost/pages might be temporarily down or it may have moved permanently to a new web address." — NMathur
– NMathur, Commented Sep 27, 2018 at 16:46
@TamilvananN print result is "Array ( [0] => Array ( [key] => Home ) [1] => Array ( [key] => ContactUs ) )" .. ok so I need to compare with value . .will try — NMathur
– NMathur, Commented Sep 27, 2018 at 19:18

Volodymir · Accepted Answer · 2018-09-27 16:42:39Z

2

Check name fields in table is same? With Uppercase first char?

Also change your code in this loop:

foreach($pageTitles as $x => $x_value)
{
    if (in_array($x, $queryResult)){ 
     $emptyPageTitle[$x] = $x_value;
    }
}

I remove ! negative in check condition

answered Sep 27, 2018 at 16:42

Volodymir

1099 bronze badges

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

4 Comments

NMathur Over a year ago

sorry .. this comment is not clear to me "Check name fields in table is same? With Uppercase first char?" ..

Volodymir Over a year ago

$pageTitles = array("Home"=> "Home",                "AboutUs"=> "About Us", //AboutUs will save in database as pageCode               "Features"=> "Features",               "ContactUs"=> "Contact Us");

in this array your list name of fields. This names also in you table structure? They are the same? With what do you compare this array?

Volodymir Over a year ago

Provide values of array $queryResult which data you get from query.

NMathur Over a year ago

Array ( [0] => Array ( [key] => Home ) [1] => Array ( [key] => ContactUs )

Tamilvanan · Accepted Answer · 2018-09-28 03:52:40Z

1

@NMathur I think you almost got it. Made some changes for you in that code, Check it.

public function getPageTitlesWithNoContent() {

    $pageTitles = $this->getPageTitles();

    $this->db->select('pageCode');
    $this->db->from('content');
    $this->db->where('status', 1); 
    $this->db->group_by('pageCode');      
    $query = $this->db->get();

    $queryResult = array();

    foreach ($query->result_array() as $row) { // This loop should need to form an array based on query result
       $queryResult[$row['pageCode']] = $row['pageCode'];
    }

    $emptyPageTitle = array_diff_key($pageTitles,$queryResult); // Compares the keys from array1 against the keys from array2 and returns the difference

    return $emptyPageTitle;

}

answered Sep 28, 2018 at 3:52

Tamilvanan

7181 gold badge8 silver badges22 bronze badges

1 Comment

NMathur Over a year ago

Thank you so much for your help and guidance .. I learnt a lot

NMathur · Accepted Answer · 2018-09-27 19:42:22Z

1

As @TamilvananN guided, I printed the queryResult and tried this workaround:

    foreach($pageTitles as $x => $x_value)
        {
            foreach ($queryResult as $item) 
            {
                if (!($x == $item['pageCode'])){ 
                 $emptyPageTitle[$x] = $x_value;
                }
            }
        }

It is working, but as you can see this has loop in a loop .. that can be very costly .. can you please share any fast way to compare the results.

answered Sep 27, 2018 at 19:42

NMathur

8291 gold badge18 silver badges35 bronze badges

Collectives™ on Stack Overflow

How to compare associative array with result_array in PHP

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related