Braunson Yager Braunson

I was curious why my authenticated user didn't persist to my error pages in Laravel.

Only noticing as the layout used for the error pages (header/footer) is the same as the rest of the site and the top right shows the authenticated user, shows a user nav, logout, etc.

Doing a quick Google search brought up some solutions but not necessarily a reason why authenticated users are not available on the error pages.

The reason not to have the authenticated user on the error page:

What if the issue is with fetching the authenticated user?

Laravel - Renaming Tables in Production

So I ran into a use-case where I joined a project that had a prefix on all tables in a production database. Now I couldn't just drop all tables and migrate + seed, this is Production we are talking about!

Since the database had a second (much smaller) app's tables in the same database, I had to be careful that I didn't rename those either.

Here's a quick script I threw in a developer-only route which would generate a query which I could manually run on production at the time of deploying the new code which was stripped of hard coded prefixes. Don't forget when you run this to remove any prefixes set for your connection in config/database.php otherwise you'll have some angry customers and "unable to find table" errors.

	<?php

	// Only when the query param is filled. Using whenFilled will check everything, not just query params
	Request::macro('whenQueryFilled', function ($key, callable $callback, callable $default = null) {
	if (! is_null($this->retrieveItem('query', $key, null))) {
	return $callback(data_get($this->query(), $key)) ?: $this;
	}

	if ($default) {
	return $default();

	<?php

	// Detect requests from Livewire
	Request::macro('isFromLivewire', function() {
	return $this->headers->has('x-livewire');
	});

	function list_hooks( $hook = '' ) {
	global $wp_filter;

	if ( isset( $wp_filter[$hook]->callbacks ) ) {
	array_walk( $wp_filter[$hook]->callbacks, function( $callbacks, $priority ) use ( &$hooks ) {
	foreach ( $callbacks as $id => $callback )
	$hooks[] = array_merge( [ 'id' => $id, 'priority' => $priority ], $callback );
	});
	} else {
	return [];

	<?php

	public function boot()
	{
	// Extend the Query Builder
	\lluminate\Database\Query\Builder::macro('whereBetweenDates', function($firstColumn, $secondColumn, $firstDate, $secondDate, $firstComparison = '>=', $secondComparison = '<=') {
	return $this
	->whereDate($firstColumn, $firstComparison, $firstDate)
	->whereDate($secondColumn, $secondComparison, $secondDate);
	});

	// Support for Query Builder
	Illuminate\Database\Query\Builder::macro('toRawSql', function() {
	return array_reduce($this->getBindings(), function ($sql, $binding) {
	$binding = str_replace(['\\', "'"], ['\\\\', "\'"], $binding);
	return preg_replace('/\?/', is_numeric($binding)
	? $binding
	: "'" . $binding . "'", $sql, 1);
	}, $this->toSql());
	});

	$route = \Route::getRoutes()->getByName('home');

	// => Illuminate\Routing\Route {
	// +uri: "/",
	// +methods: [
	// "GET",
	// "HEAD",
	// ],
	// +action: [
	// "middleware" => [

	<div x-data="{scrollBackTop: false}" x-cloak>
	<button
	x-show="scrollBackTop"
	x-on:scroll.window="scrollBackTop = (window.pageYOffset > window.outerHeight * 0.5) ? true : false"
	x-on:click="$scroll('#top')"
	aria-label="Back to top"
	class="fixed bottom-0 right-0 p-2 mx-10 my-10 text-white bg-gray-800 hover:bg-gray-700 focus:outline-none">
	<svg viewBox="0 0 20 20" fill="currentColor" class="w-6 h-6">
	<path fill-rule="evenodd" d="M14.707 12.707A1 1 0 01-1.414 0L10 9.414l-3.293 3.293a1 1 0 01-1.414-1.414l4-4a1 1 0 011.414 0l4 4a1 1 0 010 1.414z" clip-rule="evenodd"></path>
	</svg>

	#!/bin/bash

	echo "Downloading MeiliSearch"

	#
	# Install MeiliSearch
	# https://docs.meilisearch.com/create/how_to/running_production.html#step-2-run-meilisearch-as-a-service
	#

	# Update the list of available packages and their versions