Skip to content

Instantly share code, notes, and snippets.

View git-e-001's full-sized avatar

Eahiya Khan Devxhub git-e-001

4 followers · 7 following
View GitHub Profile
@git-e-001
git-e-001 / LaravelWhereLikeMacro.php
Created December 18, 2023 04:33 — forked from MrPunyapal/LaravelWhereLikeMacro.php
Laravel Custom 'whereLike' Macro for Dynamic 'LIKE' Searches including relationships
<?php
namespace App\Providers;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Arr;
use Illuminate\Support\ServiceProvider;
class AppServiceProvider extends ServiceProvider
{
@git-e-001
git-e-001 / countries.sql
Created May 22, 2023 10:34 — forked from lerouse/countries.sql
SQL Dump of all Countries, Dial Codes, Currencies and Currency Name
-- Table structure for table `countries`
CREATE TABLE IF NOT EXISTS `countries` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
`iso` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
`iso3` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
`dial` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
`currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
`currency_name` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
@git-e-001
git-e-001 / MySQL.md
Created May 23, 2021 06:23 — forked from eliyas5044/MySQL.md
MySQL Commands for Laravel

MySQL CLI

To login into mysql, enter db_password

mysql -u db_user -p

Create database

CREATE DATABASE db_name;