Skip to content

Instantly share code, notes, and snippets.

View amitchhajer's full-sized avatar

Amit Chhajer amitchhajer

View GitHub Profile
apt-get install -y ppa-purge
add-apt-repository -y ppa:ondrej/php5-oldstable
apt-get update
ppa-purge ppa:ondrej/php5
apt-get update && apt-get upgrade -y && apt-get autoremove -y && apt-get autoclean -y
@amitchhajer
amitchhajer / fibanacci_recursive_2_vars
Created October 13, 2014 08:07
Fibonaaci recursive with 2 variables
<?php
function fibo($n, $first =1, $second=1)
{
if($n==1 || $n==2)
return $second;
else
return fibo($n-1, $second,($first + $second));
}
@amitchhajer
amitchhajer / ntpdate
Created December 28, 2012 06:15 — forked from anonymous/ntpdate
There are times when you need to keep the date and time of your system to be correct.
Ntpdate in linux helps you do the same
sudo ntpdate -u ntp.ubuntu.org
ntpdate are installed on most distributions, if not install using apt-get.
@amitchhajer
amitchhajer / php datetime
Created December 28, 2012 06:25
Validating php date and date time
Validating a date from format yyyy-mm-dd
$date = DateTime::createFromFormat('Y-m-d', $generatedFrom);
if (!($date instanceof DateTime)) {
throw new ValidationError('Not valid start date');
}
Similarly other formats can be validated.
@amitchhajer
amitchhajer / mysql formatted result
Created January 10, 2013 13:00
Formatted query result mysql
After into mysql cli
use command " pager less -SFX " and then use mysql cli normally
You can use arrow keys as well as pageup/down keys.
import sublime
import sublime_plugin
class NumberCommand(sublime_plugin.TextCommand):
def run(self, edit):
selection = self.view.sel()
for region in selection:
try:
value = int(self.view.substr(region))
self.view.replace(edit, region, str(self.op(value)))
@amitchhajer
amitchhajer / delete_duplicate.mysql
Created July 20, 2013 14:29
Delete duplicate records from database leaving one of them.
delete from my_table mt1, my_table mt2 where mt1.fieldX = mt2.fieldX and mt1.fieldY = mt2.fieldY and mt1.primary_key > mt2.primary_key
@amitchhajer
amitchhajer / git_branches_specific_user
Last active January 2, 2016 09:18
Get all the branches in git for specific user
git for-each-ref --format='%(committerdate) %09 %(authorname) %09 %(refname)' | sort -k5n -k2M -k3n -k4n | grep 'user'
@amitchhajer
amitchhajer / Proxy
Created December 28, 2012 06:20
Tunnelling using ssh
ssh -C2qTnN -D 8080 username@xxx.xxx.xxx.xxx (xxx.xxx.xxx.xxx is the ip which allows ssh access) (can change the port from 8080 to as per requirement)
You are connected to the proxy. To use the proxy, go the one of your browser
and change the proxy settings to use SOCKS protocol and localhost (127.0.0.1) with port 8080.
@amitchhajer
amitchhajer / add_row.sh
Created March 31, 2017 06:18 — forked from kristjan/add_row.sh
Google Spreadsheet row insertion example
# $auth from auth.sh
# $spreadsheet_id from get_spreadsheets.sh
# $worksheet_id from get_worksheets.sh
curl \
--header "Authorization: GoogleLogin auth=$auth" \
--header 'Content-Type: application/atom+xml' \
-d @data.xml \
-X POST \
"https://spreadsheets.google.com/feeds/list/$spreadsheet_id/$worksheet_id/private/full"
# Example data in data.xml