iamshanto’s gists

iamshanto / Simple Language Switch

Created April 11, 2015 04:11

iamshanto / Oracle Coneection Example

Created April 16, 2015 05:58

	<?php
	error_reporting(E_ALL);
	ini_set('display_errors', 'On');

	$conn = oci_connect('system', 'manager', '192.168.1.4/xe');

	$stid = oci_parse($conn, 'select * from HR.GREETINGS');
	oci_execute($stid);

	echo "<table>\n";

iamshanto / AutoGenerateCRUDStoredProcs

Created April 20, 2015 02:28

	-- http://www.sqlbook.com/scripts/AutoGenerateCRUDStoredProcs.txt
	-- #########################################################
	-- Author: www.sqlbook.com
	-- Copyright: (c) www.sqlbook.com. You are free to use and redistribute
	-- this script as long as this comments section with the
	-- author and copyright details are not altered.
	-- Purpose: For a specified user defined table (or all user defined
	-- tables) in the database this script generates 4 Stored
	-- Procedure definitions with different Procedure name
	-- suffixes:

iamshanto / sql

Last active June 23, 2017 04:55

Oracle SQL

	/* SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; */
	time_zone := "+00:00";

	CREATE TABLE BACKOFFICEINFO (
	IID number(10) NOT NULL,
	BACKOFFICENAME varchar2(255) NOT NULL,
	BACKOFFICEADDRESS clob NOT NULL,
	PRIMARY KEY (IID)
	) ;

iamshanto / Oracle connection

Created May 5, 2015 08:03

	<?php
	$conn = oci_connect('system', '12', '192.168.1.71/xe');
	$stid = oci_parse($conn, 'select * from BININFO');
	oci_execute($stid);

	while (($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) != false) {
	foreach ($row as $item) {
	var_dump($item);
	}
	}

iamshanto / PHPExcel CheetSheet

Last active August 29, 2015 14:21

	### Merge Cell
	$objPHPExcel->getActiveSheet()->mergeCells('A1:C1');

	#### Set Cell Widget
	$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);

	### Set Text Bold

	// Full Cell
	$objPHPExcel->getActiveSheet()->getStyle("A1")->getFont()->setBold(true);

iamshanto / Doctrine

Created August 4, 2015 02:08

	public function getAuthoritativeSportsRecords()
	{
	$sql = "
	SELECT name,
	event_type,
	sport_type,
	level
	FROM vnn_sport
	";

iamshanto / Oracle Java-8 install on Ubuntu.txt

Created August 10, 2015 06:07

	sudo add-apt-repository ppa:webupd8team/java -y
	sudo apt-get update
	sudo apt-get install oracle-java8-installer

	--To automatically set up the Java 8 environment variables
	sudo apt-get install oracle-java8-set-default

	java -version

iamshanto / MYSQL - DROP ALL TABLES

Created August 11, 2015 05:13

	# Source http://stackoverflow.com/questions/12403662/how-to-remove-all-mysql-tables-from-the-command-line-without-drop-database-permi
	SET FOREIGN_KEY_CHECKS = 0;
	SET @tables = NULL;
	SELECT GROUP_CONCAT(table_schema, '.', table_name) INTO @tables
	FROM information_schema.tables
	WHERE table_schema = 'database_name'; -- specify DB name here.

	SET @tables = CONCAT('DROP TABLE ', @tables);
	PREPARE stmt FROM @tables;
	EXECUTE stmt;

iamshanto / Maven Build Error

Created August 25, 2015 10:16

	[INFO] Scanning for projects...
	[INFO] ------------------------------------------------------------------------
	[INFO] BUILD FAILURE
	[INFO] ------------------------------------------------------------------------
	[INFO] Total time: 0.460s
	[INFO] Finished at: Tue Aug 25 16:15:22 BDT 2015
	[INFO] Final Memory: 6M/104M
	[INFO] ------------------------------------------------------------------------
	[ERROR] Error resolving version for plugin 'spring:boot' from the repositories [local (/home/samiul/.m2/repository), spring-snapshots (http://repo.spring.io/snapshot), spring-milestones (http://repo.spring.io/milestone), central (http://repo.maven.apache.org/maven2)]: Plugin not found in any plugin repository -> [Help 1]
	[ERROR]

	<?php

	namespace Emicro\Bundle\CoreBundle\Controller;

	use Symfony\Bundle\FrameworkBundle\Controller\Controller;
	use Symfony\Component\HttpFoundation\Request;

	class LanguageSwitcherController extends Controller
	{
	public function switchAction(Request $request)

Samiul Amin Shanto iamshanto