DEV Community: Pranto Mollick

🚀 How to Set Up a Virtual Host in XAMPP (C:) to Run WordPress from Another Drive (G:)

Pranto Mollick — Mon, 18 Aug 2025 09:59:44 +0000

1. Install XAMPP(Already Installed)

Make sure Apache and MySQL modules are running from the XAMPP Control Panel.

2. Download/Edit WordPress on G:

Extract WordPress, say, to G:\wordpress.

3. Create a Database for WordPress

Go to http://localhost/phpmyadmin in your browser.
Click "Databases", create a new database (e.g., wordpress_db).

4. Set Permissions (if needed)

Make sure your user account has read/write permissions for G:\wordpress.

5. Configure Apache Virtual Hosts

a. Edit httpd-vhosts.conf:

Open C:\xampp\apache\conf\extra\httpd-vhosts.conf with a text editor (running as Administrator).
Add a block like this at the end:

<VirtualHost *:80>
    ServerName gamestore-dev.local
    ServerAlias gamestore-dev.local
    DocumentRoot "G:/wordpress"
    <Directory "G:/wordpress">
        Options +Indexes +Includes +FollowSymLinks +MultiViews
        AllowOverride All
        Require all granted
    </Directory>
    ErrorLog "logs/dummy-host2.example.com-error.log"
    CustomLog "logs/dummy-host2.example.com-access.log" common
</VirtualHost>

Replace mywordpress.local with your desired local domain.

b. Ensure mod_vhost and mod_rewrite are Enabled

In C:\xampp\apache\conf\httpd.conf, make sure these lines are uncommented (no #):

Include "conf/extra/httpd-vhosts.conf"
LoadModule rewrite_module modules/mod_rewrite.so

6. Edit Your hosts File

Open Notepad as Administrator.
File > Open: C:\Windows\System32\drivers\etc\hosts
Add this line at the end:

    127.0.0.1   mywordpress.local

7. Restart Apache

In the XAMPP Control Panel, stop and start Apache.

8. Install WordPress

Visit http://mywordpress.local in your browser.
Run the installation wizard.
Enter your database info: > - Database Name: wordpress_db > - Username: root > - Password: (leave blank unless you set one)

9. Test

You should see the WordPress setup page from G:\wordpress.
Log in to your WordPress site as normal.

Tip:
For multiple projects, just replicate the block with different folders and domain names.

Fetching Upcoming Events in WordPress with WP_Query (English + Bengali)

Pranto Mollick — Mon, 11 Aug 2025 09:47:15 +0000

Learn to fetch upcoming WordPress events with WP_Query: numeric date sorting, meta_query filters, and a bilingual walkthrough (EN + BN).

Introduction

If you're building a WordPress site that needs to show upcoming events—like a school's "Science Fair" or a community "Sports Day"—you'll often reach for WP_Query. In this post, we'll walk through a practical snippet that fetches the next two upcoming events, explain exactly how it works, why it's written this way, and how to extend it. You'll see the English explanation side-by-side with Bengali to make the concepts stick.

Step 1 — What this code does (Context)

English:
We're querying the WordPress database to get the next two upcoming "event" posts, sorted by a custom field called event_date so the soonest events appear first.

Bengali:
আমরা ওয়ার্ডপ্রেস ডাটাবেসে কোয়েরি চালিয়ে 'event' টাইপের পরবর্তী দুইটি ইভেন্ট আনছি। এগুলোকে event_date নামের কাস্টম ফিল্ড দিয়ে সাজানো হচ্ছে, যাতে দ্রুত আসছে এমন ইভেন্টগুলো আগে দেখা যায়।

Step 2 — The core snippet

$events = new WP_Query(array(
  'posts_per_page' => 2,
  'post_type'      => 'event',
  'meta_key'       => 'event_date',
  'orderby'        => 'meta_value_num',
  'order'          => 'ASC'
));

Looping through results:

if ($events->have_posts()) {
  while ($events->have_posts()) {
    $events->the_post();
    // Example output:
    // the_title();
    // echo get_post_meta(get_the_ID(), 'event_date', true);
  }
  wp_reset_postdata();
}

English:

posts_per_page limits results to two.
post_type ensures we're only looking at events.
meta_key tells WP_Query which custom field controls sorting.
orderby => meta_value_num sorts numerically (ideal for YYYYMMDD or timestamps).
order => ASC means earliest dates appear first.

Bengali:

posts_per_page মানে আমরা ২টি রেজাল্ট চাই।
post_type => event মানে কেবল ইভেন্ট পোস্টই আনবো।
meta_key দিয়ে কোন কাস্টম ফিল্ডে সাজাবো তা বলা হয়েছে।
orderby => meta_value_num সংখ্যাগতভাবে সাজায় (YYYYMMDD বা timestamp আদর্শ)।
order => ASC মানে আগের তারিখ আগে দেখাবে।

Step 3 — How the data flows

English:

Input: An array of arguments (post_type, meta_key, orderby, etc.).
Processing: WP_Query translates this into SQL for MySQL.
Database: Filters to event posts, looks at event_date, sorts ascending, returns top 2.
Output: A WP_Query object in $events you can loop through.

Bengali:

ইনপুট: আর্গুমেন্টের অ্যারে (post_type, meta_key, orderby, ইত্যাদি)।
প্রসেসিং: WP_Query এটিকে SQL-এ রূপান্তর করে।
ডাটাবেস: event পোস্ট ফিল্টার, event_date দেখে সাজানো, শীর্ষ ২ ফেরত।
আউটপুট: $events অবজেক্ট, যেটি লুপ করে দেখানো যায়।

Step 4 — Why this approach is best practice

English:
Let the database do the heavy lifting. Sorting/filtering in MySQL via WP_Query is faster and more memory-efficient than fetching everything and sorting in PHP. Using orderby => meta_value_num ensures dates stored as numbers (e.g., 20251107 or Unix timestamps) sort correctly.

Bengali:
ফিল্টারিং/সোর্টিং ডাটাবেসেই করাই শ্রেয়। WP_Query MySQL-এ কাজ করায় দ্রুত ও কম মেমরি লাগে। meta_value_num ব্যবহার করলে সংখ্যায়িত তারিখ (যেমন 20251107 বা timestamp) ঠিকভাবে সাজে।

Step 5 — Common pitfalls and fixes

1) Dates sorting wrong (e.g., "December" before "November")

