if ($search_value) {
    $sql .= "WHERE product LIKE ? OR descp LIKE ?";
    $count_sql .= "WHERE product LIKE ? OR descp LIKE ?";
}

##</code><code>##

# Add LIMIT for pagination 
# $sql .= " LIMIT ?, ?"; # i disabled it by comment. because was getting alot errors with it

##</code><code>##

file.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIKE '%tam%' OR product LIKE '%tam%'' at line 1 at file.pl 

##</code><code>##

#!/usr/bin/perl

use strict;
use warnings;
use CGI;
use JSON;
use DBI;

my $q = CGI->new;
print $q->header('content-type: application/json; charset=UTF-8');

my $dsn = "DBI:mysql:database_name:host=localhost";
my $db_user = "user";
my $db_pass = "password";
my $dbh = DBI->connect($dsn, $db_user, $db_pass, { RaiseError => 1, AutoCommit => 1 });

my $draw = $q->param('draw') || 1;
my $start = $q->param('start') || 0;
my $length = $q->param('length') || 5;
my $search_value = $q->param('search[value]') || '';

my $total_info = $dbh->prepare("SELECT count(*) FROM t_infos WHERE status = ?");
$total_info->execute('bought');
my $infos = $total_info->fetchrow_array(); 
$total_info->finish;

my $count_sql = "SELECT COUNT(*) FROM t_infos";

my $sql = '';

if ($infos >= 1) {

 $sql = "SELECT 
  snd.avatar, snd.fullname, m.product, m.descp, m.price, m.tag, m.seal FROM
  t_infos as m
  JOIN users as snd ON snd.accountnumber = m.accountnum WHERE CASE WHEN (SELECT SUM(status = ?) FROM  t_infos) > 0 THEN m.status = ? ELSE m.status = ?  OR m.status = ? OR m.status = ? END
  ORDER BY created ASC";
}

if ($infos <= 0) {

  $sql = "SELECT 
  snd.avatar, snd.fullname, m.product, m.descp, m.price, m.tag, m.seal FROM
  t_infos as m
  JOIN users as snd ON snd.accountid = m.accountnum WHERE CASE WHEN (SELECT SUM(status = ?) FROM  t_infos) > 0 THEN m.status = ? ELSE m.status = ?  OR m.status = ? OR m.status = ? END
  ORDER BY created ASC LIMIT 100";
}


if ($search_value) {
    $sql .= "WHERE product LIKE ? OR descp LIKE ?";
    $count_sql .= "WHERE product LIKE ? OR descp LIKE ?";
}

# Add LIMIT for pagination but not working if i remove comment
# $sql .= " LIMIT ?, ?";

my $count_sth = $dbh->prepare($count_sql);
if ($search_value) {
    my $search_term = "%$search_value%";
    $count_sth->execute($search_term, $search_term);
} else {
    $count_sth->execute();
}
my ($recordsTotal) = $count_sth->fetchrow_array;
my $recordsFiltered = $recordsTotal; 

my $data_sth = $dbh->prepare($sql);
if ($search_value) {
     my $search_term = "%$search_value%";
     $data_sth->execute($search_term, $search_term, 'bought', 'bought', 'available', 'outstock', 'sold');
} else {
     $data_sth->execute('bought', 'bought', 'available', 'outstock', 'sold');
}

my @rows;
while (my $row_hash = $data_sth->fetchrow_hashref) {
    push @rows, {
        avatar         => $row_hash->{'avatar'},
        fullname       => $row_hash->{'fullname'},
        product   => $row_hash->{'product'},
        descp     => $row_hash->{'descp'},
        price => $row_hash->{'price'},
        tag     => $row_hash->{'tag'},
		seal     => $row_hash->{'seal'},
    };
}


my %output = (
    "draw" => int($draw),
    "recordsTotal" => int($recordsTotal),
    "recordsFiltered" => int($recordsFiltered),
    "data" => \@rows,
);


my $jsonOutput = encode_json \%output;
print $jsonOutput;


$dbh->disconnect();