Creating and Using Tables in the WordPress Database

The requirements you’ve specified don’t indicate any need for a custom post table. Just register a custom post type using register_post_type(), and then manipulate its entries using the standard WordPress API.

Example from the codex, registering a ‘book’ custom post type with a label of “Books”:

function my_init() {
    $args = array( 'public' => true, 'label' => 'Books' );
    register_post_type( 'book', $args );
}
add_action( 'init', 'my_init' );

You can save your latitude, longitude and alternate title values as post meta.

Related Posts:

  1. Using wpdb to connect to a separate database
  2. WPDB Insert or if exists Update
  3. get_results using wpdb
  4. $wpdb won’t insert NULL into table column
  5. Get error messages when $wpdb->insert() returns false?
  6. Does dbDelta delete columns as well?
  7. How to fetch Data in WordPress using MySQLi or $wpdb
  8. wpdb->insert multiple record at once
  9. How to define composite keys with dbDelta()
  10. Does wpdb add considerable overhead on queries with large result sets?
  11. Why does $wpdb return strings for mysql integer values?
  12. $wpdb->prepare() warning in WordPress 3.5
  13. Inserting data into custom tables
  14. Hook into $wpdb
  15. Display data from a non wordpress database on a page template
  16. How does $wpdb handle COUNT(*)
  17. WordPress database error: [Query was empty] [closed]
  18. Connecting to external oracle database
  19. Can’t save ajax value to database
  20. What causes the “max_user_connections” warning on WordPress frontend?
  21. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  22. Updating all rows of table with $wpdb
  23. How to execute mulitple statement SQL queries using $wpdb->query?
  24. Is $wpdb->prepare escaping to much? How to use it properly?
  25. When and why should I use $wpdb different return types?
  26. How wordpress accesses its own database
  27. Remove database entries where post_date > expiration date
  28. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  29. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  30. How to use a different database to list and manage comments in the backend
  31. WP Database Table to CSV file
  32. Cannot update custom database table row
  33. wpdb_prepare with multiple or condition
  34. Show last modified date of database
  35. $wpdb->insert is not working
  36. Extracting the post_id via the wp_insert_post action (external db query)
  37. WordPress database error – Error in SQL syntax – I can’t identify any error?
  38. In what part of the WordPress core does the users table and usermeta table get joined?
  39. Multiple wp_options tables to share content across installs
  40. Advanced SELECT query with condtional statements
  41. Select two sums with single get_var statement
  42. WordPress choose wrong database
  43. Redirecting to old domain after migration website
  44. Create table from array with prepare
  45. Update from 4.5 to 4.6 failing
  46. Does WordPress $wpdb functions wait when table is locked?
  47. $wpdb->insert Giving duplicates
  48. I’m not able to get access to $wpdb [duplicate]
  49. Have working sql query… trying to adjust it to use $wpdb
  50. $wpdb->query can’t insert data
  51. Custom WordPress Table wpdb
  52. How to fetch records from database WordPress
  53. Best practice to import user base (subscribers) from one website to another?
  54. AJAX wp-mysql running too slow
  55. CreateOrUpdate in WordPress
  56. Problem migrating to localhost
  57. Clear Terms from Taxonomy for Specific Post IDs?
  58. How to get a list of WordPress default database tables?
  59. Connecting to a different database
  60. Query Column of Specific ID from Database Table
  61. How to delete a particular row in a database table
  62. How to create more than one new wpdb object?
  63. Update multiple rows in one query
  64. Should I use an additional column in the DB?
  65. access JSON results from wordpress database with wpdb
  66. Getting value from database table depending on field value
  67. wpdb->insert not inserting first variable
  68. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  69. $wpdb->insert not inserting all rows
  70. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  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. Help posting values to DB on submit using $wpdb->query
  79. WordPress Database Query works in phpMyAdmin but not in the code
  80. How to add download link from database on custom page template?
  81. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  82. insert data from a form:: Warning Empty query mysqli::query()
  83. How can I get $wpdb to show MySQL warnings?
  84. About wp database hooks (error establishing connection)
  85. How to get specific table by current user login
  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. Should I Use only wpdb Class to Write Custom Queries?
  89. Call to a member function insert()
  90. I have include wp-config, should I add global $wpdb also?
  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. Creating Tables in WordPress Database
  95. Inserting into data into external DB using WPDB
  96. Insert Extra fields added in the front end registration form to DB
  97. How to use remote db tables in current config? [duplicate]
  98. $wpdb->insert not working for last select option
  99. $wpdb->prepare returns empty array
  100. Uploading to WordPress Database