// id.next echo "[Client] id_next received:", $client->id_next($ctx), "\n"; echo "[Client] id_next received:", $client->id_next($ctx), "\n"; echo "[Client] id_next_with_tag received:", $client->id_next_with_tag($ctx, 5), "\n"; echo "[Client] id_next_with_tag received:", $client->id_next_with_tag($ctx, 10), "\n"; $id = $client->id_next_with_tag($ctx, 18); list($ts, $tag, $wid, $seq) = $client->id_decode($ctx, $id); echo "{$ts} {$tag} {$wid} {$seq}\n"; // lc echo '[Client] lc_set received: ', $client->lc_set($ctx, 'hello-php-lc', 'world 世界'), "\n"; echo '[Client] lc_get received: ', $client->lc_get($ctx, 'hello-php-lc'), "\n"; echo '[Client] lc_del received: ', $client->lc_del($ctx, 'hello-php-lc'), "\n"; // my.query if (1) { for ($i = 0; $i < 5; $i++) { $rows = $client->my_query($ctx, 'UserShard', 'UserInfo', 1, 'SELECT * FROM UserInfo', array(), ''); echo $rows->rowsAffected, ':rowsAffected, ', $rows->lastInsertId, ':lastInsertId, rows:', PHP_EOL; print_r($rows); } } // mc if (0) { $mcData = new TMemcacheData(); $mcData->data = 'world 世界'; echo '[Client] mc_set received: ', $client->mc_set($ctx, 'default', 'hello-php', $mcData, 120), "\n"; echo '[Client] mc_get received: ', print_r($client->mc_get($ctx, 'default', 'hello-php')), "\n"; $mcData->data = 0; echo '[Client] mc_add received: ', $client->mc_add($ctx, 'default', 'test:counter:uid', $mcData, 3500), "\n"; echo '[Client] mc_inc received: ', $client->mc_increment($ctx, 'default', 'test:counter:uid', 7), "\n"; try { echo '[Client] mc_get hello-non-exist received: ', $client->mc_get($ctx, 'default', 'hello-non-exist'), "\n";
try { $sock = new TSocketPool(array('localhost', 'localhost'), array(9001, 9011)); $sock->setDebug(1); $sock->setSendTimeout(4000); $sock->setRecvTimeout(4000); $sock->setNumRetries(1); $transport = new TBufferedTransport($sock, 1024, 1024); $protocol = new TBinaryProtocol($transport); // get our client $client = new FunServantClient($protocol); $transport->open(); $ctx = new Context(array('rid' => hexdec(uniqid()), 'reason' => 'call.init.121')); // mysql select multiple rows echo "\nDEMO SELECT\n"; echo "===============================\n"; $rows = $client->my_query($ctx, 'UserShard', 'UserInfo', 1, 'SELECT * from UserInfo where uid>?', array(1), ''); echo $rows->rowsAffected, ':rowsAffected, ', $rows->lastInsertId, ':lastInsertId, rows:', PHP_EOL; print_r($rows); // mysql query cache $rows = $client->my_query($ctx, 'UserShard', 'UserInfo', 1, 'SELECT * from UserInfo where uid=?', array(1), 'UserInfo:1'); $rows = $client->my_query($ctx, 'UserShard', 'UserInfo', 1, 'SELECT * from UserInfo where uid=?', array(1), 'UserInfo:1'); print_r($rows); // mysql update echo "\nDEMO UPDATE\n"; echo "===============================\n"; $rows = $client->my_query($ctx, 'UserShard', 'UserInfo', 1, 'UPDATE UserInfo set power=power+1 where uid=?', array(1), 'UserInfo:1'); echo $rows->rowsAffected, ':rowsAffected, ', $rows->lastInsertId, ':lastInsertId, rows:', PHP_EOL; print_r($rows); // mysql transation echo "\nDEMO transtaion\n"; echo "===============================\n";