Hasib Kamal Chowdhury hasibkamal

Senior Software Engineer

hasibkamal / HeidiSQL_SH

Last active March 6, 2018 06:08

install windows software with wine

	#!/bin/bash

	wget http://www.heidisql.com/downloads/releases/HeidiSQL_9.3_Portable.zip -O HeidiSQL.zip
	mkdir /opt/HeidiSQL
	unzip HeidiSQL.zip -d /opt/HeidiSQL
	chmod +x /opt/HeidiSQL/heidisql.exe
	chmod +x /opt/HeidiSQL/HeidiSQL.com

	touch /usr/share/applications/HeidiSQL.desktop

hasibkamal / bd_district_lat_lng

Last active December 24, 2022 02:51

Bangladesh district lang and lat

	SET NAMES utf8;
	SET time_zone = '+00:00';
	SET foreign_key_checks = 0;
	SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

	DROP TABLE IF EXISTS `bd_district_lat_lng`;
	CREATE TABLE `bd_district_lat_lng` (
	`id` tinyint(11) NOT NULL AUTO_INCREMENT,
	`name` varchar(30) CHARACTER SET utf8 NOT NULL,
	`lat` double NOT NULL,

hasibkamal / commaSeparateNumber.js

Last active December 31, 2016 06:17

Comma Separated Number

	function commaSeparateNumber(val)
	{
	while (/(\d+)(\d{3})/.test(val.toString()))
	{
	val = val.toString().replace(/(\d+)(\d{3})/, '$1'+','+'$2');
	}
	return val;
	}

	var thisVal = commaSeparateNumber(this.value);

hasibkamal / gist:d27a04b027e5f84b43232b348e4906ee

Created December 17, 2016 09:17

Study with DATE

	1>
	if($request->get('carrier_pass_validity') != '')
	$exportPermit->carrier_pass_validity = CommonFunction::changeDateFormat($request->get('carrier_pass_validity'),true);
	2>
	class CommonFunction {
	public static function changeDateFormat($dateicker, $mysql = false) {
	if ($mysql) {
	return Carbon::createFromFormat('d-M-Y', $dateicker)->format('Y-m-d');
	} else {
	return Carbon::createFromFormat('Y-m-d', $dateicker)->format('d-M-Y');

hasibkamal / gist:3ed033a831f5fe3f00c5e0889cd0a9f1

Created December 5, 2016 06:41

	App\Libraries\CommonFunction::changeDateFormat(substr($alreadyExistApplicant->arrival_date, 0, 10)

	public static function changeDateFormat($dateicker, $mysql = false) {
	if ($mysql) {
	return Carbon::createFromFormat('d-M-Y', $dateicker)->format('Y-m-d');
	} else {
	return Carbon::createFromFormat('Y-m-d', $dateicker)->format('d-M-Y');
	}
	}

hasibkamal / print_r(serial("1,2,3,4-6,7-15"));

Created November 13, 2016 19:12

	<?php
	function serial($str){
	$arr = explode(',', $str);
	$series = array();
	foreach($arr as $val){

	if(strpos($val,'-')){
	$_arr = explode('-', $val);

	$series = array_merge($series,range($_arr[0], $_arr[1]));

hasibkamal / JSON.js

Created November 8, 2016 04:57

hasibkamal / laravel_ajax.php

Created November 5, 2016 17:52