8月 « 2011 « 夢茶爺＆苦茶爺のPC奮戦備忘録

MySQL でカラム種別を tinyint(1) にしてハマッタ

Posted by muchag | CakePHP,MySQL | 2011-08-09 (火) 19:10:38

MySQL でカラム種別を tinyint(1) にしてハマッタ。

【環境】
[CakePHP] 1.3.10

状況

$user['id'] = $id;
$user['name'] = $name;
$user['present'] = 2;
$this->User->save($user);

このスクリプトで、何度試してもデータを保存できなかった。
　

原因

あれこれ試した結果

$user['present'] = 0;
または
$user['present'] = 1;

これだと保存できることがわかった。

因みに、present カラムは、オンオフフラグのため tinyint(1) としている。
　

実験

確かに元々 0 or 1 のみ入力するために作成したカラムなんだけど
テスト用に目立つ 2 を保存しようとしたらアウト。
5 で試してもだめだった。
　

MySQL には知能がある？

ん～、MySQL さんは、私のカラム定義の意図を汲み取ってくれちゃったの？
　

結論

よくわからないけど、わからないからこそメモ・・・。

CakePHP,MySQL | 2011-08-09 (火) 19:10:38 |

Comments (2)

ジオコーディング

Posted by muchag | Google Maps JavaScript API V3,PHP | 2011-08-09 (火) 16:56:51

ジオコーディングとは、住所から緯度・経度へ変換すること。
Google Maps API 以外に同様のサービスがあるようだ。

Google Code：Google Geocoding API

ジオコーディング住所から緯度・経度を取得
逆ジオコーディング緯度・経度から住所を取得（リバースジオコーディング）

リクエスト

http://maps.google.com/maps/api/geocode/output?parameters
　

output

json
xml

いずれかを指定する。

例） http://maps.google.com/maps/api/geocode/json
　

parameters

address latlng とのいずれか必須。住所。UTF-8。要 URL エンコード。ジオコーディング
latlng address とのいずれか必須。緯度,経度の書式。逆ジオコーディング
bounds 不明。未試行
region 地域コード。未試行
language 戻り値の言語。日本語にしたい場合は、language=ja
sensor 必須。センサー（GPS）機能付きの端末か否か

例） http://maps.google.com/maps/api/geocode/json?latlng=35.123456,139.123456&language=ja&sensor=false
　

PHP

ジオコーディング

$strResult = file_get_contents(
'http://maps.google.com/maps/api/geocode/json'
. '?address=' . urlencode( mb_convert_encoding('東京都港区芝公園４丁目２', 'UTF-8' ) )
. '&sensor=false'
);
$arrResult = json_decode($strResult, true);
print_r($arrResult);
// output
Array
(
[results] => Array
(
[0] => Array
(
[address_components] => Array
(
[0] => Array
(
[long_name] => ２
[short_name] => ２
[types] => Array
(
[0] => sublocality_level_3
[1] => sublocality
[2] => political
)
)
[1] => Array
(
[long_name] => ４丁目
[short_name] => ４丁目
[types] => Array
(
[0] => sublocality_level_2
[1] => sublocality
[2] => political
)
)
[2] => Array
(
[long_name] => 芝公園
[short_name] => 芝公園
[types] => Array
(
[0] => sublocality_level_1
[1] => sublocality
[2] => political
)
)
[3] => Array
(
[long_name] => Minato
[short_name] => Minato
[types] => Array
(
[0] => locality
[1] => political
)
)
[4] => Array
(
[long_name] => Tokyo
[short_name] => Tokyo
[types] => Array
(
[0] => administrative_area_level_1
[1] => political
)
)
[5] => Array
(
[long_name] => Japan
[short_name] => JP
[types] => Array
(
[0] => country
[1] => political
)
)
)
[formatted_address] => Japan, Tokyo Minato芝公園４丁目２
[geometry] => Array
(
[bounds] => Array
(
[northeast] => Array
(
[lat] => 35.6594319
[lng] => 139.7463427
)
[southwest] => Array
(
[lat] => 35.6578418
[lng] => 139.7443429
)
)
[location] => Array
(
[lat] => 35.6586039
[lng] => 139.7451331
)
[location_type] => APPROXIMATE
[viewport] => Array
(
[northeast] => Array
(
[lat] => 35.6676693
[lng] => 139.7611405
)
[southwest] => Array
(
[lat] => 35.6495375
[lng] => 139.7291257
)
)
)
[types] => Array
(
[0] => sublocality_level_3
[1] => sublocality
[2] => political
)
)
)
[status] => OK
)

