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. Disable email notification after change of password
  39. Run WP-CLI using PHP
  40. How to remove duplicate sub-menu name for top level menu items in a plugin?
  41. Plugin update error message
  42. PHP Deprecated: Non-static method should not be called statically
  43. Set a User as Author of all ‘New Posts’ posted
  44. How do I configure WordPress to talk to a Microsoft SQL Server database?
  45. Calling function from within functions.php returns unwanted value
  46. Check if a class exists within a method
  47. How to remove duplicate Custom Fields?
  48. Calling a plugin in theme development
  49. force customers to add only single item to card per purchase EDD [closed]
  50. How to get post URL in the_content filter?
  51. Write to / remove from default .htaccess file from plugin?
  52. Why isn’t admin_notices displaying my text? [Simple Plugin, Beginner]
  53. Error shown for Trying to get property ‘roles’ of non-object in WordPress After Content for User Roles
  54. How to Use Parameters with a Do_Action Function Within PHP Tags
  55. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  56. How do I pass a post ID to the page URL?
  57. wp_set_auth_cookie causes 403 error in the wooCommerce checkout
  58. add image crop function like in wp customizer
  59. Calculate price and display on woocommerce product single page under price (simple price, variable price) [closed]
  60. How can I perform high-level database merging for WordPress within continues delivery?
  61. Bootstrap and Custom CSS in custom plugin are being overwritten by theme
  62. WordPress + JavaScipt + AJAX + MySQL: insert query for form
  63. Customize permalink wordpress category id
  64. Take input from form and pass it to function using a wp-plugin
  65. Self-serve ad system like Reddit’s for WordPress? [closed]
  66. Create a plugin from within WordPress
  67. Class variables not correct on page
  68. Load Javascript from Plugin in One Page Only?
  69. Call plugin with php function
  70. Setting Up PHP Workflow in WordPress
  71. How can I exclude a dynamic URL to show a popup created using ‘WordPress Popup’ plugin
  72. output html on post or page from custom plugin [closed]
  73. How can i add simple code in only in posts by function.php
  74. Hide DIV if empty – Plugin Gallery
  75. Profile / benchmark wordpress on apache?
  76. Retrieve Plugin Settings and insert into XML string
  77. WordPress Stats Plugin: Display Post Views [closed]
  78. Pagination not working
  79. exec-PHP shows output at bottom of page
  80. WP Insert Post If user refreshes override new post
  81. Code for unique user visit count on every page WordPress
  82. Searching a tab/space delimited text file based upon form criteria and returning a ‘record’ into a word press results page
  83. Custom Plugin: How to Include Install Buttons of other 3rd Party Plugins?
  84. Redirect to a page while maintaining search query parameters without causing an infinite loop
  85. Cron job shedules replace?
  86. Create a form and have custom menu display based on user answers?
  87. Why my multisite is this slow? (stats inside)
  88. Delete user meta based on key value that is an array
  89. Problem with conditional woocommerce custom checkout field
  90. Editing Global Variables from Inside Functions
  91. Posting code inside the post instead of in the template file using shortcode
  92. conditional tags for the output of a plugin
  93. Can’t insert files in other inputs
  94. How do I output user_registered time in my correct timezone?
  95. How to tweak a plugin without preventing it from updating
  96. Place max_execution_time in plugin [closed]
  97. Creating a press page for our project
  98. wordpress illegal string offset ‘parameter’ error
  99. Warning: Undefined variable $admin
  100. public custom posts not showing in my wordpress plugin