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
Issue Fixing PHP

PHP: Get All Headers from Request

Categories
PHP

HTTP Headers for Downloading File

Categories
Regx

Regx: Remove Style Tags from Content

Categories
Regx

Regx: Remove Script Tags from Content

Categories
MySQL

MySQL: Dynamic Column from Row