Creating Tables in WordPress Database

It may be a wrong approach, but without creating a plugin, one of my seniors, once did a WordPress Shopping Cart project by creating extra tables for her custom purposes. What she did is to follow the other existing tables in WordPress database.

Suppose what wp_posts table has by default is an ID. She opened up the structure of the table and see:

+=======+============+===========+============+======+=========+================+
| Field |    Type    | Collation | Attributes | Null | Default |      Extra     |
+=======+============+===========+============+======+=========+================+
|  ID   | bigint(20) |           |  UNSIGNED  |  No  |   None  | AUTO_INCREMENT |
+-------+------------+-----------+------------+------+---------+----------------+

Then she followed a similar things to her own table’s ID’s structure. And so on… And where necessary she made a new field with her personal choices.

It’s her process— stealing structures from built-in WordPress db.

This was her methodology to the new table in WordPress for custom purpose. You can simply follow it or any other method proposed by any pro.

But being a newbie you should have to practice much with SQL & PHP first, it’ll help you to understand its basics. All the very best.

Related Posts:

  1. Get error messages when $wpdb->insert() returns false?
  2. Detecting errors generated by $wpdb->get_results()
  3. Does dbDelta delete columns as well?
  4. wpdb update add current timestamp not working
  5. How to fetch Data in WordPress using MySQLi or $wpdb
  6. WordPress Unit Testing – Cannot Create Tables
  7. How to define composite keys with dbDelta()
  8. Does wpdb add considerable overhead on queries with large result sets?
  9. Why does $wpdb return strings for mysql integer values?
  10. $wpdb->prepare() warning in WordPress 3.5
  11. Inserting data into custom tables
  12. Hook into $wpdb
  13. Display data from a non wordpress database on a page template
  14. How might I retrieve a featured post image from an external WP site and display it as a link back?
  15. Export wordpress table to excel
  16. How to close wpdb connection? [duplicate]
  17. Inserting Post Meta From SQL
  18. Why does dbDelta() not catch MysqlErrors?
  19. Connecting to external oracle database
  20. Can’t save ajax value to database
  21. What causes the “max_user_connections” warning on WordPress frontend?
  22. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  23. Updating all rows of table with $wpdb
  24. Safe way to find last inserted id in a table?
  25. Is $wpdb->prepare escaping to much? How to use it properly?
  26. Database slowdown after update to 3.4.1
  27. Remove database entries where post_date > expiration date
  28. Get data from database using $WPDB
  29. How to use a different database to list and manage comments in the backend
  30. Getting all the users who have author privilege
  31. Multiple postmeta with same name for one post in wp_postmeta table
  32. WP Database Table to CSV file
  33. wpdb_prepare with multiple or condition
  34. $wpdb->insert is not working
  35. In what part of the WordPress core does the users table and usermeta table get joined?
  36. Modify Database in Multi-Site wp_usermeta table
  37. Advanced SELECT query with condtional statements
  38. $wpdb doesn’t like to store arrays
  39. WordPress choose wrong database
  40. Redirecting to old domain after migration website
  41. Create table from array with prepare
  42. Does WordPress $wpdb functions wait when table is locked?
  43. How Can I Put Meta_Compare in the Database-Query?
  44. WordPress running SQL query to update database from form
  45. $wpdb->insert Giving duplicates
  46. I’m not able to get access to $wpdb [duplicate]
  47. WPDB SQL query with prepare() returning variable, not db value
  48. $wpdb error (Call to a member function insert() on a non-object)
  49. Is it important to have integers inserted using %d rather than %s?
  50. Problem in using wpdb
  51. How to fetch records from database WordPress
  52. Best practice to import user base (subscribers) from one website to another?
  53. AJAX wp-mysql running too slow
  54. Clear Terms from Taxonomy for Specific Post IDs?
  55. Connecting to a different database
  56. Query Column of Specific ID from Database Table
  57. How to delete a particular row in a database table
  58. How to create more than one new wpdb object?
  59. Optimizing function that automatically creates internal links based on post title string
  60. Update multiple rows in one query
  61. How to connect and insert data in database of wordpress?
  62. Should I use an additional column in the DB?
  63. Outputting query results
  64. access JSON results from wordpress database with wpdb
  65. Getting value from database table depending on field value
  66. add_post_meta — not working
  67. Select From wpdb – Author/User Directory page
  68. wpdb->insert not inserting first variable
  69. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  70. $wpdb->insert not inserting all rows
  71. wpdb Insert unknown post data dynamic foreach loop
  72. How do I get database rows from a custom table using wpdb?
  73. Insert NULL value using prepare()
  74. Help with $wpdb on custom code
  75. “BS_” rows in postmeta table
  76. $wpdb->insert duplicating rows
  77. How to rerieve comments and their replies from DB
  78. Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
  79. Help posting values to DB on submit using $wpdb->query
  80. WordPress Database Query works in phpMyAdmin but not in the code
  81. How to add download link from database on custom page template?
  82. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  83. insert data from a form:: Warning Empty query mysqli::query()
  84. How to get specific table by current user login
  85. Using $wpdb to insert data into a table
  86. How To connect to the same WordPress database with different database user
  87. Accessing content from third party as native posts in WordPress
  88. Call to a member function insert()
  89. I have include wp-config, should I add global $wpdb also?
  90. Processing a lot of $wpdb isn’t insert all the data
  91. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  92. using same mysql user with many databases
  93. Pulling values from a sepcific row in table
  94. Inserting into data into external DB using WPDB
  95. Insert Extra fields added in the front end registration form to DB
  96. How to use remote db tables in current config? [duplicate]
  97. $wpdb->insert not working for last select option
  98. $wpdb->prepare returns empty array
  99. How to delete field using WPDB?
  100. Uploading to WordPress Database