2009年10月22日木曜日

IE6で form要素の accept-charset属性が聞かないことの回避方法

http://bakera.jp/htmlbbs/inthread/3223

input type="hidden" name="dummy" value="�"
といれればよい



IE6は早くなくしたいですね。

これで毎回数時間はとられますよね。。

2009年10月20日火曜日

UTF-8でhtmlを書くとIE6で違う文字になることの回避方法

styleにsans-serifを追加する


例)
body style='font-family: "MS Pゴシック" ,sans-serif;'


※ブログ久しぶりですね。見ている人いるのかな・・・

2009年8月12日水曜日

2009年8月6日木曜日

smartyの$smarty.sessionが表示されない場合の対処法

tplファイルの$smarty.sessionが取れない場合、
php側でsession_start()をちゃんとしている確認

2009年7月29日水曜日

SEO続報

「フリーエンジニア」でgoogle検索で1ぺージ目に出ましたね。

ちょっとうれしいです。

2009年7月16日木曜日

都道府県と主な市町村の連動セレクトボックス

労力が悔しかったので
残しておく(笑)




<SCRIPT LANGUAGE=JavaScript>
<!--


function changePref(b) {
if (document.formMain.pref.selectedIndex == 0) {
document.formMain.city.length = 1;
document.formMain.city.selectedIndex = 0;
} else {
if (b) {
document.formMain.city.length = 1;
document.formMain.city.selectedIndex = 0;
}
var city = cities[document.formMain.pref.selectedIndex - 1];
document.formMain.city.length = city.length + 1;
for (var i = 0; i < city.length; i++) {
document.formMain.city.options[i + 1].value = i;
document.formMain.city.options[i + 1].text = city[i];
}
}
}

