global $wpdb; $categoriesData = $wpdb->get_results("SELECT c.*,ct.* FROM {$wpdb->prefix}terms as c JOIN {$wpdb->prefix}term_taxonomy as ct ON c.term_id=ct.term_id WHERE ct.taxonomy='category' "); foreach($categoriesData as $key=>$category) { echo $category->name; }
All posts by Pramod T P
WordPress Query to fetch the subcategories
<?php global $wpdb; $cat="2"//Parent category id $categoriesData = $wpdb->get_results("SELECT c.*,ct.* FROM {$wpdb->prefix}terms as c JOIN {$wpdb->prefix}term_taxonomy as ct ON c.term_id=ct.term_id WHERE ct.taxonomy='category' AND ct.parent ='$cat' "); ?>
WordPress query to fetch the pages
<?php global $wpdb; $querystr = " SELECT distinct(post_title) ,ID,post_title FROM $wpdb->posts WHERE post_type='page' AND post_status='publish' "; $pageposts = $wpdb->get_results($querystr, OBJECT); ?>
WordPress query to fetch the posts
<?php global $wpdb; $querystr = " SELECT distinct(post_title) ,ID,post_title FROM $wpdb->posts WHERE post_type='post' AND post_status='publish' "; $pageposts = $wpdb->get_results($querystr, OBJECT); ?>
WordPresss query to fetch the posts under the given categories
<?php global $wpdb; $const="4,8,7"; //category Ids $querystr = "SELECT distinct(wposts.post_title),wposts.ID 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) WHERE $wpdb->term_taxonomy.taxonomy = 'category' AND $wpdb->term_taxonomy.term_id IN($const) ORDER BY rand() "; $pageposts = $wpdb->get_results($querystr, OBJECT); ?>
Find out the IP address – PHP
<?php echo $_SERVER['REMOTE_ADDR'] ?>
Find out the previous page – PHP
<?php echo $_SERVER['HTTP_REFERER'] //will return the previous page ?>
How to find out the difference between two given dates – PHP
<?php $startDate=explode("-", "02-08-2010"); $endDate=explode("-", "26-04-2007"); echo gregoriantojd($startDate[1], $startDate[0], $startDate[2]) - gregoriantojd($endDate[1], $endDate[0], $endDate[2]); //1194 ?>
How to disable error reporting in php?
<?php error_reporting(0);// Will not report any error error_reporting(-1);// Shows all errors ?>
Limits the maximum execution time – PHP
<?php set_time_limit(2); // // If the value is "0" , it will rum for unknown time ?>