php-handlersocket

$hs = new HandlerSocket('db_test', '127.0.0.1', 9999);
$fields = ['id','username','score','modified_at','is_active'];
$hs->open('t_users', $fields);

$now = date('Y-m-d H:i:s');
$row = [1,'ryan',60,$now,true];
$hs->insert(array_combine($fields, $row));

#new data, pkey or index, id or index value
$hs->update([1, 'David', 80, $now, true], null, 1); 

$hs->delete(1); #the id

$ryan = $hs->get(1);

$ryan = $hs->get('username', 'ryan');

#pkey or index, operation, value, limit, offset
#operation: > >= < <=
$ryan = $hs->all(null, '>=', 1, 3, 1);

$ryan = $hs->in('username', 'ryan', 'jane');
#or
$ryan = $hs->in('username', ['ryan', 'jane']);