using on predis php client

[ihabhamad]

on testing on Laravel Redis (Predis lib) $data = Redis::connection('test')->executeRaw(['ZEESQL.QUERY',"DB","COMMAND SELECT FROM foo"]); or $data = Redis::connection('test')->executeRaw(['ZEESQL.QUERY',"DB COMMAND ","SELECT FROM foo"]); or $data = Redis::connection('test')->executeRaw(['ZEESQL.QUERY',"DB COMMAND SELECT * FROM foo"]);

return Command incomplete, no COMMAND nor STATEMENT fields"

and

$data = Redis::connection('test')->executeRaw(['ZEESQL.QUERY DB COMMAND'," SELECT * FROM foo"]);

return "ERR unknown command ZEESQL.QUERY DB COMMAND, with args beginning with: SELECT * FROM foo, "

any idea??

That's in Redis monitor the client not compatible?

[ihabhamad]

after testing phpredis extension returns the same error

you need to accept quotation marks in parameters

for example $redis->rawCommand('set','fo','bar'); in monitor "set" "fo" "bar" Redis accept that command and parameters but
"ZEESQL.EXEC" "DB COMMAND" "select * from mydb" that's not acceptable please update your module to work with PHP Redis clients

[siscia]

Can you try what to me seems the most obvious?

 $data = Redis::connection('test')->executeRaw(['ZEESQL.QUERY',"DB","COMMAND",  "SELECT * FROM foo"]);

So you are telling ZEESQL to query, then what database, then that you are executing a command and finally the command you are executing.

[ihabhamad]

@siscia thats works

[siscia]

That's great!

Glad to help :)