PHP - Problem In Time

So the code works right, (I think)  but for some reason the way I built it the logic comes back null.

I can do All w a specific shift/s, and All with department/s but I can't do All shifts and All departments
it doesn't' error either, just brings back nothing, maybe timing out?


I'm very new at this so I apologize in advance.



Code below
############################################################
<form method="post" action="">
<br><br>
<table bordercolor="yellow" border="2">
 
<tr><td class="line"><b>Start Date:</b></td><td>
<input type="text" name="startdate" value="mm/dd/yyyy" /></td></tr>
</tr>
<tr><td class="line"><b>End Date:</b></td><td>
<input type="text" name="enddate" value="mm/dd/yyyy"  /></td></tr>
</tr>

<tr><td class="line"><b>Shift:</b></td><td>
         <SELECT NAME="shift" >
      <option selected>Select Shift</option>
     <option>First</option>
     <option>Second</option>
     <option>Third</option>
     <option>All</option>
      </SELECT> </td></tr>
     
<tr><td class="line"><b>Department:</b></td><td>
         <SELECT NAME="department" >
      <option selected>Select Department</option>
     <option>Advanced Hosting Support</option>
     <option>Server Support</option>
     <option>Managed Support</option>
     <option>All</option>
      </SELECT> </td></tr>
</tr>   
</tr>
</table>

<br><br>
<input type="submit" value="submit" />
</form>
<form action="" method="post">

</form>

</html>


