Australia photo & PC memo

xajax PHP Class Library - The easiest way to develop asynchronous Ajax applications with PHP

OTN Japan - ソフトウェア : Oracle SQL Developer

JavaScript: Defer Execution - with the defer attribute of the script element

MySQL AB :: MySQL 5.1 Reference Manual :: 1.8.5 MySQL Differences from Standard SQL

1.8.5.1. SELECT INTO TABLE
1.8.5.2. Transactions and Atomic Operations
1.8.5.3. Stored Routines and Triggers
1.8.5.4. Foreign Keys
1.8.5.5. Views
1.8.5.6. '--' as the Start of a Comment

MySQL AB :: MySQL Presentations: Optimizing MySQL

* SELECT SQL_BUFFER_RESULTS ...
Will force MySQL to make a temporary result set. As soon as the temporary set is done, all locks on the tables are released. This can help when you get a problem with table locks or when it takes a long time to transfer the result to the client.

* SELECT SQL_SMALL_RESULT ... GROUP BY ...
To tell the optimizer that the result set will only contain a few rows.

* SELECT SQL_BIG_RESULT ... GROUP BY ...
To tell the optimizer that the result set will contain many rows.

* SELECT STRAIGHT_JOIN ...
Forces the optimizer to join the tables in the order in which they are listed in the FROM clause.

* SELECT ... FROM table_name [USE INDEX (index_list) | IGNORE INDEX (index_list)] table_name2
Forces MySQL to use/ignore the listed indexes.

Client Authentication with w3m

% openssl pkcs12 -cacerts -nokeys -in （PKCS#12型式ファイル） -out （PEM型式の「CA証明書ファイル」）
% openssl pkcs12 -clcerts -in （PKCS#12型式ファイル） -out （PEM型式の「クライアント証明書ファイル」）

FreeCAでWebサーバーのデジタル証明書を取得する

$ openssl pkcs12 -in loadcert.p12 -out certs.txt
Enter Import Password:
（FreeCAから証明書を取得したときのパスワードを入力します。）
MAC verified OK 
Enter PEM pass phrase:
（ここには秘密鍵を暗号化するパスワードを入力します。）
Verifying password - Enter PEM pass phrase:

$ openssl x509 -in certs.pem -noout -enddate
有効期限を確認する

curl_setopt - PHPプロ！マニュアル

PHPEclipseでリモートデバッグ(DBG) | TOnDa TondA
The debugging environment for PHPeclipse