- or download this
if ($search_value) {
$sql .= "WHERE product LIKE ? OR descp LIKE ?";
$count_sql .= "WHERE product LIKE ? OR descp LIKE ?";
}
- or download this
# Add LIMIT for pagination
# $sql .= " LIMIT ?, ?"; # i disabled it by comment. because was getti
+ng alot errors with it
- or download this
file.pl: DBD::mysql::st execute failed: You have an error in your SQL
+syntax; check the manual that corresponds to your MariaDB server vers
+ion for the right syntax to use near 'LIKE '%tam%' OR product LIKE '%
+tam%'' at line 1 at file.pl
- or download this
#!/usr/bin/perl
...
$dbh->disconnect();