[ Posted by TrapenokVictor ] CometQL example

fiddle_049668.php

<?php
 
$short_connect = new mysqli("app.comet-server.ru", "15", "lPXBFPqNg3f661JcegBY0N0dPXqUBdHXqj2cHf04PZgLHxT6z55e20ozojvMRvB8", "CometQL_v1");
 
$sql = "show status";	

//result is boolean for query other than SELECT, SHOW, DESCRIBE and EXPLAIN
$result = $short_connect->query($sql);

if (($result) && ($result->num_rows > 0))
{
	$results = array();

	//convert query result into an associative array
	while ($row = $result->fetch_assoc())
	{
		$results[] = $row;
	}
    echo "<pre>";
	var_dump($results);  
    echo "</pre>"; 
 
	$result->free(); 
}

$short_connect->close(); 
?>