Skip to content

Instantly share code, notes, and snippets.

View yogicse's full-sized avatar
🎯
Focusing

Yogendra Kumar yogicse

🎯
Focusing
View GitHub Profile
@yogicse
yogicse / cakeapp
Last active October 13, 2019 04:04
cakeapp
-- phpMyAdmin SQL Dump
-- version 4.9.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Oct 13, 2019 at 06:03 AM
-- Server version: 10.4.8-MariaDB
-- PHP Version: 7.2.23
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
@yogicse
yogicse / ccsdf
Created February 10, 2019 06:24
scrpas
<?php
error_reporting(-1);
ini_set('display_errors', 'On');
// Read $url and $sel from request ($_POST | $_GET)
$url = "https://www.procurepod.com/category/networking/routers.html";
$sel = ".product-image";
require_once 'hQuery/hquery.php';
<?php
error_reporting(-1);
ini_set('display_errors', 'On');
require_once 'app/Mage.php';
Mage::app("admin");
$importfiles = scandir('productscsv');
$importfiles = array_diff($importfiles, array('.', '..'));
// loop through with all files
Array
(
[id] => 4
[customerID] => 4
[type_id] => 0
[fullName] => kuma, yogend
[companyName] =>
[firstName] => yogend
[lastName] => kuma
[groupID] => 14
@yogicse
yogicse / crosstab.sql
Created September 6, 2018 03:17 — forked from romansklenar/crosstab.sql
PostgreSQL "pivot table" example using tablefunc extension
CREATE EXTENSION tablefunc;
CREATE TABLE sales(year int, month int, qty int);
INSERT INTO sales VALUES(2007, 1, 1000);
INSERT INTO sales VALUES(2007, 2, 1500);
INSERT INTO sales VALUES(2007, 7, 500);
INSERT INTO sales VALUES(2007, 11, 1500);
INSERT INTO sales VALUES(2007, 12, 2000);
INSERT INTO sales VALUES(2008, 1, 1000);
INSERT INTO sales VALUES(2009, 5, 2500);
@yogicse
yogicse / Run composer on MAC.txt
Last active January 26, 2018 03:50
Run composer on MAC
mv composer.phar /usr/bin/composer alias composer="php /usr/bin/composer.phar"
@yogicse
yogicse / gist:ed58d5de8bd22782780056dc2078934e
Created December 31, 2017 03:31
sample of base64 image
data:image/jpg;base64,/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAIBAQIBAQICAgICAgICAwUDAwMDAwYEBAMFBwYHBwcGBwcICQsJCAgKCAcHCg0KCgsMDAwMBwkODw0MDgsMDAz/2wBDAQICAgMDAwYDAwYMCAcIDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAz/wAARCAGqAoADASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD8BUgBbHtU8MC+WfY1AkhVsnp9KljucKcdM+lZyTGmWltxk+4qxBbr5X0qol18/wD9apo7zamMjr6VjJSvoWpourbLk5xyPWpFtfMUHjjjrVP7VhckE8Vc0a4E8jR4Kl1zk81nysrmQ+Kyw/QdPWpRbY/hB/Goo74A5LpgD0q5a2
login url
<?php echo Mage::getUrl('customer/account/login'); ?>
logout url
<?php echo Mage::getUrl('customer/account/logout'); ?>
My Account url
<?php echo Mage::getUrl('customer/account'); ?>
Register url