Cause: Dates stored as strings ("December 1, 2025").
Fix: Store event_date as numeric (YYYYMMDD or Unix timestamp). Keep orderby => meta_value_num.

2) Getting posts from other types

Cause: Missing post_type => event.
Fix: Ensure post_type is set to event.

3) Showing past events before upcoming

Cause: ASC is fine, but you also need to filter out past dates.
Fix: Add a meta_query to only include today or future.

Example: only today/future

$today = date('Ymd');
$events = new WP_Query(array(
  'posts_per_page' => 2,
  'post_type'      => 'event',
  'meta_key'       => 'event_date',
  'orderby'        => 'meta_value_num',
  'order'          => 'ASC',
  'meta_query'     => array(
    array(
      'key'     => 'event_date',
      'value'   => $today,
      'compare' => '>=',
      'type'    => 'NUMERIC'
    )
  )
));

Step 6 — Excluding cancelled events (extension)

English:
If you store an event_status custom field and want to exclude "Cancelled" events:

Bengali:
event_status নামে কাস্টম ফিল্ড থাকলে "Cancelled" বাদ দিতে:

$events = new WP_Query(array(
  'posts_per_page' => 2,
  'post_type'      => 'event',
  'meta_key'       => 'event_date',
  'orderby'        => 'meta_value_num',
  'order'          => 'ASC',
  'meta_query'     => array(
    'relation' => 'AND',
    array(
      'key'     => 'event_status',
      'value'   => 'Cancelled',
      'compare' => '!='
    ),
    array(
      'key'     => 'event_date',
      'value'   => date('Ymd'),
      'compare' => '>=',
      'type'    => 'NUMERIC'
    )
  )
));

Step 7 — Quick analogy

English:
Think of WP_Query as asking a librarian: "Please find books from the 'events' shelf, sort them by date from soonest to latest, and give me just the top two." The librarian searches the stacks (database), sorts properly, and returns exactly what you asked for.

