<?php
$dVar=new JConfig();
mysql_connect($dVar->host,$dVar->user,$dVar->password);
mysql_select_db($dVar->db);
$articleResult = mysql_fetch_assoc(mysql_query(“SELECT * FROM “.$dVar->dbprefix.”content WHERE id='”.$_REQUEST[‘id’].”‘ “)) or die(mysql_error());
echo $articleName = $articleResult[‘title’]
?>
<?php if(JRequest::getVar(‘view’) == “frontpage” ) { ?>
Home page
<?php } else { ?>
Inner Page
<?php }; ?>
<?php
if(JRequest::getVar(‘view’) == ‘featured’ ) :
echo ‘ Home page’;
else :
echo ‘Inner page’;
endif;
?>
<jdoc:include type=”modules” name=”POSITION-NAME” />
Example : <jdoc:include type=”modules” name=”position1″ />
The above mentioned code will load all the modules that are assigned to the position “position1”
<?php
$postQuery = “SELECT distinct(wposts.post_title),cast(wpostmeta.meta_key as DATE),wposts.ID,wposts.post_content,wposts.post_date,wposts.comment_count
FROM $wpdb->posts wposts
LEFT JOIN $wpdb->term_relationships ON (wposts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
LEFT JOIN $wpdb->postmeta AS wpostmeta ON wposts.ID = wpostmeta.post_id
WHERE wpostmeta.meta_key = ‘dvd_release_date’ AND $wpdb->term_taxonomy.taxonomy = ‘category’ AND $wpdb->term_taxonomy.term_id IN(‘3952’)
ORDER BY wpostmeta.meta_value DESC LIMIT $itemPerPage”;
$postResults = $wpdb->get_results($postQuery, OBJECT);
foreach( $postResults as $post ) {
echo $post->post_title;
}
?>
<?php echo $this->baseurl ?>
<?php echo JURI::base(); ?>
Zend | Magento Certified PHP | eCommerce Architect
Pramod T P 