How do I properly send HTML mail with a plain text alternative from October CMS?

To fill extra columns of a pivot table when adding a record in October CMS, you can use the ‘attach()’ or ‘sync()’ methods while specifying the additional pivot data. To do this follow the steps given below: 

In your model, define the ‘belongsToMany’ relationship with ‘pivot’ attributes:

Use the ‘attach()’ method to add a record and fill the extra pivot columns:

You can use ‘sync()’ to update multiple records and their pivot data at once:

To store an October CMS project in Git, follow the steps given below:

Run ‘git init’ in the project root.

Use ‘.gitignore’ to ignore sensitive and unnecessary files, like

/storage/

,

/vendor/

,

.env

Track important files, like ‘composer.json’, Custom plugins and themes, ‘Config’ files

Stage and commit your files:

Use ‘composer.json’ to manage dependencies.

To add a default query condition to a model in October CMS, you can use the ‘boot()’ method in your model to apply a global scope. To do this follow the steps given below:

Find the model you want to apply the default query condition to, typically located in

/models

.

Add a ‘boot()’ method in the model to apply the condition:

Test the Condition: Query the model to ensure the default condition status = 'active' is applied automatically:

If you need to query without this condition, use ‘withoutGlobalScope’:

To check if a record exists in October CMS, follow the steps given below: 

Use the ‘find()’ or ‘where()’ method with the model to check for the record:

Use an if statement to verify if the record is found:

Alternatively, using exists() with a query:

To delete a record in October CMS, follow the steps given below:

Locate the model that corresponds to the record you want to delete e.g., User, Post, etc.

Use the model to fetch the specific record by its ID or other identifiers:

Call the ‘delete()’ method to remove the record:

Ensure the record is removed by checking your database or user interface.