Skip to content

Instantly share code, notes, and snippets.

<?php
// エクセルファイルを zip として処理
$zip = new ZipArchive();
$zip->open( 'test.xlsx' );
// 1シート目のxml取得
$xml_sheet = simplexml_load_string( $zip->getFromName( 'xl/worksheets/sheet1.xml' ) );
// sharedStrings.xml を取得
@mgng
mgng / mongodb.php
Created January 7, 2013 06:16
mongoDB connect
<?php
$host = '127.0.0.1';
$port = '27017';
$dbname = 'mgng';
$username = 'dbuser';
$password = 'password';
$timeout = 5000;
try {
$options = array(
@mgng
mgng / 1.php
Created December 21, 2012 14:42
Redis で prefix つけると、キー一覧引っ張ってきてループ処理するときに面倒
<?php
$prefix = 'TEST:';
$redis = new Redis();
$redis->connect( '127.0.0.1', 6379 );
$redis->setOption( Redis::OPT_PREFIX, $prefix );
// set
$redis->set( 'key1', 'val1' );
$redis->set( 'key2', 'val2' );
$redis->set( 'key3', 'val3' );
@mgng
mgng / app.yaml
Created December 19, 2012 08:31
GAE for Python で web cron 実行させる
application: yourappname
version: 1
runtime: python
api_version: 1
threadsafe: false
handlers:
- url: /webcron
script: webcron.py
login: admin
@mgng
mgng / 1.txt
Created December 18, 2012 07:59
session + POST のときに戻ったりしても「有効期限切れ」がでなくするやつ
Cache-Control no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Expires Thu, 19 Nov 1981 08:52:00 GMT
Pragma no-cache
<?php
/**
* fetch_multi_url
*
* @param array $urls URLの配列
* @param integer $timeout タイムアウト秒数、default0秒(タイムアウトなし)
* @return array 結果レスポンス一覧
*/
function fetch_multi_url( $urls, $timeout = 0 ){
$mh = curl_multi_init();
@mgng
mgng / 1.txt
Created December 17, 2012 01:31
フォローしてる user_id 一覧
フォローされてる user_id 一覧
ブロックしてる user_id 一覧
@mgng
mgng / 1.php
Created December 14, 2012 06:41
redis + php + session
<?php
$vcap_services = json_decode( getenv( "VCAP_SERVICES" ) );
$credentials = $vcap_services->{"redis-2.2"}[0]->credentials;
$host = $credentials->host;
$port = $credentials->port;
$pass = $credentials->password;
ini_set( 'session.save_handler', 'redis' );
ini_set( 'session.save_path', "tcp://{$host}:{$port}?auth={$pass}" );
<script type="text/javascript" src="chimpo.js"></script>
<button onclick="chimpo()">「ちんぽ」表示</button>
@mgng
mgng / result.txt
Created November 26, 2012 08:44
soundcloud API で認証
stdClass Object
(
[id] => 3163465
[kind] => user
[permalink] => mgng
[username] => mgng
[uri] => https://api.soundcloud.com/users/3163465
[permalink_url] => http://soundcloud.com/mgng
[avatar_url] => https://i1.sndcdn.com/avatars-000013936604-9iswyu-large.jpg?afed582
[country] => Japan