Skip to content

Instantly share code, notes, and snippets.

View nanasess's full-sized avatar
🍣
Sushi chef

Kentaro Ohkouchi nanasess

🍣
Sushi chef
32 followers · 46 following
View GitHub Profile
@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 / 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 / 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 / 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 / file0.sql
Created May 20, 2015 02:39
PostgreSQL の日本語ロケールの LIKE で INDEX を使用する ref: http://qiita.com/nanasess/items/423e45a98ae2620dcc8c
CREATE INDEX index_name_idx ON table_name (column_name text_pattern_ops);
@nanasess
nanasess / file0.txt
Created May 21, 2015 02:17
DBD::Oracle でサービス名を指定して接続する ref: http://qiita.com/nanasess/items/344b74dfa67a9509c661
$dbh = DBI->connect("dbi:Oracle://<Host Name>:1521/<Service Name>", username, password);
@nanasess
nanasess / file0.txt
Last active August 29, 2015 14:21
log4j でアプリケーションの情報ログと各種ライブラリのデバッグログを分ける ref: http://qiita.com/nanasess/items/0946bc78a5df75490532
###########################################
# log4j でバッチの情報ログとデバッグログを分ける
###########################################
## アプリケーションの情報ログ
log4j.category.jp.example.batch=INFO, FILE, C
log4j.additivity.jp.example.batch=false
## 各種ライブラリのログ
log4j.category.org.seasar=DEBUG, FILE2, C
@nanasess
nanasess / file0.ini
Created May 28, 2015 02:49
Microsoft Azure Webapps (Websites) の PHP から Oracle Database に接続する ref: http://qiita.com/nanasess/items/ee178fdc0a0d4974ff81
extension_dir=D:\home\site\wwwroot\bin\php\ext\ ;; 修正
;extension=php_oci8.dll ;; Oracle 11g より前のバージョンはこちらを有効に
extension=php_oci8_11g.dll ;; Oracle 11g 以降のバージョンはこちらを有効に
extension=php_pdo_oci.dll ;; 追加
@nanasess
nanasess / gist:eeee5d4b9f8149191066
Created June 17, 2015 07:34
EC-CUBE3の決済連携はこんな感じがいいんじゃない？
--- a/src/Eccube/Controller/ShoppingController.php
+++ b/src/Eccube/Controller/ShoppingController.php
@@ -134,6 +134,7 @@ class ShoppingController extends AbstractController
$cartService = $app['eccube.service.cart'];
$orderService = $app['eccube.service.order'];
$orderRepository = $app['eccube.repository.order'];
+ $paymentService = $app['eccube.service.payment'];
// カートチェック
if (!$cartService->isLocked()) {
@nanasess
nanasess / file0.txt
Created July 22, 2015 01:11
twig で再帰処理 ref: http://qiita.com/nanasess/items/5a1a6dbc1090e8ec0b36
{% macro recursiveCategories(Category) %}
{% if Category.hasChildNodes() %}
<ul>
{% for child in Category.childNodes() %}
<li>{{ child.name }}</li>
{{ _self.recursiveCategories(child) }}
{% endfor %}
</ul>
{% endif %}
{% endmacro %}