Check against server time to display SQL entries – Radio Station DJ Rotator Plugin

Basically you have three parameters here:

  1. Current server time
  2. Schedule start time
  3. Schedule end time

Then your task boils down to using custom field parameters in query to request posts with two conditions:

  1. schedule start hour is smaller than current hour
  2. schedule end hour is larger than current hour

Related Posts:

  1. How to properly insert data into custom table via plugin
  2. Searching users with WP_List_Table plugin
  3. How to write one comment and publish on every post using database or plugin?
  4. How to get number of Affected rows from wordpress dbDelta() function
  5. Display data on Word Press site posts and pages from mysql table
  6. How to simultaneously access the same MySQL database in the main column and sidebar of WordPress?
  7. WpDataTables – View Image Directory
  8. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  9. Server configuration for WordPress – Do I need install PHP-SSH extensions for WordPress on Fedora28?
  10. pagination on data fetched using SQL query
  11. Notice: Uninitialized string offset: 0 in social sharing mu-plugin
  12. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  13. How can I fetch data from another website to my wordpress website with mysql database
  14. speed up pagination for huge database
  15. Way to send multiple values for column to MySQL?
  16. How to display results from a data table with an encrypted user id?
  17. Plugin error after installation
  18. add_action for publish_post doesn’t work
  19. WordPress Cache delete on plugin uninstall
  20. need to find duplicated meta value in custom filed and view the posts that have the same value
  21. Getting current user data with MySQL statement
  22. How to get the custom field value using SQL query
  23. WP Function does not trigger on Webhook API Call
  24. Cant create table on plugin activation
  25. How to get database connection details without longing to cpanel in WordPress?
  26. the content of the uploads folder gets deleted periodically, how to figure out what causes it?
  27. Moving a few select DB tables to a new WP instance
  28. How much PHP and MySQL or MariaDB knowledge should I know to start writing WordPress themes and plug-ins and whatever else a beginner can edit?
  29. get/show Last ID
  30. W3 Total Cache Can’t Really Detect Things
  31. MySql Query for WordPress
  32. how to search through plugin in wordpress cimy-user-extra-fields?
  33. True or False: Is an Apache error or PHP error the same as a WordPress error?
  34. PHP Creating a formula from mysql db values and db stored math operator
  35. Split Million WordPress Post’s Into Multiple Database Server
  36. Getting 504 Gateway Timeout Error on AWS Server! [closed]
  37. WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there
  38. How to remove index.php from WordPress site URL
  39. What are the differences between WPINC and ABSPATH?
  40. How do I call wp_get_current_user() in a plugin when plugins are loaded before pluggable.php?
  41. How to make simply “report” button on posts
  42. Get php var inside javascript file (making plugin)
  43. Find out what is using PHP sessions in WordPress
  44. Bug in Stackoverflow styled badge system script
  45. Change destination author link
  46. How can I include PHP-Code to my post?
  47. how to display all posts Custom fields dynamically?
  48. Seriously stuck with some custom meta box/plugin stuff
  49. explanation for activate_plugin function in wordpress core
  50. WordPress PHP plugin – Settings page error
  51. Get product attribute for Simple product in WooCommerce
  52. Creating an Exit Confirmation Popup
  53. Uncaught Error: Call to undefined function get_user_by() after moving function from theme to plugin
  54. Display a text message if the field is not found and not if found
  55. Reposition Woocommerce Message
  56. Scope for PHP Variables Assigned in functions.php or a plugin
  57. Add a plugin before main container
  58. Shortcode to generate and save password in a file
  59. I don’t understand how this parameter works..?
  60. problems with wordpress and php version 5.3.3-1
  61. Prevent a plugin from being automatically activated
  62. WordPress Redirect Not Working – AJAX Callback Response Not Picked Up
  63. WordPress takes too much time (100 seconds) to load – Front end and back end
  64. Saving changes in wp_editor
  65. Output array into one table cell
  66. how to change the verification url of pie register plugin of wordpress?
  67. wordpress plugin is not activating from widget
  68. Using meta_query to get date type values from post_meta table WordPress
  69. Creating a custom post type, adding custom meta fields, preventing all future editability of posts of this type
  70. wp_get_post_terms is difference obj model than the one in rest api response
  71. How to fetch products with the price in a page on woocommerce using a form or live search with php
  72. Creating a Callback URL for WordPress Woocommerce to update Order Status
  73. Using plugin functions/methods within templates
  74. WordPress shows error related to allow_url_fopen
  75. Delete mobile menu button [closed]
  76. How to replace WordPress Media Upload Window with user’s device window?
  77. Automatic switch to backup database on fail
  78. Using color picker in plugin, does input attribute order matter?
  79. How to Create a shortcode to this php function
  80. Check if variable is set in filter
  81. Access a particular field in an array
  82. JQuery prepend a function
  83. I am trying to make a field show and save from quickedit screen
  84. Add the_post_thumbnail_url to a shortcode in function.php
  85. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  86. Adding a Tag Parameter / Filter to My Shortcode
  87. can’t unzip file
  88. WordPress jQuery Post – Amending Variable Value Within Function Command
  89. how to display recent post by category on home page
  90. Change plugin descriptions
  91. Showing how many times is plugin activated or deactivated
  92. Form tries to download a file on submit
  93. Trending Tags based on post views
  94. Edit Buddypress Groups Activity Page Text [closed]
  95. how to add “alt” for all image in wordpress
  96. How to display blog posts only authored by the administrator
  97. how to show the data from a myqsl database in a post [closed]
  98. Posts in Admin only display 1 Post instead of all Post in admin area
  99. How can I save the selected page in the dropdown after anyone clicks on Save Changes?
  100. plugin doesn’t retrieve data from database