Waliullah If you are building a Drupal site and using Views to display content, you may have noticed a problem: when you use random sorting, sometimes the same content appears multiple times. In this guide, we will explain in simple language how to eliminate duplicate items in Views when using random sort. Even if you are … Read more
In Drupal, URLs are very important. When a user visits a page like /about-us, Drupal must convert it into an internal system path like /node/5. This is where InboundPathProcessorInterface comes in. It helps us change or rewrite incoming paths before Drupal routes them. In this blog, we will learn: What is InboundPathProcessorInterface? InboundPathProcessorInterface is a … Read more
Sometimes in Drupal, changes you make on your website may not appear immediately. This happens because Drupal stores data in cache to make the site faster. If your changes are not showing, you need clearing cache using SQL queries Drupal. This is especially useful if you are a developer or working on a local/test site … Read more
As a Drupal developer, sometimes you need to get a list of users with specific roles in Drupal. For example, you might want all users with the Editor role so that you can send them notifications, assign tasks, or show them in a block. In Drupal 10, this is easy using the Entity Query API. … Read more
Understanding the encryption and encoding difference is easier than it sounds. Both encryption and encoding change the way data looks, but they serve very different purposes. Encoding makes data readable by different systems, while encryption keeps data secret from anyone who shouldn’t see it. What is Encoding? Think of it like: Writing your message in … Read more
PHP switch statement is like a traffic police who decides where to send the traffic (code execution) depending on the signal (value). Instead of writing many if…else if…else, we can use switch for cleaner code. Syntax: Example (Easy to understand) Imagine you enter a canteen and ask for food based on a number: Output: You … Read more
When we say “reverse an array,” it means we want the last element to come first, and the first element to go last. For example, if we have: The reversed version will be: Using array_reverse() function PHP provides a built-in function called array_reverse() to reverse arrays easily. Syntax: <?phparray_reverse(array, preserve);?> array → The array you … Read more
GROUP BY Example: Student Subject Marks Raju Math 80 Pooja Math 90 Amit Science 70 Neha Science 60 Output: So GROUP BY = Group then summarize. ORDER BY Example: Output: So ORDER BY = Sorting (like arrange in queue). Quick Analogy (Cricket Example): Imagine a cricket match scoreboard. Super-Simple Recap for Freshers:
Aggregate = “Total / Summary”. In SQL, aggregate functions are used to calculate values from multiple rows together (instead of checking each row one by one). Example: In a class of students, instead of checking every student’s marks separately, we calculate total marks, average marks, highest marks, etc. Common Aggregate Functions: Real-Life Analogy (Cricket Example): … Read more
Imagine you have a big dictionary .If you want to find the meaning of the word “Cricket”, In SQL, Index = shortcut for the database to find data faster. What are Indexes? Types of Indexes in SQL: Quick Recap for Freshers: