<？php $session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");$session->sql("DROP DATABASE IF EXISTS nonsense")->execute();会话- > sql(“创建数据库无稽之谈”)- >执行();会话- > sql(“创建表无稽之谈。Numbers (hello int, world float unsigned)")->execute();会话- > sql(“插入无稽之谈。Numbers values (42,42)")->execute();会话模式= $ - > getSchema(“胡说”);表= $ schema - >可以获得的(“数字”); $result1 = $table->select('hello','world')->execute(); // Returns an array of ColumnResult objects $columns = $result1->getColumns(); foreach ($columns as $column) { echo "\nColumn label " , $column->getColumnLabel(); echo " is type " , $column->getType(); echo " and is ", ($column->isNumberSigned() === 0) ? "Unsigned." : "Signed."; } // Alternatively $result2 = $session->sql("SELECT * FROM nonsense.numbers")->execute(); // Returns an array of FieldMetadata objects print_r($result2->getColumns());

上面的例子将输出类似于:

列标签hello是类型19，并且是Signed。列标签世界是类型4，是Unsigned。数组([0]= > mysql_xdevapi \ FieldMetadata对象([型]= > 1 [type_name] = >它们[名字]= >你好[original_name] = >你好(表)= > [original_table] = >号码(模式)= >废话(目录)= > def(排序)= > 0 [fractional_digits] = > 0(长度)= > 11[标记]= > 0 [content_type] = > 0) [1] = > mysql_xdevapi \ FieldMetadata对象([型]= > 6 [type_name] = >浮动[名字]= > [original_name] = >世界(表)= > [original_table] = >号码(模式)= >废话(目录)= >def [collation] => 0 [fractional_digits] => 31 [length] => 12 [flags] => 1 [content_type] => 0 ) )