setQuery("SELECT * FROM `trf-details` LEFT JOIN company ON `trf-details`.idcompany=company.idcompany LEFT JOIN article_type ON `trf-details`.idarticletype=article_type.idarticletype WHERE `trf-details`.signedon IS NOT NULL ORDER BY `trf-details`.trfnumber"); $archivetrflist->execute(); ?> Crovex - Admin & Dashboard Template

Datatable

Default Datatable

DataTables has most features enabled by default, so all you need to do to use it with your own tables is to call the construction function: $().DataTable();.

atEnd()) { $wa_startindex = $archivetrflist->Index; ?> moveNext(); } $archivetrflist->moveFirst(); //return RS to first record unset($wa_startindex); unset($wa_repeatcount); ?>
TRF N. Signed On Company Name Article type
getColumnVal("trfnumber")); ?> getColumnVal("signedon")); ?> getColumnVal("companyname_company")); ?> getColumnVal("name_articletype")); ?>

Buttons example

The Buttons extension for DataTables provides a common set of options, API methods and styling to display buttons on a page that will interact with a DataTable. The core library provides the based framework upon which plug-ins can built.

atEnd()) { $wa_startindex = $archivetrflist->Index; ?> moveNext(); } $archivetrflist->moveFirst(); //return RS to first record unset($wa_startindex); unset($wa_repeatcount); ?>
TRF N. Signed On Company Name Article type
getColumnVal("trfnumber")); ?> getColumnVal("signedon")); ?> getColumnVal("companyname_company")); ?> getColumnVal("name_articletype")); ?>
© 2020 Crovex Crafted with by Mannatthemes