Bengali:
WP_Query হল লাইব্রেরিয়ানকে বলা: "events শেলফ থেকে বই নিন, তারিখ অনুযায়ী (নিকটতম আগে) সাজান, আর শীর্ষ দুইটি দিন।" লাইব্রেরিয়ান (ডাটাবেস) ঠিক সেভাবেই ফলাফল দেয়।

Bonus — Display template idea

<?php if ($events->have_posts()): ?>
  <section class="upcoming-events">
    <h2>Upcoming Events</h2>
    <ul>
      <?php while ($events->have_posts()): $events->the_post(); ?>
        <li>
          <a href="<?php the_permalink(); ?>"><?php the_title(); ?></a>
          <?php 
            $date = get_post_meta(get_the_ID(), 'event_date', true);
            if ($date) {
              // Format YYYYMMDD to Y-m-d for readability
              echo ' — ' . DateTime::createFromFormat('Ymd', $date)->format('M j, Y');
            }
          ?>
        </li>
      <?php endwhile; wp_reset_postdata(); ?>
    </ul>
  </section>
<?php endif; ?>

Mini Quiz

1) Easy: How would you change the code to fetch the next 5 events?

Answer: Change posts_per_page => 2 to posts_per_page => 5.

2) Medium: Dates look out of order—what's a likely cause?

Answer: event_date stored as human text (e.g., "December 1, 2025") instead of numeric (YYYYMMDD). Store numeric and use meta_value_num.

3) Hard: How do you exclude events with event_status = "Cancelled"?

Answer: Add a meta_query with compare => '!=' on key event_status, plus your date constraint.

Takeaways

Store dates numerically (YYYYMMDD or Unix timestamps) for reliable sorting.
Use meta_value_num for numeric meta sorting.
Filter out past events with a meta_query against today's date.
Extend with additional conditions (status, venue, capacity) via meta_query.

🎓 Mastering WordPress Font Enqueue with Google Fonts: Real Interview Questions with Bilingual Explanations

Pranto Mollick — Sun, 27 Jul 2025 08:12:07 +0000

If you're a WordPress developer aiming to crack interviews or just want to level up your theme development game, understanding how to enqueue Google Fonts is crucial. In this post, we’ll dive into a real-world code snippet and break down everything from function logic to interview questions — all explained in English and Bengali with memory tricks and analogies.

💡 The Code We’ll Explore

function gamestore_google_fonts() {
    $font_url = ''; 
    $font_family = 'Urbanist:ital,wght@0,400;0,700;1,400;1,700';

    if ('off' !== _x( 'on', 'Google font: on or off', 'gamestore' )) {
        $query_args = array(
            'family' => $font_family,
            'subset' => 'latin,latin-ext',
            'display' => 'swap',
        );
        $font_url = add_query_arg( $query_args, '//fonts.googleapis.com/css2' );
    }

    return $font_url;
}

function gamestore_google_font_script() {
    $font_url = gamestore_google_fonts();
    if ( ! empty( $font_url ) ) {
        wp_enqueue_style( 'gamestore-google-fonts', esc_url( $font_url ), array(), wp_get_theme()->get( 'Version' ) );
    }
}
add_action( 'wp_enqueue_scripts', 'gamestore_google_font_script' );

🎯 What This Code Does

✅ Dynamically builds a Google Fonts URL
✅ Loads the font into your theme using wp_enqueue_style()
✅ Supports conditional disabling and version-controlled caching

🧠 Real Interview Questions & Bilingual Explanations

Here are realistic interview questions based on this code and how to answer them with analogies and Bengali translations to help you remember them.

1. What does `wp_enqueue_style()` do?

EN: Loads CSS in a proper, WordPress-managed way.
BN: এটি সিএসএস ফাইল লোড করে সঠিকভাবে, ডুপ্লিকেট লোড হওয়া থেকে বাঁচায়।

✅ Analogy: Like placing a file in a queue for printing.
🧠 Memory Hook:
E = Enqueue = Enter into Queue

2. Why use `esc_url()`?

EN: Sanitizes the URL to prevent malicious injections.
BN: URL-এ হ্যাকারদের ক্ষতিকর স্ক্রিপ্ট ঢুকতে না দেওয়ার জন্য এটি পরিষ্কার করে।

