If you are a developer, in some cases you need to get all categories and their IDs. You might start referring to wordpress codex but most likely you will end up with no solution, just like me. Rather than counting on wordpress’s built-in function, you can write your own MySQL query to accomplish this.

MySQL query that pulls all categories from database

';
}

?>

$table_prefix is a variable declared in wp-config.php, it carries value “wp_” by default unless you changed the setting. It is your SQL tables’ prefix.

WordPress stores all category, tags, etc in wp_term_taxonomy table so we can load all categories name and ID from there.

What about Pages?

';
}

?>

WordPress stores all pages in wp_posts table, but with post_type set as “page”.

Hope this helps.