Help with SQL commands to interact with a MySQL database
- Mac /usr/local/mysql/bin
- Windows /Program Files/MySQL/MySQL version/bin
- Xampp /xampp/mysql/bin
mdsohelmia
/ mysql_cheat_sheet.md
Created
April 28, 2019 05:26
— forked from bradtraversy/mysql_cheat_sheet.md
MySQL Cheat Sheet
mdsohelmia
/ CountriesTableSeeder.php
Created
September 14, 2019 19:40
— forked from SumonMSelim/CountriesTableSeeder.php
Countries Table Seeder for Laravel
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| use App\Country; | |
| use Illuminate\Database\Seeder; | |
| class CountriesTableSeeder extends Seeder | |
| { | |
| public function run() | |
| { | |
| $countries = [ |
mdsohelmia
/ auth.php
Created
September 15, 2019 07:39
— forked from mabasic/auth.php
`config/auth.php` for JWT Authentication in Lumen
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| return [ | |
| /* | |
| |-------------------------------------------------------------------------- | |
| | Authentication Defaults | |
| |-------------------------------------------------------------------------- | |
| | | |
| | This option controls the default authentication "guard" and password |
mdsohelmia
/ compat_l5.php
Created
September 15, 2019 08:56
— forked from vluzrmos/compat_l5.php
Lumen L5 compatibility helpers. That file should be added on root path of your project... and added to your composer.json
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| if(!function_exists('config_path')) | |
| { | |
| /** | |
| * Return the path to config files | |
| * @param null $path | |
| * @return string | |
| */ | |
| function config_path($path=null) |
mdsohelmia
/ compat_l5.php
Created
September 15, 2019 08:56
— forked from vluzrmos/compat_l5.php
Lumen L5 compatibility helpers. That file should be added on root path of your project... and added to your composer.json
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| if(!function_exists('config_path')) | |
| { | |
| /** | |
| * Return the path to config files | |
| * @param null $path | |
| * @return string | |
| */ | |
| function config_path($path=null) |
- GET /tickets - Retrieves a list of tickets
- GET /tickets/12 - Retrieves a specific ticket
- POST /tickets - Creates a new ticket
- PUT /tickets/12 - Updates ticket #12
- PATCH /tickets/12 - Partially updates ticket #12
- DELETE /tickets/12 - Deletes ticket #12
Reference http://www.vinaysahni.com/best-practices-for-a-pragmatic-restful-api
mdsohelmia
/ eloquent-cheatsheet.php
Created
September 18, 2019 19:01
— forked from hasinhayder/eloquent-cheatsheet.php
Laravel 5 Eloquent CheatSheet #laravel #eloquent
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Model:: | |
| /*Select*/ | |
| select('col1','col2') | |
| ->select(array('col1','col2')) | |
| ->select(DB::raw('businesses.*, COUNT(reviews.id) as no_of_ratings, IFNULL(sum(reviews.score),0) as rating')) | |
| ->addSelect('col3','col4') | |
| ->distinct() // distinct select | |
| /*From*/ |
mdsohelmia
/ List.md
Created
December 29, 2019 16:20
— forked from msurguy/List.md
List of open source projects made with Laravel
Other people's projects:
- https://github.com/laracasts/URL-Shortener URL Shortener by Jeffrey Way
- https://github.com/basco-johnkevin/laravelsnippets Source code of http://laravelsnippets.com website
- https://github.com/jesseterry/FusionInvoice FusionInvoice is built for freelancers and small businesses who need a simple, yet powerful self-hosted web based invoicing system.
- https://github.com/ezynda3/burnmsg is a self-destructing encrypted message app. A demo is also running on https://burnmsg.com
- https://github.com/martindilling/auto-generating-gallery the demo is at http://gallerydemo.martindilling.com/
My projects (tutorials are on my blog at http://maxoffsky.com):
- https://github.com/CodepadME/laravel-tricks - Source of Laravel-tricks.com
mdsohelmia
/ List.md
Created
December 29, 2019 16:20
— forked from msurguy/List.md
List of open source projects made with Laravel
Other people's projects:
- https://github.com/laracasts/URL-Shortener URL Shortener by Jeffrey Way
- https://github.com/basco-johnkevin/laravelsnippets Source code of http://laravelsnippets.com website
- https://github.com/jesseterry/FusionInvoice FusionInvoice is built for freelancers and small businesses who need a simple, yet powerful self-hosted web based invoicing system.
- https://github.com/ezynda3/burnmsg is a self-destructing encrypted message app. A demo is also running on https://burnmsg.com
- https://github.com/martindilling/auto-generating-gallery the demo is at http://gallerydemo.martindilling.com/
My projects (tutorials are on my blog at http://maxoffsky.com):
- https://github.com/CodepadME/laravel-tricks - Source of Laravel-tricks.com
mdsohelmia
/ List.md
Created
December 29, 2019 16:20
— forked from msurguy/List.md
List of open source projects made with Laravel
Other people's projects:
- https://github.com/laracasts/URL-Shortener URL Shortener by Jeffrey Way
- https://github.com/basco-johnkevin/laravelsnippets Source code of http://laravelsnippets.com website
- https://github.com/jesseterry/FusionInvoice FusionInvoice is built for freelancers and small businesses who need a simple, yet powerful self-hosted web based invoicing system.
- https://github.com/ezynda3/burnmsg is a self-destructing encrypted message app. A demo is also running on https://burnmsg.com
- https://github.com/martindilling/auto-generating-gallery the demo is at http://gallerydemo.martindilling.com/
My projects (tutorials are on my blog at http://maxoffsky.com):
- https://github.com/CodepadME/laravel-tricks - Source of Laravel-tricks.com
OlderNewer