Null value is returned from mysql through php -
i working on project, in need send 2 alerts through email. have implemented 1 email alert , working fine , i'm getting status message completed after successfull delivery of email second 1 have added 1 more column service_status. although email functionality working fine doesnot showing completed instead showing null or empty value, value in database "completed"... here peice of code need show completed result
<?php if(count($det)){ ?> <?php for($i=0;$i<count($det);$i++) {?> <tr class="rowvalues"> <td rowspan="2" class="bottomcolor"> <input type="checkbox" name="list[]" value="<?php echo $det[$i]['customer_id']; ?>" /></td> <td rowspan="2" class="bottomcolor"><?php echo $det[$i]['customer_title'].".".$det[$i]['customer_surname']; ?></td> <td rowspan="2" class="bottomcolor"><?php echo $det[$i]['vehicle_regno']; ?></td> <td>reminder1</td> <td><?php if ($det[$i]['reminder1_duedate'] != '0000-00-00'){ echo date('d/m/y',strtotime($det[$i]['reminder1_duedate']));}else{echo '00/00/0000';} ?></td> <td><?php if ($det[$i]['reminder1_duedate'] != '0000-00-00'){ echo date('d/m/y',strtotime($det[$i]['reminder1_duedate'].'- 28 days'));}else{echo '00/00/0000';} ?></td> <td><?php if ($det[$i]['reminder1_duedate'] != '0000-00-00'){ echo date('d/m/y',strtotime($det[$i]['reminder1_duedate'].'- 14 days'));}else{echo '00/00/0000';} ?></td> <td><?php if ($det[$i]['reminder1_duedate'] != '0000-00-00'){ echo date('d/m/y',strtotime($det[$i]['reminder1_duedate'].'- 2 days'));}else{echo '00/00/0000';} ?></td> <td><?php echo isset($det[$i]['reminder1_status'])?($det[$i]['status']=='c')?'completed':'pending':'';?> </td> <td rowspan="2" class="bottomcolor"><a href="<?php echo base_url();?>preview/view_vehicle.php?vid=<?php echo $det[$i]['customer_id'];?>" rel="facebox"><img src="<?php echo base_url();?>images/view.gif" alt="view"/></a> <a style="text-decoration:none;" href="<?php echo base_url();?>index.php/vehicles/edit_mot/<?php echo $det[$i]['customer_id'];?>" title="edit"> <img src="<?php echo base_url();?>images/edit.gif" alt="search"/></a> <a style="text-decoration:none;" href="<?php echo base_url();?>index.php/vehicles/view/delete/<?php echo $det[$i]['customer_id'];?>" onclick="return confirm('are sure want delete vehicle details?');" title="delete"> <img src="<?php echo base_url();?>images/delete.gif" alt="delete"/></a></td> </tr> <tr> <td class="bottomcolor">reminder 2</td> <td class="bottomcolor"><?php if ($det[$i]['reminder2_duedate'] != '0000-00-00'){ echo date('d/m/y',strtotime($det[$i]['reminder2_duedate'])); }else{echo '00/00/0000';}?></td> <td class="bottomcolor"><?php if ($det[$i]['reminder2_duedate'] != '0000-00-00'){ echo date('d/m/y',strtotime($det[$i]['reminder2_duedate'].'- 28 days'));}else{echo '00/00/0000';}?></td> <td class="bottomcolor"><?php if ($det[$i]['reminder2_duedate'] != '0000-00-00'){ echo date('d/m/y',strtotime($det[$i]['reminder2_duedate'].'- 14 days'));}else{echo '00/00/0000';}?> </td> <td class="bottomcolor"><?php if ($det[$i]['reminder2_duedate'] != '0000-00-00'){ echo date('d/m/y',strtotime($det[$i]['reminder2_duedate'].'- 2 days'));}else{echo '00/00/0000';}?> </td> <td class="bottomcolor"><?php echo isset($det[$i]['reminder2_status'])?($det[$i]['service_status']=='c')?'completed':'pending':'';?> </td> </tr> <?php } } else{ echo '<div class="row"><p style="text-align:center;"><strong>no records found</strong></p></div>'; } ?> </table> the problem line of code
<td class="bottomcolor"><?php echo isset($det[$i]['reminder2_status'])?($det[$i]['service_status']=='c')?'completed':'pending':'';?> </td> this returning empty or null value
its because $det[$i]['reminder_status'] variable undefined. check $det variable in call mysql query. make sure reminder_status column returned through mysql.
Comments
Post a Comment