Multiple filter, date range search pivot report PHP SQL with source code

This video shows how to sum/calculate all values using date-range and multiple filter and filter from other table and get a summary report. Please download it try to understand the query and if you need any assistance please let me know.
Login ID: admin and PW: admin Thanks
Source Code:

[kisho]

How add multiple select/checkboxes filter per column?

[MDMediaTV]

thanks i was looking for this script source code...

[davidpangaribuan]

Hi..how to make the selected option still shown after the filter submitted

[anirudhachakrabarty]

How to export this filtered data as csv?

[muhammadaliefmulyadin]

Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'AND AND OR usertype = 'Admin' AND AND AND GROUP BY city, farm_name, sal...' at line 3 in C:\xampp\htdocs\14 multi filter\index.php:36 Stack trace: #0 C:\xampp\htdocs\14 multi filter\index.php(36): PDOStatement->execute() #1 {main} thrown in C:\xampp\htdocs\14 multi filter\index.php on line 36, helppp :(((

[gujasimonishvili]

I have an error: Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'AND AND OR usertype = 'Admin' AND AND AND GROUP BY city, farm_name, sal...' at line 3 in Stack trace: #0 PDOStatement->execute() #1 {main}

[YZX-jodo]

I'm using xampp, and I've imported the database into phpMyAdmin, I've put the folder containing the php files into xampp, but cannot run the website for some reason as it gives me this error message:
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'test2022'@'localhost' (using password: YES) in Stack trace: #0 mysqli->__construct('localhost', 'test2022', 'test2022', 'test2022') #1 {main} thrown in on line 3

[modernlooksinteriors]

kindly share the user login credentials for multiple filter project

[linusbett]

Thanks for the tutorial. how will I send the searched record to pdf or print?

[prodesigntv]

Hello Sir im new subscriber here please kindly put print out for the search result?

[bismillahfillingstationpum]

I have an error: Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'AND AND OR usertype = 'Admin' AND AND AND GROUP BY city, farm_name, sal...' at line 3 in Stack trace: #0 PDOStatement->execute() #1 {main}