<h2>そもそもどういうサービス？</h3>
<p>githubはリポジトリ（プロジェクトの意味）を公開するためのwebサービスです。<br />
開発チームがgitを使って開発を行うために、必ずしもgithubに登録することがありません。<br />
あくまで公開（リリース）に向けてチーム（もちろん個人も）作業用のものになります。<br />
※公開したくないもの（private repo）でもgithubで管理できますが、有料になります。</p>
<p>今回は、自分の作品を公開するためのgithubを利用した手順を紹介したいと思います。</p>
<h2>githubに登録する前</h3>
<h3>gitがインストールされてるかを確認</h4>
<p>Macなら、ターミナルから </p>
<p></p>

		<div id="crayon-64953fd596976585381177" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
which git</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd596976585381177-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd596976585381177-1"><span class="crayon-e">which </span><span class="crayon-i">git</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<p>のコマンドを実行し確認できます。</p>
<h3>gitをインストール</h4>
<p>まだインストールしていない場合は、<a href="http://git-scm.com/" target="_blank">gitの公式サイト</a>からgitをダウンロードしてインストールすることができます。</p>
<h3>gitの初期設定</h4>
<p><a href="/programmer/git%E5%86%8D%E5%85%A5%E9%96%80.html" target="_blank">ここ</a>を参考してください。</p>
<h2>ユーザー登録</h3>
<p><a href="http://github.com" target="_blank">github</a>にアクセスして、ログインしていない状態なら、登録画面がでてくるので、フローに従って登録してください。</p>
<h2>SSH公開鍵登録</h3>
<p>githubにSSH公開鍵を登録しはじめて、SSHでgithubで管理するリポジトリを取得できるようになります。<br />
また作業を進み、ローカルのものをgithubにpushするため、やはりSSH公開鍵の登録が避けられません。</p>
<p>公開鍵の作成とアップロードは、<a href="https://help.github.com/articles/generating-ssh-keys" target="_blank">ここ</a>を参考してください。</p>
<h2>githubでリポジトリを作成</h3>
<p>公開するのはこのリポジトリになります。まずgithubの上で作成しなければなりません。</p>
<p>githubの画面（ログインしている状態で）の右上にから「+」のボタンをクリックして「New Repository」を選択し、容易に新しいリポジトリを作成できます。</p>
<h2>作成したリポジトリをローカルにcloneする</h3>
<p>実際にファイル追加・編集作業に使うのはローカルのリポジトリになります。<br />
cloneするのに、下記コマンドを実行すればいいと思います。</p>
<p></p>

		<div id="crayon-64953fd59697a502712875" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
git clone git@github.com:youraccount/the_new_repo.git</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd59697a502712875-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd59697a502712875-1"><span class="crayon-e">git </span><span class="crayon-r">clone</span><span class="crayon-h"> </span><span class="crayon-i">git</span><span class="crayon-sy">@</span><span class="crayon-i">github</span><span class="crayon-sy">.</span><span class="crayon-i">com</span><span class="crayon-sy">:</span><span class="crayon-i">youraccount</span>/<span class="crayon-i">the_new_repo</span><span class="crayon-sy">.</span><span class="crayon-i">git</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<h2>ローカルでの作業を進む</h3>
<p>ファイルを追加し、gitの管理上に置きます。（git add）<br />
ある程度作業が進んだら、ローカルでcommitします。（git commit）</p>
<p>gitのコマンドについて、<a href="/programmer/git%E5%86%8D%E5%85%A5%E9%96%80.html" target="_blank">ここ</a>を参考してください。</p>
<p>または、「git cheatsheet」で検索してみてください。</p>
<h2>githubに、ローカルの作業をpushする</h3>
<p>ローカルの作業をgithubにあげるため、 下記コマンドを実行します。</p>

		<div id="crayon-64953fd59697c718448901" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
git push origin current_branch</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd59697c718448901-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd59697c718448901-1"><span class="crayon-e">git </span><span class="crayon-e">push </span><span class="crayon-e">origin </span><span class="crayon-i">current_branch</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<p>※　masterブランチにのpushは、避けたほうが無難かと思います。<br />
※　pushが成功するなら、この時点でもうgithubで見えるようになります（正式なものではなく、あくまで別ブランチ）。</p>
<h2>githubでpull requestを実行</h3>
<p><a href="https://help.github.com/articles/using-pull-requests" target="_blank">pull request</a>は、リポジトリの管理者に、「自分のソースコードを確認して使ってください」というリクエストです。<br />
当たり前なことですが、このリクエストはgithubでしか行えません。<br />
新しいpushがあるとき、「pull request」のボタンが自動的に現れます。</p>
<h2>githubでブランチをmergeする</h3>
<p>自分が管理者なので、「pull request」があったらページに表示されます。<br />
ソースコードの差分が確認できたら、それを最新のバージョンとして取り込むことができます。<br />
「merge pull request」のボタンを押せば、「pull request」されてきたものが正式なもの（masterブランチ）になります。</p>
<h2>おまけ</h3>
<p>Macなら、「github for Mac」という公式アプリがあります。<br />
使い方は<a href="http://kuroigamen.com/48" target="_blank">ここ</a>を参考してください。</p>

【自分の作品を公開するため】github入門

<p>As I know, there are many ways to use Ubuntu(Linux) our laptop or PC.</p>
<p>Firstly, if your HDD(harddisk) is new or clean one and there are two or more partitions on it, you can use dual OSes with it: eg, Window OS and Linux one.  One OS is running at a time.   In each partition, each OS is hosted. When PC is started, Window Boot Manager shows OS selecting menu on very first page to choose a desired OS. We can&#8217;t switch to another OS when using a specific OS is running.</p>
<p>My prefer method to install Ubuntu(Linux) is installing via bootable Live USB. The steps are so easy to do so. Just go <a href="http://www.ubuntu.com/download/desktop">http://www.ubuntu.com/download/desktop</a> and get ubuntu OS&#8217;s &#8220;.iso&#8221; file. Then, by visiting to <a href="http://unetbootin.sourceforge.net/">http://unetbootin.sourceforge.net/</a> and get unetbootin software. Run unetbootin software on your laptop or PC. Then point out the desired USB (assumed that a USB(at least 4 GB capacity) is already assembled in PC, it should be formatted by FAT32, be aware that it&#8217;s with FAT32) and downloaded .iso file. After that, you will get a bootable USB to install Ubuntu OS.</p>
<p>Open the PC or laptop that you want to install Ubuntu(Linux). Already assumed that you changed boot sequence to &#8220;Removable Device&#8221; in BIOS setup. Then it will automatically loaded Ubuntu OS and will make installation automatically by just following on screen instructions. Then you can start using Ubuntu OS on the fly.</p>
<p>Next, you are a Window OS user. Let&#8217;s say that your HDD has only one partition and Window OS is already running on it. At that time, you want to start using Ubuntu(Linux) OS. OK fine, there is another alternative way for you. You can use &#8220;Wubi Ubuntu Window Installer&#8221; at <a href="http://www.ubuntu.com/download/desktop/install-ubuntu-with-windows">http://www.ubuntu.com/download/desktop/install-ubuntu-with-windows</a>.</p>
<p>Just run &#8220;wubi&#8221; to install Ubuntu. After following on screen instructions, you will find dual OS on start up screen when PC is opened. You can find your Ubuntu OS as a disk image file on hosted Window OS.</p>
<p>Another option is if you want to use parallel OSes, you should use Virtual Machine or Virtual Box(installed Ubuntu OS) on Window OS. Just be aware that your machine&#8217;s memory is parallel exhausted by parallel OSes at that same time.</p>
<p>That&#8217;s all. Enjoy!!!</p>
<p>&nbsp;</p>
<p>&nbsp;</p>


