<h2>Bootstrap用の星型レーティング実装</h2>
<p>商品のレビューに使えそうです。<br />
<a href="http://plugins.krajee.com/star-rating/demo" target="_blank">Demo</a> <a href="https://github.com/kartik-v/bootstrap-star-rating" target="_blank">Download</a></p>
<h2>好きなサイズの画像サムネイルが生成できる「jQThumb」</h2>
<p>画像の切り出しができそうです。<br />
<a href="http://pakcheong.github.io/jqthumb/" target="_blank">Demo &#038; Download</a></p>
<h2>カスタマイズ性の高いタグ入力用フィールド実装用軽量JS「tagEditor」</h2>
<p>何となくカッコいい！と思いました。ただし、サーバー側の連携を工夫しなかれば実用するのが難しいです。<br />
<a href="http://goodies.pixabay.com/jquery/tag-editor/demo.html" target="_blank">Demo &#038; Download</a></p>
<h2>フルスクリーンで縦横無尽に広がるページを構築できる「fullContent.js」</h2>
<p>これだけでまともなサイトが作れそうです。<br />
<a href="http://www.zehfernandes.com/jquery.fullContent/#home" target="_blank">Demo &#038; Download</a></p>


最近見つかった便利なjQueryプラグイン

<p>今年の「Linux Journal Awards」が発表されたので、興味のあるものだけを転載されていただきます。<br />
英語は、わかりやすいものをそのまま、難しいのものを注釈されていただきます。<br />
知らないものがいっぱい出てきて刺激です。<br />
元リンクは<a href="http://www.linuxjournal.com/rc2014" target="_blank">ここ</a>です。</p>
<h2>Best Linux Distribution</h2>
<ol>
<li>Ubuntu 16.5%</li>
<li>Debian 16.4%</li>
<li>Linux Mint 11%</li>
<li>Arch Linux 8.5%</li>
<li>Fedora 8.3%</li>
<li>CentOS 6%</li>
<li>openSUSE 5.3%</li>
<li>Kubuntu 4.1%</li>
<li>Gentoo 2.9%</li>
<li>Slackware 2.7%</li>
<li>Xubuntu 2.5%</li>
<li>Other 2.3%</li>
<li>Red Hat Enterprise Linux 1.6%</li>
<li>NixOS 1.4%</li>
<li>elementary OS 1.3%</li>
<li>Lubuntu 1.2%</li>
<li>CrunchBang 1%</li>
<li>Mageia .7%</li>
<li>LXLE .4%</li>
<li>Tails .4%</li>
<li>Android-x86 .3%</li>
<li>Bodhi Linux .3%</li>
<li>Chakra .3%</li>
<li>Kali Linux .3%</li>
<li>PCLinuxOS .3%</li>
<li>SolydK .3%</li>
<li>Mandriva .1%</li>
<li>Oracle Linux .1%</li>
</ol>
<h2>Best Mobile Linux OS</h2>
<ol>
<li>Stock Android 37.1%</li>
<li>Sailfish OS 27.6%</li>
<li>CyanogenMod 20.2%</li>
<li>Other 3%</li>
<li>Ubuntu Phone 3%</li>
<li>Amazon Fire OS 1.5%</li>
<li>Ubuntu for Android 1.4%</li>
<li>Replicant .8%</li>
<li>Tizen .8%</li>
</ol>
<h2>Best Linux Tablet</h2>
<ol>
<li>Google Nexus 7 35.3%</li>
<li>Google Nexus 10 14.8%</li>
<li>Samsung Galaxy Tab 14%</li>
<li>Samsung Galaxy Note 9.8%</li>
<li>ASUS Transformer Pad 8.4%</li>
<li>Other 6.4%</li>
<li>Kindle Fire HD 4.7%</li>
<li>ASUS MeMO Pad 2%</li>
<li>Dell Venue 1.6%</li>
<li>Acer Iconia One 1.4%</li>
<li>Samsung Galaxy Note Edge .9%</li>
<li>Ekoore Python S3 .7%</li>
</ol>
<h2>Best Other Linux-Based Gadget (スマホとタブレット以外の装置)</h2>
<ol>
<li>Raspberry Pi 71.4%</li>
<li>BeagleBone Black 8.1%</li>
<li>Other 4.3%</li>
<li>Lego Mindstorms Ev3 3.7%</li>
<li>Moto 360 3.4%</li>
<li>Cubieboard 1.7%</li>
<li>Parrot A.R Drone 1.7%</li>
<li>Samsung Gear S 1.4%</li>
<li>Yamaha Motif XF8 1.1%</li>
<li>Nvidia Jetson-K1 Development System .8%</li>
<li>Cloudsto EVO Ubuntu Linux Mini PC .5%</li>
<li>VoCore Open Hardware Computer .5%</li>
<li>LG G Watch .4%</li>
<li>RaZberry .4%</li>
<li>VolksPC .4%</li>
<li>IFC6410 Pico-ITX Board .2%</li>
<li>JetBox 5300 .1%</li>
</ol>
<h2>Best Content Management System</h2>
<ol>
<li>WordPress 34.7%</li>
<li>Drupal 25.3%</li>
<li>Joomla! 11.1%</li>
<li>MediaWiki 10.5%</li>
<li>Other 10%</li>
<li>Alfresco 4.3%</li>
<li>WebGUI 1.3%</li>
<li>ikiwiki 1.1%</li>
<li>eZ publish .7%</li>
<li>Wolf CMS .4%</li>
<li>Elgg .3%</li>
<li>Blosxom .2%</li>
</ol>
<h2>Best Web Browser</h2>
<ol>
<li>Firefox 53.8%</li>
<li>Chrome 26.9%</li>
<li>Chromium 8.1%</li>
<li>Iceweasel 4%</li>
<li>Opera 3%</li>
<li>Other 2%</li>
<li>SeaMonkey .8%</li>
<li>rekonq .5%</li>
<li>dwb .4%</li>
<li>QupZill .4%</li>
<li>Dillo .2%</li>
</ol>
<h2>Best Cloud-Based File Storage</h2>
<ol>
<li>Dropbox 30.5%</li>
<li>ownCloud 23.6%</li>
<li>Google Drive 16%</li>
<li>rsync 8.3%</li>
<li>Other 7.5%</li>
<li>Amazon S3 6.6%</li>
<li>SpiderOak 4.4%</li>
<li>Box 1.8%</li>
<li>Copy 1%</li>
<li>AjaXplorer .3%</li>
</ol>
<h2>Best Virtualization Solution</h2>
<ol>
<li>Oracle VM VirtualBox 33.4%</li>
<li>VMware 22.3%</li>
<li>KVM 21.1%</li>
<li>XEN 5.7%</li>
<li>QEMU 5.3%</li>
<li>OpenStack 4.9%</li>
<li>Other 4.2%</li>
<li>OpenVZ 1.7%</li>
<li>Linux-VServer 1.3%</li>
<li>Symantec Workspace Virtualization .1%</li>
</ol>
<h2>Best Monitoring Application（システム監視）</h2>
<ol>
<li>Nagios 27.1%</li>
<li>Wireshark 20.7%</li>
<li>htop 12.3%</li>
<li>Zabbix 10.5%</li>
<li>Other 8.6%</li>
<li>Zenoss 6.2%</li>
<li>Munin 3.4%</li>
<li>PC Monitor 2.8%</li>
<li>New Relic 1.9%</li>
<li>Opsview 1.2%</li>
<li>SaltStack 1%</li>
<li>NTM (Network Traffic Monitor) .7%</li>
<li>xosview .7%</li>
<li>Manage Engine .5%</li>
<li>FlowViewer .3%</li>
<li>Circonus .2%</li>
<li>SysPeek .2%</li>
</ol>
<h2>Best DevOps Configuration Management Tool※</h2>
<ol>
<li> Git 39.4%</li>
<li>Puppet 17.2%</li>
<li>Ansible 8.9%</li>
<li>cron jobs 8.8%</li>
<li>Subversion 7.6%</li>
<li>Chef 5%</li>
<li>SaltStack 5.4%</li>
<li>Other 4.6%</li>
<li>CFEngine 3%</li>
</ol>
<h2>Best Programming Language</h2>
<ol>
<li>Python 30.2%</li>
<li>C++ 17.8%</li>
<li>C 16.7%</li>
<li>Perl 7.1%</li>
<li>Java 6.9%</li>
<li>Other 4.6%</li>
<li>Ruby 4.3%</li>
<li>Go 2.4%</li>
<li>JavaScript 2.4%</li>
<li>QML 2.2%</li>
<li>Fortran 1.4%</li>
<li>Haskell 1.4%</li>
<li>Lisp 1.2%</li>
<li>Erlang .6%</li>
<li>Rust .6%</li>
<li>D .4%</li>
<li>Hack .1%</li>
</ol>
<h2>Best Scripting Language</h2>
<ol>
<li>Python 37.1%</li>
<li>Bash/Shell scripts 27%</li>
<li>Perl 11.8%</li>
<li>PHP 8.4%</li>
<li>JavaScript 6.7%</li>
<li>Ruby 4.9%</li>
<li>Other 2.1%</li>
<li>Lua 2%</li>
</ol>
<h2>Best New Linux/Open-Source Product/Project</h2>
<ol>
<li>Docker 28%</li>
<li>Jolla and Sailfish OS 19%</li>
<li>LibreOffice 7%</li>
<li>ownCloud 5%</li>
<li>Steam 5%</li>
<li>Zenoss Control Center 5%</li>
<li>Raspberry Pi 4%</li>
<li>Git 4%</li>
<li>Apache Cordova/OpenOffice/Spark/Tika 3%</li>
<li>Ansible 2%</li>
<li>Elementary OS 2%</li>
<li>OpenStack 2%</li>
<li>Zabbix 2%</li>
<li>CoreOS 2%</li>
<li>Firefox OS 2%</li>
<li>KDE Connect 1%</li>
<li>NixOS and NixOps 1%</li>
<li>Open Media Vault 1%</li>
</ol>
<p>※開発と操作合わせてDevOpsといいます。</p>


