|
Project Information
Featured
Downloads
|
more usable interface for php-handlersocket before use this PHP Class, you must install the php-handlersocket first. <?php
require('handlersocket_wrapper.php');
$db_host = '127.0.0.1';
$port_read = 9998;
$port_write = 9999;
$dbname = 'test';
$table = 'user';
$indexid = 1;
$hsr = new HandlerScoketWrapper($db_host, $port_read, $dbname, $table);
$hsr->init(array('user_id', 'user_email'), $indexid);
$result = $hsr->get('101');
var_dump($result);
$result = $hsr->get(array('101', '102', '111'));
var_dump($result);
$hsw = new HandlerScoketWrapper($db_host, $port_write, $dbname, $table);
$hsw->init(array('user_id', 'user_name', 'user_email'), $indexid + 1);
/**
* https://github.com/ahiguti/HandlerSocket-Plugin-for-MySQL/blob/master/docs-en/protocol.en.txt
*
* ...
* Once an 'open_index' request is issued, the HandlerSocket plugin opens the
* specified index and keep it open until the client connection is closed. Each
* open index is identified by <indexid>. If <indexid> is already open, the old
* open index is closed. You can open the same combination of <dbname>
* <tablename> <indexname> multple times, possibly with different <columns>.
* For efficiency, keep <indexid> small as far as possible.
* ...
*
*/
$result = $hsw->add(array('104', 'cool', 'cool@example.com'));
/* the first element of the array is the Primary Key, and the rest elements are value of each column. */
var_dump($result);
$result = $hsw->get('104');
/* use primary key to get value */
var_dump($result);
$data = array('hot', 'hot@example.com');
$result = $hsw->update('104', $data);
/* first param is primary key, second param is data (as an array) */
var_dump($result);
$status = $hsw->del('104');
/* delete the record by primary key. */
var_dump($status);
|