Press ATL+F11 Insert This code Sub DownloadFileFromURL() Dim ws As Worksheet Dim FileUrl As String Dim objXmlHttpReq As Objec...
Continue Reading→Saturday, October 7, 2023
Saturday, March 11, 2023
Joomla 4 Error - 1054: Unknown column 'system' in 'field list'
Open your C-Panel. Open the linked database using phpmyadmin and find the table named (your-db-prefix)_extensions. Open the table and check ...
Continue Reading→Friday, September 16, 2022
Copy or Move files from one folder to another based on a list in Excel
If you have a list of file names in a column in a worksheet, and the files locate in a folder in your computer. If you need to move or cop...
Continue Reading→Monday, August 1, 2022
Dynamic Base URL on Codeigniter 4
If you need make base_ur() dynamic every project with Codeigniter 4, you can config by using this code. You need config on 2 files: App.php...
Continue Reading→Monday, July 12, 2021
Grant Remote Access to MySQL server in CentOS
To grant remote access here are the steps: Step 1. Edit the file etc/my.cnf and add these lines on [mysqld_safe] [mysqld_safe] Port = 3...
Continue Reading→How to set some SELinux bools permanent to true?
By default, the httpd_can_network_connect_db Boolean is off, preventing Apache HTTP Server scripts and modules from connecting to database...
Continue Reading→Autostart Network Services on CentOS
Network Service: Open the file /etc/sysconfig/network-scripts/ifcfg-eno<number> and check for the IPADDR value. If you set IP address ...
Continue Reading→