2014 Linux Journal Awards

Twigの基本

【PHP】可変長引数リスト

centosメールサーバー構築（postfix + dovecot + Cyrus SASL）

<p>ここはオンラインリソースだけ紹介します。</p>
<h2>Computer Science入門</h2>
<p><a href="https://www.google.com/url?q=https%3A%2F%2Fwww.udacity.com%2Fcourse%2Fcs101&amp;sa=D&amp;sntz=1&amp;usg=AFQjCNGdmrWTUY5b_qe3xle9-ddkB1YXqA" target="_blank">Udacity &#8211; intro to CS course</a><br />
<a href="https://www.google.com/url?q=https%3A%2F%2Fwww.coursera.org%2Fcourse%2Fcs101&amp;sa=D&amp;sntz=1&amp;usg=AFQjCNE-mScGCD0MJRKuWuFyLJbIr4XdbA" target="_blank">Coursera &#8211; Computer Science 101</a></p>
<h2>少なくとも１個のオブジェクト指向言語を使ってコーディングする &#8211; C++、JavaもしくはPython</h2>
<h3>初心者コース</h3>
<p><a href="https://www.google.com/url?q=https%3A%2F%2Fwww.coursera.org%2Fcourse%2Fprogramming1&amp;sa=D&amp;sntz=1&amp;usg=AFQjCNERrKn8RoMF2C-tzZ_51XpGA2QzUQ" target="_blank">Coursera &#8211; Learn to Program: The Fundamentals</a><br />
<a href="http://www.google.com/url?q=http%3A%2F%2Focw.mit.edu%2Fcourses%2Felectrical-engineering-and-computer-science%2F6-092-introduction-to-programming-in-java-january-iap-2010%2Findex.htm&amp;sa=D&amp;sntz=1&amp;usg=AFQjCNHfuFmBicr4_Zh4dtfmk_mYq0BtNQ" target="_blank">MIT Intro to Programming in Java</a><br />
<a href="https://developers.google.com/edu/python/" target="_blank">Google&#8217;s Python Class</a><br />
<a href="https://www.coursera.org/course/interactivepython" target="_blank">Coursera &#8211; Introduction to Python</a><br />
<a href="http://www.openbookproject.net/thinkcs/python/english2e/" target="_blank">Python Open Source E-Book</a></p>
<h3>中級者コース</h3>
<p><a href="https://www.udacity.com/course/cs212" target="_blank">Udacity&#8217;s Design of Computer Programs</a><br />
<a href="https://www.coursera.org/course/programming2" target="_blank">Coursera &#8211; Learn to Program: Crafting Quality Code</a><br />
<a href="https://www.coursera.org/course/proglang" target="_blank">Coursera &#8211; Programming Languages</a><br />
<a href="http://cs.brown.edu/courses/cs173/2012/OnLine/" target="_blank">Brown University &#8211; Introduction to Programming Languages</a></p>
<h2>他のプログラミング言語を勉強する</h2>
<p>例えば、Java Script、CSS、HTML、Ruby、PHP、C、Perl、Shell、Lisp、Scheme。<br />
<a href="http://www.w3schools.com/" target="_blank">w3school.com &#8211; HTML Tutorial</a><br />
<a href="http://www.codecademy.com/learn" target="_blank">CodeAcademy.com</a></p>
<h2>コードをテストする</h2>
<p><a href="https://www.udacity.com/course/cs258" target="_blank">Udacity &#8211; Software Testing Methods</a><br />
<a href="https://www.udacity.com/course/cs259" target="_blank">Udacity &#8211; Software Debugging</a></p>
<h2>ロジック推理と離散数学を勉強する</h2>
<p><a href="http://www.google.com/url?q=http%3A%2F%2Focw.mit.edu%2Fcourses%2Felectrical-engineering-and-computer-science%2F6-042j-mathematics-for-computer-science-fall-2010%2Findex.htm&amp;sa=D&amp;sntz=1&amp;usg=AFQjCNEXtF_m9Lj7XMQZFy8Y92633L2EcQ" target="_blank"> MIT Mathematics for Computer Science</a></p>
<h2>データ構造とアルゴリズムを勉強する</h2>
<p><a href="http://www.google.com/url?q=http%3A%2F%2Focw.mit.edu%2Fcourses%2Felectrical-engineering-and-computer-science%2F6-006-introduction-to-algorithms-spring-2008%2Findex.htm&amp;sa=D&amp;sntz=1&amp;usg=AFQjCNEIwTJvLQcPGJL2hPxLibPRvjhbbg" target="_blank">MIT Introduction to Algorithms</a></p>
<h2>オペレーティングシステムについて勉強する</h2>
<p><a href="http://www.youtube.com/watch?v=XgQo4JkN4Bw&amp;list=PL3289DD0D0F0CD4A3" target="_blank">UC Berkeley Computer Science 162</a></p>
<h2>人工知能</h2>
<p><a href="http://see.stanford.edu/see/courseinfo.aspx?coll=86cc8662-f6e4-43c3-a1be-b30d1d179743" target="_blank">Introduction to Robotics</a><br />
<a href="http://see.stanford.edu/see/courseinfo.aspx?coll=63480b48-8819-4efd-8412-263f1a472f5a" target="_blank">Natural Language Processing</a><br />
<a href="http://see.stanford.edu/see/courseinfo.aspx?coll=348ca38a-3a6d-4052-937d-cb017338d7b1" target="_blank">Machine Learning</a></p>
<h2>コンパイラ構築</h2>
<p><a href="https://www.coursera.org/course/compilers" target="_blank">Coursera &#8211; Compilers</a></p>
<h2>暗号化</h2>
<p><a href="https://www.coursera.org/course/crypto" target="_blank">Coursera &#8211; Cryptography</a><br />
<a href="https://www.udacity.com/course/cs387" target="_blank">Udacity &#8211; Applied Cryptography</a></p>
<h2>Parallel Programming</h2>
<p><a href="https://www.coursera.org/course/hetero" target="_blank">Coursera &#8211; Heterogeneous Parallel Programming</a></p>
<h2>元リンク</h2>
<p><a href="http://www.google.com/edu/tools-and-solutions/guide-for-technical-development/index.html" target="_blank">元リンク</a></p>


