My if is not working as expected

Question

$mt = $conn->query("SELECT entry_type FROM myTable")->fetchAll();

foreach ($mt as $FB) {

if ($FB['entry_type'] == 'pagina'){ 
    echo '<meta property="og:type" content="website">';
} else{
    echo '<meta property="og:type" content="article">';
    echo '<meta property="article:author" content="">';
    echo '<meta property="article:publisher" content="">';
    echo '<meta property="article:published_time" content="">';
    echo '<meta property="article:modified_time" content="">';
}

}

The column called "entry_type" has only two possible values: "page" or "post", this code should give echo in meta tag that is on if when the entry_type = pagina, and give echo in meta tags that are on else when the entry_type = post.

This code is duplicating the meta tags according to how many records have the values pagina or post in the column entry_type of my DB. Regardless of whether the page I’m on equals entry_type = pagina or entry_type = post. And this code is also printing the meta tags from if and of else together.

Edit: I solved the duplication problem:

$mt = $conn->query("SELECT entry_type FROM myTable WHERE entry_type IS NOT NULL GROUP BY entry_type")->fetchAll();

foreach ($mt as $FB) {

    if ($FB['entry_type'] == 'pagina'){ 
        echo '<meta property="og:type" content="website">';
    } else{
        echo '<meta property="og:type" content="article">';
        echo '<meta property="article:author" content="">';
        echo '<meta property="article:publisher" content="">';
        echo '<meta property="article:published_time" content="">';
        echo '<meta property="article:modified_time" content="">';
    }

 }

This code is printing the meta tags from if and of else together. Ignoring the instruction of if.

What’s wrong with my code, and how do I fix it?

This is the result of print_r:

$mt = $conn->query("SELECT entry_type FROM myTable WHERE entry_type IS NOT NULL GROUP BY entry_type")->fetchAll();

foreach ($mt as $FB) {
print_r($mt); //Resultado 1

    if ($FB['entry_type'] == 'pagina'){
    print_r($mt); //Resultado 2

        //codigo postado na pergunta

    } else{    
      print_r($mt); //Resultado 3

        //codigo postado na pergunta

    }

} 

• Result 1 :

Array ( [0] => Array ( [entry_type] => page [0] => page ) [1] => Array ( [entry_type] => post [0] => post ) Array ( [0] => Array ( [entry_type] => page [0] => page ) [1] => Array ( [entry_type] => post [0] => post ) )

• Score 2 :

Array ( [0] => Array ( [entry_type] => page [0] => page ) [1] => Array ( [entry_type] => post [0] => post ) )

• Score 3 :

Array ( [0] => Array ( [entry_type] => page [0] => page ) [1] => Array ( [entry_type] => post [0] => post ) )

Answer 1

For his var_dump apparently the first index of its vector $mt has the value null in the column entry_type. In other words, how null is not página he will fall into your else.

For safety I advise you to put one else if in place. Here is an example of how the code would look:

$mt = $conn->query("SELECT entry_type FROM myTable")->fetchAll();

foreach ($mt as $FB) {
    $type = '';
    if ($FB['entry_type'] == 'pagina'){ 
        $type = 'website';
    } else if ($FB['entry_type'] == 'post') {
        $type = 'article';
    }

    if($type == 'website' || $type == 'article') {
      echo '<meta property="og:type" content="'.$type.'">';
      echo '<meta property="article:author" content="">';
      echo '<meta property="article:publisher" content="">';
      echo '<meta property="article:published_time" content="">';
      echo '<meta property="article:modified_time" content="">';
      break;
    }
 }

Answer 2

For you to do this there that you want, you have to pass which key of the associative array will use as value within the traversed array, because the structure that closeAll fera is the following:

Array/Row/Column, for example: Result(0,'entry_type') with page, Result(1,'entry_type') with post, Result(2,'entry_type') with article, and so on and so forth... With this, sinlize in the foreach after the 'as' what you want to use in the array, as below:

$mt = $conn->query("
    SELECT
       entry_type
    FROM myTable
    WHERE
       entry_type = 'pagina'
    GROUP BY
       entry_type");

$res = $mt->fetchAll(PDO::FETCH_ASSOC);

print("<pre>");
print_r($res);
print("</pre>");

foreach ($res as $FB) {
    if ($FB["entry_type"] == "pagina") {
        echo '<meta property="og:type" content="website">';
    } else {
        echo '<meta property="og:type" content="article">';
        echo '<meta property="article:author" content="">';
        echo '<meta property="article:publisher" content="">';
        echo '<meta property="article:published_time" content="">';
        echo '<meta property="article:modified_time" content="">';
    }
}