must be specified as an integer<\/b>\u00c2\u00a0while all the other database configuration values like host or cluster name can be strings.<\/p>\n<?php\n include('griddb_php_client.php');\n $factory = StoreFactory::get_default();\n $update = true;\n try {\n \/\/Get GridStore object\n $gridstore = $factory->get_store(array(\"notificationAddress\" => $argv[1],\n \"notificationPort\" => $argv[2],\n \"clusterName\" => $argv[3],\n \"user\" => $argv[4],\n \"password\" => $argv[5]\n ));\n } catch(GSException $e){\n echo($e->what().\"n\");\n echo($e->get_code().\"n\");\n }\n?>\n<\/pre>\nCreating Row Schemas in PHP<\/h3>\n
Schemas for containers and rows can be created using arrays with GridDB API types.
\nYou can simply use two-dimensional array<\/i>\u00c2\u00a0of interfaces to map the column types for your container. From there you can create a container schema (array(array())<\/code>) by using ->put_container()<\/code> method. You can use and insert these\u00c2\u00a0schemas<\/i>\u00c2\u00a0to create containers.
\nRows<\/b>\u00c2\u00a0can be modeled using GridDB API specific functions. To create a row just create a row object ( $row = $ts->create_row();<\/code>) and then set each field using the GridDB API functions,\u00c2\u00a0and have each index mapped to each corresponding value.
\nFor example, if in a container the second column stores a boolean with the value of false<\/code>, then the value should be mapped as $row->set_field_by_bool(1, false);<\/code>.<\/p>\n\/\/ Creating container info\n#Create ContainerInfo\n $conInfo =\n\/\/ Creating schema for our TimeSeries Container\n\/\/ The first column is always the row key\n#Create TimeSeries\n $ts = $gridstore->put_container(\"point01\", array(array(\"timestamp\" => GS_TYPE_TIMESTAMP),\n array(\"active\" => GS_TYPE_BOOL),\n array(\"voltage\" => GS_TYPE_DOUBLE)),\n GS_CONTAINER_TIME_SERIES);\n #Create and set row data\n $row = $ts->create_row();\n $row->set_field_by_timestamp(0, TimestampUtils::current());\n $row->set_field_by_bool(1, false);\n $row->set_field_by_double(2, 100);\n #Put row to timeseries with current timestamp\n $ts->put_row($row);\n<\/pre>\nYou can also obtain a\u00c2\u00a0Row<\/b>\u00c2\u00a0with a simple call to the get_next();<\/code> method on the container with the name of the row object. As mentioned before, a row is created using GridDB\u00c2\u00a0 API methods, all one needs to do to access the column value is to reference the\u00c2\u00a0row-index<\/i>\u00c2\u00a0of the column.<\/p>\n \/\/Create Collection\n $col = $gridstore->put_container(\"col01\", array(array(\"name\" => GS_TYPE_STRING),\n array(\"status\" => GS_TYPE_BOOL),\n array(\"count\" => GS_TYPE_LONG),\n array(\"lob\" => GS_TYPE_BLOB)),\n GS_CONTAINER_COLLECTION);\n \/\/Change auto commit mode to false\n $col->set_auto_commit(false);\n \/\/Set an index on the Row-key Column\n $col->create_index(\"name\", GS_INDEX_FLAG_DEFAULT);\n \/\/Set an index on the Column\n $col->create_index(\"count\", GS_INDEX_FLAG_DEFAULT);\n \/\/Create and set row data\n $row = $col->create_row(); \/\/Create row for refer\n $row->set_field_by_string(0, \"name01\");\n $row->set_field_by_bool(1, False);\n $row->set_field_by_long(2, 1);\n $row->set_field_by_blob(3, \"ABCDEFGHIJ\");\n \/\/Put row: RowKey is \"name01\"\n $col->put_row($row);\n $col->commit();\n $row2 = $col->create_row(); \/\/Create row for refer\n $col->get_row_by_string(\"name01\", True, $row2); \/\/Get row with RowKey \"name01\"\n $col->delete_row_by_string(\"name01\"); \/\/Remove row with RowKey \"name01\"\n \/\/Put row: RowKey is \"name02\"\n $col->put_row_by_string(\"name02\", $row);\n $col->commit();\n \/\/Create normal query\n $query = $col->query(\"select * where name = 'name02'\");\n \/\/Execute query\n $rrow = $col->create_row();\n $rs = $query->fetch($update);\n while ($rs->has_next()){\n $rs->get_next($rrow);\n $name = $rrow->get_field_as_string(0);\n $status = $rrow->get_field_as_bool(1);\n $count = $rrow->get_field_as_long(2) + 1;\n $lob = $rrow->get_field_as_blob(3);\n echo(\"Person: name=$name status=\");\n echo $status ? 'true' : 'false';\n echo(\" count=$count lob=$lobn\");\n \/\/Update row\n $rrow->set_field_by_long(2, $count);\n $rs->update_current($rrow);\n }\n \/\/End transaction\n $col->commit();\n<\/pre>\nQueries and Data Management<\/h3>\n
Once you have your containers populated with data and inserted into GridDB, you are ready to query and fetch your data. Similar to the Python or Java APIs, all you need to is to construct a\u00c2\u00a0Query object<\/b>\u00c2\u00a0(by using the query method from a container object $query = $ts->query(\"select * \");<\/code>) with the specific query you would like to issue to your container. Once that is done, simply fetch the query\u00e2\u20ac\u2122s results and store it in the query object.<\/p>\n\n- Note: <\/b> if you want to select specific rows to update, you must set the commit-mode<\/i> of the container you are trying update to false<\/i>.<\/li>\n<\/ul>\n
Once you have finished with updating row values, you can simply ->commit();<\/code> the changes.<\/p>\nConclusion<\/h3>\n
It should now be quite easy to connect and manage your GridDB cluster using PHP. With all the various utilities offered by the GridDB PHP Client,\u00c2\u00a0storing data and developing high-performance PHP applications with GridDB should now be possible.<\/p>\n