MySQL Download URL
https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz
- Uninstall any existing version of MySQL
sudo rm /var/lib/mysql/ -R
/* | |
* 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 | |
* |
<?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(); |
public function getSubOrgsForTranspnakl(Entity $topitem) | |
{ | |
$childrenArray = array(); | |
$iterate = true; | |
$listOfParents = array(); | |
$listOfParents = array_push($listOfParents, $topitem); | |
while ($iterate){ | |
$q = $this | |
->createQueryBuilder('o') |
<?php | |
/** | |
* Class for working with wood Adjacency List | |
* see down sql 'show create table' | |
* | |
* @author Alexander Kapliy <[email protected]> | |
*/ | |
class AdjacencyList { | |
protected $tbl; |
{% 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> |
-- 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); |
<?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; |
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 / { |
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.