nadyshalaby

function fallbackCopyTextToClipboard(text) {
            var textArea = document.createElement("textarea");
            textArea.value = text;

            // Avoid scrolling to bottom
            textArea.style.top = "0";
            textArea.style.left = "0";
            textArea.style.position = "fixed";

            document.body.appendChild(textArea);

nadyshalaby

Worktree most used commands

To open worktree from current bransh

git worktree add --detach <worktree-path> <branch-name>

To open worktree from remote branch

git worktree add --detach <worktree-path> <remote-name>/<branch-name>

To open worktree from commit

git worktree add --detach

nadyshalaby

SET @target_table = '`klame_new`.`url`';
SET @source_table = '`klame_url`.`url`';

SELECT GROUP_CONCAT(column_name)
 FROM INFORMATION_SCHEMA.COLUMNS a 
 WHERE a.TABLE_NAME = 'url'
 AND a.TABLE_SCHEMA = 'klame_url'
 AND a.COLUMN_NAME IN (
   SELECT b.COLUMN_NAME
   FROM INFORMATION_SCHEMA.COLUMNS b 

nadyshalaby

RewriteEngine on

# Disable Directory listing
Options -Indexes

# Redirect Trailing Slashes If Not A Folder...
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} (.+)/$
RewriteRule ^ %1 [L,R=301]

nadyshalaby

FROM php:8.1-apache
RUN apt-get update && apt-get install -y git \
  libpng-dev \
  zlib1g-dev \
  libwebp-dev \
  libjpeg62-turbo-dev \
  libpng-dev libxpm-dev \
  libfreetype6-dev

RUN docker-php-ext-configure gd \

nadyshalaby

#!/bin/sh

# This script is used to as a seeder for the database.
# It will dump a database data only or populate it.

# Show a drawing of word "MySQL Dumper Script by @nadyshalaby" on the screen.
echo "
 _____________________________________
< MySQL Dumper Script by @nadyshalaby >
 -------------------------------------

nadyshalaby

RewriteEngine on

# Redirect Trailing Slashes If Not A Folder...
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} (.+)/$
RewriteRule ^ %1 [L,R=301]

RewriteCond %{REQUEST_URI} !^public

RewriteRule ^(.*)$ public/$1 [L]

nadyshalaby

-----BEGIN PRIVATE KEY-----
MIGTAgohoMGByqGS....
.....etc.
-----END PRIVATE KEY-----

nadyshalaby

private function findNearestLocation(Request $request)
{
    $location = DB::table('locations')
        ->select('name', 'latitude', 'longitude', 'region', DB::raw(sprintf(
            '(6371 * acos(cos(radians(%1$.7f)) * cos(radians(latitude)) * cos(radians(longitude) - radians(%2$.7f)) + sin(radians(%1$.7f)) * sin(radians(latitude)))) AS distance',
            $request->input('latitude'),
            $request->input('longitude')
        )))
        ->having('distance', '<', 50)
        ->orderBy('distance', 'asc')

nadyshalaby

function iframeURLChange(iframe, callback) {
    var lastDispatched = null;

    var dispatchChange = function () {
        var newHref = iframe.contentWindow.location.href;

        if (newHref !== lastDispatched) {
            callback(newHref);
            lastDispatched = newHref;
        }