Checking for new message using AJAX and PHP. Server overload?

Thank you for your help. I did it another way. I believe it won’t overload in the future when there will be more users.

I will try to explain it, but if anyone will need help with the code I’m willing to help.

In the “send_message.php” file, after database insert, I added a piece of code that creates a new empty text file with receiving user id as a name.

In the “receive_user.php” file, after database update (message read), I also added a piece of code, but this one deletes that same text file from above.

Finally, the PHP code used by AJAX checks if text file with logged in user id as filename exists. If it does, it echoes 1.

As you can see, there’s no constant database checking.

Related Posts:

  1. Jquery ajax to custom php file: returning blank data
  2. A $_POST should occur when submit form but is not?
  3. Live search from database table
  4. Ajax not updating to database
  5. Help with creating commenting system using PHP, jQuery and AJAX
  6. AJAX request status 200 but no actual “response”
  7. wordpress count link clicks by ip address
  8. ajax, right way to do it and make it works?
  9. Ajax load more posts with multiple tax query
  10. WordPress Sending data to Ajax with select option
  11. WordPress ajax doesn’t display object method on jQuery .change() function
  12. Ajax loaded form replaces form action with Ajax url
  13. prevent default not stopping page refresh. Passing form information to and from php with ajax in a wordpress site
  14. Ajax date_query not working past the first iteration
  15. Ajax request not sending to server and returning – wp-admin/admin-ajax.php 400
  16. Why ajax doesn’t work on certain wordpress hooks and reload the page instead?
  17. AJAX pagination, update current page
  18. Save Search System
  19. adjust section according to country?
  20. populate form fields in a loop with ajax
  21. dynamic dependent select dropdown
  22. Change “add to cart” button color based on Woocommerce product category [closed]
  23. Ajax request returns ‘Array’. How to output the actual results?
  24. How to add a do_action on refreshing of WP customizer?
  25. Refresh table data with Ajax
  26. Setting value of session with Ajax not working
  27. [jQuery]Adding shortcode
  28. Display parent and child taxonomies in separate drop down select fields
  29. Show success or error messages in Ajax response to WordPress custom registration form
  30. How to add a Custom Mailchimp AJAX Newsletter Subscribe Form
  31. Plugins not working on AJAX requests
  32. Fancybox type popup window that’s not an iframe
  33. How to disable controls in theme customizer?
  34. Can I use a jQuery Ajax request in Code Snippets Plugin for WordPress?
  35. How do I Import / Upload Files with jQuery AJAX?
  36. WordPress admin-ajax.php 400 bad request
  37. WordPress Ajax Call inserting data but success response false
  38. Ajax contact form return 0
  39. AJAX – Returning Two JSON Objects with One PHP Function
  40. Pull GetOption() variable into jQuery dynamically created html
  41. Unset session variable on page reload / setup but exclude AJAX
  42. Add Ajax Hooks and Call from Custom Template PHP
  43. WordPress Ajax Always returning 0
  44. Function won’t run onclick using Ajax
  45. How to keep track of when a vote is cast?
  46. WordPress plugin admin page – using WordPress function in linked php file
  47. My jQuery Ajax form submit is still refreshing page?
  48. jQuery Ajax PHP function call returning [object Object]
  49. Shortcode to pull posts
  50. Ajax search shows all results when user empties input?
  51. Why i can’t get custom fields value or post ID via Ajax?
  52. Output votes to div dynamically in wordpress
  53. Get uploaded image and attach it to the new post
  54. Admin-ajax php not working on new wordpress version
  55. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  56. Proper way to use WordPress function with AJAX PHP file
  57. How to use AJAX in WordPress in MYSQL query?
  58. Processing ajax call to php to insert into mysql database
  59. Add a counter for mouseovers (custom field)
  60. Accessing an API with jQuery and AJAX
  61. Execute Jquery when a specific page in my plugin is loading
  62. what does $options = get_option(‘test_theme’); do?
  63. Change Query Arguments (filter) with jQuery/Ajax or PHP?
  64. How to load previous or next attachment with jquery ?
  65. How to set variables with AJAX request to use in another function in WordPress
  66. Search Ajax Call – Use Form Data in Response
  67. Validating an email input from form field before submit using JQuery, AJAX, and PHP
  68. Why does PHP called with Jquery AJAX not allow additional php code to be added?
  69. Using Ajax to submit a form, and run a SQL Select query based on user input from the form
  70. WordPress cascading dropdown selection search based on Parent Page & Child Page
  71. Tracking Visitor LatLng with WordPress using JS, PHP. How to put data which was extract using JS into DB
  72. Ajax on the Administration Side of plugin – wp_localize_script – how to pass value from JQuery to PHP function in class?
  73. Database entry removed on browser refresh, Ajax PHP jQuery
  74. jquery & ajax getting data from php in wordpress . admin-ajax.php returns 400
  75. Failed to load resource: the server responded with a status of 500 (Internal Server Error) through wp_admin_ajax.php
  76. How do I call a value from the datase using ajax
  77. Ajax result show in console if is called outside function and not showing in array
  78. Ajax filter with loadmore button
  79. Admin-ajax.php 404 error
  80. Where to add my PHP codes for AJAX Jquery to work?
  81. How to pass values from one function to the other using an array variable
  82. How to change PHP variables with AJAX request in WordPress
  83. How to use wp_ajax_set_post_thumbnail?
  84. Update $wpdb query with AJAX
  85. Can’t make lazy load for my site, help!
  86. How to reload a php script, using AJAX and jQuery
  87. wp_ajax_ 400 Bad Request
  88. AJAX to add to cart multiple products woocommerce
  89. update_post_meta Not Processing Array Data (Not Sure What I Am Missing)
  90. wp_set_object_terms returns 500 error when called through AJAX function
  91. How can i send id of the currently posted form data through json response in custom wordpress plugin?
  92. Cannot successfully execute AJAX script to call function.php specific function. Using XAMPP localhost to test
  93. autocomplete in wordpress using ajax with json-data
  94. WordPress ajax filter returning all posts when it should be filtering by category
  95. Input field duplicates on form submit by jQuery
  96. How to echo a PHP code into WooCommerce variation product?
  97. How can i get the same ajax result using WP REST API instead of admin-ajax?
  98. How to call a function from functions.php with ajax?
  99. Custom theme admin-ajax.php 400 (Bad Request)
  100. Remove item from post_meta array via AJAX
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)