Blog

query($sqlA); $conteggio = 0; setlocale(LC_TIME, 'it_IT'); while($resultA = $queryA->fetch_array()) { $conteggio = $conteggio+1; $sqlMetaDesc = "SELECT * FROM ".$prefisso_tabelle."postmeta WHERE post_id = '".$resultA['ID']."' AND meta_key = '_yoast_wpseo_metadesc'"; $queryMetaDesc = $db->query($sqlMetaDesc); $resultMetaDesc = $queryMetaDesc->fetch_assoc(); $sqlAF = "SELECT meta_value FROM ".$prefisso_tabelle."postmeta WHERE meta_key = '_thumbnail_id' AND post_id = '".$resultA['ID']."'"; $queryAF = $db->query($sqlAF); $numAF = $queryAF->num_rows; $resultAF = $queryAF->fetch_array(); $sqlAF1 = "SELECT meta_value FROM ".$prefisso_tabelle."postmeta WHERE meta_key = '_wp_attached_file' AND post_id = '".$resultAF['meta_value']."'"; $queryAF1 = $db->query($sqlAF1); $resultAF1 = $queryAF1->fetch_array(); ?>
".formattatitoli($resultA['post_title']).""; ?>
".formattatitoli($resultMetaDesc['meta_value'])."
"; echo "
".utf8_encode(strftime("%A, %d %B %Y, %H:%M",strtotime($resultA['post_date'])))."
"; echo "
"; echo ""; ?>
'; echo '
'; //echo '
Categorie del blog:
'; echo '
'; $sqlLA = "SELECT * FROM ".$prefisso_tabelle."term_taxonomy LEFT JOIN ".$prefisso_tabelle."terms ON ".$prefisso_tabelle."term_taxonomy.term_id = ".$prefisso_tabelle."terms.term_id WHERE ".$prefisso_tabelle."term_taxonomy.taxonomy = 'category' AND ".$prefisso_tabelle."term_taxonomy.count > '0' ORDER BY ".$prefisso_tabelle."terms.name ASC"; $queryLA = $db->query($sqlLA); while($resultLA = $queryLA->fetch_array()) { echo "".$resultLA['name']."
"; } echo '
'; echo '
'; ?>