✅ Analogy: Washing vegetables before cooking.
🧠 Memory Hook:
Escape harmful input = ESC → esc_url()

3. What is the use of `add_action()` here?

EN: Hooks your function to run at a specific point (wp_enqueue_scripts).
BN: নির্দিষ্ট সময়ে ফাংশন চালানোর জন্য এটি WordPress-এ যুক্ত করে।

✅ Analogy: Like telling your assistant when to serve coffee.
🧠 Memory Hook:
Hook = Trigger Point

4. How are Google Fonts added dynamically?

EN: URL query strings are used to define fonts, weights, and subsets.
BN: ফন্ট, ওজন, এবং সাবসেট নির্ধারণ করতে URL query string ব্যবহার করা হয়।

✅ Analogy: Ordering a pizza with specific toppings.
🧠 Memory Hook:
Query = Instruction to Google Fonts

5. Why use `_x()` instead of `__()` or `_e()`?

EN: _x() allows context-aware translation.
BN: _x() দিয়ে একই শব্দের বিভিন্ন অর্থ context অনুযায়ী ট্রান্সলেট করা যায়।

✅ Example: “Post” could mean blog post or mail.
🧠 Memory Hook:
x = eXtra info → Use when context matters

6. What happens if `_x()` returns 'off'?

EN: The font won’t be loaded, which helps with performance or localization.
BN: _x() 'off' রিটার্ন করলে ফন্ট লোড হবে না, এটা কিছু দেশে দরকার হতে পারে।

✅ Use case: Chinese users where Google is blocked.
🧠 Memory Hook:
Translation = ON/OFF switch

7. How to make the font customizable from the WordPress Customizer?

EN: Use get_theme_mod() to dynamically fetch the selected font.
BN: Customizer থেকে get_theme_mod() দিয়ে ফন্টের নাম dynamically নেওয়া যায়।

✅ Analogy: Letting the user choose their outfit before an event.
🧠 Memory Hook:
Customizer = Personalization Panel

8. Why use `wp_get_theme()->get('Version')` instead of a fixed version?

EN: It automatically updates the version for cache busting.
BN: থিম আপডেট হলে CSS কেশে ফাইল আটকে না থাকে।

✅ Analogy: Putting a version sticker on a product.
🧠 Memory Hook:
Version = Cache Breaker

9. How to load multiple fonts or preload for performance?

EN: Combine multiple family values or use wp_resource_hints for preload.
BN: একাধিক ফন্ট একসাথে যুক্ত করে বা preload করলে পারফরম্যান্স বাড়ে।

✅ Analogy: Buying multiple tickets in one booking = fewer HTTP requests.
🧠 Memory Hook:
Preload = VIP Access

10. Why use `//fonts.googleapis.com` instead of `https://`?

EN: Protocol-relative URLs support both HTTP and HTTPS.
BN: সাইটের প্রোটোকল অনুযায়ী স্বয়ংক্রিয়ভাবে ঠিক URL ব্যবহার হয়।

✅ Analogy: Letting the elevator decide which floor you’re on.
🧠 Memory Hook:
// = Smart Link (protocol auto-adjusts)

📝 Final Summary Table

Question	Answer Summary	Bengali Keyword
`wp_enqueue_style()`	Adds CSS to WordPress safely	সঠিকভাবে CSS লোড
`esc_url()`	Cleans URL	URL নিরাপদ করা
`add_action()`	Hooks function into WP event	নির্দিষ্ট সময়ে ফাংশন
Dynamic Fonts	Fonts via query string	ফন্ট URL
`_x()`	Contextual translation	কনটেক্সট অনুযায়ী অনুবাদ
`_x() = off`	Disables font loading	ফন্ট বন্ধ
Customizer Fonts	Use `get_theme_mod()`	কাস্টোমাইজার ফন্ট
Theme Version	Cache busting	কেশে সমস্যা সমাধান
Multiple Fonts	Combine in one query	একাধিক ফন্ট
`//` URL	Protocol-relative	HTTP/HTTPS auto

🚀 Mastering WSL 2 and Docker on Windows: What I Learned, Real-World Use Cases, and Interview Prep

Pranto Mollick — Thu, 24 Jul 2025 05:40:59 +0000

