Replies

• kqueekquee Posts: 40Questions: 1Answers: 0

  March 2014

  new version
  
  http://live.datatables.net/nimawun/3/edit
• lyndonwil Posts: 40Questions: 5Answers: 0

  March 2014

  Have a look at http://www.datatables.net/forums/discussion/20096/individual-column-filter-in-1-10#Item_1
• kqueekquee Posts: 40Questions: 1Answers: 0

  March 2014

  merci beaucoup
  
  i have changed code of ' ssp.class.php ' and i can filtering all Individual column
  if ( count( $columnSearch ) ) {
  $where = $where === '' ?
  implode(' AND ', $columnSearch) :
  $where .' AND '. implode(' AND ', $columnSearch);
  }
• kqueekquee Posts: 40Questions: 1Answers: 0

  March 2014

  when data contains spécial caracters ' èçàù...' the datatable return ' null '
  i changed ssp.class.php with utf8_encode( to return the spécial caracters in the datatable
  
  // Is there a formatter?
  // 28/03/2014 utf8_encode () for spécial character éàèù...
  if ( isset( $column['formatter'] ) ) {
  $row[ $column['dt'] ] = utf8_encode($column['formatter']( $data[$i][ $column['db'] ], $data[$i] ));
  }
  else {
  $row[ $column['dt'] ] = utf8_encode( $data[$i][ $columns[$j]['db'] ]);
  }
  }
• kqueekquee Posts: 40Questions: 1Answers: 0

  March 2014

  il have datatable with spécial french caracter example ' pointe à pitre , château ,... and it's not possible to filter in global or individual
• NelsonTiger Posts: 3Questions: 0Answers: 0

  May 2014

  kqueekquee, you can add support for languages other than those that use latin characters by adding this line:

  //Set the character encoding to UTF-8
  SSP::sql_exec( $db, "SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'");
  

  Right before:

  $data = SSP::sql_exec( $db, $bindings, $query);
  

  In the simple() function of ssp.class.php. Then in the sql_exec() function replace the return line with this:

  return $stmt->rowCount() > 0 ? $stmt->fetchAll() : false;
  
• kqueekquee Posts: 40Questions: 1Answers: 0

  May 2014

  thanks
  it's ok with ' SSP::sql_exec( $db, "SET character_set_client = 'utf8'"); '
  filtering it's ok when i use latin character

  SSP::sql_exec( $db, "SET character_set_client = 'utf8'");
  $data = SSP::sql_exec( $db, $bindings,
  "SELECT SQL_CALC_FOUND_ROWS ".implode(", ", SSP::pluck($columns, 'db'))."
  FROM $table
  $where
  $order
  $limit"
  );

  // Execute
  try {
  $stmt->execute();
  }
  catch (PDOException $e) {
  SSP::fatal( "An SQL error occurred: ".$e->getMessage() );
  }

  // Return all
  // return $stmt->fetchAll();
  // 23.05.2014 http://datatables.net/forums/discussion/comment/61516#Comment_61516
  return $stmt->rowCount() > 0 ? $stmt->fetchAll() : false;
  }

  christian