bradtraversy

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

• Mac /usr/local/mysql/bin
• Windows /Program Files/MySQL/MySQL version/bin
• Xampp /xampp/mysql/bin

Add mysql to your PATH

Splode

Run Laravel Scheduled Tasks on Windows

The following are instructions for running scheduled tasks defined in a Laravel project on Windows. The Laravel documentation provides instructions for running scheduled tasks using cron jobs on Linux systems. However, cron jobs are not available on Windows. The built-in Windows Task Scheduler can be used to run scheduled tasks instead.

Create a Scheduled Task

1. Open Task Scheduler
2. Select Create Task...
3. Give the task a name and description
4. To run the task in the background, select Run whether the user is logged on or not and check the Hidden checkbox.

mchoiruln

Undefined variable $router

where : inside routes\web.php
solution : just add this comment on top that code or top of file after <?php

<?php
/** @var \Laravel\Lumen\Routing\Router $router */
$router->get('/', function () use ($router) {
    return $router->app->version();
});

ahmadshobirin

Open File App\Providers\AppServiceProvider

Change method boot

use Carbon\Carbon;


public function boot()
{
	config(['app.locale' => 'id']);

fedme

Run Visual Studio Code for Linux from WSL

Thanks a lot to mredbishop and others for their insturctions posted here. This is just a recap of what they figured out.

This process was tested on WSL Ubuntu 18.04.

Install VcXsrv on Windows

1. Dowload the VcXsrv installer from https://sourceforge.net/projects/vcxsrv/
2. Install the software on Windows

Add VS Code repositories

BenSampo

# Change to the project directory
cd $FORGE_SITE_PATH

# Turn on maintenance mode
php artisan down || true

# Pull the latest changes from the git repository
# git reset --hard
# git clean -df
git pull origin $FORGE_SITE_BRANCH

primaryobjects

<div className='delete-button' onClick={() => { if (window.confirm('Are you sure you wish to delete this item?')) this.onCancel(item) } } />

judy2k

# Pass the env-vars to MYCOMMAND
eval $(egrep -v '^#' .env | xargs) MYCOMMAND
# … or ...
# Export the vars in .env into your shell:
export $(egrep -v '^#' .env | xargs)

keithweaver

Point Domain to Amazon Web Services (AWS) EC2 Instance

1. Open the Amazon Route 53 console at https://console.aws.amazon.com/route53/.
2. If you are new to Amazon Route 53, you see a welcome page; choose Get Started Now for DNS Management. Otherwise, choose Hosted Zones in the navigation pane.
3. Choose Create Hosted Zone.
4. For Domain Name, type your domain name.
5. Choose Create.
6. Click the Hosted Zone, edit record set.
7. In the value, add ec2-54-152-134-146.compute-1.amazonaws.com.
8. Change your DNS file to point to the IPv4 address (This would be in something like GoDaddy).

orumad

How to setup Laravel 5.3 + Vue.js + Semantic UI project

Create a new Laravel project with composer:

$ composer create-project Laravel/Laravel myproject

Create the database for the project:

$ mysql -uroot