var prefs = new Array("北海道","青森県","岩手県","宮城県","秋田県","山形県","福島県","茨城県","栃木県","群馬県","埼玉県","千葉県","東京都","神奈川県","新潟県","富山県","石川県","福井県","山梨県","長野県","岐阜県","静岡県","愛知県","三重県","滋賀県","京都府","大阪府","兵庫県","奈良県","和歌山県","鳥取県","島根県","岡山県","広島県","山口県","徳島県","香川県","愛媛県","高知県","福岡県","佐賀県","長崎県","熊本県","大分県","宮崎県","鹿児島県","沖縄県");
var cities = new Array();
cities[0] = new Array("札幌市","江別市","千歳市","恵庭市","北広島市","石狩市","夕張市","小樽市","函館市","北斗市","室蘭市","苫小牧市","登別市","旭川市","稚内市","北見市","網走市","帯広市","釧路市","根室市","その他");
cities[1] = new Array("青森市","弘前市","八戸市","黒石市","五所川原市","十和田市","三沢市","むつ市","つがる市","平川市","その他");
cities[2] = new Array("盛岡市","宮古市","大船渡市","花巻市","北上市","久慈市","遠野市","一関市","陸前高田市","釜石市","二戸市","八幡平市","奥州市","その他");
cities[3] = new Array("仙台市","石巻市","塩竈市","気仙沼市","白石市","名取市","角田市","多賀城市","岩沼市","登米市","栗原市","東松島市","大崎市","その他");
cities[4] = new Array("秋田市","能代市","横手市","大館市","男鹿市","湯沢市","鹿角市","由利本荘市","潟上市","大仙市","北秋田市","にかほ市","仙北市","その他");
cities[5] = new Array("山形市","米沢市","鶴岡市","酒田市","新庄市","寒河江市","上山市","村山市","長井市","天童市","東根市","尾花沢市","南陽市","その他");
cities[6] = new Array("福島市","会津若松市","郡山市","いわき市","白河市","須賀川市","喜多方市","相馬市","二本松市","田村市","南相馬市","伊達市","本宮市","その他");
cities[7] = new Array("水戸市","日立市","土浦市","古河市","石岡市","結城市","龍ケ崎市","下妻市","常総市","常陸太田市","高萩市","北茨城市","笠間市","取手市","牛久市","つくば市","ひたちなか市","鹿嶋市","潮来市","守谷市","常陸大宮市","那珂市","筑西市","坂東市","稲敷市","かすみがうら市","桜川市","神栖市","行方市","鉾田市","つくばみらい市","小美玉市","その他");
cities[8] = new Array("宇都宮市","足利市","栃木市","佐野市","鹿沼市","日光市","小山市","真岡市","大田原市","矢板市","那須塩原市","さくら市","那須烏山市","下野市","その他");
cities[9] = new Array("前橋市","高崎市","桐生市","伊勢崎市","太田市","沼田市","館林市","渋川市","藤岡市","富岡市","安中市","みどり市","その他");
cities[10] = new Array("さいたま市","川越市","熊谷市","川口市","行田市","秩父市","所沢市","飯能市","加須市","本庄市","東松山市","春日部市","狭山市","羽生市","鴻巣市","深谷市","上尾市","草加市","越谷市","蕨市","戸田市","入間市","鳩ヶ谷市","朝霞市","志木市","和光市","新座市","桶川市","久喜市","北本市","八潮市","富士見市","三郷市","蓮田市","坂戸市","幸手市","鶴ヶ島市","日高市","吉川市","その他");
cities[11] = new Array("千葉市","銚子市","市川市","船橋市","館山市","木更津市","松戸市","野田市","茂原市","成田市","佐倉市","東金市","旭市","習志野市","柏市","勝浦市","市原市","流山市","八千代市","我孫子市","鴨川市","鎌ケ谷市","君津市","富津市","浦安市","四街道市","袖ケ浦市","八街市","印西市","白井市","富里市","南房総市","匝瑳市","香取市","山武市","いすみ市","その他");
cities[12] = new Array("千代田区","中央区","港区","新宿区","文京区","台東区","墨田区","江東区","品川区","目黒区","大田区","世田谷区","渋谷区","中野区","杉並区","豊島区","北区","荒川区","板橋区","練馬区","足立区","葛飾区","江戸川区","八王子市","立川市","武蔵野市","三鷹市","青梅市","府中市","昭島市","調布市","町田市","小金井市","小平市","日野市","東村山市","国分寺市","国立市","福生市","狛江市","東大和市","清瀬市","東久留米市","武蔵村山市","多摩市","稲城市","羽村市","あきる野市","西東京市","その他");
cities[13] = new Array("横浜市","川崎市","横須賀市","平塚市","鎌倉市","藤沢市","小田原市","茅ヶ崎市","逗子市","相模原市","三浦市","秦野市","厚木市","大和市","伊勢原市","海老名市","座間市","南足柄市","綾瀬市","その他");
cities[14] = new Array("新潟市","長岡市","三条市","柏崎市","新発田市","小千谷市","加茂市","十日町市","見附市","村上市","燕市","糸魚川市","妙高市","五泉市","上越市","阿賀野市","佐渡市","魚沼市","南魚沼市","胎内市","その他");
cities[15] = new Array("富山市","高岡市","魚津市","氷見市","滑川市","黒部市","砺波市","小矢部市","南砺市","射水市","その他");
cities[16] = new Array("金沢市","七尾市","小松市","輪島市","珠洲市","加賀市","羽咋市","かほく市","白山市","能美市","その他");
cities[17] = new Array("福井市","敦賀市","小浜市","大野市","勝山市","鯖江市","あわら市","越前市","坂井市","その他");
cities[18] = new Array("甲府市","富士吉田市","都留市","山梨市","大月市","韮崎市","南アルプス市","北杜市","甲斐市","笛吹市","上野原市","甲州市","中央市","その他");
cities[19] = new Array("長野市","松本市","上田市","岡谷市","飯田市","諏訪市","須坂市","小諸市","伊那市","駒ヶ根市","中野市","大町市","飯山市","茅野市","塩尻市","佐久市","千曲市","東御市","安曇野市","その他");
cities[20] = new Array("岐阜市","大垣市","高山市","多治見市","関市","中津川市","美濃市","瑞浪市","羽島市","恵那市","美濃加茂市","土岐市","各務原市","可児市","山県市","瑞穂市","飛騨市","本巣市","郡上市","下呂市","海津市","その他");
cities[21] = new Array("静岡市","浜松市","沼津市","熱海市","三島市","富士宮市","伊東市","島田市","富士市","磐田市","焼津市","掛川市","藤枝市","御殿場市","袋井市","下田市","裾野市","湖西市","伊豆市","御前崎市","菊川市","伊豆の国市","牧之原市","その他");
cities[22] = new Array("名古屋市","豊橋市","岡崎市","一宮市","瀬戸市","半田市","春日井市","豊川市","津島市","碧南市","刈谷市","豊田市","安城市","西尾市","蒲郡市","犬山市","常滑市","江南市","小牧市","稲沢市","新城市","東海市","大府市","知多市","知立市","尾張旭市","高浜市","岩倉市","豊明市","日進市","田原市","愛西市","清須市","北名古屋市","弥富市","その他");
cities[23] = new Array("津市","四日市市","伊勢市","松阪市","桑名市","鈴鹿市","名張市","尾鷲市","亀山市","鳥羽市","熊野市","いなべ市","志摩市","伊賀市","その他");
cities[24] = new Array("大津市","彦根市","長浜市","近江八幡市","草津市","守山市","栗東市","甲賀市","野洲市","湖南市","高島市","東近江市","米原市","その他");
cities[25] = new Array("京都市","福知山市","舞鶴市","綾部市","宇治市","宮津市","亀岡市","城陽市","向日市","長岡京市","八幡市","京田辺市","京丹後市","南丹市","木津川市","その他");
cities[26] = new Array("大阪市","堺市","岸和田市","豊中市","池田市","吹田市","泉大津市","高槻市","貝塚市","守口市","枚方市","茨木市","八尾市","泉佐野市","富田林市","寝屋川市","河内長野市","松原市","大東市","和泉市","箕面市","柏原市","羽曳野市","門真市","摂津市","高石市","藤井寺市","東大阪市","泉南市","四條畷市","交野市","大阪狭山市","阪南市","その他");
cities[27] = new Array("神戸市","姫路市","尼崎市","明石市","西宮市","洲本市","芦屋市","伊丹市","相生市","豊岡市","加古川市","赤穂市","西脇市","宝塚市","三木市","高砂市","川西市","小野市","三田市","加西市","篠山市","養父市","丹波市","南あわじ市","朝来市","淡路市","宍粟市","加東市","たつの市","その他");
cities[28] = new Array("奈良市","大和高田市","大和郡山市","天理市","橿原市","桜井市","五條市","御所市","生駒市","香芝市","葛城市","宇陀市","その他");
cities[29] = new Array("和歌山市","海南市","橋本市","有田市","御坊市","田辺市","新宮市","紀の川市","岩出市","その他");
cities[30] = new Array("鳥取市","米子市","倉吉市","境港市","その他");
cities[31] = new Array("松江市","浜田市","出雲市","益田市","大田市","安来市","江津市","雲南市","その他");
cities[32] = new Array("岡山市","倉敷市","津山市","玉野市","笠岡市","井原市","総社市","高梁市","新見市","備前市","瀬戸内市","赤磐市","真庭市","美作市","浅口市","その他");
cities[33] = new Array("広島市","呉市","竹原市","三原市","尾道市","福山市","府中市","三次市","庄原市","大竹市","東広島市","廿日市市","安芸高田市","江田島市","その他");
cities[34] = new Array("下関市","宇部市","山口市","萩市","防府市","下松市","岩国市","光市","長門市","柳井市","美祢市","周南市","その他");
cities[35] = new Array("徳島市","鳴門市","小松島市","阿南市","吉野川市","阿波市","美馬市","三好市","その他");
cities[36] = new Array("高松市","丸亀市","坂出市","善通寺市","観音寺市","さぬき市","東かがわ市","三豊市","その他");
cities[37] = new Array("松山市","今治市","宇和島市","八幡浜市","新居浜市","西条市","大洲市","伊予市","四国中央市","西予市","東温市","その他");
cities[38] = new Array("高知市","室戸市","安芸市","南国市","土佐市","須崎市","宿毛市","土佐清水市","四万十市","香南市","香美市","その他");
cities[39] = new Array("北九州市","福岡市","大牟田市","久留米市","直方市","飯塚市","田川市","柳川市","八女市","筑後市","大川市","行橋市","豊前市","中間市","小郡市","筑紫野市","春日市","大野城市","宗像市","太宰府市","前原市","古賀市","福津市","うきは市","宮若市","嘉麻市","朝倉市","みやま市","その他");
cities[40] = new Array("佐賀市","唐津市","鳥栖市","多久市","伊万里市","武雄市","鹿島市","小城市","嬉野市","神埼市","その他");
cities[41] = new Array("長崎市","佐世保市","島原市","諫早市","大村市","平戸市","松浦市","対馬市","壱岐市","五島市","西海市","雲仙市","南島原市","その他");
cities[42] = new Array("熊本市","八代市","人吉市","荒尾市","水俣市","玉名市","山鹿市","菊池市","宇土市","上天草市","宇城市","阿蘇市","天草市","合志市","その他");
cities[43] = new Array("大分市","別府市","中津市","日田市","佐伯市","臼杵市","津久見市","竹田市","豊後高田市","杵築市","宇佐市","豊後大野市","由布市","国東市","その他");
cities[44] = new Array("宮崎市","都城市","延岡市","日南市","小林市","日向市","串間市","西都市","えびの市","その他");
cities[45] = new Array("鹿児島市","鹿屋市","枕崎市","阿久根市","出水市","指宿市","西之表市","垂水市","薩摩川内市","日置市","曽於市","霧島市","いちき串木野市","南さつま市","志布志市","奄美市","南九州市","伊佐市","その他");
cities[46] = new Array("那覇市","宜野湾市","石垣市","浦添市","名護市","糸満市","沖縄市","豊見城市","うるま市","宮古島市","南城市","その他");
// -->
</SCRIPT>
</HEAD>
<BODY onLoad="changePref(false)">
<FORM NAME=formMain >
<SELECT NAME="pref" onChange="changePref(true)">
<OPTION VALUE="" SELECTED>(都道府県を選択してください)
<OPTION VALUE="0">北海道
<OPTION VALUE="1">青森県
<OPTION VALUE="2">岩手県
<OPTION VALUE="3">宮城県
<OPTION VALUE="4">秋田県
<OPTION VALUE="5">山形県
<OPTION VALUE="6">福島県
<OPTION VALUE="7">茨城県
<OPTION VALUE="8">栃木県
<OPTION VALUE="9">群馬県
<OPTION VALUE="10">埼玉県
<OPTION VALUE="11">千葉県
<OPTION VALUE="12">東京都
<OPTION VALUE="13">神奈川県
<OPTION VALUE="14">新潟県
<OPTION VALUE="15">富山県
<OPTION VALUE="16">石川県
<OPTION VALUE="17">福井県
<OPTION VALUE="18">山梨県
<OPTION VALUE="19">長野県
<OPTION VALUE="20">岐阜県
<OPTION VALUE="21">静岡県
<OPTION VALUE="22">愛知県
<OPTION VALUE="23">三重県
<OPTION VALUE="24">滋賀県
<OPTION VALUE="25">京都府
<OPTION VALUE="26">大阪府
<OPTION VALUE="27">兵庫県
<OPTION VALUE="28">奈良県
<OPTION VALUE="29">和歌山県
<OPTION VALUE="30">鳥取県
<OPTION VALUE="31">島根県
<OPTION VALUE="32">岡山県
<OPTION VALUE="33">広島県
<OPTION VALUE="34">山口県
<OPTION VALUE="35">徳島県
<OPTION VALUE="36">香川県
<OPTION VALUE="37">愛媛県
<OPTION VALUE="38">高知県
<OPTION VALUE="39">福岡県
<OPTION VALUE="40">佐賀県
<OPTION VALUE="41">長崎県
<OPTION VALUE="42">熊本県
<OPTION VALUE="43">大分県
<OPTION VALUE="44">宮崎県
<OPTION VALUE="45">鹿児島県
<OPTION VALUE="46">沖縄県
</SELECT>
<SELECT NAME="city">
<OPTION VALUE="" SELECTED>(市区町村を選択してください)
<OPTION VALUE="">
<OPTION VALUE="">
<OPTION VALUE="">
<OPTION VALUE="">
<OPTION VALUE="">
<OPTION VALUE="">
<OPTION VALUE="">
</SELECT>
</FORM>
</BODY>
</HTML>

