Hi,
Working with grid connector with Sqlite through PDO . After reordering column , filter isn’t trully working . I tried to change 2 ir 3 columns . Data are correct . But choosing from #connector_select_filter in the new 2-nd column it not finding data …
<body>
<div id="dGrid" style=height:540px;background-color:white;"></div>
<script type="text/jvascript">
mygrid = new dhtmlXGridObject( 'dGrid' );
mygrid.setImagePath( "codebase/imgs/" );
mygrid.setSkin( "dhx_skyblue" )
mygrid.setHeader( "Uzsak ID,Telkinys,Uzs.data,Uzs.sav,Preke,Uzs.kiekis" );
mygrid.setInitWidths( "150, 100, 150, 75, 150, 100" )
mygrid.setColAlign( "left,left,center,center,left,rigth" )
mygrid.setColTypes( "ed,ed,ed,ro,ed,ed" );
//mygrid.setColSorting( "str,str,str,str,str,int");
mygrid.attachHeader( "#connector_text_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_text_filter" );
mygrid.setColSorting( "connector,connector,connector,connector,connector,connector" );
mygrid.enableMultiselect(true);
mygrid.enableColumnMove(true);
mygrid.init();
mygrid.enableHeaderMenu();
mygrid.load( "uzs1.php" );
mygrid.enableUndoRedo();
myDp = new dataProcessor( "uzs1.php" );
myDp.init( mygrid );
</script>
</body>
Php :
<?php
require( "php/codebase/grid_connector.php" );
require( "php/codebase/db_pdo.php" );
if ( $dbh = new PDO( "sqlite:db/engel.db3") )
{
$grid = new GridConnector( $dbh, "PDO" );
$grid->set_encoding("utf-8");
$grid->render_table( "uzsakym", "uzsak", "uzsak,telkinys,uzs_data,uzs_sav,preke,uzs_kiekis" );
}
else
die( $sqliteerror );
?>
What I’m doing wrong ? With best regards !