Using Ubuntu(Linux)

<p>csvファイルをアップロードして、中身のデータをデータベースに挿入する。</p>
<p>しかし、全部のデータを挿入するのではなくて、必要な項目だけを取ってデータベースに入れる。</p>
<p>まず、csvファイルをアップロードして、ある場所にファイルを保存する。</p>
<p>次はデータを配列に入れる。</p>
<p>配列に入っているデータからどこの項目をデータベースに入れるかを決めて、挿入する。</p>
<p>sprintf を利用して書きます。</p>
<p></p>

		<div id="crayon-64953fd5965b0732000193" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title">php</span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
$sql = sprintf("INSERT INTO testingcsv (test1,test2,test3) VALUES('%d','%s','%s');",$csv_array[0],$csv_array[1],$csv_array[2]);</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd5965b0732000193-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd5965b0732000193-1"><span class="crayon-sy">$</span><span class="crayon-i">sql</span><span class="crayon-h"> </span>=<span class="crayon-h"> </span><span class="crayon-e">sprintf</span><span class="crayon-sy">(</span><span class="crayon-s">"INSERT INTO testingcsv (test1,test2,test3) VALUES('%d','%s','%s');"</span><span class="crayon-sy">,</span><span class="crayon-sy">$</span><span class="crayon-i">csv_array</span><span class="crayon-sy">[</span><span class="crayon-cn">0</span><span class="crayon-sy">]</span><span class="crayon-sy">,</span><span class="crayon-sy">$</span><span class="crayon-i">csv_array</span><span class="crayon-sy">[</span><span class="crayon-cn">1</span><span class="crayon-sy">]</span><span class="crayon-sy">,</span><span class="crayon-sy">$</span><span class="crayon-i">csv_array</span><span class="crayon-sy">[</span><span class="crayon-cn">2</span><span class="crayon-sy">]</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<p>sprintf の形式は</p>
<p></p>

		<div id="crayon-64953fd5965b4406158772" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
int sprintf ( string $format [, mixed $args [, mixed $... ]] )</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd5965b4406158772-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd5965b4406158772-1"><span class="crayon-t">int</span><span class="crayon-h"> </span><span class="crayon-e">sprintf</span><span class="crayon-h"> </span><span class="crayon-sy">(</span><span class="crayon-h"> </span><span class="crayon-t">string</span><span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-i">format</span><span class="crayon-h"> </span><span class="crayon-sy">[</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-i">mixed</span><span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-i">args</span><span class="crayon-h"> </span><span class="crayon-sy">[</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-i">mixed</span><span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-sy">.</span><span class="crayon-sy">.</span><span class="crayon-sy">.</span><span class="crayon-h"> </span><span class="crayon-sy">]</span><span class="crayon-sy">]</span><span class="crayon-h"> </span><span class="crayon-sy">)</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<p>型指定子として指定できる値をまとめました。</p>
<table>
<tr>
<td>b</td>
<td>引数を整数として扱い、バイナリの数値として表現します。</td>
</tr>
<tr>
<td>c</td>
<td>引数を整数として扱い、その ASCII 値の文字として表現します。</td>
</tr>
<tr>
<td>d</td>
<td>引数を整数として扱い、 10 進数として表現します。</td>
</tr>
<tr>
<td>e</td>
<td>引数を科学記法として扱います (例 1.2e+2)。精度の指定子は、PHP 5.2.1<br />
                     以降では小数点以下の桁数を表します。</td>
</tr>
<tr>
<td>u</td>
<td>引数を整数として扱い、符号無しの 10 進数として表現します。</td>
</tr>
<tr>
<td>f</td>
<td>引数を double として扱い、浮動小数点数として表現します。</td>
</tr>
<tr>
<td>F</td>
<td>引数を float として扱い、浮動小数点数として表現します。</td>
</tr>
<tr>
<td>o</td>
<td>引数を整数として扱い、 8 進数として表現します。</td>
</tr>
<tr>
<td>s</td>
<td>引数を文字列として扱い、表現します。</td>
</tr>
<tr>
<td>x</td>
<td>引数を整数として扱い、16 進数として(小文字で)表現します。</td>
</tr>
<tr>
<td>X</td>
<td>引数を整数として扱い、16 進数として(大文字で)表現します。</td>
</tr>
</table>
<p>例えば：以下のように書きます。</p>
<p></p>

		<div id="crayon-64953fd5965b6015315011" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
%d
%s
%x</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd5965b6015315011-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd5965b6015315011-2">2</div><div class="crayon-num" data-line="crayon-64953fd5965b6015315011-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd5965b6015315011-4">4</div><div class="crayon-num" data-line="crayon-64953fd5965b6015315011-5">5</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd5965b6015315011-1"><span class="crayon-ta">%</span><span class="crayon-i">d</span></div><div class="crayon-line crayon-striped-line" id="crayon-64953fd5965b6015315011-2">&nbsp;</div><div class="crayon-line" id="crayon-64953fd5965b6015315011-3"><span class="crayon-ta">%</span><span class="crayon-i">s</span></div><div class="crayon-line crayon-striped-line" id="crayon-64953fd5965b6015315011-4">&nbsp;</div><div class="crayon-line" id="crayon-64953fd5965b6015315011-5"><span class="crayon-sy">%</span><span class="crayon-i">x</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>

csvアップロードとsprintf

