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.