The results for me for the code you provided:
array(14) {
["ID"]=>
string(1) "0"
[0]=>
string(1) "0"
["USERKEY"]=>
string(73) "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed
do elit, sed"
[1]=>
string(73) "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed
do elit, sed"
["SERVER"]=>
string(1) "b"
[2]=>
string(1) "b"
["TSESSION"]=>
string(1) "c"
[3]=>
string(1) "c"
["TPOST"]=>
string(1) "d"
[4]=>
string(1) "d"
["TGET"]=>
string(1) "e"
[5]=>
string(1) "e"
["ADDDATE"]=>
string(1) "1"
[6]=>
string(1) "1"
}
Are you sure you are using new driver?
Best Regards,
Igor
On Wed, Feb 28, 2018 at 6:08 PM, bagsiur <[email protected]>
wrote:
> I'm try to execute fallowing code:
>
> <?php
>
> ini_set("display_errors", 1);
> error_reporting(E_ALL);
>
> try {
>
> $ignite = new PDO('odbc:Apache Ignite');
> $ignite->setAttribute(PDO::ATTR_ERRMODE,
> PDO::ERRMODE_EXCEPTION);
>
> $sql = 'CREATE TABLE IF NOT EXISTS test_md5 (id int PRIMARY
> KEY, userkey
> LONGVARCHAR, server LONGVARCHAR, tsession LONGVARCHAR, tpost LONGVARCHAR,
> tget LONGVARCHAR, adddate int) WITH
> "atomicity=transactional,cachegroup=somegroup"';
> $ignite->exec($sql);
>
> for($i=0; $i <= 10; $i++){
> $dbs = $ignite->prepare("INSERT INTO test_md5 (id,
> userkey, server,
> tsession, tpost, tget, adddate) VALUES ($i, 'Lorem ipsum dolor sit amet,
> consectetur adipiscing elit, sed do elit, sed', 'b', 'c', 'd', 'e', 1)");
> $dbs->execute();
> }
>
>
> } catch (PDOException $e) {
> print "Error!: " . $e->getMessage() . "\n";
> die();
> }
>
> ?>
>
> String length is 73 characters...
>
> After when I try to read data from Ignite by similar code:
>
> $stmt = $ignite->prepare("select * from test_md5");
> $endTime = microtime(true);
>
> $stmt->execute();
> $rows = $stmt->fetchAll();
>
> foreach($rows as $item){
> echo var_dump($item);
> die();
> }
>
> I have fallowing results:
>
> array(14) { ["ID"]=> string(1) "0" [0]=> string(1) "0" ["USERKEY"]=> NULL
> [1]=> NULL ["SERVER"]=> string(1) "b" [2]=> string(1) "b" ["TSESSION"]=>
> string(1) "c" [3]=> string(1) "c" ["TPOST"]=> string(1) "d" [4]=> string(1)
> "d" ["TGET"]=> string(1) "e" [5]=> string(1) "e" ["ADDDATE"]=> string(1)
> "1"
> [6]=> string(1) "1" }
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
