ishtaka

# install phalcon
cd /tmp
git clone git://github.com/phalcon/cphalcon.git
cd cphalcon/build
sudo ./install
echo "extension=phalcon.so" > /etc/php.d/phalcon.ini
sudo service httpd restart

# install phalcon devtools
curl -s http://getcomposer.org/installer | php

ishtaka

#!/bin/bash

# install emacs24.3
cd /tmp
curl -O http://ftp.gnu.org/pub/gnu/emacs/emacs-24.3.tar.gz
tar xfz emacs-24.3.tar.gz
cd emacs-24.3
./configure --without-x --without-selinux　#--prefix=$HOME/local
make
sudo make install

ishtaka

<!DOCTYPE web-app PUBLIC
  "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
  "http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>
  <servlet>
    <servlet-name>HelloServlet</servlet-name>
    <servlet-class>HelloServlet</servlet-class>
  </servlet>

ishtaka

sudo vi /etc/httpd/conf/httpd.conf 

// AJPを有効
LoadModule proxy_ajp_module modules/mod_proxy_ajp.so
// ディレクトリを指定
<Location /path/>
    ProxyPass ajp://localhost:8009/path/
</Location>

ishtaka

# download http://tomcat.apache.org/
cd /tmp
wget http://ftp.tsukuba.wide.ad.jp/software/apache/tomcat/tomcat-8/v8.0.3/bin/apache-tomcat-8.0.3.tar.gz

# make group and user for tomcat 
groupadd -g 1001 tomcat
useradd -u 1001 -g tomcat -s /bin/bash tomcat

# install tomcat
su - tomcat

ishtaka

# /etc/profile.d/tomcat.sh
# Java
export JAVA_HOME=/usr/java/jdk1.8.0
export PATH=$PATH:$JAVA_HOME/bin
export CLASSPATH=.:$JAVA_HOME/jre/lib:$JAVA_HOME/lib:$JAVA_HOME/lib/tools.jar
# Tomcat
export JRE_HOME=$JAVA_HOME
export TOMCAT_HOME=/usr/local/tomcat
export CATALINA_HOME=/usr/local/tomcat
export CLASSPATH=$CLASSPATH:$CATALINA_HOME/common/lib

ishtaka

# 現在の設定を確認
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |

ishtaka

# 一般ユーザuserの作成
useradd user
# passwd centos　←　centosのパスワード設定
passwd user
# New UNIX password: 　←　centosのパスワード応答
# Retype new UNIX password: 　←　centosのパスワード応答(確認)
# ユーザuserの削除
userdel -r user

ishtaka

SELECT table_name, column_name FROM information_schema.columns WHERE column_name ='検索するカラム名';

ishtaka

<?php

/**
 * CSV読み込み
 *
 * @access public
 * @param  string $path
 * @retunr array  $result
 */
public static function readCsv($path)