How to get data from Tarantool using SQL query about client HOT 10 CLOSED

I haven't tested it myself, but it looks like the lua's return statement is missing in your first example. Try this line instead:

$result = $client->evaluate('return box.sql.execute([[SELECT * FROM table1;]])'); // <- note return here

from client.

And it works with next way...

$client->evaluate('function testfunc()
    return box.sql.execute([[SELECT * FROM table1;]])
end');
$result = $client->call('testfunc');
var_dump($result->getData());

Result is:

array (size=1)
  0 => 
    array (size=1)
      0 => 
        array (size=2)
          0 => int 1
          1 => string 'A' (length=1)

from client.

Thanks! It works!

from client.

Thank you very much for the library!
I would not like to correct such mistakes -

`PHP Fatal error: Uncaught Error: Class 'MessagePack\Packer' not found in /home/work/php/test/vendor/tarantool/client/src/Packer/PurePacker.php:19
Stack trace:
#0 /home/work/php/test/tarantool.php(12): Tarantool\Client\Packer\PurePacker->__construct()
#1 {main}
thrown in /home/work/php/test/vendor/tarantool/client/src/Packer/PurePacker.php on line 19

Fatal error: Uncaught Error: Class 'MessagePack\Packer' not found in /home/work/php/test/vendor/tarantool/client/src/Packer/PurePacker.php:19
Stack trace:
#0 /home/work/php/test/tarantool.php(12): Tarantool\Client\Packer\PurePacker->__construct()
#1 {main}
thrown in /home/work/php/test/vendor/tarantool/client/src/Packer/PurePacker.php on line 19`

from client.

Hi Artem,

Looks like the rybakit/msgpack package is missing in your setup, check a note under the "Usage" section for details: https://github.com/tarantool-php/client#usage.

TLDR, try to run composer require rybakit/msgpack to solve the issue.

from client.

Yes, thank you very much, I did it.
I would like this dependency to be enabled by default!

from client.

I would like this dependency to be enabled by default!

Well, rybakit/msgpack is not necessary if you use the msgpack-php pecl extension. That is why it's not enabled by default.

from client.

how to get an associative array?

from client.

var_dump($result->getData()); returns values without columns

from client.

@artem-webdev Please ask that kind of questions on stackoverflow.com or at least create a dedicated issue, it will make easier to other concerned developers to find answers to these questions in the future.

from client.