逆ジオコーディング

$strResult = file_get_contents(
'http://maps.google.com/maps/api/geocode/json'
. '?latlng=35.6586039,139.7451331'
. '&language=ja'
. '&sensor=false'
);
$arrResult = json_decode($strResult, true);
print_r($arrResult);
// output
Array
(
[results] => Array
(
[0] => Array
(
[address_components] => Array
(
[0] => Array
(
[long_name] => ８
[short_name] => ８
[types] => Array
(
[0] => sublocality_level_4
[1] => sublocality
[2] => political
)
)
[1] => Array
(
[long_name] => ２
[short_name] => ２
[types] => Array
(
[0] => sublocality_level_3
[1] => sublocality
[2] => political
)
)
[2] => Array
(
[long_name] => ４丁目
[short_name] => ４丁目
[types] => Array
(
[0] => sublocality_level_2
[1] => sublocality
[2] => political
)
)
[3] => Array
(
[long_name] => 芝公園
[short_name] => 芝公園
[types] => Array
(
[0] => sublocality_level_1
[1] => sublocality
[2] => political
)
)
[4] => Array
(
[long_name] => 港区
[short_name] => 港区
[types] => Array
(
[0] => locality
[1] => political
)
)
[5] => Array
(
[long_name] => 東京都
[short_name] => 東京都
[types] => Array
(
[0] => administrative_area_level_1
[1] => political
)
)
[6] => Array
(
[long_name] => 日本
[short_name] => JP
[types] => Array
(
[0] => country
[1] => political
)
)
)
[formatted_address] => 日本, 東京都港区芝公園４丁目２－８
[geometry] => Array
(
[location] => Array
(
[lat] => 35.6587039
[lng] => 139.7454081
)
[location_type] => APPROXIMATE
[viewport] => Array
(
[northeast] => Array
(
[lat] => 35.660052880292
[lng] => 139.74675708029
)
[southwest] => Array
(
[lat] => 35.657354919709
[lng] => 139.74405911971
)
)
)
[types] => Array
(
[0] => sublocality_level_4
[1] => sublocality
[2] => political
)
)
[1] => Array
(
[address_components] => Array
(
[0] => Array
(
[long_name] => ２
[short_name] => ２
[types] => Array
(
[0] => sublocality_level_3
[1] => sublocality
[2] => political
)
)
[1] => Array
(
[long_name] => ４丁目
[short_name] => ４丁目
[types] => Array
(
[0] => sublocality_level_2
[1] => sublocality
[2] => political
)
)
[2] => Array
(
[long_name] => 芝公園
[short_name] => 芝公園
[types] => Array
(
[0] => sublocality_level_1
[1] => sublocality
[2] => political
)
)
[3] => Array
(
[long_name] => 港区
[short_name] => 港区
[types] => Array
(
[0] => locality
[1] => political
)
)
[4] => Array
(
[long_name] => 東京都
[short_name] => 東京都
[types] => Array
(
[0] => administrative_area_level_1
[1] => political
)
)
[5] => Array
(
[long_name] => 日本
[short_name] => JP
[types] => Array
(
[0] => country
[1] => political
)
)
)
[formatted_address] => 日本, 東京都港区芝公園４丁目２
[geometry] => Array
(
[bounds] => Array
(
[northeast] => Array
(
[lat] => 35.6594319
[lng] => 139.7463427
)
[southwest] => Array
(
[lat] => 35.6578418
[lng] => 139.7443429
)
)
[location] => Array
(
[lat] => 35.6586039
[lng] => 139.7451331
)
[location_type] => APPROXIMATE
[viewport] => Array
(
[northeast] => Array
(
[lat] => 35.659985830291
[lng] => 139.74669178029
)
[southwest] => Array
(
[lat] => 35.657287869708
[lng] => 139.74399381971
)
)
)
[types] => Array
(
[0] => sublocality_level_3
[1] => sublocality
[2] => political
)
)
[2] => Array
(
[address_components] => Array
(
[0] => Array
(
[long_name] => ４丁目
[short_name] => ４丁目
[types] => Array
(
[0] => sublocality_level_2
[1] => sublocality
[2] => political
)
)
[1] => Array
(
[long_name] => 芝公園
[short_name] => 芝公園
[types] => Array
(
[0] => sublocality_level_1
[1] => sublocality
[2] => political
)
)
[2] => Array
(
[long_name] => 港区
[short_name] => 港区
[types] => Array
(
[0] => locality
[1] => political
)
)
[3] => Array
(
[long_name] => 東京都
[short_name] => 東京都
[types] => Array
(
[0] => administrative_area_level_1
[1] => political
)
)
[4] => Array
(
[long_name] => 日本
[short_name] => JP
[types] => Array
(
[0] => country
[1] => political
)
)
)
[formatted_address] => 日本, 東京都港区芝公園４丁目
[geometry] => Array
(
[bounds] => Array
(
[northeast] => Array
(
[lat] => 35.6598254
[lng] => 139.7504335
)
[southwest] => Array
(
[lat] => 35.6529283
[lng] => 139.7433174
)
)
[location] => Array
(
[lat] => 35.6574486
[lng] => 139.7470913
)
[location_type] => APPROXIMATE
[viewport] => Array
(
[northeast] => Array
(
[lat] => 35.6598254
[lng] => 139.7504335
)
[southwest] => Array
(
[lat] => 35.6529283
[lng] => 139.7433174
)
)
)
[types] => Array
(
[0] => sublocality_level_2
[1] => sublocality
[2] => political
)
)
[3] => Array
(
[address_components] => Array
(
[0] => Array
(
[long_name] => 106-0044
[short_name] => 106-0044
[types] => Array
(
[0] => postal_code
)
)
[1] => Array
(
[long_name] => 日本
[short_name] => JP
[types] => Array
(
[0] => country
[1] => political
)
)
)
[formatted_address] => 〒106-0044, 日本
[geometry] => Array
(
[bounds] => Array
(
[northeast] => Array
(
[lat] => 35.6600953
[lng] => 139.7473204
)
[southwest] => Array
(
[lat] => 35.6534543
[lng] => 139.7358241
)
)
[location] => Array
(
[lat] => 35.6564125
[lng] => 139.7425667
)
[location_type] => APPROXIMATE
[viewport] => Array
(
[northeast] => Array
(
[lat] => 35.6600953
[lng] => 139.7473204
)
[southwest] => Array
(
[lat] => 35.6534543
[lng] => 139.7358241
)
)
)
[types] => Array
(
[0] => postal_code
)
)
[4] => Array
(
[address_components] => Array
(
[0] => Array
(
[long_name] => 芝公園
[short_name] => 芝公園
[types] => Array
(
[0] => sublocality_level_1
[1] => sublocality
[2] => political
)
)
[1] => Array
(
[long_name] => 港区
[short_name] => 港区
[types] => Array
(
[0] => locality
[1] => political
)
)
[2] => Array
(
[long_name] => 東京都
[short_name] => 東京都
[types] => Array
(
[0] => administrative_area_level_1
[1] => political
)
)
[3] => Array
(
[long_name] => 日本
[short_name] => JP
[types] => Array
(
[0] => country
[1] => political
)
)
)
[formatted_address] => 日本, 東京都港区芝公園
[geometry] => Array
(
[bounds] => Array
(
[northeast] => Array
(
[lat] => 35.6621377
[lng] => 139.7528936
)
[southwest] => Array
(
[lat] => 35.6529258
[lng] => 139.7432918
)
)
[location] => Array
(
[lat] => 35.6575015
[lng] => 139.7521575
)
[location_type] => APPROXIMATE
[viewport] => Array
(
[northeast] => Array
(
[lat] => 35.6621377
[lng] => 139.7528936
)
[southwest] => Array
(
[lat] => 35.6529258
[lng] => 139.7432918
)
)
)
[types] => Array
(
[0] => sublocality_level_1
[1] => sublocality
[2] => political
)
)
[5] => Array
(
[address_components] => Array
(
[0] => Array
(
[long_name] => 105-0011
[short_name] => 105-0011
[types] => Array
(
[0] => postal_code
)
)
[1] => Array
(
[long_name] => 日本
[short_name] => JP
[types] => Array
(
[0] => country
[1] => political
)
)
)
[formatted_address] => 〒105-0011, 日本
[geometry] => Array
(
[bounds] => Array
(
[northeast] => Array
(
[lat] => 35.6625143
[lng] => 139.7537082
)
[southwest] => Array
(
[lat] => 35.6509114
[lng] => 139.7434881
)
)
[location] => Array
(
[lat] => 35.6575015
[lng] => 139.7521575
)
[location_type] => APPROXIMATE
[viewport] => Array
(
[northeast] => Array
(
[lat] => 35.6625143
[lng] => 139.7537082
)
[southwest] => Array
(
[lat] => 35.6509114
[lng] => 139.7434881
)
)
)
[types] => Array
(
[0] => postal_code
)
)
[6] => Array
(
[address_components] => Array
(
[0] => Array
(
[long_name] => 港区
[short_name] => 港区
[types] => Array
(
[0] => locality
[1] => political
)
)
[1] => Array
(
[long_name] => 東京都
[short_name] => 東京都
[types] => Array
(
[0] => administrative_area_level_1
[1] => political
)
)
[2] => Array
(
[long_name] => 日本
[short_name] => JP
[types] => Array
(
[0] => country
[1] => political
)
)
)
[formatted_address] => 日本, 東京都港区
[geometry] => Array
(
[bounds] => Array
(
[northeast] => Array
(
[lat] => 35.6825958
[lng] => 139.7828356
)
[southwest] => Array
(
[lat] => 35.6231224
[lng] => 139.7087473
)
)
[location] => Array
(
[lat] => 35.6580681
[lng] => 139.7515992
)
[location_type] => APPROXIMATE
[viewport] => Array
(
[northeast] => Array
(
[lat] => 35.6825958
[lng] => 139.7828356
)
[southwest] => Array
(
[lat] => 35.6231224
[lng] => 139.7087473
)
)
)
[types] => Array
(
[0] => locality
[1] => political
)
)
[7] => Array
(
[address_components] => Array
(
[0] => Array
(
[long_name] => 東京都
[short_name] => 東京都
[types] => Array
(
[0] => administrative_area_level_1
[1] => political
)
)
[1] => Array
(
[long_name] => 日本
[short_name] => JP
[types] => Array
(
[0] => country
[1] => political
)
)
)
[formatted_address] => 日本, 東京都
[geometry] => Array
(
[bounds] => Array
(
[northeast] => Array
(
[lat] => 35.898644
[lng] => 139.919853
)
[southwest] => Array
(
[lat] => 35.50119
[lng] => 138.942758
)
)
[location] => Array
(
[lat] => 35.6894875
[lng] => 139.6917064
)
[location_type] => APPROXIMATE
[viewport] => Array
(
[northeast] => Array
(
[lat] => 35.898644
[lng] => 139.919853
)
[southwest] => Array
(
[lat] => 35.50119
[lng] => 138.942758
)
)
)
[types] => Array
(
[0] => administrative_area_level_1
[1] => political
)
)
[8] => Array
(
[address_components] => Array
(
[0] => Array
(
[long_name] => 日本
[short_name] => JP
[types] => Array
(
[0] => country
[1] => political
)
)
)
[formatted_address] => 日本
[geometry] => Array
(
[bounds] => Array
(
[northeast] => Array
(
[lat] => 45.6691047
[lng] => 149.120962
)
[southwest] => Array
(
[lat] => 23.9207972
[lng] => 122.91
)
)
[location] => Array
(
[lat] => 36.204824
[lng] => 138.252924
)
[location_type] => APPROXIMATE
[viewport] => Array
(
[northeast] => Array
(
[lat] => 45.6691047
[lng] => 149.120962
)
[southwest] => Array
(
[lat] => 23.9207972
[lng] => 122.91
)
)
)
[types] => Array
(
[0] => country
[1] => political
)
)
)
[status] => OK
)

Google Maps JavaScript API V3,PHP | 2011-08-09 (火) 16:56:51 |

Comments (0)

ウィンドウ情報

Posted by muchag | jQuery | 2011-08-05 (金) 18:28:16

【環境】
[jQuery] 1.6.1

ターゲット

ウィンドウ情報についてのターゲットは

$('html')
$(window)
$(document)

この３つが対応しているようだが
下２つはブラウザ依存度が高く使いにくいらしい。

私自身は、まだ $(‘html’) しか試していない。
　

プロパティ

pageX	ドキュメント内でのマウスカーソルの当該 X 座標
pageY	ドキュメント内でのマウスカーソルの当該 Y 座標
clientX	表示領域内でのマウスカーソルの当該 X 座標スクロールによって値が変動
clientY	表示領域内でのマウスカーソルの当該 Y 座標スクロールによって値が変動