googleが技術開発のガイドを出しました

<p>サブクエリを使って条件を抽出していきます。</p>
<h2>サブクエリとは</h2>
<p>SQL文の中にSELECT文を埋め込み、抽出条件として利用することを可能としています。<br />
SELECT文の中に、SELECT文が入る「入れ子」になります。<br />
サブクエリは()で囲って使用します。</p>

		<div id="crayon-649540157feed601029454" 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 列名1, 列名2, ...
FROM テーブル名
WHERE 列名 = ( 
    SELECT 
    列名 
    FROM 
    テーブル名 
    [WHERE 条件式など]
)</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-649540157feed601029454-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157feed601029454-2">2</div><div class="crayon-num" data-line="crayon-649540157feed601029454-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157feed601029454-4">4</div><div class="crayon-num" data-line="crayon-649540157feed601029454-5">5</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157feed601029454-6">6</div><div class="crayon-num" data-line="crayon-649540157feed601029454-7">7</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157feed601029454-8">8</div><div class="crayon-num" data-line="crayon-649540157feed601029454-9">9</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-649540157feed601029454-1"><span class="crayon-i">SELECT</span><span class="crayon-h"> </span>列名<span class="crayon-cn">1</span><span class="crayon-sy">,</span><span class="crayon-h"> </span>列名<span class="crayon-cn">2</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-sy">.</span><span class="crayon-sy">.</span><span class="crayon-sy">.</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157feed601029454-2"><span class="crayon-i">FROM</span><span class="crayon-h"> </span>テーブル名</div><div class="crayon-line" id="crayon-649540157feed601029454-3"><span class="crayon-i">WHERE</span><span class="crayon-h"> </span>列名<span class="crayon-h"> </span>=<span class="crayon-h"> </span><span class="crayon-sy">(</span><span class="crayon-h"> </span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157feed601029454-4"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-i">SELECT</span><span class="crayon-h"> </span></div><div class="crayon-line" id="crayon-649540157feed601029454-5"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span>列名<span class="crayon-h"> </span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157feed601029454-6"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-i">FROM</span><span class="crayon-h"> </span></div><div class="crayon-line" id="crayon-649540157feed601029454-7"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span>テーブル名<span class="crayon-h"> </span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157feed601029454-8"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">[</span><span class="crayon-i">WHERE</span><span class="crayon-h"> </span>条件式など<span class="crayon-sy">]</span></div><div class="crayon-line" id="crayon-649540157feed601029454-9"><span class="crayon-sy">)</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p>WHERE以下の（）で示した部分がサブクエリです．実行の際にはまずサブクエリが解決され，値が抽出されます．次にメインのクエリが解決され，サブクエリから返された値と等しい値を持つレコードが選択されます．上記ではサブクエリとメインのクエリを「=」で結んでいますが，そのほかにも以下の演算子が使用できます．</p>
<table>
<tbody>
<tr>
<th>比較演算子</th>
<th>説明</th>
</tr>
<tr>
<td class="code">=</td>
<td>等しい</td>
</tr>
<tr>
<td class="code">&lt;</td>
<td>小さい</td>
</tr>
<tr>
<td class="code">&gt;</td>
<td>大きい</td>
</tr>
<tr>
<td class="code">&lt;=</td>
<td>以下</td>
</tr>
<tr>
<td class="code">&gt;=</td>
<td>以上</td>
</tr>
<tr>
<td class="code">&lt;&gt;, !=</td>
<td>等しくない</td>
</tr>
</tbody>
</table>
<h2>サブクエリを使用したSQLサンプル</h2>
<p>以下のデータを使用してサブクエリを使って行います。</p>
<table border="1" cellspacing="0" cellpadding="4">
<caption>User</caption>
<tbody>
<tr>
<th>UserID</th>
<th>Name</th>
</tr>
<tr>
<td>1</td>
<td>嶋田</td>
</tr>
<tr>
<td>2</td>
<td>山城</td>
</tr>
<tr>
<td>3</td>
<td>後藤</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<table border="1" cellspacing="0" cellpadding="4">
<caption>Order</caption>
<tbody>
<tr>
<th>OrderID</th>
<th>OrderItem</th>
<th>OrderUserID</th>
</tr>
<tr>
<td>1</td>
<td>Pコート</td>
<td>3</td>
</tr>
<tr>
<td>2</td>
<td>ダッフルコート</td>
<td>3</td>
</tr>
<tr>
<td>3</td>
<td>ダウンジャケット</td>
<td>1</td>
</tr>
<tr>
<td>4</td>
<td>モッズコート</td>
<td>1</td>
</tr>
<tr>
<td>5</td>
<td>N-2Bブルゾン</td>
<td>2</td>
</tr>
</tbody>
</table>
<p>この場合、例えば「嶋田」さんが注文した商品をリストアップしたい、というときには、<br />
・まず、テーブル「User」を検索して「嶋田」という名前のユーザーのIDを取得<br />
・取得したユーザーのIDを元に「Order」を検索して、注文した商品リストを取得<br />
という手順になるわけですが、この処理をサブクエリを使うことによって、以下のようにできます。<br />
SQL</p>

		<div id="crayon-649540157fef2996090447" 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 Order.OrderID,Order.OrderItem
