wsydney76

Craft 6 Element Queries With Laravel Query Builder

Craft 6 element queries are built on Laravel's query builder, providing access to Laravel's query methods alongside Craft's element-specific query methods.

This document collects practical examples, differences from Craft 5 and native Laravel, and things to watch out for when working with element queries in Craft 6. It covers filtering, ordering, retrieving and paginating elements, working with custom fields, and more advanced techniques such as reusable query conditions and raw SQL.

The focus is on PHP and Blade, but most concepts also apply to Twig when using helper functions that return element queries.

| PHP | Twig |

ryanleichty

{% set relatedEntries = craft.entries
  .relatedTo({ targetElement: element.rootOwner })
  .provisionalDrafts(false)
  .all() %}

{# Filter out entries that have provisional draft owners #}
{% set withoutProvisionalDrafts = [] %}
{% for entry in relatedEntries %}
  {% set hasProvisionalOwner = false %}
  {% set currentEntry = entry.owner %}

croxton

{% set rels = craft.entries.relatedTo({ targetElement: element }).siteId('*').collect() %}
{% set owners = [] %}

{% for rel in rels %}
    {% set owner = rel.owner ?? rel %}
    {% set owner = owner.primaryOwner ?? owner %}
    {% if owner.canonicalId not in owners %}
        {% set owners = owners + {
            (""~owner.canonicalId~"") : {
                cpEditUrl : owner.cpEditUrl,

bencroker

<?php
namespace modules;

use Craft;
use craft\controllers\EntriesController;
use craft\controllers\UsersController;
use yii\base\ActionEvent;
use yii\base\Event;
use yii\base\Module;
use yii\web\ForbiddenHttpException;

KatieMFritz

Color code sites in Craft 3 Multisite

Dependencies

1. Control Panel Body Classes plugin
2. Control Panel JavaScript plugin
3. Control Panel CSS plugin

Notes

croxton

<?php
// In general.php define an alias:

'aliases' => [
    '@baseUrl' => getenv('CRAFTENV_BASE_URL')
],

// In the CP, set the Base URL for each site to @baseUrl/
// When previewing, the CP will therefore always use the hostname the editor logged into as the base url for the preview
// (that happens with 'new' entries anyway regardless of base url, but existing entries use base url).

nfourtythree

How to password protect your Serverpilot app

This is a quick (rough) guide on how to protect a Serverpilot pilot app with auth basic

1. SSH into your Serverpilot Server

ssh SERVERPILOTUSERNAME@your.server.ip.address

2. Create a htpasswd file in your app

nfourtythree

How To Disable Strict SQL Mode in MySQL 5.7

I wrote a quick script for those that provision servers often enough.

To get this to work take the following steps

1. Log into your server as root
2. Get script wget https://gist.githubusercontent.com/nfourtythree/90fb8ef5eeafdf478f522720314c60bd/raw/disable-strict-mode.sh
3. Make is executable chmod +x disable-strict-mode.sh
4. Run the script ./disable-strict-mode.sh

khalwat

This is now part of craft-scripts:

https://github.com/nystudio107/craft-scripts

joshangell

<?php
namespace Craft;

class MyPluginController extends BaseController
{
  
  // This lets anyone run the controller actions we specify, useful for CRON etc
	protected $allowAnonymous = array('actionMigrate');
	
	/**