Radio schedule php -


i making radio scheduler. should show program on now.

<?php header('access-control-allow-origin: *'); ?> <?php mysql_connect("localhost", "dennis", "***") or die(mysql_error()); mysql_select_db("daletnew") or die(mysql_error()); date_default_timezone_set('europe/amsterdam'); $day = date('l'); $hour = date('h');   $query = "select time_end shows day='$day' , time_start='$hour'"; $result = mysql_query($query);  $query = "select * shows day='$day' , time_start='$hour'"; $result = mysql_query($query); if (mysql_num_rows($result)==0) {   echo '<div id="onair_info" style="position: relative; top: 40px;">'; echo '<br />'; echo '<div class="info_time_time" style="position: relative; left: 4px; color: #2980b9; font-size: 18px; font-family: roboto; font-weight:300; top: -10px; ">'; echo "favoritefm music"; echo '</div>'; echo '</div>';  } else {  while ($row = mysql_fetch_assoc($result)) {      $show_name = $row['show_name'];      $dj = $row['dj'];       $time_start = $row['time_start'];       $time_stop = $row['time_stop'];        $sql1 = "select * dj dj='$dj'"; $result1 = mysql_query($sql1);  while($info1 = mysql_fetch_array($result1))   {  $image_url = $info1['image_url']; }  echo '<div id="circle" style="position: relative; top: 40px; left: 175px; width:50px;height:50px; border-color:#00aeff; border-radius:50px; line-height:100px;text-align:center; background-repeat: no-repeat; background-image: url(' . $image_url . ');"></div>';       echo '<div id="onair_info" style="position: relative; top: 0px;">'; echo '<div class="info_time_live" style="position: relative; color: #2980b9; font-size: 12px; font-family: roboto;top: -12px;left: 20px;">'; echo 'live </div>'; echo '<div class="info_time_time" style="position: relative; left: 60px; color: #2980b9; font-size: 12px; font-family: roboto;top: -26px;">'; echo $time_start; echo '</div>'; echo '<div class="arrow_to_right" style="position: relative; width:15px; top: -40px;left: 80px;height:15px; background-repeat: no-repeat; background-image:url(\'http://test.favoritefm.com/wp-content/themes/favoritefm/img/arrow_to_right.png\')"></div>'; echo '<div class="info_time_time" style="position: relative; left: 100px; color: #2980b9; font-size: 12px; font-family: roboto;top: -55px;">'; echo $time_stop; echo '</div>'; echo '<br />'; echo '<div class="info_show" style="position: relative; top: -57px; left: 20px; color: #2980b9; font-size: 14px; font-family: roboto;">'; echo '<div class="dj_name" style="font-size: 15px; font-family: roboto; font-weight: bold";>'; echo $dj; echo '</div>'; echo '<br />'; echo '<div class="show_name" style="font-size: 14px; font-family: roboto;position: relative;top: -15px">'; echo $show_name; echo '</div>'; echo '</div>'; echo '</div>'; } }  ?>

obviously, shows shows last 1 hour. have shows start @ 12 , end @ 16. don't know start or how it. how can script show radio show between 12 , 16? have beginning , end time in table als time_start , time_stop.

try changing second sql line this:

$query = "select * shows day='$day' , time_start<=$hour , time_stop>$hour"; $result = mysql_query($query);

you can remove first sql query , keep other code same. uses sql comparison operators return radio show if current hour between start , end hours. using example (12-16 hours), 12:15 , 15:50 return show, 11:55 , 16:05 not.

edit: please ensure time_start , time_stop sql int type, , $hour int. comparison operators can't compare strings.


Comments

Post a Comment

Popular posts from this blog

javascript - Bootstrap Popover: iOS Safari strange behaviour -

i looking through twitter bootstrap documentation, , i'm interested in implementing dismissible popover when button clicked. here example bootstrap's docs: http://getbootstrap.com/javascript/#dismiss-on-next-click when press "dismissible popover" button os x safari browser works fine. when access same link above ios safari, button not work. is, popover not dismissed on click. why button not working ios safari? the example linked using data-trigger="focus" attribute. try changing data-trigger="click" . <a tabindex="0" class="btn btn-lg btn-danger" role="button" data-toggle="popover" data-trigger="click" title="dismissible popover" data-content="and here's amazing content. it's engaging. right?">dismissible popover</a>
Read more

Website Login Issue developed in magento -

i have website developed using magento . able login. right now, login failed. infact operations interacts user table failing. need know issue. how figure out? first clear try clear log file second make sure have not upgraded magento and 3rd make sure db accessible in magento -harry p
Read more

Can the constants be defined inside a model file of a framework in PHP? -

i'm using phpfox framework. i've define 2 constants used 2 functions present within model class file. can define constants @ beginning of model class file or cause issue or against coding standards? please me in regard. following 1 method model class file. i want write following code : <?php /** * [phpfox_header] */ /*header('content-type: text/event-stream'); header('cache-control: no-cache');*/ defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($stype, $iitemid, $iowneruserid, $isenderuserid = null) ...
Read more