Skip to content

Instantly share code, notes, and snippets.

View nanasess's full-sized avatar
🍣
Sushi chef

Kentaro Ohkouchi nanasess

🍣
Sushi chef
41 followers · 47 following
View GitHub Profile
@nanasess
nanasess / file0.ini
Last active August 29, 2015 14:21
Windows 環境の PHP から Oracle へ接続する ref: http://qiita.com/nanasess/items/efa7c027838509a44586
;; extension=php_oci8.dll ;; Oracle 11g より前のバージョンはこちらを有効に
extension=php_oci8_11g.dll ;; Oracle 11g 以降のバージョンはこちらを有効に
extension=php_pdo_oci.dll
@nanasess
nanasess / doctrine_dbal_oracle.patch
Last active August 29, 2015 14:19
Doctrine DBAL on Oracle XE 11g of patch.
--- a/lib/Doctrine/DBAL/Driver/AbstractOracleDriver.php
+++ b/lib/Doctrine/DBAL/Driver/AbstractOracleDriver.php
@@ -117,7 +117,7 @@ abstract class AbstractOracleDriver implements Driver, ExceptionConverterDriver
if ( ! isset($params['port'])) {
$params['port'] = 1521;
}
-
+ $params['service'] = true;
$serviceName = $params['dbname'];
@nanasess
nanasess / example.js
Last active August 29, 2015 14:17
jQueryプラグインのスケルトン
/*
* jQuery plugin skelton.
*/
;(function($, window, undefined) {
$.fn.example = function(options) {
return this.each(function() {
var o;
if (options) {
o = $.fn.extend({}, $.fn.example.defaults, options);
} else {
@nanasess
nanasess / normalize.php
Created November 14, 2014 09:32
波ダッシュ(U+301C) を PHP で UTF-8 → SJIS-win → UTF-8 とすると、全角チルダ(U+FF5E)になってしまう罠
<?php
$code1 = 'FF5E'; /* 全角チルダ */
$code2 = '301C'; /* 波ダッシュ */
$char1 = h2bin($code1);
$char2 = h2bin($code2);
var_dump(urlencode($char1));
var_dump(urlencode($char2));
@nanasess
nanasess / gist:b7776f76f83784b3d2a2
Created August 28, 2014 12:18
PHPむずかしい
$ php -r "var_dump('null-null-null' <= '1800-1-1');"
bool(false)
$ php -r "var_dump("null-null-null" <= '1800-1-1');"
bool(true)
@nanasess
nanasess / file0.txt
Created July 19, 2014 06:45
LISTEN しているポート一覧を確認する ref: http://qiita.com/nanasess/items/1244b75b084d166cca05
netstat -an | grep -e 'LISTEN *$'
@nanasess
nanasess / file0.xml
Created May 1, 2014 04:59
IIS で PHP の ob_* 関数が効かない場合の対処法 ref: http://qiita.com/nanasess/items/ac002829035dbf78aa02
<configuration>
<system.webServer>
.....
<handlers>
<remove name="PHP53_via_FastCGI" />
<add name="PHP53_via_FastCGI" path="*.php" verb="GET,HEAD,POST" modules="FastCgiModule" scriptProcessor="D:\Program Files (x86)\PHP\v5.3\php-cgi.exe" resourceType="Either" requireAccess="Script" responseBufferLimit="0"/>
</handlers>
</system.webServer>
</configuration>
@nanasess
nanasess / file0.sh
Last active August 29, 2015 14:00
ssh でローカルとリモートの diff をとる ref: http://qiita.com/nanasess/items/3c75642a079c236bd46d
ssh [email protected] "cat /path/to/remote_file" | diff -u /path/to/local_file -
@nanasess
nanasess / file0.sh
Last active August 29, 2015 14:00
vi(vim) で文字エンコーディングを指定してファイルを開く ref: http://qiita.com/nanasess/items/d5e920137b29f2fcaa4f
vi -c ":e ++enc=euc-jp" filename
@nanasess
nanasess / gist:10961450
Created April 17, 2014 07:38
INDEX of SQL Database for EC-CUBE
-- product_code を nvarchar(64) に変更しておくこと!
CREATE NONCLUSTERED INDEX product_category_category_id_idx ON [dbo].[dtb_product_categories] ([category_id]) INCLUDE ([product_id]);
CREATE NONCLUSTERED INDEX product_code_idx ON dtb_products_class (product_code) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX price01_idx ON dtb_products_class (price01) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX price02_idx ON dtb_products_class (price02) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX stock_idx ON dtb_products_class (stock) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX stock_unlimited_idx ON dtb_products_class (stock_unlimited) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX point_rate_idx ON dtb_products_class (point_rate) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX deliv_fee_idx ON dtb_products_class (deliv_fee) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX product_id_idx ON dtb_products_class (product_id);