from Order
where Order.OrderUserID = (
     select User.UserID
     from User
     where User.Name= '嶋田');</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-649540157fef2996090447-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fef2996090447-2">2</div><div class="crayon-num" data-line="crayon-649540157fef2996090447-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fef2996090447-4">4</div><div class="crayon-num" data-line="crayon-649540157fef2996090447-5">5</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fef2996090447-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-649540157fef2996090447-1"><span class="crayon-e">select </span><span class="crayon-i">Order</span><span class="crayon-sy">.</span><span class="crayon-i">OrderID</span><span class="crayon-sy">,</span><span class="crayon-i">Order</span><span class="crayon-sy">.</span><span class="crayon-e">OrderItem</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fef2996090447-2"><span class="crayon-e">from </span><span class="crayon-e">Order</span></div><div class="crayon-line" id="crayon-649540157fef2996090447-3"><span class="crayon-e">where </span><span class="crayon-i">Order</span><span class="crayon-sy">.</span><span class="crayon-i">OrderUserID</span><span class="crayon-h"> </span>=<span class="crayon-h"> </span><span class="crayon-sy">(</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fef2996090447-4"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp; </span><span class="crayon-e">select </span><span class="crayon-i">User</span><span class="crayon-sy">.</span><span class="crayon-e">UserID</span></div><div class="crayon-line" id="crayon-649540157fef2996090447-5"><span class="crayon-e">&nbsp;&nbsp;&nbsp;&nbsp; </span><span class="crayon-e">from </span><span class="crayon-e">User</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fef2996090447-6"><span class="crayon-e">&nbsp;&nbsp;&nbsp;&nbsp; </span><span class="crayon-e">where </span><span class="crayon-i">User</span><span class="crayon-sy">.</span><span class="crayon-i">Name</span>=<span class="crayon-h"> </span><span class="crayon-s">'嶋田'</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p><b>結果</b></p>
<table>
<tbody>
<tr>
<th>OrderID</th>
<th>OrderItem</th>
</tr>
<tr>
<td>3</td>
<td class="col-number">ダウンジャケット</td>
</tr>
<tr>
<td>4</td>
<td class="col-number">モッズコート</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>

Mysql サブクエリを使ったSELECT文　

<p>Symfony2で使えるクローラーを判別するプログラムを書いてきました。<br />
すべてのものを判別するのは不可能に近いゆえ、メインのものしか書いてありません。</p>
<p></p>

		<div id="crayon-649540157fb0a682867180" 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;">
&lt;?php

namespace HogeBundle\API;

use Symfony\Component\DependencyInjection\ContainerInterface;

class UserAgentAPI {

    private $container;

    public function __construct(ContainerInterface $container) {
        $this-&gt;container = $container;
    }