As a Windows user diving into modern development workflows, I recently explored WSL 2 (Windows Subsystem for Linux) and integrated it with Docker Desktop — and it was a game-changer!

In this post, I’ll break down:

✅ What I learned from installing and configuring WSL 2
🌍 How these skills apply in real-world development
🎯 Interview questions I’m now prepared to answer

✅ What I Learned

WSL 2 is a tool that allows you to run a real Linux kernel inside Windows, making it ideal for local development, especially when paired with Docker.

Here's what I learned step-by-step:

Check System Requirements

Windows 10 (build 1903+) or Windows 11 (WSL 2 built-in)

Install WSL 2 (Automatically or Manually)

PowerShell command:
```
 wsl --install
```
Manual alternative: enable features via DISM, install the Linux kernel update package, and set default version to 2.

Install a Linux distribution (e.g., Ubuntu)

Via Microsoft Store → Set it up with username/password

Verify Installation

Run:
```
 wsl --list --verbose
```

Install Docker Desktop

During installation, enable WSL 2 integration
Connect Docker to your Linux distro in Docker Settings

This entire setup creates a powerful hybrid environment: Windows + Linux + Docker — right on your desktop.

🛠️ Services I Can Offer (Freelancer or Team Contributor)

Now that I understand this system deeply, I can offer real-world tech services like:

💼 Service	Description
WSL 2 & Docker Setup	Help devs or businesses set up WSL 2 and Docker Desktop on Windows
Local Dev Environment	Build Linux-based dev environments for Laravel, Django, Node.js, etc.
Docker Containerization	Dockerize apps and teach others how to use Docker on Windows
DevOps Assistant	Assist with Linux + Docker pipelines, CI/CD, and local test environments
Troubleshooting Support	Solve Docker/WSL issues that Windows users frequently face

These services are in demand on remote job boards.

🌍 Real-World Use Cases

Here’s how this knowledge applies in real-life projects:

Use Case	How It Works
🧑‍💻 Full-Stack Web Dev	Run Linux-only tools (like Nginx, Redis, PHP) on Windows via WSL
🐳 Container Dev	Build and test Docker images before deploying to cloud (AWS/GCP)
🐍 Python/ML Projects	Use Jupyter, TensorFlow, and PyTorch inside Linux via WSL
🧪 CI/CD Testing	Simulate Linux pipelines locally with Docker containers
🚀 Dev Workflow Boost	No need for dual-booting or switching to Linux — best of both worlds

🎯 Interview Questions You Now Ready For

These are the kinds of questions that can come up in DevOps, Backend, or Full-Stack roles:

🔹 WSL 2 Focused

What is WSL 2 and how does it differ from WSL 1?
How do you manage multiple Linux distros on WSL?
What are the limitations of WSL 2?

🔹 Docker with WSL 2

Why is WSL 2 preferred for Docker Desktop on Windows?
How does Docker Desktop integrate with WSL?
How do you troubleshoot Docker-Windows-WSL issues?

🔹 General System Setup

How do you set up a dev environment for Linux-based applications on Windows?
What PowerShell commands are used to enable WSL features?

🔹 WSL 2 Related

1. What is WSL and how is WSL 2 different from WSL 1?
Think of WSL like a translator who helps Windows speak Linux.

WSL 1 is like Google Translate — it converts Linux commands into Windows language, but it’s not perfect.
WSL 2 is like hiring a native Linux speaker (a full Linux kernel!) and giving them their own room inside your Windows PC.

In short:
WSL 1 fakes Linux, WSL 2 runs real Linux inside a small virtual machine — faster, more powerful, and closer to real Linux.

**2. How do you install and configure WSL2 on Windows?
just open PowerShell as Admin and Run:

wsl --install

This will:

Enable necessary windows features
Install Ubuntu
Set WSL 2 as the default

It’s like ordering a Linux room service — it arrives ready to use!
If it doesn’t work, you can do it manually using a few commands (enabling features, installing Linux kernel, restarting, and downloading a distro like Ubuntu).

3. Can you run Linux-only tools on Windows using WSL 2? How?

Yes, and it’s magical! ✨
magine you want to cook a Bengali recipe but you only have a Western kitchen. WSL 2 brings a real Bengali kitchen inside your Western home. You can now:

