database columns: post_title vs post_name
it’s the URL encoded version of your text. <?php echo urldecode(‘%d7%90%d7%90%d7%90’); ?> outputs: אאא post_name is the slug, so the characters have to be URL-safe.
database
migrate comments from old database to new database
You could export all of the posts from your old site, including comments. Then, import them into your new site and delete the posts you don’t want. This will preserve all of the links between posts and comments.
Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?
This question has been discussed several times on the WordPress Hackers email list, I’d recommend Googling something like wp-hackers absolute relative to get an overview of the various lively debates that have taken place over the years. Personally I use the searchreplacedb2 script whenever I migrate a database between URLs, e.g. from live to local/test/dev.
Custom search page and search by title, content and tag
Search in WordPress is complicated matter because: WP doesn’t do it very well out of the box People tend to have varied expectations of how precisely search should work Even light (from human perspective) requirements for search tend to translate in complicated and involved code Building search from scratch is involved (I know because I … Read more
Database for development
I think you are looking for the Theme Unit Test data: http://codex.wordpress.org/Theme_Unit_Test Download the .xml file and import with the WordPress importer plugin, and you should be good to go.
What are terms and taxonomy, how they related to post and how these three are stored in database?
What are the terms and taxonomy in wordpress? From WordPress.org’s Taxonomy Codex… In WordPress, a “taxonomy” is a grouping mechanism for some posts (or links or custom post types)… The names for the different groupings in a taxonomy are called terms. Using groupings of animals as an example, we might call one group “birds”, and … Read more
Why do wordpress store pages/posts within the database instead of files? [closed]
WordPress was forked (2003) from b2 that used PHP/MySQL, to generate pages dynamically – So I think that’s the why part. https://codex.wordpress.org/History
Finding the login page from database?
Alright! I understand that there is a custom wordpress login url. Also you need to login to a user’s profile. If that’s the case, I suggest a simple hack(If you legally have rights to access/modify the database). Try this: Go to cpanel and login to phpmyadmin and open the database for your website/blog. Find ‘wp_options’ … Read more
wpdb query on custom table not working [closed]
Try putting the table name inside quotes, like this SELECT * FROM `sparte-bogensport` Edit More info on why this happens: http://dev.mysql.com/doc/refman/5.7/en/identifiers.html
Usage of Direct Database Call Without Caching Error
I agree with @Tom J Nowell: I’d suggest you remove it, or better yet just say “all rights reserved”. But in the quest for answers, here’s a suggestion using an option field to cache the years: /** * Get year range for posts. * * @return str */ function wpse_226627_get_copyright() { if ( ! $years … Read more