Reply to thread

Message

<blockquote data-quote="DDDDec" data-source="post: 465031" data-attributes="member: 75952">how it works:shows the current next and later event by the hour.sql:[CODE=sql]DROP TABLE IF EXISTS `cms_events`;CREATE TABLE `cms_events` (&nbsp; `id` int(11) NOT NULL,&nbsp; `event_name` varchar(255) NOT NULL,&nbsp; `time` varchar(255) NOT NULL,&nbsp; `day` varchar(255) NOT NULL,&nbsp; PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;[/CODE]css:[CODE=css].events {&nbsp; &nbsp; width: 100%;&nbsp; &nbsp; margin-top: 10px;&nbsp; &nbsp; display: grid;&nbsp; &nbsp; grid-template-columns: 1fr 1fr 1fr;&nbsp; &nbsp; grid-gap: 1%;}.event-image {&nbsp; &nbsp; display: inline-block;&nbsp; &nbsp; height: 130px;&nbsp; &nbsp; width: 100;&nbsp; &nbsp; overflow: hidden;&nbsp; &nbsp; padding-right: 10px;&nbsp; &nbsp; padding-bottom: 10px;&nbsp; &nbsp; color: white;&nbsp; &nbsp; border-radius: 3px;&nbsp; &nbsp; display: inline-block;&nbsp; &nbsp; background-image: url('http://localhost/cms_images/dump/lpromo_nov20_gen.png');&nbsp; &nbsp; background-repeat: no-repeat;&nbsp; &nbsp; background-position: bottom right;&nbsp; &nbsp; font-weight: bold;&nbsp; &nbsp; text-align: center;}.event-time {&nbsp; &nbsp; padding: 10px;&nbsp; &nbsp; margin-top: 10px;&nbsp; &nbsp; width: 70%;&nbsp; &nbsp; background-color: #00000075;&nbsp; &nbsp; border-radius: 3px;&nbsp; &nbsp; display: inline-block;&nbsp; &nbsp; margin-left: 10px;}.event-type {&nbsp; &nbsp; padding: 10px;&nbsp; &nbsp; margin-top: 10px;&nbsp; &nbsp; width: 70%;&nbsp; &nbsp; background-color: #00000075;&nbsp; &nbsp; border-radius: 3px;&nbsp; &nbsp; display: inline-block;&nbsp; &nbsp; margin-left: 10px;}[/CODE]php:[CODE=php]class events {&nbsp;&nbsp; &nbsp; public function timeCheck($time) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($time == '25') {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $time = '0';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($time == '26') {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $time = '1';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; public function now_plugin() {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $db;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $time = date('H') - 1 + 1;&nbsp; &nbsp; &nbsp; &nbsp; $day = date('N');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $now_plugin = $db-&gt;prepare(&quot;&nbsp; &nbsp; &nbsp; &nbsp; SELECT * FROM cms_events WHERE time = :time AND day = :day&nbsp; &nbsp; &nbsp; &nbsp; &quot;);&nbsp; &nbsp; &nbsp; &nbsp; $now_plugin-&gt;bindParam(&quot;:time&quot;, $time);&nbsp; &nbsp; &nbsp; &nbsp; $now_plugin-&gt;bindParam(&quot;:day&quot;, $day);&nbsp; &nbsp; &nbsp; &nbsp; $now_plugin-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($now_plugin-&gt;RowCount() &gt; 0) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $now_plugin_data = $now_plugin-&gt;fetch();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class='event-image'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-time'&gt;{$now_plugin_data['time']}:00&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-type'&gt;{$now_plugin_data['event_name']}&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class='event-image'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-time'&gt;$time:00&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-type'&gt;NO EVENT BOOKED&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; public function next_plugin() {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $db;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $time = date('H') - 1 + 2;&nbsp; &nbsp; &nbsp; &nbsp; $day = date('N');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; self::timeCheck($time);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $next_plugin = $db-&gt;prepare(&quot;&nbsp; &nbsp; &nbsp; &nbsp; SELECT * FROM cms_events WHERE time = :time AND day = :day&nbsp; &nbsp; &nbsp; &nbsp; &quot;);&nbsp; &nbsp; &nbsp; &nbsp; $next_plugin-&gt;bindParam(&quot;:time&quot;, $time);&nbsp; &nbsp; &nbsp; &nbsp; $next_plugin-&gt;bindParam(&quot;:day&quot;, $day);&nbsp; &nbsp; &nbsp; &nbsp; $next_plugin-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($next_plugin-&gt;RowCount() &gt; 0) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $next_plugin_data = $next_plugin-&gt;fetch();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style='opacity: 0.5;' class='event-image'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-time'&gt;{$now_plugin_data['time']}:00&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-type'&gt;{$now_plugin_data['event_name']}&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style='opacity: 0.75;' class='event-image'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-time'&gt;$time:00&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-type'&gt;NO EVENT BOOKED&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; public function later_plugin() {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $db;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $time = date('H') - 1 + 3;&nbsp; &nbsp; &nbsp; &nbsp; $day = date('N');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; self::timeCheck($time);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $later_plugin = $db-&gt;prepare(&quot;&nbsp; &nbsp; &nbsp; &nbsp; SELECT * FROM cms_events WHERE time = :time AND day = :day&nbsp; &nbsp; &nbsp; &nbsp; &quot;);&nbsp; &nbsp; &nbsp; &nbsp; $later_plugin-&gt;bindParam(&quot;:time&quot;, $time);&nbsp; &nbsp; &nbsp; &nbsp; $later_plugin-&gt;bindParam(&quot;:day&quot;, $day);&nbsp; &nbsp; &nbsp; &nbsp; $later_plugin-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($later_plugin-&gt;RowCount() &gt; 0) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $later_plugin_data = $later_plugin-&gt;fetch();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style='opacity: 0.5;' class='event-image'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-time'&gt;{$now_plugin_data['time']}:00&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-type'&gt;{$now_plugin_data['event_name']}&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style='opacity: 0.5;' class='event-image'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-time'&gt;$time:00&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;div class='event-type'&gt;NO EVENT BOOKED&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;}[/CODE]image i used:[ATTACH=full]11635[/ATTACH]put this anywhere before you run the script, change the timezone if your not using londons timezone:date_default_timezone_set('Europe/London');how it looks:[ATTACH=full]11634[/ATTACH]Alternative: <a href="https://github.com/BigDeclan/now-next-later-script" target="_blank">https://github.com/BigDeclan/now-next-later-script</a></blockquote>

[QUOTE="DDDDec, post: 465031, member: 75952"] how it works: shows the current next and later event by the hour. sql: [CODE=sql]DROP TABLE IF EXISTS `cms_events`; CREATE TABLE `cms_events` ( `id` int(11) NOT NULL, `event_name` varchar(255) NOT NULL, `time` varchar(255) NOT NULL, `day` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;[/CODE] css: [CODE=css].events { width: 100%; margin-top: 10px; display: grid; grid-template-columns: 1fr 1fr 1fr; grid-gap: 1%; } .event-image { display: inline-block; height: 130px; width: 100; overflow: hidden; padding-right: 10px; padding-bottom: 10px; color: white; border-radius: 3px; display: inline-block; background-image: url('http://localhost/cms_images/dump/lpromo_nov20_gen.png'); background-repeat: no-repeat; background-position: bottom right; font-weight: bold; text-align: center; } .event-time { padding: 10px; margin-top: 10px; width: 70%; background-color: #00000075; border-radius: 3px; display: inline-block; margin-left: 10px; } .event-type { padding: 10px; margin-top: 10px; width: 70%; background-color: #00000075; border-radius: 3px; display: inline-block; margin-left: 10px; }[/CODE] php: [CODE=php]class events { public function timeCheck($time) { if ($time == '25') { $time = '0'; } if ($time == '26') { $time = '1'; } } public function now_plugin() { global $db; $time = date('H') - 1 + 1; $day = date('N'); $now_plugin = $db->prepare(" SELECT * FROM cms_events WHERE time = :time AND day = :day "); $now_plugin->bindParam(":time", $time); $now_plugin->bindParam(":day", $day); $now_plugin->execute(); if ($now_plugin->RowCount() > 0) { $now_plugin_data = $now_plugin->fetch(); echo " <div class='event-image'> <div class='event-time'>{$now_plugin_data['time']}:00</div> <div class='event-type'>{$now_plugin_data['event_name']}</div> </div> "; } else { echo " <div class='event-image'> <div class='event-time'>$time:00</div> <div class='event-type'>NO EVENT BOOKED</div> </div> "; } } public function next_plugin() { global $db; $time = date('H') - 1 + 2; $day = date('N'); self::timeCheck($time); $next_plugin = $db->prepare(" SELECT * FROM cms_events WHERE time = :time AND day = :day "); $next_plugin->bindParam(":time", $time); $next_plugin->bindParam(":day", $day); $next_plugin->execute(); if ($next_plugin->RowCount() > 0) { $next_plugin_data = $next_plugin->fetch(); echo " <div style='opacity: 0.5;' class='event-image'> <div class='event-time'>{$now_plugin_data['time']}:00</div> <div class='event-type'>{$now_plugin_data['event_name']}</div> </div> "; } else { echo " <div style='opacity: 0.75;' class='event-image'> <div class='event-time'>$time:00</div> <div class='event-type'>NO EVENT BOOKED</div> </div> "; } } public function later_plugin() { global $db; $time = date('H') - 1 + 3; $day = date('N'); self::timeCheck($time); $later_plugin = $db->prepare(" SELECT * FROM cms_events WHERE time = :time AND day = :day "); $later_plugin->bindParam(":time", $time); $later_plugin->bindParam(":day", $day); $later_plugin->execute(); if ($later_plugin->RowCount() > 0) { $later_plugin_data = $later_plugin->fetch(); echo " <div style='opacity: 0.5;' class='event-image'> <div class='event-time'>{$now_plugin_data['time']}:00</div> <div class='event-type'>{$now_plugin_data['event_name']}</div> </div> "; } else { echo " <div style='opacity: 0.5;' class='event-image'> <div class='event-time'>$time:00</div> <div class='event-type'>NO EVENT BOOKED</div> </div> "; } } }[/CODE] image i used: [ATTACH type="full" width="348px" alt="lpromo_nov20_gen.png"]11635[/ATTACH] put this anywhere before you run the script, change the timezone if your not using londons timezone: date_default_timezone_set('Europe/London'); how it looks: [ATTACH type="full" alt="nownextlater.png"]11634[/ATTACH] Alternative: [URL]https://github.com/BigDeclan/now-next-later-script[/URL] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members