    public function isCrawler() {
        $ua = $this-&gt;container-&gt;get ( "request" )-&gt;headers-&gt;get ( 'User-Agent' );
        // $_SERVER['HTTP_USER_AGENT']
        
        $crawler_arr = array (
                "Googlebot", // google
                "Baiduspider", // Baidu
                "bingbot", // Bing
                "Yeti", // NHN
                "NaverBot", // NaverBot
                "Yahoo", // Yahoo
                "Tumblr", // Tumblr
                "livedoor" // livedoor
        ) 
;
        foreach ( $crawler_arr as $value ) {
            if (stripos ( $ua, $value ) !== false) {
                return true;
            }
        }
        return false;
    }
}</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-649540157fb0a682867180-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-2">2</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-4">4</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-5">5</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-6">6</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-7">7</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-8">8</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-9">9</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-10">10</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-11">11</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-12">12</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-13">13</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-14">14</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-15">15</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-16">16</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-17">17</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-18">18</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-19">19</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-20">20</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-21">21</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-22">22</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-23">23</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-24">24</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-25">25</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-26">26</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-27">27</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-28">28</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-29">29</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-30">30</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-31">31</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-32">32</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-33">33</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-34">34</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-35">35</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157fb0a682867180-36">36</div><div class="crayon-num" data-line="crayon-649540157fb0a682867180-37">37</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-649540157fb0a682867180-1"><span class="crayon-h">&lt;</span><span class="crayon-sy">?</span><span class="crayon-e">php</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-2">&nbsp;</div><div class="crayon-line" id="crayon-649540157fb0a682867180-3"><span class="crayon-t">namespace</span><span class="crayon-h"> </span><span class="crayon-i">HogeBundle</span><span class="crayon-sy">\</span><span class="crayon-i">API</span><span class="crayon-sy">;</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-4">&nbsp;</div><div class="crayon-line" id="crayon-649540157fb0a682867180-5"><span class="crayon-st">use</span><span class="crayon-h"> </span><span class="crayon-i">Symfony</span><span class="crayon-sy">\</span><span class="crayon-i">Component</span><span class="crayon-sy">\</span><span class="crayon-i">DependencyInjection</span><span class="crayon-sy">\</span><span class="crayon-i">ContainerInterface</span><span class="crayon-sy">;</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-6">&nbsp;</div><div class="crayon-line" id="crayon-649540157fb0a682867180-7"><span class="crayon-t">class</span><span class="crayon-h"> </span><span class="crayon-e">UserAgentAPI</span><span class="crayon-h"> </span><span class="crayon-sy">{</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-8">&nbsp;</div><div class="crayon-line" id="crayon-649540157fb0a682867180-9"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-m">private</span><span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-i">container</span><span class="crayon-sy">;</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-10">&nbsp;</div><div class="crayon-line" id="crayon-649540157fb0a682867180-11"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-m">public</span><span class="crayon-h"> </span><span class="crayon-t">function</span><span class="crayon-h"> </span><span class="crayon-e">__construct</span><span class="crayon-sy">(</span><span class="crayon-i">ContainerInterface</span><span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-i">container</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-649540157fb0a682867180-12"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">$</span><span class="crayon-r">this</span>-<span class="crayon-h">&gt;</span><span class="crayon-i">container</span><span class="crayon-h"> </span>=<span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-i">container</span><span class="crayon-sy">;</span></div><div class="crayon-line" id="crayon-649540157fb0a682867180-13"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">}</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-14">&nbsp;</div><div class="crayon-line" id="crayon-649540157fb0a682867180-15"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-m">public</span><span class="crayon-h"> </span><span class="crayon-t">function</span><span class="crayon-h"> </span><span class="crayon-e">isCrawler</span><span class="crayon-sy">(</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-649540157fb0a682867180-16"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">$</span><span class="crayon-i">ua</span><span class="crayon-h"> </span>=<span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-r">this</span>-<span class="crayon-h">&gt;</span><span class="crayon-i">container</span>-<span class="crayon-h">&gt;</span><span class="crayon-e">get</span><span class="crayon-h"> </span><span class="crayon-sy">(</span><span class="crayon-h"> </span><span class="crayon-s">"request"</span><span class="crayon-h"> </span><span class="crayon-sy">)</span>-<span class="crayon-h">&gt;</span><span class="crayon-i">headers</span>-<span class="crayon-h">&gt;</span><span class="crayon-e">get</span><span class="crayon-h"> </span><span class="crayon-sy">(</span><span class="crayon-h"> </span><span class="crayon-s">'User-Agent'</span><span class="crayon-h"> </span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div><div class="crayon-line" id="crayon-649540157fb0a682867180-17"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-c">// $_SERVER['HTTP_USER_AGENT']</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-18"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></div><div class="crayon-line" id="crayon-649540157fb0a682867180-19"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">$</span><span class="crayon-i">crawler_arr</span><span class="crayon-h"> </span>=<span class="crayon-h"> </span><span class="crayon-t">array</span><span class="crayon-h"> </span><span class="crayon-sy">(</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-20"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-s">"Googlebot"</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-c">// google</span></div><div class="crayon-line" id="crayon-649540157fb0a682867180-21"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-s">"Baiduspider"</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-c">// Baidu</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-22"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-s">"bingbot"</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-c">// Bing</span></div><div class="crayon-line" id="crayon-649540157fb0a682867180-23"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-s">"Yeti"</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-c">// NHN</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-24"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-s">"NaverBot"</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-c">// NaverBot</span></div><div class="crayon-line" id="crayon-649540157fb0a682867180-25"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-s">"Yahoo"</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-c">// Yahoo</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-26"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-s">"Tumblr"</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-c">// Tumblr</span></div><div class="crayon-line" id="crayon-649540157fb0a682867180-27"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-s">"livedoor"</span><span class="crayon-h"> </span><span class="crayon-c">// livedoor</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-28"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">)</span><span class="crayon-h"> </span></div><div class="crayon-line" id="crayon-649540157fb0a682867180-29"><span class="crayon-sy">;</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-30"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-st">foreach</span><span class="crayon-h"> </span><span class="crayon-sy">(</span><span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-e">crawler_arr </span><span class="crayon-st">as</span><span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-i">value</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" id="crayon-649540157fb0a682867180-31"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-st">if</span><span class="crayon-h"> </span><span class="crayon-sy">(</span><span class="crayon-e">stripos</span><span class="crayon-h"> </span><span class="crayon-sy">(</span><span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-i">ua</span><span class="crayon-sy">,</span><span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-i">value</span><span class="crayon-h"> </span><span class="crayon-sy">)</span><span class="crayon-h"> </span><span class="crayon-sy">!</span>==<span class="crayon-h"> </span><span class="crayon-t">false</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-649540157fb0a682867180-32"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-st">return</span><span class="crayon-h"> </span><span class="crayon-t">true</span><span class="crayon-sy">;</span></div><div class="crayon-line" id="crayon-649540157fb0a682867180-33"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">}</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-34"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">}</span></div><div class="crayon-line" id="crayon-649540157fb0a682867180-35"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-st">return</span><span class="crayon-h"> </span><span class="crayon-t">false</span><span class="crayon-sy">;</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157fb0a682867180-36"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">}</span></div><div class="crayon-line" id="crayon-649540157fb0a682867180-37"><span class="crayon-sy">}</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>

【Symfony2】クローラーの判別

VagrantをWindows7にインストールしてCentos6.5環境構築

<p>Subversion（svn）でどうやって前のバージョンに戻す方法について調べてみました。<br />
実際に使ったわけではなく、メモになります。</p>
<h2>ツール</h2>
<h3>svnコマンド（Macのターミナル）</h3>
<p>Xcodeをインストールしたついてくるらしいです。<br />
brewやmacportsでインストールこともあり。</p>
<p></p>

		<div id="crayon-649540157f6c5387415407" 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 svn
/usr/bin/svn</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-649540157f6c5387415407-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157f6c5387415407-2">2</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-649540157f6c5387415407-1"><span class="crayon-e">which </span><span class="crayon-i">svn</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157f6c5387415407-2">/<span class="crayon-i">usr</span>/<span class="crayon-i">bin</span>/<span class="crayon-i">svn</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<h3> TortoiseSVN（Windows）</h3>
<p>GUI（フォルダの窓になる）。<br />
WindowsのShellでコマンドラインが使えるらしい。</p>
<h3>Eclipse</h3>
<p>Subversionプラグインをインストールすること。<br />
GUI。コマンドラインは使えないらしい。</p>
<h2>やり方</h2>
<p>コマンドラインでコマンドを打つか、EclipseのGUIで操作をするかでやり方が分けられます。</p>
<p>コマンドラインでコマンドを打つ方法で、svn merge と svn updateの２つの方法を紹介しますが、<br />
個人的にはsvn updateのほうが使えたとしても、ローカルファイルの更新のみになるので、もう一回svn commitが必要かと思います。</p>
<h3>svn merge</h3>
<p>リビジョン 31 を破棄して 30 に戻す例である。</p>

		<div id="crayon-649540157f6c9792510396" 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;">
svn merge -r 31:30 http://svn.example.com/repos/calc/trunk
svn commit -m "Undoing change committed in r31."</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-649540157f6c9792510396-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157f6c9792510396-2">2</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-649540157f6c9792510396-1"><span class="crayon-e">svn </span><span class="crayon-i">merge</span><span class="crayon-h"> </span>-<span class="crayon-i">r</span><span class="crayon-h"> </span><span class="crayon-cn">31</span><span class="crayon-sy">:</span><span class="crayon-cn">30</span><span class="crayon-h"> </span><span class="crayon-i">http</span><span class="crayon-sy">:</span><span class="crayon-c">//svn.example.com/repos/calc/trunk</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157f6c9792510396-2"><span class="crayon-e">svn </span><span class="crayon-i">commit</span><span class="crayon-h"> </span>-<span class="crayon-i">m</span><span class="crayon-h"> </span><span class="crayon-s">"Undoing change committed in r31."</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<h3>svn update</h3>
<p></p>

		<div id="crayon-649540157f6cb742467329" 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;">
svn update -r 30</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-649540157f6cb742467329-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-649540157f6cb742467329-1"><span class="crayon-e">svn </span><span class="crayon-i">update</span><span class="crayon-h"> </span>-<span class="crayon-i">r</span><span class="crayon-h"> </span><span class="crayon-cn">30</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<h2>おわり</h2>
<p>けっこう前からSubversionを使ってきましたが、やはりSubversionの機能全部は使えこなせていなかったのようです。<br />
Subversionサーバー構築もあるから、少し奥深い感じますね。</p>

svnを前のバージョンに戻す方法

SQLセキュリティ対策

ajaxの書き方

JSON形式のデータを返すAPI

CentOS 6から7にアップグレード

<p>MEAN(MongoDB, Express, AngularJS, Node.js)アーキテクチャは、下記の特徴で注目されています。<br />
・JavaScriptフルスタックである<br />
・データモデルはjson使っている</p>
<h3>各パーツの紹介</h3>
<h4>MongoDB &#8211; <a href="http://www.mongodb.org/" target="_blank">http://www.mongodb.org/</a></h4>
<p>RDBと概念が異なり「DB」「コレクション」「オブジェクト（＝ドキュメント）」といった新しい概念になります。</p>
<h4>Express &#8211; <a href="http://expressjs.com/" target="_blank">http://expressjs.com/</a></h4>
<p>Node.js上で動くWeb Applicationフレームワークのようです。</p>
<h4>AngularJS &#8211; <a href="https://angularjs.org/" target="_blank">https://angularjs.org/</a></h4>
<p>「Directive」、「Module」、「Provider」や「Dependency Injection」というアーキテクチャを持つJavaScriptフレームワークです。</p>
<h4>Node.js &#8211; <a href="http://nodejs.org/" target="_blank">http://nodejs.org/</a></h4>
<p>サーバサイドJavaScript環境です。</p>
<h3>YEOMANジェネレータ</h3>
<p>いくつMEANのYEOMANジェネレータが存在するらしくて、使わなければどういう感じなものかがわからないです。<br />
あとで調査しますが、コマンドを打ってファイルを生成するものかと思います。</p>
<p>一番優れるジェネレータは下記であるのようです。<br />
<a href="https://github.com/DaftMonk/generator-angular-fullstack" target="_blank">DaftMonk/generator-angular-fullstack · GitHub</a></p>


MEANアーキテクチャ

<h2>NoSQLとは</h2>
<p>データベース管理システム(DBMS)の種類を表す用語で、現在最も普及しているリレーショナルデータベース(RDB/RDBMS → Mysql,PostGre,Oracleなど)とは異なる新しい方式の総称。RDBでデータの問い合わせや操作に用いる言語であるSQLを用いない(使えない)ことからこのように呼ばれる。主にビッグデータを扱うときに用いる。</p>
<h2>NoSQLの種類</h2>
<h4>KVS（Key-Value Store型）</h4>
<p>キーと値をペアにして保持するシンプルなデータ構造を持つ。キーと、格納したいデータを紐付け、キーを指定することでそれに対応したデータを格納／取得することができる。<br />
例：Memcashed</p>
<h4>列指向型（テーブル指向型）</h4>
<p>列方向のデータのまとまりを効率的に扱えるように設計されたデータベース。列データをファイルシステム上の連続した位置に格納することによって、大量の行に対する少数の列の集約処理や、同一の値をまとめるデータ圧縮などを効率的に行うことができる。大量のデータを対象とした分析やデータマイニングなどに特に適していると言われている。<br />
例：Cassandra</p>
<h4>ドキュメント指向型</h4>
<p>XMLやJSONなどのように半構造化されたドキュメントデータの格納に特化したデータベース。ドキュメント自体に関するメタデータも含め、全てドキュメント内に保存される点が特徴となっている。<br />
例：MongoDB</p>
<h4>グラフ指向型</h4>
<p>ノード、エッジ、プロパティから構成されるグラフ構造でデータを格納するデータベース。データ同士の複雑な関連性を表現することができる。<br />
例：Neo4j</p>
<h2>NoSQLの特徴</h2>
<p>・RDBMSと比べて高速に動作する(大量のデータの読み書きが得意)<br />
・スケールアウト(サーバを増加させることで性能をアップ)をすることを想定した作り<br />
・トランザクションやテーブル間のジョインのような仕組みがないものが多く、シンプルな設計＆機能</p>


NoSQL基本

<p>Symfony2のデフォルトでは、キャッシュフォルダはapp/フォルダの下にあります。<br />
時々いろな理由（例えば、ソースコード管理）で、キャッシュフォルダをプロジェクトフォルダの外に置きたい場合があります。<br />
その状況のために、キャッシュフォルダを変更する方法を調べてみました。</p>
<h2>キャッシュフォルダの変更</h2>
<p>一見難しそうなタスクですが、Symfony2では簡単なやり方を提供しています（画像などのリソースファイルをweb/フォルダの下からプロジェクトフォルダの外に移動するほうが手間かかる気がします）。<br />
app/AppKernel.phpのファイルに、getCacheDirの関数を追加すればよいです。</p>
<p></p>

		<div id="crayon-649540157dba6052766325" 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;">
    public function getCacheDir()
    {
        return $this-&gt;rootDir.'/../cache/[project_name]/'.$this-&gt;environment;
    }</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-649540157dba6052766325-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157dba6052766325-2">2</div><div class="crayon-num" data-line="crayon-649540157dba6052766325-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157dba6052766325-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-649540157dba6052766325-1"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-m">public</span><span class="crayon-h"> </span><span class="crayon-t">function</span><span class="crayon-h"> </span><span class="crayon-e">getCacheDir</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157dba6052766325-2"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">{</span></div><div class="crayon-line" id="crayon-649540157dba6052766325-3"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-st">return</span><span class="crayon-h"> </span><span class="crayon-sy">$</span><span class="crayon-r">this</span>-<span class="crayon-h">&gt;</span><span class="crayon-i">rootDir</span><span class="crayon-sy">.</span><span class="crayon-s">'/../cache/[project_name]/'</span><span class="crayon-sy">.</span><span class="crayon-sy">$</span><span class="crayon-r">this</span>-<span class="crayon-h">&gt;</span><span class="crayon-i">environment</span><span class="crayon-sy">;</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157dba6052766325-4"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">}</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>
<p>上記の例では、プロジェクトフォルダと同じ階層にcacheを作って、その中にプロジェクトごと環境を分けてcacheを保存するイメージです。</p>
<h2>リソースフォルダの変更</h2>
<p>画像の容量を小さくするため、画像を違うサイズの小画像を自動作成しキャッシュ化するバンドル<a href="https://github.com/avalanche123/AvalancheImagineBundle" target="_blank">AvalancheImagineBundle</a>を使います。<br />
初回目画像を作成するため時間がかかって重いのは難点ですが。</p>
<p>app/config.ymlに設定すれば、デフォルトの設定を上書きできるようになっています。</p>
<p></p>

		<div id="crayon-649540157dbaa460413710" 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;">
avalanche_imagine:
    source_root:  処理したい画像フォルダの絶対パス
    web_root:     処理したい画像フォルダの（webルートから）相対パス
    cache_prefix: media/cache
    driver:       gd
    filters:      []</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-649540157dbaa460413710-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157dbaa460413710-2">2</div><div class="crayon-num" data-line="crayon-649540157dbaa460413710-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157dbaa460413710-4">4</div><div class="crayon-num" data-line="crayon-649540157dbaa460413710-5">5</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157dbaa460413710-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-649540157dbaa460413710-1"><span class="crayon-i">avalanche_imagine</span><span class="crayon-sy">:</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157dbaa460413710-2"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-i">source_root</span><span class="crayon-sy">:</span><span class="crayon-h">&nbsp;&nbsp;</span>処理したい画像フォルダの絶対パス</div><div class="crayon-line" id="crayon-649540157dbaa460413710-3"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-i">web_root</span><span class="crayon-sy">:</span><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp; </span>処理したい画像フォルダの（<span class="crayon-i">web</span>ルートから）相対パス</div><div class="crayon-line crayon-striped-line" id="crayon-649540157dbaa460413710-4"><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-i">cache_prefix</span><span class="crayon-sy">:</span><span class="crayon-h"> </span><span class="crayon-i">media</span>/<span class="crayon-e">cache</span></div><div class="crayon-line" id="crayon-649540157dbaa460413710-5"><span class="crayon-e">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-i">driver</span><span class="crayon-sy">:</span><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span class="crayon-e">gd</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157dbaa460413710-6"><span class="crayon-e">&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-i">filters</span><span class="crayon-sy">:</span><span class="crayon-h">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span class="crayon-sy">[</span><span class="crayon-sy">]</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p> </p>

【Symfony2】キャッシュフォルダの変更

<p>URLを操作して、様々な用途に使用できるmodRewiteについて書きました。</p>
<h3>mod_rewriteとは</h4>
<p>WebサーバーであるApache上で利用することができる機能です。<br />
機能内容を簡単にいえば、ユーザー（又は検索エンジン）からのリクエストにあるURL情報を、変更し「リダイレクト」する事ができます。</p>
<p>&nbsp;</p>
<h3>mod_rewriteの初期設定</h4>
<p>mod_rewriteはApacheのモジュールなので設定ファイルで有効にする必要があります。</p>

		<div id="crayon-649540157d7a2153226191" 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;">
vi /etc/httpd/conf/httpd.conf

  #LoadModule rewrite_module modules/mod_rewrite.so
  LoadModule rewrite_module modules/mod_rewrite.so

/etc/init.d/httpd/restart</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-649540157d7a2153226191-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157d7a2153226191-2">2</div><div class="crayon-num" data-line="crayon-649540157d7a2153226191-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157d7a2153226191-4">4</div><div class="crayon-num" data-line="crayon-649540157d7a2153226191-5">5</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157d7a2153226191-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-649540157d7a2153226191-1"><span class="crayon-i">vi</span><span class="crayon-h"> </span>/<span class="crayon-i">etc</span>/<span class="crayon-i">httpd</span>/<span class="crayon-i">conf</span>/<span class="crayon-i">httpd</span><span class="crayon-sy">.</span><span class="crayon-i">conf</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157d7a2153226191-2">&nbsp;</div><div class="crayon-line" id="crayon-649540157d7a2153226191-3"><span class="crayon-h">&nbsp;&nbsp;</span><span class="crayon-p">#LoadModule rewrite_module modules/mod_rewrite.so</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157d7a2153226191-4"><span class="crayon-h">&nbsp;&nbsp;</span><span class="crayon-e">LoadModule </span><span class="crayon-e">rewrite_module </span><span class="crayon-i">modules</span>/<span class="crayon-i">mod_rewrite</span><span class="crayon-sy">.</span><span class="crayon-i">so</span></div><div class="crayon-line" id="crayon-649540157d7a2153226191-5">&nbsp;</div><div class="crayon-line crayon-striped-line" id="crayon-649540157d7a2153226191-6">/<span class="crayon-i">etc</span>/<span class="crayon-i">init</span><span class="crayon-sy">.</span><span class="crayon-i">d</span>/<span class="crayon-i">httpd</span>/<span class="crayon-i">restart</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p>これでmodRewiteが使えます。</p>
<p>&nbsp;</p>
<h3>使用例</h4>
<p>1, サイトの引越し（リニューアル）の時にリダイレクトする方法。<br />
例：<br />
http://www.aaa.com/ から http://www.bbb.com/ にドメインが変更になった場合に<br />
http://www.bbb.com/ にリダイレクトさせることができます。<br />
・設置場所 → http://www.aaa.com/ のドキュメントルートに.htaccessを設置</p>

		<div id="crayon-649540157d7a6869719857" 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;">
RewriteEngine on
RewriteRule ^/(.*)$ http://www.bbb.com/$1 [R=301,L]</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-649540157d7a6869719857-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157d7a6869719857-2">2</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-649540157d7a6869719857-1"><span class="crayon-e">RewriteEngine </span><span class="crayon-e">on</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157d7a6869719857-2"><span class="crayon-i">RewriteRule</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-i">http</span><span class="crayon-sy">:</span><span class="crayon-c">//www.bbb.com/$1 [R=301,L]</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p>2, 動的ページを静的ページに見せる<br />
SEO対策でよく使われます。<br />
動的ページを静的ページに見せることによって、検索エンジンにインデックスされやすくなるらしいです。<br />
例：<br />
http://www.aaa.com/search.php?id=123&#038;name=bob<br />
↓<br />
http://www.aaa.com/123_bob.html</p>

		<div id="crayon-649540157d7a8687247126" 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;">
Options FollowSymLinks
RewriteEngine on

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^([0-9A-Za-z]+)_([0-9A-Za-z]+).html$ search.php?id=$1&amp;amp;name=$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-649540157d7a8687247126-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157d7a8687247126-2">2</div><div class="crayon-num" data-line="crayon-649540157d7a8687247126-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157d7a8687247126-4">4</div><div class="crayon-num" data-line="crayon-649540157d7a8687247126-5">5</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157d7a8687247126-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-649540157d7a8687247126-1"><span class="crayon-e">Options</span><span class="crayon-h"> </span><span class="crayon-e">FollowSymLinks</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157d7a8687247126-2"><span class="crayon-e">RewriteEngine</span><span class="crayon-h"> </span><span class="crayon-e">on</span></div><div class="crayon-line" id="crayon-649540157d7a8687247126-3">&nbsp;</div><div class="crayon-line crayon-striped-line" id="crayon-649540157d7a8687247126-4"><span class="crayon-e">RewriteCond</span><span class="crayon-h"> </span><span class="crayon-sy">%</span><span class="crayon-sy">{</span><span class="crayon-i">REQUEST_FILENAME</span><span class="crayon-sy">}</span><span class="crayon-h"> </span><span class="crayon-sy">!</span>-<span class="crayon-e">f</span></div><div class="crayon-line" id="crayon-649540157d7a8687247126-5"><span class="crayon-e">RewriteCond</span><span class="crayon-h"> </span><span class="crayon-sy">%</span><span class="crayon-sy">{</span><span class="crayon-i">REQUEST_FILENAME</span><span class="crayon-sy">}</span><span class="crayon-h"> </span><span class="crayon-sy">!</span>-<span class="crayon-i">d</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157d7a8687247126-6"><span class="crayon-i">RewriteRule</span><span class="crayon-h"> </span>^<span class="crayon-sy">(</span><span class="crayon-sy">[</span><span class="crayon-cn">0</span>-<span class="crayon-cn">9A</span>-<span class="crayon-i">Za</span>-<span class="crayon-i">z</span><span class="crayon-sy">]</span>+<span class="crayon-sy">)</span><span class="crayon-e">_</span><span class="crayon-sy">(</span><span class="crayon-sy">[</span><span class="crayon-cn">0</span>-<span class="crayon-cn">9A</span>-<span class="crayon-i">Za</span>-<span class="crayon-i">z</span><span class="crayon-sy">]</span>+<span class="crayon-sy">)</span><span class="crayon-sy">.</span><span class="crayon-i">html</span><span class="crayon-sy">$</span><span class="crayon-h"> </span><span class="crayon-i">search</span><span class="crayon-sy">.</span><span class="crayon-i">php</span><span class="crayon-sy">?</span><span class="crayon-i">id</span>=<span class="crayon-sy">$</span><span class="crayon-cn">1</span><span class="crayon-sy">&amp;amp;</span><span class="crayon-i">name</span>=<span class="crayon-sy">$</span><span class="crayon-cn">2</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p>3, wwwありをwwwなしに301リダイレクト<br />
SEOの基本ですが、wwwありか、なしで統一する方法です。<br />
例：<br />
http://www.aaa.com/ (あり)から http://aaa.com/ (なし)へ統一する。</p>

		<div id="crayon-649540157d7a9819016847" 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;">
RewriteEngine on

RewriteCond %{HTTP_HOST} www\.aaa\.com
RewriteRule ^(.*)$ http://aaa.com/$1 [R=301,L]</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-649540157d7a9819016847-1">1</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157d7a9819016847-2">2</div><div class="crayon-num" data-line="crayon-649540157d7a9819016847-3">3</div><div class="crayon-num crayon-striped-num" data-line="crayon-649540157d7a9819016847-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-649540157d7a9819016847-1"><span class="crayon-e">RewriteEngine</span><span class="crayon-h"> </span><span class="crayon-e">on</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157d7a9819016847-2">&nbsp;</div><div class="crayon-line" id="crayon-649540157d7a9819016847-3"><span class="crayon-e">RewriteCond</span><span class="crayon-h"> </span><span class="crayon-sy">%</span><span class="crayon-sy">{</span><span class="crayon-i">HTTP_HOST</span><span class="crayon-sy">}</span><span class="crayon-h"> </span><span class="crayon-i">www</span><span class="crayon-sy">\</span><span class="crayon-sy">.</span><span class="crayon-i">aaa</span><span class="crayon-sy">\</span><span class="crayon-sy">.</span><span class="crayon-e">com</span></div><div class="crayon-line crayon-striped-line" id="crayon-649540157d7a9819016847-4"><span class="crayon-i">RewriteRule</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-i">http</span><span class="crayon-sy">:</span><span class="crayon-c">//aaa.com/$1 [R=301,L]</span></div></div></td>
					</tr>
				</table>
			</div>
		</div>

<p>他にも様々な方法があります。<br />
気になる方はこちらチェックしてみてください。<br />
<a href="http://snipsnaptmae.wordpress.com/2013/02/28/modrewrite/" target="_brank">http://snipsnaptmae.wordpress.com/2013/02/28/modrewrite/</a></p>

Company

Our Solutions

Support

News

Blog

Blogブログ

カテゴリーから探す

年別から見る

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

2015/01/07

2014/12/17

2014/12/10

2014/12/09

2014/12/04

2014/12/03

2014/11/26

2014/11/25

2014/11/19

2014/11/19

2014/11/12

2014/11/11

2014/11/06

2014/11/04

2014/10/28

2014/10/22

2014/10/22

2014/10/15