1

How to convert empty string to Null or "Nothing" when the column appears in the datatable. For example, in the brand column, there are many empty strings. So, i wanted to change it to null or "None".

$columns = array(
    array( 'db' => 'id', 'dt' => 0 ),
    array( 'db' => 'name',      'dt' => 1 ),
    array( 'db' => 'brand',     'dt' => 2 ),
    array(
        'db'        => 'end-date',
        'dt'        => 3,
        'formatter' => function( $d, $row ) {
            return date( 'jS M Y', strtotime($d));
        }
    ),
    array(
        'db'        => 'id',
        'dt'        => 4,
        'formatter' => function( $d, $row ) {
            return '<a class="btn btn-danger" href="proDelete.php?id=' . $d . '" onclick="return confirm(\'Are you sure you want to delete this item?\')">Delete</a>';
        }
    ),
);

$where = "end-date< CURDATE()";
// Include SQL query processing class
require( 'ssp.class.php' );

// Output data as json format
echo json_encode(
    SSP::complex( $_GET, $dbDetails, $table, $primaryKey, $columns, $where)
);
Flucky
  • 15
  • 3

1 Answers1

0

Just use a function like you do it in other columns:

array(
    'db' => 'brand',
    'dt' => 2,
    'formatter' => function($d, $row) {
        return $d !== '' ? $d : 'Nothing';
    }
),
CodyKL
  • 1,024
  • 6
  • 14