<?php
require_once('global.inc.php');

   
class DataLogic
{
//function to obtain Employee names from RealID array to pass to MSSQL for call count

function GetEmpNames ($RealID)
{
   global $ems_db_connect;
   
   
foreach ($RealID as $emplist){

$query1 = mysql_query ("SELECT FirstName, LastName
                     FROM ems_employee_list
                  WHERE RealID=$emplist", $ems_db_connect) or die(mysql_error());;

while($row = mysql_fetch_array($query1))
                  {
                     $FirstName[] = $row['FirstName'];
                     $LastName[] = $row['LastName'];
                  }
                  
}
$friendlyname = array('first_name' => $FirstName, 'last_name' =>$LastName);
return $friendlyname;            
}
                  
//function to display Employee names from RealID array obtained from department and shift

function DisplayEmpNames ($RealID)
{
   global $ems_db_connect;
   
   
foreach ($RealID as $emplist){

$query1 = mysql_query ("SELECT FirstName, LastName
                     FROM ems_employee_list
                  WHERE RealID=$emplist", $ems_db_connect) or die(mysql_error());;

while($row = mysql_fetch_array($query1))
                  {
                     $FirstName = $row['FirstName'];
                     $LastName = $row['LastName'];
                     $fullname[] = "$LastName, $FirstName";
                  }
                  
}
return $fullname;
}

//function to pull the RealID's of Employees based on shift
//Returns a list of RealID's for use with GetIris and RepSort functions
function SelectEmpShift ($key)
{
global $ems_db_connect;


switch($key)
      {
         case "First":
            $shift = 1;
            break;
            
         case "Second":
            $shift = 2;
            break;
         
         case "Third":
            $shift = 3;
            break;
            
         default:
            $shift = 4;
         
      }   
if ($shift == 4){

   $query1 = mysql_query ("SELECT RealID
                     FROM ems_employee_list
                     LEFT JOIN ems_employee_schedules
                     USING (EmployeeID)
                     WHERE RealID > 0 AND Department='AHS'", $ems_db_connect) or die(mysql_error());
 
   while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
            }

else {
      $query1 = mysql_query ("SELECT RealID
                           FROM ems_employee_list
                           LEFT JOIN ems_employee_schedules
                           USING (EmployeeID)
                           WHERE RealID > 0 AND Shift = $shift AND Department ='AHS'", $ems_db_connect);
                  
                  

      while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
   }

return $x;
}

//Function to Select Employees based on Department
function SelectEmpDep ($key)
{
global $ems_db_connect;


switch($key)
      {
         case "Managed Support":
            $deptcode = 6;
            break;
            
         case "Server Support":
            $deptcode = 5;
            break;
         
         case "Advanced Hosting Support":
            $deptcode = 2;
            break;
            
         default:
            $deptcode = 7;
         
      }   
if ($deptcode == 7){
   
   $query1 = mysql_query ("SELECT RealID
                     FROM ems_employee_list
                     LEFT JOIN ems_employee_schedules
                     USING (EmployeeID)
                     WHERE RealID > 0 AND Department='AHS'", $ems_db_connect) or die(mysql_error());
 
   while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
               }

elseif ($deptcode == 5){


   $query1 = mysql_query ("SELECT RealID
                     FROM ems_employee_list
                     LEFT JOIN ems_employee_schedules
                     USING (EmployeeID)
                     WHERE RealID > 0 AND AccessID=5 OR AccessID=3 AND Department='AHS' AND RealID >0", $ems_db_connect) or die(mysql_error());
 
   while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
                  }

else {

      $query1 = mysql_query ("SELECT RealID
                           FROM ems_employee_list
                           LEFT JOIN ems_employee_schedules
                           USING (EmployeeID)
                           WHERE RealID > 0 AND AccessID=$deptcode AND Department ='AHS' ", $ems_db_connect);
                  
                  
      
      while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }

   }

return $x;
}


//function to sort Shift by multiple Deparments
function RepSortShiftDept ($RealIDShift, $RealIDDepartment='', $RealIDDepartment2='')

{
   $deptnumber = func_num_args();
   
      if ($deptnumber == 1)
         {
         
            $result = $RealIDShift;
         }
   
      elseif ($deptnumber == 2)
         {

            $result = array_intersect($RealIDShift, $RealIDDepartment);
         }
   
      else {
            $result = array_intersect($RealIDShift, array_merge($RealIDDepartment, $RealIDDepartment2));
         }

   return $result;
}

//function to sort Department by multiple Shifts
function RepSortDeptShift ($RealIDDepartment, $RealIDShift='', $RealIDShift2='')

{
      $shiftnumber = func_num_args();
   
      if ($shiftnumber == 1)
         {
         
            $result = $RealIDDepartment;
         }
   
      elseif ($shiftnumber == 2)
         {

            $result = array_intersect($RealIDDepartment, $RealIDShift);
         }
   
      else {
            $result = array_intersect($RealIDDepartment, array_merge($RealIDShift, $RealIDShift2));
         }

   return $result;

}


//Function to get and display count of Iris tickets from a date rage.
//$RealID needs to be an array of EmployeeIDs obtained from SelectEmpShift, SelectEmpDepart, and RepSort functions
function GetIris($RealID, $startdate, $enddate)
{
global $hocstat_db_connect;

foreach ($RealID as $emplist){

$mssqlquery = "SELECT COUNT (IncidentID) AS mycount
            FROM hocstats.dbo.DailyStatsEmployee
            WHERE hocstats.dbo.DailyStatsEmployee.EmployeeID=$emplist      
            AND(hocstats.dbo.DailyStatsEmployee.DateModified
            BETWEEN '$startdate 00:00:00.000' AND '$enddate 23:59:59.000')";
                                       
                  $query_3 = mssql_query ($mssqlquery,                              $hocstat_db_connect);                   
                     $row =(mssql_fetch_array($query_3)) ;
                     $iriscount[] = $row['mycount'];
}
return $iriscount;
}


//Function to get and display call counts from a date range. For use with GetEmpName ONLY
function GetCalls ($friendlyname, $startdate, $enddate)
{
global $hocstat_db_connect;

for ($x = 0; $x < count ($friendlyname['last_name']); $x++)
   {

$query1 ="SELECT ISNULL(SUM(CallsHandledToHalf), 0) AS calls
                  FROM Agent_Skill_Group_Half_Hour ASGHH WITH (NOLOCK)
                  INNER JOIN dbo.agent ON ASGHH.skilltargetid = dbo.agent.skilltargetid
      WHERE(dbo.agent.enterprisename = 'HOC_{$friendlyname['last_name'][$x]}_{$friendlyname['first_name'][$x]}'
      OR dbo.agent.enterprisename = '{$friendlyname['last_name'][$x]}_{$friendlyname['first_name'][$x]}')
                  AND (ASGHH.datetime BETWEEN '$startdate 00:00:00' AND '$enddate 23:59:00')";
                  
                  $mssqlquery = mssql_query ($query1, $hocstat_db_connect);
                  
while ($row =(mssql_fetch_array($mssqlquery)))
                     {                                                                                                                                                                                                                                                                                                                  
   $callcount[] = $row['calls'];   
}               
   
   }
return $callcount;   
}

}//class close


if($_POST)
//setting varibles from form input
{   
   
   $shift_id= isset($_POST['shift']) ? trim($_POST['shift']) : die('Missing entry: Shift Selection');
   $start_date= isset($_POST['startdate']) ? trim($_POST['startdate']) : die('Missing enty: Start Date');
   $end_date= isset($_POST['enddate']) ? trim($_POST['enddate']) : die('Missing enty: End Date');
   $depart_id= isset($_POST['department']) ? trim($_POST['department']) : die('Missing entry: Shift Selection');
   
}


echo "You have selected stats for $shift_id shift(s) and $depart_id department(s) from $start_date to $end_date. </br>" ;

$test=new DataLogic();

$calls = $test->GetCalls($test->GetEmpNames($test->RepSortShiftDept($test->SelectEmpShift("$shift_id"), $test->SelectEmpDep("$depart_id"))), $start_date, $end_date);


$iris= $test->GetIris ($test->RepSortShiftDept($test->SelectEmpShift("$shift_id"), $test->SelectEmpDep("$depart_id")), $start_date, $end_date);

$name= $test-> DisplayEmpNames($test->RepSortShiftDept($test->SelectEmpShift("$shift_id"), $test->SelectEmpDep("$depart_id")));

$table = array ( 'calls' => $calls, 'iris' => $iris, 'name' => $name);

for ($x = 0; $x < count ($table['calls']); $x++)
   {    
      echo $table["name"][$x];
      echo "</br> Calls Taken :";
      echo $table["calls"][$x];
      echo "</br> Iris Tickets Resolved:";
      echo $table["iris"][$x];
      echo "</br>";
   
   }

?>

Hi - I have been searching for a way to select the stored time from a database (stored in 24h format - 13:20:00) and display it as 12h format. I have checked a number of forums and nothing quite seems to fit the bill. I would like it to display as 2:00pm, 12:00am, etc. Here is what I have so far:

  $sql = ('SELECT * FROM events WHERE active="1" AND event_date >= CURRENT_DATE AND MONTH(event_date) = 1 order by event_date ASC, event_start ASC');
  $result = mysql_query($sql);
  $num_rows = mysql_num_rows($result);
 
  // Yes Item
  if (!($num_rows == 0)) {
   $myrow = mysql_fetch_array($result);
   echo ('<span class="bold" style="font-size:14px">January</span>');
   do {
     printf ('<span>Event Time: %s', $myrow['event_start']);
        if ($myrow['event_end'] != '') {
        printf (' to %s', $myrow['event_end']);
        }
   }
   while ($myrow = mysql_fetch_array($result));
  } 

Right now this just shows the regular 24h format (hh:mm:ss) for any events in the month of January. I would like both "event_start" and "event_end" to show up in 12h format. I have tried a number of things but none of it works. I'm SURE it is something simple that I have missed. Thanks in advance for any help.

Hi
My code was working perfectly when my hosting company located in Japan. But i transfer to US(hostgator) and now my time zone changes asia/tokyo to America/Chicago. Therefore, all my codes, scripts and sites are following one day behind of Japan local time.
Great appreciate for any help. My code is below:


<?php

$host = "localhost";
$user = "user";
$pass = "pass";
$data = "mysql_db";

$cn     = mysql_connect($host, $user, $pass) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($data, $cn) or die("Could not Connect Database Please Try again later !!!");
mysql_query("set names utf-8", $cn);

if(date("H:i:s") < '03:00:00') // Changes midnight 00:00:00 to 03:00:00
          $midnight = 1;
else
          $midnight = 0;

       $TODAY__ = mktime(0, 0, 0, date("n"), date("d") - $midnight, date("Y"));
       date_default_timezone_set('Asia/Tokyo');
?>

Hi,

I'm preparing a code for an automated email, but the date time is not working correctly. I wanted to do a cron scheduler that emails people twice a day - 9am and 9pm. 9am sends email about records logged starting 9pm yesterday to 9am, while 9pm sends email about records logged from 9:01am to 9:00pm. The database uses date/time, so I was doing an if statement of date time, but I wasn't getting the result I wanted.

Sometimes the $now time is not within the yesterday 9pm to the 9pm today range. I don't know what I'm doing wrong, but I'm sure that it has something to do with the if statement, as the some of the $now time enters the else statement

Here is my code:


<?php
$today = date('Y-m-d 00:00:00');
$nineyesterday = date('Y-m-d H:i:s', mktime(date("H") - (date("H") + 6), date("i") - date("i"), date("s") - date("s"), date("m") , date("d"), date("Y")));
$now = date('Y-m-d H:i:s', mktime(date("H") + 13, date("i"), date("s"), date("m") , date("d"), date("Y")));
$nineam = date('Y-m-d 09:00:00');
$nine30 = date('Y-m-d 09:30:00');
$ninepm = date('Y-m-d 18:00:00');
echo '9pm yesterday: '.$nineyesterday;
echo '<br/>';
echo '9am: '.$nineam;
echo '<br/>';
echo '9pm: '.$ninepm;
echo '<br/>';
echo 'now: '.$now;
echo '<br/>';


if ((strtotime($now) > strtotime($nineyesterday)) and  (strtotime($now) <= strtotime($nineam)))
{
//count the answers by yes or no
echo 'am';

}
elseif ((strtotime($now) > strtotime($nineam)) and  (strtotime($now) <= strtotime($ninepm)))
{
//count the answers by yes or no
echo 'pm';
}
else
{
echo 'error';
}
?>


Thanks in advance