这段代码根据我在entry_type
列上有多少数据来复制元标记,无论entry_type
是我所在页面的post
还是pagina
。它打印出来自if
和else
的meta
标签。
$mt = $conn->query("SELECT entry_type FROM bn_publicacao")->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="">';
}
}
编辑:我解决了副本的问题
$mt = $conn->query("SELECT entry_type FROM bn_publicacao 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="">';
}
}
但是我仍然有一个问题,if
和else
同时打印出来。
来自print_r
的结果
$mt = $conn->query("SELECT entry_type FROM bn_publicacao WHERE entry_type IS NOT NULL GROUP BY entry_type")->fetchAll();
foreach ($mt as $FB) {
print_r($mt); //Result 1
if ($FB['entry_type'] == 'pagina'){
print_r($mt); //Result 2
//code posted on the question
} else{
print_r($mt); //Result 3
//code posted on the question
}
}
阵列( =>阵列( entry_type =>页面=>页面)1 =>阵列( entry_type => post => post ))阵列( =>阵列( entry_type =>页面=>页面)1 =>阵列( entry_type => post => post ))
阵列( =>阵列( entry_type =>页面和=>页面)1 =>阵列( entry_type => post和=> post ))
阵列( =>阵列( entry_type =>页面和=>页面)1 =>阵列( entry_type => post和=> post ))
我的代码出了什么问题?我怎么才能解决它呢?
发布于 2018-09-26 02:50:10
fetchColumn
只返回一个结果,即fetchColumn。您可以使用fetchAll,它以数组的形式返回所有结果。
您需要遍历结果,因为它将是一个数组。代码如下:
$mtFBs = $conn->query("SELECT entry_type FROM bn_publicacao")->fetchAll();
foreach ($mtFbs as $mtFb) {
if ($mtFB['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="">';
}
}
https://stackoverflow.com/questions/52504823
复制相似问题