Get Instagram Posts Without any API
There is very simple way to pull instagram feeds from any account using “file_get_contents” method of PHP. Here is the demo of the script in […]
Month: January 2018
MySQL Query to Get WordPress Post Categories
Here is pretty straight forward mysql query to get WordPress post categories. I’ve excluded the default Uncategorized category.
|
1 2 3 4 |
SELECT wt.*, wtt.taxonomy FROM wp_terms wt inner join wp_term_relationships wtr on wtr.term_taxonomy_id = wt.term_id inner join wp_term_taxonomy wtt on wtt.term_taxonomy_id = wtr.term_taxonomy_id where wt.term_id <> 1 and wtr.object_id = 1 |
“wt.term_id 1″ to exclude Uncategorized Category […]