2009年7月4日土曜日

雑誌に載りました

今月発売のメンズユカイ(Men's Yukai)の編集後記にのってます♪

専属SEってかいてあるやつです。

って言っても寝てるところとられんだてすけどね。ハワイいったときのやつです

2009年6月29日月曜日

google map携帯版がauで表示されない

ここみてgoogle map携帯版をつくっていたのだがauでみると表示されない。
調べた結果改行をすべてとって一行のタグにしたら表示されました。

<img src="http://maps.google.com/staticmap?center=XXXXXXX,XXXXXXX7& markers=XXXXXXX,XXXXXXX,red&zoom=18&size=250x2500&key=XXXXX">

こんな感じ

2009年6月24日水曜日

EC-CUBEでSQL Server(mssql)適応するときの変更点のメモ書き

・LIMIT→top書き換え
・now()→current_timstampに書き換え。ただし文字列'Now()'を受け取り、正規表現でnow関数を与えている箇所に注意
・join using→join onに書き換え
・BEGIN → BEGIN TRANSACTION
・エスケープを独自追加。たぶん\と'でよいと思われ。
ファイル名 data\class\util\SC_Utils.php#sfManualEscape

具体的なファイル名は時間があれば

2009年6月18日木曜日

SEOやってみるさ

うちのサイト
http://ii-s.biz
をフリーエンジニアで検索すると
ただいま25位。

ちなみにここで検索


まあまあかな?

まあちょっと裏技つかってるから・・

「ホームページ制作」では200位圏外。やっぱ激戦区だなぁ。。。


うちはまだSEOでお金とってない。まだノウハウが足りてないから。
でもまあ、SEOって本当はあまりよくないことかもしれないけど

2009年6月17日水曜日

javaとperl/phpの違和感

javaとperl/phpはかなり違うのは当たり前なんだが、
ちょこちょこ困るなと思うのはjavaは基本的に
ファイル入力(読み込み)では末端の改行を基本的に読み込まない。
※読み込み方にもよるけどFileInputStreamとか使った下記みたいなノーマルなやり方は含まない
String path = "C:/in_file";
File dir = new File(path);
File[] files = dir.listFiles();
for (int i = 0; i < files.length; i++) {
File file = files[i];
String fileName=file.getName();
FileInputStream fis = null;
InputStreamReader ir = null;
BufferedReader br = null;
//LineNumberReader lnr = null;
StringBuilder buf = new StringBuilder();
try{
fis = new FileInputStream(file);
ir = new InputStreamReader(fis , "utf-8");
br = new BufferedReader(ir);
String line;

//---1行ずつ表示
while((line = br.readLine()) != null){
buf.append(line+"\n");
}
}catch(IOException e){
e.printStackTrace();
}finally{
try{
//---ファイルを閉じる
// lnr.close();
}catch(Exception e){
}
}

これがperlやphpだと改行がだいたい含まれて状態になる。perlでいうrtrimとか作業が場合によっては必要。
これでよく混乱しちゃって困る。統一してほしいもんだ。

2009年6月15日月曜日

いいもの見つけた

このサイトの画像。
http://www.atmarkit.co.jp/fjava/rensai4/troublehacks06/troublehacks06_1.html



参考にさせてもらいます

2009年6月14日日曜日

fgetcsvにはまる

fgetcsvに感動したという日記を書いたのだが
どうも これ穴があったようだphp5だと日本語が適度に化ける

解決策をいろいろさぐってみたところ

http://yossy.iimp.jp/wp/?p=56じゃないとダメみたい。

このサイトの方には感謝!

2009年6月13日土曜日

とりあえずShift_jisは非推奨

Shift_jisはすぐ化ける。

五十嵐と入力するとphpでは五\十嵐
となる

五\十嵐でぐぐると・・・


結構有名サイト出てくるね。

一応php.iniを以下のようにすればなおるんだけど
magic_quotes_gpc = Off


これだとエスケープしてくれないから
SQLインジェクション対策とか自分で必要。
つまりセキュリティ的にあやういと。

結局Shift_jis使わないに限るんだけど
テキストエディタとかはデフォがShift_jisになってて
かなりやっかい。

認知活動が必要なのかな~

製品を作ってみたい

PHPをまじめに勉強しだして約半年。smartyの構築も経験したし
そろそろなんかパッケージにまとめてつくってみたい。

とりあえずファイルが添付できるフォームを無料で配布してみるかな。

2009年6月12日金曜日

fgetcsvに感動した

http://phpspot.net/php/man/php/function.fgetcsv.html

phpのfgetcsvってすごい。
こんなのしらなかった。普通にfopenとかつかってた。(笑い)

他の言語にもあるのかなーと思ってしらべた

●java
・CSVTokenizer & CSVLine
http://www.wakhok.ac.jp/~tomoharu/Java/csv/
こんなのがあるけど、標準ではない。
javaならあると思ってたけど
StringTokenizer を使うのが普通だけどデータの中に「,」があると使えない

●perl
・Text::CSV_XS、Text::CSV
http://blog.livedoor.jp/dankogai/archives/50765677.html

ほぅ。。。これはなかなか。使える。

●Ruby
http://www.ruby-lang.org/ja/man/html/CSV.html
まあ予想通りと

総評
Java以外は基本的にあるということで。
C系とかcobolとかは知らない。
たぶんないと思われ。








smartyでマ行で落ちる時の対応法(shift_jis対応)

●参考サイト

http://www.ninnin.net/blog/archives/000356.html

●共通系のところに下記関数追加

//--------------------------------
// Smarty SJIS対応用関数1
//--------------------------------
function convert_encoding_to_eucjp($template_source) {
if (function_exists("mb_convert_encoding")) {
//文字コードを変換する
return mb_convert_encoding($template_source, "EUC-JP", "SJIS");
}
return $template_source;
}

//--------------------------------
// Smarty SJIS対応用関数2
//--------------------------------
function convert_encoding_to_sjis($template_source) {
if (function_exists("mb_convert_encoding")) {
//文字コードを変換する
return mb_convert_encoding($template_source, "SJIS", "EUC-JP");
}
return $template_source;
}

●smartyオブジェクトをnewしたあとに以下を追加

$smarty->register_prefilter("convert_encoding_to_eucjp");
$smarty->register_postfilter("convert_encoding_to_sjis");