Categories
Issue Fixing Regx

Fix: Reformatting Youtube Auto Generated Caption File

If you download auto-generated caption file from youtube and then use it in other platform like vimeo, you will see this auto-generated caption file doesn’t work. We can fix this by running a regular expression like this:

 

Categories
PHP

PHP: Search for Files Inside Folder and Sub-Folder

To find all png files inside uploads directory we can use following code.
This would search in all sub-directories as well.

Categories
PHP

PHP: Write CSV File with UTF-8 Encoding

Categories
PHP

PHP: Timestamp in PST

Categories
MySQL

MySQL: Import Database from Command Line

Copy your sql file and paste it inside xampp/mysql/bin directory. Let’s say our sql filename is: “userinfo.sql”.

Now, open command line and run following commands.

Categories
MySQL

MySQL: Import Table from CSV File

Run following command from command line

If your MariaDB doesn’t support this command, maybe you need to add following in my.ini file.

I am using Xampp on Windows 10. For me, my.ini file is located at:

Categories
Apache Issue Fixing

Fix: Authorization Header Missing in Apache Server

Add following snippet in .htaccess file

Categories
PHP

HTTP Headers for Downloading File

Categories
Regx

Regx: Remove Style Tags from Content

Categories
Regx

Regx: Remove Script Tags from Content