WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]

Instead of adding new columns to the WordPress database, you might want to use the wp_usermeta table. It is used to store any kind of data about your users (just like the wp_postmeta for your posts and pages).

To add fields on the registration form you can use the user_new_form action which is triggered by the admin form or the register_form on the registration form on the website.

Then, hook into the insert_user_meta filter (triggered after the user save) and add the user meta that you submitted with your form.

Finally, as you probably need to display those values in the user edit form, try to hook into edit_user_profile to add your custom fields in the user profile page.
When posting the form, the user update function will automatically trigger the same function you used to add the user meta.

Related Posts:

  1. MySQL: Can’t create table (errno: 150)
  2. Moving database with phpMyAdmin
  3. Change sticky status of posts from phpMyAdmin
  4. Restose content from revisions – sql query
  5. Better way to migrate to server?
  6. How delete post_content records of specific category from phpmyadmin
  7. Reset post IDs with all post meta
  8. Want to delete woocommerce coupon in bulk from phpmyadmin based on published date
  9. What is a stored procedure?
  10. Unknown column in ‘field list’ error on MySQL Update query
  11. SQL Inner-join with 3 tables?
  12. Conversion failed when converting date and/or time from character string while inserting datetime
  13. MySQL create table if not exists and insert record only if table was created
  14. error, string or binary data would be truncated when trying to insert
  15. Why do we need “Relationships” between tables at all?
  16. Using group by on multiple columns
  17. How to declare a variable in MySQL?
  18. ORA-01843 not a valid month- Comparing Dates
  19. How do I escape a single quote in SQL Server?
  20. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  21. How Stuff and ‘For Xml Path’ work in SQL Server?
  22. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  23. Oracle SELECT TOP 10 records
  24. must appear in the GROUP BY clause or be used in an aggregate function
  25. How can I return pivot table output in MySQL?
  26. The multi-part identifier could not be bound
  27. SQLite – UPSERT *not* INSERT or REPLACE
  28. how to drop partition without dropping data in MySQL?
  29. Simple way to calculate median with MySQL
  30. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  31. Error 1046 No database Selected, how to resolve?
  32. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  33. Insert text with single quotes in PostgreSQL
  34. SQL Server IF NOT EXISTS Usage?
  35. How to insert date values into table
  36. Arithmetic overflow error converting numeric to data type numeric
  37. I want to use CASE statement to update some records in sql server 2005
  38. SELECT DISTINCT on one column
  39. how to remove time from datetime
  40. TSQL PIVOT MULTIPLE COLUMNS
  41. MySQL – UPDATE multiple rows with different values in one query
  42. How to create a MySQL hierarchical recursive query?
  43. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  44. Query to convert from datetime to date mysql
  45. How to query MongoDB with “like”
  46. Equivalent of Oracle’s RowID in SQL Server
  47. Subtract one day from datetime
  48. MySQL equivalent of DECODE function in Oracle
  49. what is the difference between triggers, assertions and checks (in database)
  50. Replacing NULL with 0 in a SQL server query
  51. How to delete from multiple tables in MySQL?
  52. How to copy a row and insert in same table with a autoincrement field in MySQL?
  53. Backup a single table with its data from a database in sql server 2008
  54. Error converting data type varchar
  55. updating table rows in postgres using subquery
  56. I want to use CASE statement to update some records in sql server 2005
  57. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  58. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  59. ROW_NUMBER() in MySQ
  60. Foreign key references invalid table
  61. Is there a coalesce-like function in Excel?
  62. What are database constraints?
  63. Postgresql column reference “id” is ambiguous
  64. Inner Joining three tables
  65. How do I view the Explain Plan in Oracle Sql developer?
  66. ORA-01779: cannot modify a column which maps to a non key-preserved table
  67. SUM OVER PARTITION BY
  68. MySQL LIKE IN()?
  69. Filter data based on date in sql
  70. Varchar invalid for Sum operator
  71. SQL: How to properly check if a record exists
  72. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  73. SQL query to extract only the “current” wp_posts?
  74. Sorting search results by taxonomy terms
  75. SQL select of users by metadata
  76. How to properly sanitize strings without $wpdb->prepare?
  77. How to retrieve sticky post in raw sql?
  78. How to remove in the wordpress database all posts revisions except the last three?
  79. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  80. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  81. $wpdb get_var issue
  82. posts_where Fails with More than One Custom Field in Query
  83. Inserting rows into a custom table, when plugin is activated
  84. WordPress database error: You have an error in your SQL syntax
  85. Inner Join user tables to select users with roles
  86. $wpdb->prepare with LIKE returning blank array instead of rows
  87. Posts modified in the last 48 hours
  88. How to migrate a database from a server to another
  89. Removing posts by sql
  90. Why line returns are not reapply after doing esc_sql?
  91. SQL: Select wordpress posts with given text string and add a custom field to them?
  92. post id not displaying
  93. How to export 2 week’s worth of posts
  94. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  95. Adding wordpress posts using phpmyadmin
  96. How to retrieve user data based on role using SQL?
  97. Insert multiple checkbox values
  98. How to get EVENT based on startday, using BETWEEN
  99. wpdb prepare without placeholder
  100. This SQL request call all time and overload my server : SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘wp_installer_network’ AND site_id = 1