<p>There are many services(api) provided by<strong> Amazon Web Services (AWS).</strong></p>
<ul>
<li>Amazon Elastic Compute Cloud (Amazon EC2)</li>
<li>Amazon Simple Notification Service (SNS)</li>
<li>Amazon Simple Queue Service (SQS)</li>
<li>Amazon CloudFront</li>
<li>Amazon Simple Storage Service (S3)</li>
<li>Amazon CloudSearch</li>
<li>Amazon Simple Workflow Service (SWF)</li>
<li>Product Advertising API etc ..</li>
</ul>
<p>Among them, if we would like to extract <em>product information</em> that hosted on amazon databases, we could use</p>
<p><strong>Product Advertising API (API Version 2011-08-01) [formerly called ECS].</strong></p>
<p><strong>Developer Guide:</strong></p>
<p><em><a href="http://docs.aws.amazon.com/AWSECommerceService/latest/DG/Welcome.html">http://docs.aws.amazon.com/AWSECommerceService/latest/DG/Welcome.html</a></em></p>
<p><strong>Getting Started Guide:</strong></p>
<p><em><a href="http://docs.aws.amazon.com/AWSECommerceService/latest/GSG/Welcome.html">http://docs.aws.amazon.com/AWSECommerceService/latest/GSG/Welcome.html</a></em></p>
<p><strong>Testing and Debugging:</strong></p>
<p><em>http://associates-amazon.s3.amazonaws.com/scratchpad/index.html</em></p>
<p><em>http://associates-amazon.s3.amazonaws.com/signed-requests/helper/index.html</em></p>
<p>To make an api request to amazon, we need to get respective <em>access key</em>, <em>secret key</em> and <em>associate tag or associate ID</em>. How to get those keys and tag is stated on the following link:</p>
<p><em>http://docs.aws.amazon.com/AWSECommerceService/2011-08-01/GSG/GettingSetUp.html</em></p>
<p>The briefly procedure is as follow: we firstly need to create (1)an amazon aws account(.co.jp). With that account, we have to create (2)Associate Tag(Japan end with -22, eg; asdf-22). After that, on Associate Tage admin page, we will find (3)&#8221;Product Advertising API&#8221; tag and we can create product advertising api account(.co.jp) from that tag. If we have created product advertising api account, we will get amazon access key and secret key.</p>
<p>When we create aws account,  Associate Tag and product advertising account, those works <em><span style="text-decoration: underline;">only in the locale in which you register</span></em>. There are many locale provided by amazon: <code>de, com, co.uk, ca, fr, co.jp, it, cn, es</code></p>
<p>For each locale, there is a respective database. If we choose co.jp locale, our api request will go to amazon&#8217;s jp database instead of .com database and then get required data from it.</p>
<p>After we have got all keys and tag, we could make an api request to amazon web services with request type: REST or SOAP.</p>
<p><strong>Request type:</strong></p>
<p>REST and SOAP</p>
<p><strong>Response format:</strong></p>
<p>XML</p>
<p>The following operations are available in the Product Advertising API.</p>
<ul>
<li>BrowseNodeLookup</li>
<li>CartAdd</li>
<li>CartClear</li>
<li>CartCreate</li>
<li>CartGet</li>
<li>CartModify</li>
<li>ItemLookup</li>
<li>ItemSearch</li>
<li>SimilarityLookup</li>
</ul>
<p>When we make an api request to amazon, the response will include huge amount of data. So if we would like to narrow response data scope according to our specific requirement, we could customize &#8220;<em>Response Groups</em>&#8221; on api request.</p>
<p><em>http://docs.aws.amazon.com/AWSECommerceService/2011-08-01/DG/CHAP_ResponseGroupsList.html</em></p>
<p>In each Response Groups, we could choose desired &#8220;Response Elements&#8221; again according to our need.</p>
<p><em>http://docs.aws.amazon.com/AWSECommerceService/2011-08-01/DG/RG_ItemAttributes.html</em></p>
<p>After preparing all of the requirements stated above, we will get actual api request to amazon:</p>
<p><strong>Sample API request:</strong></p>
<p><em>http://webservices.amazon.co.jp/onca/xml?</em></p>
<p><em>AWSAccessKeyId=ACCESSKEYHERE</em></p>
<p><em>&amp;AssociateTag=ASSOCIATETAGHERE</em></p>
<p><em>&amp;Condition=All</em></p>
<p><em>&amp;Keywords=1449319793 (ISBN)</em></p>
<p><em>&amp;Operation=ItemSearch</em></p>
<p><em>&amp;ResponseGroup=Images%2CItemAttributes%2COffers</em></p>
<p><em>&amp;SearchIndex=Books</em></p>
<p><em>&amp;Service=AWSECommerceService</em></p>
<p><em>&amp;Timestamp=2013-12-17T02%3A35%3A47.000Z</em></p>
<p><em>&amp;Version=2011-08-01</em></p>
<p><em>&amp;Signature=SIGNATUREHERE</em></p>
<p>If you properly setup the api request link and put it in browser&#8217;s address bar, you will get amazon&#8217;s response with XML format.</p>
<p>Enjoy!!!</p>


How to use AWS for searching products&#8217; info from amazon databases

【Mac】eclipse 4.3 + PDT + symfonyプラグインをインストールしました

<p>urlの最後のidを取得して、スライドショーを始める位置を指定する方法を紹介します。</p>
<p>今回はスライドショーに「bxslider」を利用しています。</p>
<p>一覧ページと詳細ページのつながりの内容</p>
<p>①　商品一覧ページがあります。<br />
②　詳細ページは商品一つ一つのページごとにスライドしてあります。<br />
③　詳細ページにいく場合、一覧ページからクリックされた商品の詳細を表示する<br />
④　また、スライドは通常通り動く。</p>
<p>上記のような流れで実装したい！</p>
<p>今回初めて使ったのは「location.hash」です。</p>
<p>「location.hash」は一覧ページからidで指定した値を取得します。</p>
<p>一覧ページからクリックした場合のurlは</p>
<p></p>

		<div id="crayon-64953fd59569b522526158" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
index.html#product01　　// #からの文字を取得します。</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd59569b522526158-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd59569b522526158-1"><span class="crayon-i">index</span><span class="crayon-sy">.</span><span class="crayon-i">html</span><span class="crayon-p">#product01　　// #からの文字を取得します。</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<p></p>

		<div id="crayon-64953fd59569f605822285" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
