Check if post id exist in table than only update instead of inserting new row

why use a custom table for this? eliminate the whole save_post function and just use get_post_meta and update_post_meta to check/increment the view count. this is exactly what post meta data is for.

Related Posts:

  1. Show content from database
  2. Post Views / Hit Counter Problem?
  3. What is the difference between an ORM and an ODM?
  4. Rename a table in MySQL
  5. How should I tackle –secure-file-priv in MySQL?
  6. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  7. Keeping WP database synced across multiple developers using git
  8. Checking if Database Table exists
  9. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  10. How to define composite keys with dbDelta()
  11. Is it possible to define two databases for one installation?
  12. Connect forms in WP to external database
  13. Hook into $wpdb
  14. How to get site URL if database is disconnected?
  15. Is it wise to delete post revisions and autosaves from database?
  16. Improve or optimize a very slow query
  17. What is the advantage of separating wp_users and wp_usermeta table?
  18. Multiple WP install with same users database
  19. “MySQL server has gone away” since update to 3.8
  20. Using two different DB users on one WP install
  21. Usage of Direct Database Call Without Caching Error
  22. Can I transfer a mysql database to another site?
  23. MySQL Syntax Error upon restoring database from backup [closed]
  24. Weird issue with database migration and SSL links
  25. Merge two databases: OLD SITE -> NEW SITE
  26. Backup another database with BackUpWordPress plugin [closed]
  27. Easiest Way to Authenticate WP Users Using an External DB?
  28. How to use a different database to list and manage comments in the backend
  29. Who is responsible for data sanitization in WordPress development?
  30. How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
  31. Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
  32. How do I find out the full path of a page’s template?
  33. I need to get an array from the wordpress database
  34. Moving minor updates between local and live sites – just database?
  35. what is the best way to store user created data?
  36. Use mulitple usernames?
  37. Using GROUP CONCAT in my-sql query with wp_usermeta table
  38. Routine to convert custom post meta from old to new value
  39. “The link you followed has expired” & “Error while saving” messages when adding new post
  40. input data and output table [closed]
  41. sanitize POST arrays
  42. WP character encoding error after sharing post on Facebook �
  43. Sending data with multi step form to wp database
  44. WordPress query is not returning proper results
  45. Localhost to Staging to Development Dynamic WP-CONFIG
  46. WordPress and user security
  47. Migrating from PDO using SQLite to clean new install using MySQL
  48. can we add extra table or column in wordpress for adding our data
  49. Change WordPress URL in sql file via Terminal
  50. $wpdb->insert Giving duplicates
  51. Where is phpMyAdmin inside WordPress?
  52. Changing root password in PHPMyAdmin for WordPress Database when going live
  53. How to properly check if a table exists in WordPress Database using Show Tables Query
  54. How to delete database without using any plugin?
  55. restore a db after bad backup
  56. Best practice to import user base (subscribers) from one website to another?
  57. AJAX wp-mysql running too slow
  58. Some weird users in database
  59. Delete/Replace words from X to Y in post content
  60. Location of image metadata on my server
  61. How to create more than one new wpdb object?
  62. Multiple WordPress sites installs sharing the same database but with different content and domains
  63. Brandoo WordPress Unable to Update to WordPress 4.2.2
  64. Remote database -> massive response time increase?
  65. Custom Post Type not showing anything added by code anymore?
  66. Is it good practice to import/export a blog to test a redesign?
  67. Getting value from database table depending on field value
  68. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  69. Secure way to use name_save_pre?
  70. wpdb->insert not inserting first variable
  71. Database tables for sports betting integrated in WordPress
  72. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  73. New installation fatal error in 5.9.3 at edit or create entry
  74. Storing transients giving database error
  75. I want to replicate a wordpress website over multiple servers
  76. Is there anyway to split posts to different databases?
  77. wp-cli + valet: “Error establishing a database connection”
  78. How to edit custom table data in frontend
  79. local wordpress broke after changing URL
  80. Unable to login to a https website via the app after changing from http
  81. mysqli_query(): MySQL server has gone away for Curl Request
  82. Is it safe to add INDEX to a column in WordPress database?
  83. WP website showing blank page after moving from subdomain to main domain
  84. create a table using user meta custom data
  85. wpdb query to insert images in to post/page gallery
  86. WPCLI search and replace in a particlar site dir effect another site-dir
  87. How do I find out from my database what version of WordPress I need?
  88. How to create a database table?
  89. get_user_meta and umeta_id
  90. Extracted CSV as Array for Custom Query Loop
  91. Hang Up Followed By Can’t select database
  92. Database error after importing WordPress
  93. Send data to database after redirect (and popping out of iframe)
  94. Pulling values from a sepcific row in table
  95. import (migration) user database to wp-users
  96. Create hundreds of users with just ID in phpMyAdmin
  97. What is best for saving lot of extra detail of user?
  98. Insert Extra fields added in the front end registration form to DB
  99. $wpdb->insert not working for last select option
  100. How to create a table [closed]