Run Bash
Use apt to install packages
Use Linux web servers like Apache
Compile code using GCC
Run Python, Node, PHP with native linux behaviour. All without leaving windows.

4. What are the limitations of WSL 2?
Every superhero has a weakness 💔

It uses a lightweight VM in the background → more RAM
Slower file access between Windows ↔ Linux (use /home, avoid /mnt/c )
No full support for USB devices or kernel modules
Some system services (like systemd) needed workarounds (fixed in latest WSL)

Analogy:
You invited Linux to your house (Windows), but you can’t let them use your Wi-Fi (USB access) or let them renovate your house (low-level hardware stuff).

5. How do you manage multiple Linux distros in WSL?

You can install many flavors of Linux: Ubuntu, Debian, Kali, etc.

🔧 Check list:

wsl --list --verbose

🔁 Set default:

wsl --set-default Ubuntu

🔄 Change version:

wsl --set-version Ubuntu 2

🔹 Docker + WSL 2 Integration

6. Why is WSL 2 preferred for Docker on Windows?
Docker runs best on Linux, but Windows doesn’t speak Linux natively.
🧠 With WSL 2:

You get a real Linux kernel
Docker can run natively, not emulated
It’s faster, lighter, and more efficient

Analogy:
It’s like building a pool (Docker) — it works way better on real ground (WSL 2) than on a floating platform (Windows VM).

7. What is Docker Desktop, and how does it use WSL 2?
Docker Desktop is a GUI tool that makes it easy to manage Docker on Windows. With WSL 2:

Docker doesn’t need a big VM anymore
It installs inside your WSL distro
It runs containers as if you're on real Linux

8. How do you troubleshoot Docker not starting on Windows with WSL 2?

✅ Check WSL 2 is installed:

wsl --list --verbose

✅ Restart Docker Desktop
✅ Ensure virtualization is enabled in BIOS
✅ Check WSL Integration is turned on in Docker Settings
✅ Run PowerShell as Admin and update kernel if needed

9. What are some real-world advantages of using Docker + WSL 2 for development?

You can test Linux apps on Windows
Use Docker without full VMs → faster builds
No more dual-booting or cloud deployments just to test things
Easily build containers for Laravel, Django, React, etc.

Example:
You’re building a Laravel site. Run it in a Docker container in WSL 2, test it, and then push it to production — all from your Windows laptop!

10. How do you configure Docker to use a specific WSL distro?

Open Docker Desktop →
Settings → Resources → WSL Integration → Enable for your preferred distro (e.g., Ubuntu).

Now Docker knows which kitchen (distro) to use when cooking up containers.

🔹 General System Knowledge

11. Explain the role of virtualization in WSL 2.
WSL 2 uses a tiny virtual machine to run a real Linux kernel.
🔍 This VM is lightweight, fast, and auto-managed by Windows — you won’t even notice it’s there.
Analogy:
It’s like running a guest Linux computer inside your Windows PC — but it shares your home’s (system’s) electricity and water (RAM and CPU) without making noise.

12. Have you used PowerShell for administrative setup? Give examples.
Yes! PowerShell is like the control room of Windows. I’ve used it for:

Installing WSL features:

dism.exe /online /enable-feature /featurename:Microsoft-Windows-Subsystem-Linux /all /norestart

Setting default WSL version:

wsl --set-default-version 2

Installing Docker
Automating System Task

13. How would you set up a development environment for a Linux-based application on Windows?

Let’s say you want to build a Django web app. Here’s how:

Install WSL 2 and Ubuntu
Update and install dependencies:

sudo apt update && sudo apt install python3-pip python3-venv

Create a virtual environment and install Django
Install Docker Desktop with WSL 2 integration
Dockerize your Django app

Now you can code, test, and deploy like you’re on a Linux server — from your Windows machine.

💡 When you master WSL 2 and Docker together, you unlock a hybrid development world: Linux power, Windows productivity, and cloud-readiness — all from your laptop.

test

Pranto Mollick — Fri, 11 Apr 2025 14:38:05 +0000

[Boost]

Pranto Mollick — Fri, 11 Apr 2025 14:36:49 +0000