if (location.hash){
		id = location.hash.replace("#product0","");  //最後の数字を取得しています。

			$('#slider1').bxSlider({
				 	startSlide: id - 1,　//zero based
					infiniteLoop: true,
//  infiniteLoopをtrueにしてループ表示を有効化します。
  				});
	}else{
		$('#slider1').bxSlider();
	}</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd59569f605822285-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd59569f605822285-2">2</div><div class="crayon-num" data-line="crayon-64953fd59569f605822285-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd59569f605822285-4">4</div><div class="crayon-num" data-line="crayon-64953fd59569f605822285-5">5</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd59569f605822285-6">6</div><div class="crayon-num" data-line="crayon-64953fd59569f605822285-7">7</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd59569f605822285-8">8</div><div class="crayon-num" data-line="crayon-64953fd59569f605822285-9">9</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd59569f605822285-10">10</div><div class="crayon-num" data-line="crayon-64953fd59569f605822285-11">11</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd59569f605822285-1"><span class="crayon-st">if</span><span class="crayon-h"> </span><span class="crayon-sy">(</span><span class="crayon-i">location</span><span class="crayon-sy">.</span><span class="crayon-i">hash</span><span class="crayon-sy">)</span><span class="crayon-sy">{</span></div><div class="crayon-line crayon-striped-line" id="crayon-64953fd59569f605822285-2"><span class="crayon-h">		</span><span class="crayon-i">id</span><span class="crayon-h"> </span>=<span class="crayon-h"> </span><span class="crayon-i">location</span><span class="crayon-sy">.</span><span class="crayon-i">hash</span><span class="crayon-sy">.</span><span class="crayon-e">replace</span><span class="crayon-sy">(</span><span class="crayon-s">"#product0"</span><span class="crayon-sy">,</span><span class="crayon-s">""</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span><span class="crayon-h">&nbsp;&nbsp;</span><span class="crayon-c">//最後の数字を取得しています。</span></div><div class="crayon-line" id="crayon-64953fd59569f605822285-3">&nbsp;</div><div class="crayon-line crayon-striped-line" id="crayon-64953fd59569f605822285-4"><span class="crayon-h">			</span><span class="crayon-sy">$</span><span class="crayon-sy">(</span><span class="crayon-s">'#slider1'</span><span class="crayon-sy">)</span><span class="crayon-sy">.</span><span class="crayon-e">bxSlider</span><span class="crayon-sy">(</span><span class="crayon-sy">{</span></div><div class="crayon-line" id="crayon-64953fd59569f605822285-5"><span class="crayon-h">				 	</span><span class="crayon-i">startSlide</span><span class="crayon-sy">:</span><span class="crayon-h"> </span><span class="crayon-i">id</span><span class="crayon-h"> </span>-<span class="crayon-h"> </span><span class="crayon-cn">1</span><span class="crayon-sy">,</span>　<span class="crayon-c">//zero based</span></div><div class="crayon-line crayon-striped-line" id="crayon-64953fd59569f605822285-6"><span class="crayon-h">					</span><span class="crayon-i">infiniteLoop</span><span class="crayon-sy">:</span><span class="crayon-h"> </span><span class="crayon-t">true</span><span class="crayon-sy">,</span></div><div class="crayon-line" id="crayon-64953fd59569f605822285-7"><span class="crayon-c">//&nbsp;&nbsp;infiniteLoopをtrueにしてループ表示を有効化します。</span></div><div class="crayon-line crayon-striped-line" id="crayon-64953fd59569f605822285-8"><span class="crayon-h">&nbsp;&nbsp;				</span><span class="crayon-sy">}</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div><div class="crayon-line" id="crayon-64953fd59569f605822285-9"><span class="crayon-h">	</span><span class="crayon-sy">}</span><span class="crayon-st">else</span><span class="crayon-sy">{</span></div><div class="crayon-line crayon-striped-line" id="crayon-64953fd59569f605822285-10"><span class="crayon-h">		</span><span class="crayon-sy">$</span><span class="crayon-sy">(</span><span class="crayon-s">'#slider1'</span><span class="crayon-sy">)</span><span class="crayon-sy">.</span><span class="crayon-e">bxSlider</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div><div class="crayon-line" id="crayon-64953fd59569f605822285-11"><span class="crayon-h">	</span><span class="crayon-sy">}</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>

URLを取得してスライドショーの位置を調整する

<p>今回はxargsコマンドによる一括操作を紹介したいと思います。</p>
<h3>あるフォルダ下のファイルを検索し、特定文字列があるところを出力</h4>
<p></p>

		<div id="crayon-64953fd5954ba106189722" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
find /path/to/files -type f -print | xargs grep "search_string"</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd5954ba106189722-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd5954ba106189722-1"><span class="crayon-i">find</span><span class="crayon-h"> </span>/<span class="crayon-i">path</span>/<span class="crayon-st">to</span>/<span class="crayon-i">files</span><span class="crayon-h"> </span>-<span class="crayon-i">type</span><span class="crayon-h"> </span><span class="crayon-i">f</span><span class="crayon-h"> </span>-<span class="crayon-i">print</span><span class="crayon-h"> </span><span class="crayon-sy">|</span><span class="crayon-h"> </span><span class="crayon-e">xargs </span><span class="crayon-i">grep</span><span class="crayon-h"> </span><span class="crayon-s">"search_string"</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<h3>あるフォルダ下のファイルを検索し、特定文字列を置換</h4>
<p></p>

		<div id="crayon-64953fd5954be030239999" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
find /path/to/files -name "*.sh" -print | xargs sed -i 's@string_before_replace@string_after_replace@g'</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd5954be030239999-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd5954be030239999-1"><span class="crayon-i">find</span><span class="crayon-h"> </span>/<span class="crayon-i">path</span>/<span class="crayon-st">to</span>/<span class="crayon-i">files</span><span class="crayon-h"> </span>-<span class="crayon-i">name</span><span class="crayon-h"> </span><span class="crayon-s">"*.sh"</span><span class="crayon-h"> </span>-<span class="crayon-i">print</span><span class="crayon-h"> </span><span class="crayon-sy">|</span><span class="crayon-h"> </span><span class="crayon-e">xargs </span><span class="crayon-i">sed</span><span class="crayon-h"> </span>-<span class="crayon-i">i</span><span class="crayon-h"> </span><span class="crayon-s">'s@string_before_replace@string_after_replace@g'</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p>※置換操作の前に、ファイルのバックアップを取ったほうがより安全でオススメです。</p>
<h3>あるフォルダ下のファイルを検索し、子フォルダだけ権限変更</h4>
<p></p>

		<div id="crayon-64953fd5954c0642220699" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
find /path/to/files -type d -print0 | xargs -0 chmod 777</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd5954c0642220699-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd5954c0642220699-1"><span class="crayon-i">find</span><span class="crayon-h"> </span>/<span class="crayon-i">path</span>/<span class="crayon-st">to</span>/<span class="crayon-i">files</span><span class="crayon-h"> </span>-<span class="crayon-i">type</span><span class="crayon-h"> </span><span class="crayon-i">d</span><span class="crayon-h"> </span>-<span class="crayon-i">print0</span><span class="crayon-h"> </span><span class="crayon-sy">|</span><span class="crayon-h"> </span><span class="crayon-i">xargs</span><span class="crayon-h"> </span>-<span class="crayon-cn">0</span><span class="crayon-h"> </span><span class="crayon-i">chmod</span><span class="crayon-h"> </span><span class="crayon-cn">777</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<p>※findコマンドもある程度一括操作ができるようです。</p>

【Linux】知って便利な一括操作コマンド

