Need to edit homepage via phpMyAdmin. How do I find the homepage in posts table?

  • My site is malfunctioning due to malware, so while it is being removed I need to edit my homepage. I can’t access my wp-admin, but I can access phpmyadmin, and there I found the table with all my posts (including pages). I searched “home” and I searched the name of my website and I searched words that appear near the top of the page, but I’m not finding the homepage. I have 1500 posts. I can sort by post type, but still … is there a way to find the page without opening all the ones for which there is not a clear name indicating that’s not the one?

    I viewed the source and searched for things like “post-id” and “page”, and found a number (post-id=4002) but that’s not the right number.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Jonathon N

    (@imagiscapeca)

    By the way, I did search and found posts that seemed relevant but were not, like: https://wordpress.stackexchange.com/questions/165374/how-to-get-post-id-of-static-front-page

    Moderator bcworkz

    (@bcworkz)

    From your home page’s HTML body tag, it includes class page-id-4002, indicating 4002 is indeed the correct post ID. It’s likely your front page is composed of more than just post_content. Often a front page template is responsible for much if not all of front page content. Sometimes post_content is not even used at all!

    You might need to alter the template used for your front page in order to see the changes you want. The template file can be any number of possible file names. See Template Hierarchy for all the possibilities.

    Template files are usually a mix of HTML and PHP code. You can usually edit the HTML parts without much worry, but be very careful when editing any PHP code. Very minor syntax errors can cause the entire page to malfunction.

    While the template file is responsible for the page’s HTML content, often most content actually comes from elsewhere. The template code often is merely pulling everything together. So you may need to go elsewhere in the DB to alter front page content. The template code will be your best clue on where you need to go to change something.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Need to edit homepage via phpMyAdmin. How do I find the homepage in posts table?’ is closed to new replies.