Jump to content

Problem in NULL value


newphpbees

Recommended Posts

Hi...

i have table

EMP_NO

LOGIN - DATETIME, NULL

LOGOUT - DATETIME, NULL

 

I have this query:

 

<?php

include 'config.php';

$currentEmpID = $_SESSION['empID']; 

if(!isset($_POST['submit_'])){ 
     
    $DATE1 = $_POST['firstinput'];
    $DATE2   = $_POST['secondinput'];
    
  
$sql = "SELECT EMP_NO, LOGIN, LOGOUT  FROM employee_attendance WHERE DATE(LOGIN) BETWEEN '$DATE1' AND '$DATE2'";
    $attendance = $conn3->GetAll($sql);
   
    $smarty->assign('attendance', $attendance);

}
$smarty->display('header_att.tpl');
$smarty->display('empAttendance.tpl');
$smarty->display('footer.tpl');
  
?> 

 

My problem is I have data

EMP_NO 00000223

LOGIN NULL

LGOUT NULL

 

this data was not displayed because it has a null value.. i want it to displayed also and highlight it because it has a value null..

 

Thank you

Link to comment
Share on other sites

This is my new code...my problem now is highlighting with null values

 

 

Now also I need to highlight the data which has a NULL value.

 

I have this revised code:

if(!isset($_POST['Regsubmit_'])){ 
     
    $DATE1 = $_POST['Regfirstinput'];
    $DATE2   = $_POST['Regsecondinput'];


$sql = "SELECT a.EMP_NO, CONCAT(LNAME, ', ' , FNAME, ' ', MI) AS FULLNAME, a.LOGIN, a.LOGOUT
FROM $ATTENDANCE.employee_attendance AS a LEFT JOIN $ADODB_DB.employment em ON a.EMP_NO = em.EMP_NO 
LEFT JOIN $ADODB_DB.personal p ON em.EMP_ID = p.EMP_ID WHERE DATE(LOGIN) BETWEEN '$DATE1' AND '$DATE2' 
AND em.STATUS IN ('Reg Operatives', 'Reg Staff ') OR LOGIN IS NULL";
    $DTR = $conn3->GetAll($sql);
    
$LOGIN = $DTR->fields['LOGIN'];

if($LOGIN == NULL){
// I dont know how can I add stylesheet here so that if it has a NULL value it will have a background color RED
}
   
    $smarty->assign('attendance', $DTR);

}

 

<div id="attendance" style="width: 580px; height: 420px; overflow: auto; padding: 5px; top:95px">
<fieldset>
<legend>Employee Attendance</legend>
<table border="1">
<tr>
<td colspan="2" style="text-align:center">Employee No</td>
<td colspan="2" style="text-align:center">Employee Name</td>
<td colspan="2" style="text-align:center">Time In</td>
<td colspan="2" style="text-align:center">Time Out</td>
</tr>

{section name=att loop=$attendance}
  <tr>
    <td colspan="2">{$attendance[att].EMP_NO}</td>
    <td colspan="2">{$attendance[att].FULLNAME}</td>  
    <td colspan="2">{$attendance[att].LOGIN|date_format:"%d-%m-%Y %I:%M %p"}</td>
    <td colspan="2">{$attendance[att].LOGOUT|date_format:"%d-%m-%Y %I:%M %p"}</td> 
  </tr>
{sectionelse}
  <tr><td colspan="1">No DATA</td></tr>
{/section}
</table>
</fieldset>
</div>

 

Thank you

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.