<p>Let&#8217;s start a new blog post. Today I would like to introduce a book,</p>
<p>of course, if you’re an entrepreneur, designer, programmer, or marketer working on a big idea and want to build</p>
<p style="padding-left: 30px;"><em><strong>A successful web application</strong></em></p>
<p style="padding-left: 30px;"><em><strong>with the smarter, faster, easier ways</strong></em><em><strong><br />
</strong></em></p>
<p>Here&#8217;s we go: <strong>Getting Real</strong> (http://gettingreal.37signals.com/)</p>
<p>This book is created by <strong>37signals </strong>that produces awesome software products and one open source web application framework(<strong><em>Ruby on Rails</em></strong>).</p>
<p>Book Outlines:</p>
<p style="padding-left: 30px;">1) Introduction</p>
<p style="padding-left: 60px;"><em>&#8211; Getting Real is actually building the real things what customers need and eliminates anything they don’t. </em></p>
<p style="padding-left: 60px;"><em>&#8211; You don’t need tons of money or a huge team or a lengthy development cycle to build great software.</em></p>
<p style="padding-left: 30px;"><em></em>2) The Starting Line</p>
<p style="padding-left: 60px;"><em>&#8211; Build Less : </em>Underdo your competition</p>
<p style="padding-left: 60px;"><em>&#8211; What’s Your Problem? : </em>Build software for yourself</p>
<p style="padding-left: 60px;"><em>&#8211; Fund Yourself : </em>Outside money is plan B</p>
<p style="padding-left: 60px;"><em>&#8211; Fix Time and Budget, Flex Scope : </em>Launch on time and on budget</p>
<p style="padding-left: 60px;"><em>&#8211; Have an Enemy : </em>Pick a fight</p>
<p style="padding-left: 60px;"><em>&#8211; It Shouldn&#8217;t be a Chore: </em>The less your app is a chore to build, the better it will be. Keep it small and manageable so you can actually enjoy the process.</p>
<p style="padding-left: 30px;">3) Stay Lean</p>
<p style="padding-left: 30px;">4) Priorities</p>
<p style="padding-left: 30px;">5) Feature Selection</p>
<p style="padding-left: 30px;">6) Process</p>
<p style="padding-left: 30px;">7) The Organization</p>
<p style="padding-left: 30px;">8) Staffing</p>
<p style="padding-left: 30px;">9) Interface Design</p>
<p style="padding-left: 30px;">10) Code</p>
<p style="padding-left: 30px;">11) Words</p>
<p style="padding-left: 30px;">12) Pricing and Signup</p>
<p style="padding-left: 30px;">13) Promotion</p>
<p style="padding-left: 30px;">14) Support</p>
<p style="padding-left: 30px;">15) Post-Launch</p>
<p style="padding-left: 30px;">16) Conclusion</p>
<p>I just introduced just top two chapters and if you would like to dig more, for completed reference, I attach English PDF version of this book. Please take a look and dig the content as much as you can.</p>
<p><a href="/uploads-archive/2013/12/Getting-Real-ebook-by-37signals.pdf">Getting Real [ebook by 37signals]</a></p>
<p>Enjoy!</p>


Getting Real for startups

Ajax でデータ送信、受信

<p>There is a bit differences between Symfony 2.0.x and latest Symfony versions.</p>
<p>For symfony 2.o.x, firstly download the zip file from http://symfony.com/download(Legacy Release/Pick a specific version)</p>
<p>File and folder structure in symfony 2.0.x ,</p>
<p>Symfony</p>
<p style="padding-left: 30px;">&#8211; app</p>
<p style="padding-left: 30px;">&#8211; bin</p>
<p style="padding-left: 30px;">&#8211; deps</p>
<p style="padding-left: 30px;">&#8211; deps.lock</p>
<p style="padding-left: 30px;">&#8211; src</p>
<p style="padding-left: 30px;">&#8211; web</p>
<p>There is no &#8220;vendor&#8221; folder after archiving symfony 2.o.x.</p>
<p>To create &#8220;vendor&#8221; folder including all required third-party bundles: assetic, bundles, doctrine, monolog, symfony, twig etc</p>
<p>Please open Terminal(command line):</p>
<p><strong>$ cd /var/www/html/Symfony/</strong></p>
<p>* please be sure to add <strong>https</strong> to all links in &#8220;<strong>deps</strong>&#8221; file.</p>
<p>example:</p>
<p>[original data in deps]</p>
<p style="padding-left: 30px;">[symfony]</p>
<p style="padding-left: 30px;">    git=http://github.com/symfony/symfony.git</p>
<p style="padding-left: 30px;">    version=v2.0.1</p>
<p>[edited]</p>
<p style="padding-left: 30px;">[symfony]</p>
<p style="padding-left: 30px;">    git=http<span style="text-decoration: underline;"><strong>s</strong></span>://github.com/symfony/symfony.git</p>
<p style="padding-left: 30px;">    version=v2.0.1</p>
<p>Then if it&#8217;s firstly installation symfony, type:</p>
<p><strong>$ php bin/vendors install</strong></p>
<p>bin/vendors will firstly look &#8220;deps&#8221; files and will automatically create &#8220;vendor&#8221; folder under /var/www/html/Symfony/</p>
<p>Or if you want to add new bundle or update existing ones:</p>
<p><strong>$ php bin/vendors update</strong></p>
<p>If you want to know, which symfony version did you install?</p>
<p><strong>$ php app/console &#8211;version</strong></p>
<p>If you want to know, how to use &#8220;php app/console&#8221; command,</p>
<p><strong>$ php app/console &#8211;help</strong></p>
<p style="text-align: center;">##############################</p>
<p>In Symfony latest version (2.3 or 2.4):</p>
<p>We can install symfony via terminal easily.</p>
<p>Please install composer:(on Linux disto)</p>
<p><strong>$ curl -sS https://getcomposer.org/installer | php </strong>(assumed that you&#8217;ve already installed &#8220;curl&#8221; command)</p>
<p><strong>$ mv composer.phar /usr/local/bin/composer</strong></p>
<p>If so, you&#8217;ve already installed &#8220;composer&#8221; in your computer and can use &#8220;composer&#8221; command in Terminal.</p>
<p><strong>$ cd /var/www/html/</strong></p>

		<div id="crayon-64953fd594a80493195022" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
$ composer create-project symfony/framework-standard-edition path/ 2.3.7</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd594a80493195022-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd594a80493195022-1"><span class="crayon-sy">$</span><span class="crayon-h"> </span><span class="crayon-e">composer </span><span class="crayon-i">create</span>-<span class="crayon-e">project </span><span class="crayon-i">symfony</span>/<span class="crayon-i">framework</span>-<span class="crayon-i">standard</span>-<span class="crayon-e">edition </span><span class="crayon-i">path</span>/<span class="crayon-h"> </span><span class="crayon-cn">2.3.7</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p>Then composer will install symfony 2.3.7 (as above command) to /var/www/html/Symfony</p>
<p>Folder and file structure in symfony 2.3.7:</p>
<p style="padding-left: 30px;">&#8211; app</p>
<p style="padding-left: 30px;">&#8211; bin</p>
<p style="padding-left: 30px;">&#8211; composer.json</p>
<p style="padding-left: 30px;">&#8211; composer.lock</p>
<p style="padding-left: 30px;">&#8211; src</p>
<p style="padding-left: 30px;">&#8211; vendor</p>
<p style="padding-left: 30px;">&#8211; web</p>
<p><strong>$ cd Symfony</strong></p>
<p><strong>$ composer install</strong></p>
<p>composer command will firstly look &#8220;composer.json&#8221; and automatically install required bundles.</p>
<p>If you want to add new bundle or update existing one,</p>
<p><strong>$ composer update</strong></p>
<p>If you want to know, which symfony version did you install?</p>
<p><strong>$ php app/console &#8211;version</strong></p>
<p>The End!</p>

Differences between Symfony 2.0.x and latest Symfony versions installation

git再入門

