Stores WordPress user accounts. Core authentication and profile data.<\/p>
ID<\/code><\/td>bigint(20) unsigned<\/td>NO<\/td>auto_increment<\/td>Unique user identifier<\/td><\/tr>user_login<\/code><\/td>varchar(60)<\/td>NO<\/td>”<\/td>Username for login<\/td><\/tr>user_pass<\/code><\/td>varchar(255)<\/td>NO<\/td>”<\/td>Hashed password (phpass)<\/td><\/tr>user_nicename<\/code><\/td>varchar(50)<\/td>NO<\/td>”<\/td>URL-friendly username slug<\/td><\/tr>user_email<\/code><\/td>varchar(100)<\/td>NO<\/td>”<\/td>User email address<\/td><\/tr>user_url<\/code><\/td>varchar(100)<\/td>NO<\/td>”<\/td>User website URL<\/td><\/tr>user_registered<\/code><\/td>datetime<\/td>NO<\/td>0000-00-00 00:00:00<\/td>Registration timestamp<\/td><\/tr>user_activation_key<\/code><\/td>varchar(255)<\/td>NO<\/td>”<\/td>Password reset key<\/td><\/tr>user_status<\/code><\/td>int(11)<\/td>NO<\/td>0<\/td>Deprecated (was spam flag in MU)<\/td><\/tr>display_name<\/code><\/td>varchar(250)<\/td>NO<\/td>”<\/td>Public display name<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>ID<\/td>Yes<\/td>Primary key<\/td><\/tr>user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_login<\/code><\/td>varchar(60)<\/td>NO<\/td>”<\/td>Username for login<\/td><\/tr>user_pass<\/code><\/td>varchar(255)<\/td>NO<\/td>”<\/td>Hashed password (phpass)<\/td><\/tr>user_nicename<\/code><\/td>varchar(50)<\/td>NO<\/td>”<\/td>URL-friendly username slug<\/td><\/tr>user_email<\/code><\/td>varchar(100)<\/td>NO<\/td>”<\/td>User email address<\/td><\/tr>user_url<\/code><\/td>varchar(100)<\/td>NO<\/td>”<\/td>User website URL<\/td><\/tr>user_registered<\/code><\/td>datetime<\/td>NO<\/td>0000-00-00 00:00:00<\/td>Registration timestamp<\/td><\/tr>user_activation_key<\/code><\/td>varchar(255)<\/td>NO<\/td>”<\/td>Password reset key<\/td><\/tr>user_status<\/code><\/td>int(11)<\/td>NO<\/td>0<\/td>Deprecated (was spam flag in MU)<\/td><\/tr>display_name<\/code><\/td>varchar(250)<\/td>NO<\/td>”<\/td>Public display name<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>ID<\/td>Yes<\/td>Primary key<\/td><\/tr>user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_pass<\/code><\/td>varchar(255)<\/td>NO<\/td>”<\/td>Hashed password (phpass)<\/td><\/tr>user_nicename<\/code><\/td>varchar(50)<\/td>NO<\/td>”<\/td>URL-friendly username slug<\/td><\/tr>user_email<\/code><\/td>varchar(100)<\/td>NO<\/td>”<\/td>User email address<\/td><\/tr>user_url<\/code><\/td>varchar(100)<\/td>NO<\/td>”<\/td>User website URL<\/td><\/tr>user_registered<\/code><\/td>datetime<\/td>NO<\/td>0000-00-00 00:00:00<\/td>Registration timestamp<\/td><\/tr>user_activation_key<\/code><\/td>varchar(255)<\/td>NO<\/td>”<\/td>Password reset key<\/td><\/tr>user_status<\/code><\/td>int(11)<\/td>NO<\/td>0<\/td>Deprecated (was spam flag in MU)<\/td><\/tr>display_name<\/code><\/td>varchar(250)<\/td>NO<\/td>”<\/td>Public display name<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>ID<\/td>Yes<\/td>Primary key<\/td><\/tr>user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_nicename<\/code><\/td>varchar(50)<\/td>NO<\/td>”<\/td>URL-friendly username slug<\/td><\/tr>user_email<\/code><\/td>varchar(100)<\/td>NO<\/td>”<\/td>User email address<\/td><\/tr>user_url<\/code><\/td>varchar(100)<\/td>NO<\/td>”<\/td>User website URL<\/td><\/tr>user_registered<\/code><\/td>datetime<\/td>NO<\/td>0000-00-00 00:00:00<\/td>Registration timestamp<\/td><\/tr>user_activation_key<\/code><\/td>varchar(255)<\/td>NO<\/td>”<\/td>Password reset key<\/td><\/tr>user_status<\/code><\/td>int(11)<\/td>NO<\/td>0<\/td>Deprecated (was spam flag in MU)<\/td><\/tr>display_name<\/code><\/td>varchar(250)<\/td>NO<\/td>”<\/td>Public display name<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>ID<\/td>Yes<\/td>Primary key<\/td><\/tr>user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_email<\/code><\/td>varchar(100)<\/td>NO<\/td>”<\/td>User email address<\/td><\/tr>user_url<\/code><\/td>varchar(100)<\/td>NO<\/td>”<\/td>User website URL<\/td><\/tr>user_registered<\/code><\/td>datetime<\/td>NO<\/td>0000-00-00 00:00:00<\/td>Registration timestamp<\/td><\/tr>user_activation_key<\/code><\/td>varchar(255)<\/td>NO<\/td>”<\/td>Password reset key<\/td><\/tr>user_status<\/code><\/td>int(11)<\/td>NO<\/td>0<\/td>Deprecated (was spam flag in MU)<\/td><\/tr>display_name<\/code><\/td>varchar(250)<\/td>NO<\/td>”<\/td>Public display name<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>ID<\/td>Yes<\/td>Primary key<\/td><\/tr>user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_url<\/code><\/td>varchar(100)<\/td>NO<\/td>”<\/td>User website URL<\/td><\/tr>user_registered<\/code><\/td>datetime<\/td>NO<\/td>0000-00-00 00:00:00<\/td>Registration timestamp<\/td><\/tr>user_activation_key<\/code><\/td>varchar(255)<\/td>NO<\/td>”<\/td>Password reset key<\/td><\/tr>user_status<\/code><\/td>int(11)<\/td>NO<\/td>0<\/td>Deprecated (was spam flag in MU)<\/td><\/tr>display_name<\/code><\/td>varchar(250)<\/td>NO<\/td>”<\/td>Public display name<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>ID<\/td>Yes<\/td>Primary key<\/td><\/tr>user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_registered<\/code><\/td>datetime<\/td>NO<\/td>0000-00-00 00:00:00<\/td>Registration timestamp<\/td><\/tr>user_activation_key<\/code><\/td>varchar(255)<\/td>NO<\/td>”<\/td>Password reset key<\/td><\/tr>user_status<\/code><\/td>int(11)<\/td>NO<\/td>0<\/td>Deprecated (was spam flag in MU)<\/td><\/tr>display_name<\/code><\/td>varchar(250)<\/td>NO<\/td>”<\/td>Public display name<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>ID<\/td>Yes<\/td>Primary key<\/td><\/tr>user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_activation_key<\/code><\/td>varchar(255)<\/td>NO<\/td>”<\/td>Password reset key<\/td><\/tr>user_status<\/code><\/td>int(11)<\/td>NO<\/td>0<\/td>Deprecated (was spam flag in MU)<\/td><\/tr>display_name<\/code><\/td>varchar(250)<\/td>NO<\/td>”<\/td>Public display name<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>ID<\/td>Yes<\/td>Primary key<\/td><\/tr>user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_status<\/code><\/td>int(11)<\/td>NO<\/td>0<\/td>Deprecated (was spam flag in MU)<\/td><\/tr>display_name<\/code><\/td>varchar(250)<\/td>NO<\/td>”<\/td>Public display name<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>ID<\/td>Yes<\/td>Primary key<\/td><\/tr>user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
display_name<\/code><\/td>varchar(250)<\/td>NO<\/td>”<\/td>Public display name<\/td><\/tr><\/tbody><\/table><\/figure>Indexes<\/h2>Key Name<\/th>Columns<\/th>Unique<\/th>Purpose<\/th><\/tr><\/thead>PRIMARY<\/code><\/td>ID<\/td>Yes<\/td>Primary key<\/td><\/tr>user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
PRIMARY<\/code><\/td>ID<\/td>Yes<\/td>Primary key<\/td><\/tr>user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_login_key<\/code><\/td>user_login<\/td>No<\/td>Login lookup<\/td><\/tr>user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_nicename<\/code><\/td>user_nicename<\/td>No<\/td>Author archive URLs<\/td><\/tr>user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_email<\/code><\/td>user_email<\/td>No<\/td>Email lookup<\/td><\/tr><\/tbody><\/table><\/figure>Foreign Key Relationships<\/h2>Referenced by:<\/p>wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Referenced by:<\/p>
wp_posts.post_author<\/code> \u2192 wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_users.ID<\/code><\/li>wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_comments.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_users.ID<\/code><\/li>wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_usermeta.user_id<\/code> \u2192 wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_users.ID<\/code><\/li>wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_links.link_owner<\/code> \u2192 wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_users.ID<\/code><\/li><\/ul>Password Hashing<\/h2>WordPress uses phpass-based hashing:<\/p>Passwords start with $P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
WordPress uses phpass-based hashing:<\/p>
$P$<\/code> (portable hash)<\/li>Modern WP also supports bcrypt ($2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
$2y$<\/code>)<\/li>Never store or compare plaintext passwords<\/li><\/ul>php<\/span><\/use><\/svg><\/button><\/div>\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\/\/ Check password\nwp_check_password( $plaintext, $hash, $user_id );\n\n\/\/ Hash password\nwp_hash_password( $plaintext );<\/code><\/pre><\/div>Common Queries<\/h2>Get user by ID<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT * FROM wp_users WHERE ID = 1;<\/code><\/pre><\/div>Get user by login<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT * FROM wp_users WHERE user_login = 'admin';<\/code><\/pre><\/div>Get user by email<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT * FROM wp_users WHERE user_email = 'user@example.com';<\/code><\/pre><\/div>Get all users with roles<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT u.ID, u.user_login, u.display_name, um.meta_value as capabilities\nFROM wp_users u\nJOIN wp_usermeta um ON u.ID = um.user_id\nWHERE um.meta_key = 'wp_capabilities';<\/code><\/pre><\/div>Get users registered in date range<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT * FROM wp_users \nWHERE user_registered BETWEEN '2024-01-01' AND '2024-12-31'\nORDER BY user_registered DESC;<\/code><\/pre><\/div>Count users by registration month<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT DATE_FORMAT(user_registered, '%Y-%m') as month, COUNT(*) as count\nFROM wp_users\nGROUP BY month\nORDER BY month DESC;<\/code><\/pre><\/div>Get user with post count<\/h3>sql<\/span><\/use><\/svg><\/button><\/div>SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
SELECT u.*, COUNT(p.ID) as post_count\nFROM wp_users u\nLEFT JOIN wp_posts p ON u.ID = p.post_author \n AND p.post_type = 'post' \n AND p.post_status = 'publish'\nGROUP BY u.ID\nORDER BY post_count DESC;<\/code><\/pre><\/div>WordPress API Functions<\/h2>get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
get_user_by( $field, $value )<\/code> – Get user by ID, slug, email, or login<\/li>get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
get_userdata( $user_id )<\/code> – Get user data object<\/li>wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_get_current_user()<\/code> – Current logged-in user<\/li>wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_create_user()<\/code> – Create new user<\/li>wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_update_user()<\/code> – Update user<\/li>wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
wp_delete_user()<\/code> – Delete user<\/li>username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
username_exists()<\/code> – Check if username taken<\/li>email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
email_exists()<\/code> – Check if email registered<\/li><\/ul>Security Notes<\/h2>user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_login<\/code> cannot be changed after creation<\/li>user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_email<\/code> must be unique<\/li>user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_activation_key<\/code> is time-limited and single-use<\/li>user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
user_status<\/code> is deprecated\u2014spam status stored in usermeta<\/li><\/ul>","protected":false},"excerpt":{"rendered":"Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique user identifier user_login varchar(60) NO ” Username for login…<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"footnotes":""},"tags":[],"project":[611],"project_type":[749],"class_list":["post-5594","documentation","type-documentation","status-publish","hentry","project-database-schema","project_type-wordpress-reference"],"project_info":{"id":589,"name":"WordPress Core","slug":"wordpress-core"},"project_type_info":{"id":749,"name":"WordPress Reference","slug":"wordpress-reference"},"_links":{"self":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/types\/documentation"}],"version-history":[{"count":3,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions"}],"predecessor-version":[{"id":8930,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/documentation\/5594\/revisions\/8930"}],"wp:attachment":[{"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/media?parent=5594"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/tags?post=5594"},{"taxonomy":"project","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project?post=5594"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/chubes.net\/wp-json\/wp\/v2\/project_type?post=5594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}