芝麻web文件管理V1.00

编辑当前文件:/home/disqkgca/public_html/cargo/downloadbox.php

<?php

global $wpdb;

$displaymsg = '';

$today = date('Y-m-d H;i:s');

$wpdb->get_results("

SELECT * FROM kn_departuredates where processclose = 0   ");

if($wpdb->num_rows>0)

{

$myrows = $wpdb->get_results( "SELECT * FROM kn_departuredates where processclose = 0  order by departuredate ASC" );

?>

<div class="row">

<table class="table table-striped table-bordered">

<thead style="background:black;color:#fff;">

<tr>

<td>#</td>

<th>Delivery Type</th>

<th>Dates</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

$counter = 0 ;

foreach($myrows as $key=>$val)

{

$counter++;

$dtype = $wpdb->get_row( "SELECT * FROM kn_delieverytype WHERE id = '".$val->dtype."' ", ARRAY_A );

$class = '';

if($val->dtype == 1)

{

$class='style="color:blue"';

}

else

{

$class='style="color:red"';

}

?>

<tr>

<td><?php echo $counter;?></td>

<td><span <?php echo $class;?>><?php echo $dtype['dtype']; ?></span></td>

<td><?php echo date("dS F, Y ",strtotime($val->departuredate));?></td>

<td><a  href="https://disqinc.co.uk/cargo/download-box-list/?d=<?php echo $val->id; ?>">Download</a></td>

</tr>

<?php

}

?>

</tbody>

</table>

<?php

}

else

{

$displaymsg = '<div class="alert alert-info">No Record Found...</div>';

}

echo $displaymsg;

?>