<p>My first experience in installation symfony 2 on Mac made me crazy. I had experienced installing it on Ubuntu Linux and it worked fine. I used to setup web development on Ubuntu Linux and mobile development on Mac.</p>
<p>In Mac, for web development, I used MAMP (<strong>Macintosh, Apache, Mysql and PHP</strong>) instead of using built-in PHP and Apache Web server. I know that its time saving but it can&#8217;t make a complete and perfect development environment. But setting up built-in web server and using PHP take time to completely setup. So I was lazy to set it up.</p>
<p>In previous days, I need to install symfony 2 on my Mac. I thought installing a PHP framework is piece of cake for me. Because I&#8217;ve many experience since earlier. But, when I try to install symfony, I can&#8217;t get perfect installation. Installation stages reported back many errors. I was googling again and again to solve it. Finally, I found that Symfony 2 uses</p>
<ul>
<li>Alternative PHP Cache (APC) 3.1.13</li>
</ul>
<p>But in MAMP package, it can offer &#8220;Alternative PHP Cache (APC) 3.1.9&#8221; only. I can&#8217;t upgrade MAMP version anymore. If I will continue want to use current MAMP version, I can only downgrade symfony version, it may be version 1 of Symfony.</p>
<p>So, finally, I completely gave up using MAMP package and start setting up all required tools for web development in my local laptop. It took about half day to fully setting up it manually, but its the most suitable development for a developer.</p>
<p>Yes, of course, we developer guys like to setup our own web development environment by ourselves instead of using the ready-made already setting up working environment.</p>
<p>Ok, this is just my first experience when I try to install symfony 2 with MAMP.</p>
<p>Thank for reading at the end.</p>
<p>&nbsp;</p>
<p>&nbsp;</p>


Symfony 2 installation problem with MAMP

【CentOS6】phpmyadminをインストールしてみた

<p>hoverの場合、画像の明るさを調整したいので、いつものようにcssを書きました。<br />
　　　</p>

		<div id="crayon-64953fd593fa8909326414" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
opacity:0.6;</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd593fa8909326414-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd593fa8909326414-1"><span class="crayon-i">opacity</span><span class="crayon-sy">:</span><span class="crayon-cn">0.6</span><span class="crayon-sy">;</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<p>今回はIE8、FF、Safariを対応しないといけないので、</p>
<p>それぞれのブラウザを対応するcssを追加して、確認したところIE8ではうまくいかなかった。</p>
<p></p>

		<div id="crayon-64953fd593fac682675553" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
