{"id":11628,"date":"2009-07-09T22:41:51","date_gmt":"2009-07-09T20:41:51","guid":{"rendered":"https:\/\/mamchenkov.net\/blog\/?p=188"},"modified":"2009-07-09T22:41:51","modified_gmt":"2009-07-09T20:41:51","slug":"learning-wordpress-files-and-database","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2009\/07\/09\/learning-wordpress-files-and-database\/","title":{"rendered":"Learning WordPress : files and database"},"content":{"rendered":"\n

There are a numerous blog posts and forum discussion about WordPress.\u00a0 However you can read all of them back and forward and still not know how the system works.\u00a0 If you seek the real understanding of WordPress, there are two and two things only that you need to go through : its database scheme<\/strong> and its source code files<\/strong>.\u00a0 And it’s not as hard as it might seem.<\/p>\n

While you can download WordPress source code<\/a> and go through each file using your preferred text editor or programming IDE, that might not be the best of fastest way to learn it.\u00a0 Instead, I’d recommend a web-based interfac<\/a>e available at PHPXref.com .\u00a0 It might not necessarily have the latest version of WordPress, but usually it’s not that far behind.\u00a0 For example, it currently features WordPress 2.7, with WordPress 2.8.1 being the latest version available for download.<\/p>\n

\"WordPress<\/a>
WordPress at PHPXref.com<\/figcaption><\/figure>\n

The coolest things about such an interface are syntax highlighting and cross-reference within WordPress source code, as well as links to PHP manual for native functions.<\/p>\n

\"WordPress<\/a>
WordPress database scheme (ERD)<\/figcaption><\/figure>\n

As for the database, you have three things going for you here.\u00a0 Firstly, WordPress database scheme is very small, simple and straightforward. It’s only 10 tables<\/strong> with just a few fields each.\u00a0 Secondly, it’s very well documented<\/a>.\u00a0 And thirdly, when you do a fresh installation of WordPress, you have some sample data in your database, which helps to understand what goes where.\u00a0 You’ll find one post and one page (to see the difference), one comment (to see how those are linked to posts), one category, one user, and a few links in the blogroll.\u00a0 Just inspecting that fresh database will clear up your head and sort things out.<\/p>\n

Spending a few minutes going through the source code and understanding the database scheme is very worth it.\u00a0 Firstly, you’ll better understand what WordPress can and cannot do.\u00a0 Secondly, you’ll get inspired (that I can pretty much guarantee you).\u00a0 Thirdly, you will automatically get the understanding of how almost each and every WordPress plugin works.\u00a0 Not in details, but you’ll be able to reverse engineer them in your head easily.\u00a0 And fourthly, you’ll become much more efficient with WordPress customizations – you’ll just know where to put things and how to better change stuff.<\/p>\n\n","protected":false},"excerpt":{"rendered":"\n

There are a numerous blog posts and forum discussion about WordPress.\u00a0 However you can read all of them back and forward and still not know how the system works.\u00a0 If you seek the real understanding of WordPress, there are two and two things only that you need to go through : its database scheme and … Continue reading Learning WordPress : files and database<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_links_to":"","_links_to_target":""},"categories":[1,62,60],"tags":[1905],"keyring_services":[],"class_list":["post-11628","post","type-post","status-publish","format-standard","hentry","category-general","category-technology","category-wordpress","tag-wordpress-internals"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t