Show more results in table
Show more results in table
kapikua
Posts: 8Questions: 1Answers: 0
Hello folks
I have a list of 150.000 results with name, surname, phone and email.
The problem is that when I am showing it, everything is blocked and the search or indexing tools do not appear.
I am aware that this is a lot of results, is it better for me to use another system or is there something I can do?
Thanks a lot for you time
This question has accepted answers - jump to:
Answers
Sounds like you will need to use Server Side Processing to handle paging of the data. You will need a server script to support the Server Side Processing Protocol. Datatables provides some SSP scripts. See this blog for information on how to use them.
Kevin
Thanks a lot
I will check now
hello Again
Finally works perfectly, thanks.
I have another question, i have my data encrypted width this fuction:
function encriptar($string, $key) {
$result = "";
for($i=0; $i<strlen($string); $i++) {
$char = substr($string, $i, 1);
$keychar = substr($key, ($i % strlen($key))-1, 1);
$char = chr(ord($char)+ord($keychar));
$result.=$char;
}
return base64_encode($result);
}
And decrypted with this:
function desencriptar($string, $key) {
$result = "";
$string = base64_decode($string);
for($i=0; $i<strlen($string); $i++) {
$char = substr($string, $i, 1);
$keychar = substr($key, ($i % strlen($key))-1, 1);
$char = chr(ord($char)-ord($keychar));
$result.=$char;
}
return $result;
}
++++++++++++++++++++++
The think is i dont know how desencript in array from server_processing.php.
**$columns = array(
array( 'db' => 'name', 'dt' => 0 ),
array( 'db' => 'surname', 'dt' => 1 ),
);
**
Some can helpme with some idea for solve ?
Thanks for you time,
For the demo SSP class, you could use a
formatterfunction as shown here.Allan
Yes, works perfect.
Its awesome folks, thanks for help.
Another query, I am seeing that the search for results does not work.
Is this normal or do I have to do something to make it work?
Im looking in "Sent parameters"
Do you mean for the formatted data? Unfortunately that is a limitation of the script. The formatting is done in PHP while the search is performed in the SQL engine. The only way to address that is to perform the formatting in the database as well.
See this SO question (and other similar ones) for how to search encrypted data in a database.
Allan
One thing to add, since your encryption looks like it is base64 with a secret string offset, I'd encourage you to not roll your own. Use the built in functions in the database that are designed for that sort of thing.
Allan
Finally I am not going to have the encrypted data, is there a way for the browser to consult the database and NOT the results of the table?
Yes, with normal text ( No encripted ) works very good.
This is Awesome guys, well donne.
Only if that is exposed via an HTTP API.
Good to hear you've got it working now.
Allan