iron-viper

Installing Laravel in a subfolder

Installing Laravel in a domain subfolder can be useful in certain situations, although it is not officially supported by Laravel creators. In this instruction, I will describe how to configure Laravel 10 in a subfolder and additional tools such as Livewire v3.

Table of Contents

1. Laravel Basse
2. Livewire
3. Filament Panel Builder

Laravel Base

iron-viper

server {
    listen       80;
    server_name  site.dev;
    index        index.php;
    root         /Users/balkon_smoke/Sites/site.dev/web;

    error_log   /Users/balkon_smoke/Sites/site.dev/logs/error.log;
    access_log  /Users/balkon_smoke/Sites/site.dev/logs/access.log;

    location / {

iron-viper

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use Illuminate\Console\Concerns\CallsCommands;
use Illuminate\Support\Facades\Http;
use Laravel\Forge\Forge;
use Laravel\Forge\Resources\Daemon;

iron-viper

MySQL Download URL

https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz

Open the terminal and follow along:

• Uninstall any existing version of MySQL

sudo rm /var/lib/mysql/ -R

iron-viper

-- 1. Вывести список сотрудников, получающих заработную плату большую чем у непосредственного руководителя
SELECT * 
FROM Employee AS employees, Employee AS chieves
WHERE chieves.id = employees.chief_id AND employees.salary > chieves.salary;

-- 2. Вывести список сотрудников, получающих максимальную заработную плату в своем отделе
SELECT * 
FROM Employee AS employees
WHERE employees.salary = (SELECT MAX(salary) FROM Employee AS max WHERE max.department_id = employees.department_id);

iron-viper

{% macro recursiveCategory(category) %}
    <li>
        <h4><a href="{{ path(category.route, category.routeParams) }}">{{ category }}</a></h4>

        {% if category.children|length %}
            <ul>
                {% for child in category.children %}
                    {{ _self.recursiveCategory(child) }}
                {% endfor %}
            </ul>

iron-viper

<?php
/**
 * Class for working with wood Adjacency List
 * see down sql 'show create table'
 * 
 * @author Alexander Kapliy <[email protected]>
 */
class AdjacencyList {
    
	protected $tbl;

iron-viper

    public function getSubOrgsForTranspnakl(Entity $topitem)
    {
        $childrenArray = array();
        $iterate = true;
        $listOfParents = array();
        $listOfParents = array_push($listOfParents, $topitem);

        while ($iterate){
            $q = $this
                ->createQueryBuilder('o')

iron-viper

<?php

// Snippet for Symfony 2 application that uses Doctrine 2 to handle transactions
// It uses the names of the objects/doctrine repositories from the Beta 4 Manual of Symfony 2.

// Get the entity manager
$em = $this->getDoctrine()->getEntityManager();

// suspend auto-commit
$em->getConnection()->beginTransaction();

iron-viper

/*
 * XSS filter 
 *
 * This was built from numerous sources
 * (thanks all, sorry I didn't track to credit you)
 * 
 * It was tested against *most* exploits here: http://ha.ckers.org/xss.html
 * WARNING: Some weren't tested!!!
 * Those include the Actionscript and SSI samples, or any newer than Jan 2011
 *