Databasemodel (WordPress): verschil tussen versies

Uit De Vliegende Brigade
Naar navigatie springen Naar zoeken springen
Regel 18: Regel 18:
  
 
WordPress Screen Options are displayed in a hanging tab in the upper right of the WordPress dashboard. Screen Options are user specific based on your login name. They're stored in table <code>wp_usermeta</code>
 
WordPress Screen Options are displayed in a hanging tab in the upper right of the WordPress dashboard. Screen Options are user specific based on your login name. They're stored in table <code>wp_usermeta</code>
 +
 +
''' Voorbeeld'''
 +
 +
<pre>
 +
#
 +
# Change the number of products that is being displayed at 'all products'
 +
############################################################################
 +
#
 +
# * Change the number of products for a specific user: The page doesn't load
 +
#  anymore to do this manually
 +
# * Select user through "user_login", so it works equally well on development
 +
#  environment and production environment
 +
# * Jeroen Strompf - Okt. 2020
 +
#
 +
#
 +
############################################################################
 +
# Use the production database
 +
############################################################################
 +
#
 +
use example_com;
 +
 +
 +
############################################################################
 +
# Read out the old value
 +
############################################################################
 +
#
 +
select
 +
  wp_users.user_login,
 +
  wp_users.ID,
 +
  wp_usermeta.*
 +
from
 +
  wp_users
 +
join
 +
  wp_usermeta
 +
  on
 +
      wp_usermeta.user_id = wp_users.ID
 +
where
 +
  user_login like "Jeroen"
 +
  and
 +
  meta_key like "edit_shop_order_per_page";
 +
 +
 +
############################################################################
 +
# Change value
 +
############################################################################
 +
#
 +
update
 +
  wp_usermeta
 +
join
 +
  wp_users
 +
  on
 +
      wp_usermeta.user_id = wp_users.ID
 +
set
 +
  meta_value=25
 +
where
 +
  wp_users.user_login = "Jeroen"
 +
  and
 +
  wp_usermeta.meta_key = "edit_shop_order_per_page";
 +
 +
 +
############################################################################   
 +
# Read out the new value
 +
############################################################################
 +
#
 +
select
 +
  wp_users.user_login,
 +
  wp_users.ID,
 +
  wp_usermeta.*
 +
from
 +
  wp_users
 +
join
 +
  wp_usermeta
 +
  on
 +
      wp_usermeta.user_id = wp_users.ID
 +
where
 +
  user_login like "Jeroen"
 +
  and
 +
  meta_key like "edit_shop_order_per_page";   
 +
</pre>
 +
 +
=== WooCommerce-producten ===
 +
 +
WooCommerce-productinformatie, vind je voornamelijk op twee plekken [https://stackoverflow.com/questions/36965352/woocommerce-finding-the-products-in-database]:
 +
 +
* wp_posts
 +
* wp_postmeta
 +
 +
Voorbeeld: Selecteer de belangrijkste gegevens uit wp_posts en de SKU's uit wp_postmeta:
 +
 +
<pre>
 +
select
 +
    wp_posts.ID as post_id,
 +
    wp_posts.post_title as post_title,
 +
    wp_posts.post_name as slug,
 +
    wp_posts.guid as guid,
 +
    wp_postmeta.meta_value as sku
 +
from
 +
    wp_posts
 +
join
 +
    wp_postmeta
 +
    on
 +
    wp_posts.ID = wp_postmeta.post_id
 +
where
 +
    post_type="product"
 +
    and
 +
    post_status="publish"
 +
    and
 +
    meta_key="_sku";
 +
</pre>
  
 
== Tabellen ==
 
== Tabellen ==

Versie van 3 okt 2020 14:51

Dit is het hoofdartikel rondom het databasemodel van WordPress. Dit it artikel is slechts een beginnetje. Zie sectie Zie ook voor meer.

Fields

GUID's

WordPress maintains GUID-fields, like in wp_posts. I think it's okay to update them [1]

Functies

Posting-URL

De URL van een posting (vanaf de root van de site) vind je in wp_posts in de kolom post_name [2].

Screen Options

[3]:

WordPress Screen Options are displayed in a hanging tab in the upper right of the WordPress dashboard. Screen Options are user specific based on your login name. They're stored in table wp_usermeta

Voorbeeld 

#
# Change the number of products that is being displayed at 'all products'
############################################################################
#
# * Change the number of products for a specific user: The page doesn't load
#   anymore to do this manually
# * Select user through "user_login", so it works equally well on development
#   environment and production environment
# * Jeroen Strompf - Okt. 2020
#
#
############################################################################
# Use the production database
############################################################################
#
use example_com;


############################################################################
# Read out the old value
############################################################################
#
select
   wp_users.user_login,
   wp_users.ID,
   wp_usermeta.*
from
   wp_users
join
   wp_usermeta
   on
      wp_usermeta.user_id = wp_users.ID
where
   user_login like "Jeroen"
   and
   meta_key like "edit_shop_order_per_page";


############################################################################
# Change value
############################################################################
#
update
   wp_usermeta
join
   wp_users
   on
      wp_usermeta.user_id = wp_users.ID
set
   meta_value=25
where
   wp_users.user_login = "Jeroen"
   and
   wp_usermeta.meta_key = "edit_shop_order_per_page";


############################################################################    
# Read out the new value
############################################################################
#
select
   wp_users.user_login,
   wp_users.ID,
   wp_usermeta.*
from
   wp_users
join
   wp_usermeta
   on
      wp_usermeta.user_id = wp_users.ID
where
   user_login like "Jeroen"
   and
   meta_key like "edit_shop_order_per_page";

WooCommerce-producten

WooCommerce-productinformatie, vind je voornamelijk op twee plekken [4]:

  • wp_posts
  • wp_postmeta

Voorbeeld: Selecteer de belangrijkste gegevens uit wp_posts en de SKU's uit wp_postmeta: 

select 
    wp_posts.ID			as post_id,
    wp_posts.post_title		as post_title,
    wp_posts.post_name		as slug,
    wp_posts.guid		as guid,
    wp_postmeta.meta_value	as sku
from 
    wp_posts
join
    wp_postmeta
    on
    wp_posts.ID = wp_postmeta.post_id
where 
    post_type="product"
    and
    post_status="publish"
    and
    meta_key="_sku";

Tabellen

Zie ook

Bronnen

Overgenomen van "https://wiki.devliegendebrigade.nl/index.php?title=Databasemodel_(WordPress)&oldid=23833"