<?php $testArray = array('Test1', 'Test2', 'Test3'); $testString = implode(",", $testArray); echo $testString; // Test1,Test2,Test3 ?>
Tag Archives: PHP
Remove null values from an array – PHP
<?php $testArray = array('Test1', 'Test2', ''); print_r( array_filter($testArray)); // Array ( [0] => Test1 [1] => Test2 ) ?>
Remove duplicate entries from an array – PHP
<?php $testArray = array('Test1', 'Test2', 'Test1'); print_r( array_unique($testArray)); // Array ( [0] => Test1 [1] => Test2 ) ?>
Find out the number of elements in an array – PHP
<?php $testArray = array('Test1', 'Test2', 'Test1'); echo( count($testArray)); // 3 echo( sizeof($testArray)); // 3 ?>
Find out the length of a string – PHP
<?php echo $length = strlen("Efforts"); // 7 ?>
WordPress Query to fetch the Categories
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; }
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); ?>