Lines 88-102
else {
Link Here
|
88 |
my $iTotalRecords = ''; |
88 |
my $iTotalRecords = ''; |
89 |
my $sth = ''; |
89 |
my $sth = ''; |
90 |
|
90 |
|
91 |
if (my $filter = $params->{'sSearch'}) { |
91 |
$iTotalRecords = $dbh->selectrow_array('SELECT count(*) FROM quotes;'); |
92 |
# This seems a bit brute force and ungraceful, but it provides a very general, simple search on all fields |
92 |
$sth = $dbh->prepare("SELECT * FROM quotes;"); |
93 |
$iTotalRecords = $dbh->selectrow_array("SELECT count(*) FROM quotes WHERE id LIKE %?% OR source LIKE %?% OR text LIKE %?% OR timestamp LIKE %?%;",undef,($filter, $filter, $filter, $filter)); |
|
|
94 |
$sth = $dbh->prepare("SELECT * FROM quotes;"); |
95 |
} |
96 |
else { |
97 |
$iTotalRecords = $dbh->selectrow_array('SELECT count(*) FROM quotes;'); |
98 |
$sth = $dbh->prepare("SELECT * FROM quotes;"); |
99 |
} |
100 |
|
93 |
|
101 |
$sth->execute(); |
94 |
$sth->execute(); |
102 |
if ($sth->err) { |
95 |
if ($sth->err) { |
103 |
- |
|
|