filter: alpha(opacity=60);        /* ie lt 8 */
-ms-filter: "alpha(opacity=60)";  /* ie 8 */
-moz-opacity:0.6;                 /* FF lt 1.5, Netscape */
-khtml-opacity: 0.6;              /* Safari 1.x */</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd593fac682675553-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd593fac682675553-2">2</div><div class="crayon-num" data-line="crayon-64953fd593fac682675553-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd593fac682675553-4">4</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd593fac682675553-1"><span class="crayon-i">filter</span><span class="crayon-sy">:</span><span class="crayon-h"> </span><span class="crayon-e">alpha</span><span class="crayon-sy">(</span><span class="crayon-i">opacity</span>=<span class="crayon-cn">60</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-c">/* ie lt 8 */</span></div><div class="crayon-line crayon-striped-line" id="crayon-64953fd593fac682675553-2">-<span class="crayon-i">ms</span>-<span class="crayon-i">filter</span><span class="crayon-sy">:</span><span class="crayon-h"> </span><span class="crayon-s">"alpha(opacity=60)"</span><span class="crayon-sy">;</span><span class="crayon-h">&nbsp;&nbsp;</span><span class="crayon-c">/* ie 8 */</span></div><div class="crayon-line" id="crayon-64953fd593fac682675553-3">-<span class="crayon-i">moz</span>-<span class="crayon-i">opacity</span><span class="crayon-sy">:</span><span class="crayon-cn">0.6</span><span class="crayon-sy">;</span><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span class="crayon-c">/* FF lt 1.5, Netscape */</span></div><div class="crayon-line crayon-striped-line" id="crayon-64953fd593fac682675553-4">-<span class="crayon-i">khtml</span>-<span class="crayon-i">opacity</span><span class="crayon-sy">:</span><span class="crayon-h"> </span><span class="crayon-cn">0.6</span><span class="crayon-sy">;</span><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-c">/* Safari 1.x */</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<p>対策方法を検索した結果を</p>

		<div id="crayon-64953fd593fad858977391" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
zoom:1;</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd593fad858977391-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd593fad858977391-1"><span class="crayon-i">zoom</span><span class="crayon-sy">:</span><span class="crayon-cn">1</span><span class="crayon-sy">;</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p>を追加したら、早速うまくいったので、<br />
安心して、本番にアップしたら、本番環境ではうまくいっていない！</p>
<p>cssのパスが違っているか何度も確認しても、テスト環境との違いが見つからない！</p>
<p>それで、cssを変えようとして、また検索したところ、<br />
場合によって、「a」タグの幅と「display: block;」を指定しないといけないみたいです。</p>
<p>試してみたら本番環境もうまくいくようになりました。</p>
<p>cssも同じブラウザでも環境によって、動作がちがうって初めての体験でした。</p>

IE8対応 画像 opacity

<p>１つのデータベースに、それぞれが異なる情報を持つ複数のテーブルを保持し、<br />
それぞれのテーブルに同じフィールドがあれば、それを利用してテーブル結合してデータを取得する事が出来ます。</p>
<p>今回はサンプルでcustomersテーブルとshopテーブルを利用して説明します。</p>
<p>先に以下の内容でテーブルを作りました。</p>
<h2>customersテーブル</h3>
<table>
<tr>
<th>id</th>
<th>name</th>
<th>address</th>
<th>products</th>
</tr>
<tr>
<td> 1 </td>
<td> poe </td>
<td>  shinjyuku </td>
<td> iphone5 </td>
</tr>
<tr>
<td> 2 </td>
<td> su  </td>
<td>  shinagawa </td>
<td> iphone3  </td>
</tr>
<tr>
<td> 3 </td>
<td> hnin </td>
<td> ikebukuro </td>
<td> iphone5  </td>
</tr>
<tr>
<td> 4 </td>
<td> ei </td>
<td> ikebukuro </td>
<td> iphone5  </td>
</tr>
</table>
<h2>shopテーブル</h3>
<table>
<tr>
<th>id</th>
<th>products</th>
<th>price</th>
<th>code</th>
</tr>
<tr>
<td> 1 </td>
<td> iphone </td>
<td>  30000 </td>
<td> IP01 </td>
</tr>
<tr>
<td> 2 </td>
<td> iphone4  </td>
<td>  40000 </td>
<td> IP02  </td>
</tr>
<tr>
<td> 3 </td>
<td> iphone4S </td>
<td> 42000 </td>
<td> IP03  </td>
</tr>
<tr>
<td> 4 </td>
<td> iphone5 </td>
<td> 50000 </td>
<td> IP04  </td>
</tr>
</table>
<p>customersテーブのproductsというフィールドとshopテーブルのproductsフィールドを一致して、<br />
現在販売されている商品とお客さんの情報を取得できます。</p>
<p>以下のようなmysql文で取得できます。</p>
<p></p>

		<div id="crayon-64953fd593847096081621" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
SELECT * from customers,shop WHERE customers.products = shop.products;</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd593847096081621-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd593847096081621-1"><span class="crayon-e ">SELECT *</span><span class="crayon-h"> </span><span class="crayon-e">from </span><span class="crayon-i">customers</span><span class="crayon-sy">,</span><span class="crayon-e">shop </span><span class="crayon-e">WHERE </span><span class="crayon-i">customers</span><span class="crayon-sy">.</span><span class="crayon-i">products</span><span class="crayon-h"> </span>=<span class="crayon-h"> </span><span class="crayon-i">shop</span><span class="crayon-sy">.</span><span class="crayon-i">products</span><span class="crayon-sy">;</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<p>結果の表示です。</p>
<table>
<tr>
<th>id</th>
<th>name</th>
<th>address</th>
<th>products</th>
<th>id</th>
<th>products</th>
<th>price</th>
<th>code</th>
</tr>
<tr>
<td>2 </td>
<td> su   </td>
<td> shinagawa </td>
<td> iphone4  </td>
<td>  2 </td>
<td> iphone4  </td>
<td> 40000 </td>
<td> IP02 </td>
</tr>
<tr>
<td>1 </td>
<td> poe  </td>
<td> shinjyuku </td>
<td> iphone5  </td>
<td>  4 </td>
<td> iphone5  </td>
<td> 50000 </td>
<td> IP04 </td>
</tr>
<tr>
<td>3 </td>
<td> hnin </td>
<td> ikebukuro </td>
<td> iphone5  </td>
<td>  4 </td>
<td> iphone5  </td>
<td> 50000 </td>
<td> IP04 </td>
</tr>
<tr>
<td>4 </td>
<td> ei </td>
<td> ikebukuro </td>
<td> iphone5  </td>
<td>  4 </td>
<td> iphone5  </td>
<td> 50000 </td>
<td> IP04 </td>
</tr>
</table>
<h2>NATURAL JOIN</h3>
<p>-NATURAL JOINは2つのテーブルを取り、同じ名前を持つ列を<br />
自動的に結合させます。<br />
サンプル :</p>

		<div id="crayon-64953fd59384c240439438" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
SELECT * FROM customers NATURAL JOIN shop;</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd59384c240439438-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd59384c240439438-1"><span class="crayon-e ">SELECT *</span><span class="crayon-h"> </span><span class="crayon-e">FROM </span><span class="crayon-e">customers </span><span class="crayon-e">NATURAL </span><span class="crayon-e">JOIN </span><span class="crayon-i">shop</span><span class="crayon-sy">;</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p>結果表示：</p>
<table>
<tr>
<th>id</th>
<th>products</th>
<th>name</th>
<th>address</th>
<th>price</th>
<th>code</th>
</tr>
<tr>
<td>2</td>
<td>iphone4</td>
<td>su</td>
<td>shinagawa</td>
<td>40000</td>
<td>IP02</td>
</tr>
<tr>
<td>4</td>
<td>iphone5</td>
<td>ei</td>
<td>ikebukuro</td>
<td>50000</td>
<td>IP04</td>
</tr>
</table>
<p>上記の場合、テーブルの両方に存在するカラムは「id」と「products」カラムだけですので「id」と「products」カラムを使って結合が行われます。</p>
<h2>JOIN…..ON</h3>
<p>2つのテーブルの結合させる列を指定したい場合には、JOIN…..ON構造を次のように使用します。<br />
サンプル：</p>
<p></p>

		<div id="crayon-64953fd59384d248140877" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
SELECT * FROM customers JOIN shop ON customers.products = shop.products;</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd59384d248140877-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd59384d248140877-1"><span class="crayon-e ">SELECT *</span><span class="crayon-h"> </span><span class="crayon-e">FROM </span><span class="crayon-e">customers </span><span class="crayon-e">JOIN </span><span class="crayon-e">shop </span><span class="crayon-e">ON </span><span class="crayon-i">customers</span><span class="crayon-sy">.</span><span class="crayon-i">products</span><span class="crayon-h"> </span>=<span class="crayon-h"> </span><span class="crayon-i">shop</span><span class="crayon-sy">.</span><span class="crayon-i">products</span><span class="crayon-sy">;</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<p>※結果は「SELECT * from customers,shop WHERE customers.products = shop.products;」と同じです。</p>
<h2>ASの使用</h3>
<p>ASキーワードを利用して、入力にかかる手数を減らしクエリを読みやすくする事も出来ます。<br />
サンンプル：</p>

		<div id="crayon-64953fd59384e693006288" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
SELECT * from customers AS cust, shop AS sp WHERE cust.products = sp.products;</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd59384e693006288-1">1</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd59384e693006288-1"><span class="crayon-e ">SELECT *</span><span class="crayon-h"> </span><span class="crayon-e">from </span><span class="crayon-e">customers </span><span class="crayon-st">AS</span><span class="crayon-h"> </span><span class="crayon-i">cust</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-e">shop </span><span class="crayon-st">AS</span><span class="crayon-h"> </span><span class="crayon-e">sp </span><span class="crayon-e">WHERE </span><span class="crayon-i">cust</span><span class="crayon-sy">.</span><span class="crayon-i">products</span><span class="crayon-h"> </span>=<span class="crayon-h"> </span><span class="crayon-i">sp</span><span class="crayon-sy">.</span><span class="crayon-i">products</span><span class="crayon-sy">;</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p>※結果は「SELECT * from customers,shop WHERE customers.products = shop.products;」と同じです。</p>

テーブル結合

<p>急な案件で、facebookとtwitterのAPI仕様の再確認になりました。</p>
<h2>facebook</h3>
<h3>sharer.php</h4>
<p>軽くソーシャルボタンで対応したいから、sharer.phpの仕様を調べてみたことろ、<br />
<a href="https://developers.facebook.com/docs/opengraph/howtos/maximizing-distribution-media-content/" target="_blank">OGPの仕様追加</a>によって、サイトの「og:image」設定ではなく、個別の画像をソーシャルボタンで投稿することができなってしまいました。<br />
よって、今回も<a href="https://developers.facebook.com/docs/graph-api/" target="_blank">graph API</a>で対応することにしました。</p>
<h3>graph API</h4>
<p>こちらはあまり一年前と変わってないみたで、わりと簡単にできました。</p>
<h2>twitter</h3>
<h3>REST API</h4>
<p>1.0から1.1にアップデータしてから、ほぼ変化がないみたいです。<br />
oauth2が出て、<a href="https://dev.twitter.com/docs/auth/application-only-auth" target="_blank">application-only authentication</a>（bearer token）が新しく出てきたぐらいです。</p>
<h3>流れ</h4>
<p>忘れがちですが、<br />
request_tokenを取得してから、access_tokenを取得するのは基本です。</p>
<h3>ライブラリ</h4>
<p>以前は、<a href="https://github.com/abraham/twitteroauth" target="_blank">twitteroauth</a>を使ってきました。<br />
特に挫折なくできてましたが、<br />
今回は前方の都合で、<a href="https://github.com/themattharris/tmhOAuth" target="_blank">tmhOAuth</a>を使いました。<br />
直感使い方が違くて、twitteroauthのような便利のものではないようです。</p>


【API】facebookとtwitterのAPI再確認

MATCH Against In Boolean Mode

<p>今日はMySQLの外部参照について話したいと思います。<br />
慣れないキーワードがちょっと出てきますが、安心してください。<br />
MySQLの外部参照はこれだけで覚えます。</p>
<h2>キーワード</h3>
<p>CONSTRAINT<br />
REFERENCES<br />
RESTRICT<br />
NO ACTION<br />
CASCADE<br />
SET NULL</p>
<h2>基本用法</h3>
<p></p>

		<div id="crayon-64953fd593043722562159" class="crayon-syntax crayon-theme-monokai crayon-font-monaco crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover wrap" style=" margin-top: 12px; margin-bottom: 12px; font-size: 13px !important; line-height: 18px !important;">
		
			<div class="crayon-toolbar" data-settings=" mouseover overlay hide delay" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><span class="crayon-title"></span>
			<div class="crayon-tools" style="font-size: 13px !important;height: 19.5px !important; line-height: 19.5px !important;"><div class="crayon-button crayon-nums-button" title="Toggle Line Numbers"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-plain-button" title="Toggle Plain Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-expand-button" title="Expand Code"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-copy-button" title="Copy"><div class="crayon-button-icon"></div></div><div class="crayon-button crayon-popup-button" title="Open Code In New Window"><div class="crayon-button-icon"></div></div></div></div>
			<div class="crayon-info" style="min-height: 19.5px !important; line-height: 19.5px !important;"></div>
			<div class="crayon-plain-wrap"><textarea  class="crayon-plain print-no" data-settings="dblclick" readonly style="-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 13px !important; line-height: 18px !important;">
CREATE TABLE 子テーブル名(子カラム名 データ型,
  CONSTRAINT キー名 FOREIGN KEY (子カラム名)
  REFERENCES 親テーブル名(親カラム名)
  ON DELETE reference_option
  ON UPDATE reference_option
) ENGINE=InnoDB;</textarea></div>
			<div class="crayon-main" style="">
				<table class="crayon-table">
					<tr class="crayon-row">
				<td class="crayon-nums " data-settings="show">
					<div class="crayon-nums-content" style="font-size: 13px !important; line-height: 18px !important;"><div class="crayon-num" data-line="crayon-64953fd593043722562159-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd593043722562159-2">2</div><div class="crayon-num" data-line="crayon-64953fd593043722562159-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd593043722562159-4">4</div><div class="crayon-num" data-line="crayon-64953fd593043722562159-5">5</div><div class="crayon-num crayon-striped-num" data-line="crayon-64953fd593043722562159-6">6</div></div>
				</td>
						<td class="crayon-code"><div class="crayon-pre" style="font-size: 13px !important; line-height: 18px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;"><div class="crayon-line" id="crayon-64953fd593043722562159-1"><span class="crayon-e">CREATE </span><span class="crayon-i">TABLE</span><span class="crayon-h"> </span>子テーブル名<span class="crayon-sy">(</span>子カラム名<span class="crayon-h"> </span>データ型<span class="crayon-sy">,</span></div><div class="crayon-line crayon-striped-line" id="crayon-64953fd593043722562159-2"><span class="crayon-h">&nbsp;&nbsp;</span><span class="crayon-i">CONSTRAINT</span><span class="crayon-h"> </span>キー名<span class="crayon-h"> </span><span class="crayon-e">FOREIGN </span><span class="crayon-e">KEY</span><span class="crayon-h"> </span><span class="crayon-sy">(</span>子カラム名<span class="crayon-sy">)</span></div><div class="crayon-line" id="crayon-64953fd593043722562159-3"><span class="crayon-h">&nbsp;&nbsp;</span><span class="crayon-i">REFERENCES</span><span class="crayon-h"> </span>親テーブル名<span class="crayon-sy">(</span>親カラム名<span class="crayon-sy">)</span></div><div class="crayon-line crayon-striped-line" id="crayon-64953fd593043722562159-4"><span class="crayon-h">&nbsp;&nbsp;</span><span class="crayon-e">ON </span><span class="crayon-e">DELETE </span><span class="crayon-e">reference_option</span></div><div class="crayon-line" id="crayon-64953fd593043722562159-5"><span class="crayon-e">&nbsp;&nbsp;</span><span class="crayon-e">ON </span><span class="crayon-e">UPDATE </span><span class="crayon-i">reference_option</span></div><div class="crayon-line crayon-striped-line" id="crayon-64953fd593043722562159-6"><span class="crayon-sy">)</span><span class="crayon-h"> </span><span class="crayon-i">ENGINE</span>=<span class="crayon-i">InnoDB</span><span class="crayon-sy">;</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<h2>reference_option</h3>
<h3>RESTRICT</h4>
<p>ON DELETE句やON UPDATE句にRESTRICTを指定した場合は、親テーブルに対して更新や削除を行うとエラーが発生します。RESTRICTはON DELETE句やON UPDATE句を明示的に指定しなかった場合に設定される値です。</p>
<h3>NO ACTION</h4>
<p>ON DELETE句やON UPDATE句にNO ACTIONを指定した場合は、親テーブルに対して更新や削除を行うとエラーが発生します。MySQLにおいてはNO ACTIONとRESTRICTは同じ挙動となります。</p>
<h3>CASCADE</h4>
<p>ON DELETE句やON UPDATE句にCASCADEを指定した場合は、親テーブルに対して更新を行うと子テーブルで同じ値を持つカラムの値も合わせて更新されます。また親テーブルに対して削除を行うと子テーブルで同じ値を持つデータが削除されます。</p>
<h3>SET NULL</h4>
<p>ON DELETE句やON UPDATE句にSET NULLを指定した場合は、親テーブルに対して更新を行うと子テーブルで同じ値を持つカラムの値がNULLに更新されます。また親テーブルに対して削除を行うと子テーブルで同じ値を持つデータのカラムの値がNULLに更新されます。</p>
<h2>参考リンク</h3>
<p><a href="http://dev.mysql.com/doc/refman/5.1/ja/innodb-foreign-key-constraints.html" target="_blank">http://dev.mysql.com/doc/refman/5.1/ja/innodb-foreign-key-constraints.html</a><br />
<a href="http://www.dbonline.jp/mysql/table/index12.html" target="_blank">http://www.dbonline.jp/mysql/table/index12.html</a></p>

Company

Our Solutions

Support

News

Blog

Blogブログ

カテゴリーから探す

年別から見る

記事一覧 - タグ: #プログラマー

2014/01/08

2014/01/08

2014/01/07

2013/12/17

2013/12/12

2013/12/11

2013/12/10

2013/12/10

2013/12/04

2013/12/04

2013/12/03

2013/11/27

2013/11/27

2013/11/26

2013/11/21

2013/11/19

2013/11/13

2013/11/12