Posts

Showing posts from November, 2020

Simple Read XLSX and CSV file in PHP

 here is the code and the library file is attached below. Library File is here:- Download from here https://drive.google.com/file/d/1fNXtQQbmnII5P7_CZ4EUulaazoPfuz-b/view To Read CSV:  $FileURL = ' testfile.xlsx '; require_once "lib/parsecsv.lib.php"; $csv = new parseCSV($FileURL); echo "test<pre>"; print_r($csv->data); To Read XLSX:  $FileURL = ' testfile.xlsx '; require_once "lib/SimpleXLSX.php" $xlsx = SimpleXLSX::parse($FileURL); echo "test<pre>"; print_r($xlsx->rows());

Openart 3.0.3.3 Error " Notice: Trying to access array offset on value of type null in vendor\scss.inc.php on line 1753"

Image
 Hi, I was getting a lots of errors while doing disable the cache from opencart admin by clicking on this button. like this "Notice: Trying to access array offset on value of type null in vendor\scss.inc.php on line 1753" to fix this error. I did change this code in the following files storage->vendor->scss.inc.php $key = $key[1]; to $key = isset($key[1]) ? $key[1] : null; Now everything is fine and working great 😅