PhpOrient - query()

This method issues an SQL query to the database.

Querying the Database

In the event that you're more comfortable working in SQL, you can build and issue queries to OrientDB directly using this method.

Syntax

$client->query(<sql>)

• <sql> Defines the query you want to issue.

Example

In cases where you find yourself frequently issuing queries to OrientDB, you may find it convenient to construction a function to manage the process.

// QUERY FUNCTION
function queryDatabase($className, 
			$properties = array('*'), 
			$whereConditions = array(), 
			$limit = 0){

	// LOG OPERATION
	echo "Querying $className";

	// FETCH GLOBAL CLIENT
	global $client;

	// CONSTRUCT SELECT STATEMENT
	if ($properties == array('*')) {
		$sql = "SELECT FROM $classname";
	} else {
		$props = join(', ', $properties)
		$sql = "SELECT $prop FROM $classname";
	}

	// CONSTRUCT WHERE CLAUSE
	if ($whereConditions != array()){
		$where = "WHERE";

		// LOOP OVER CONDITIONS
		foreach($whereConditions as $property => $value){
			$where = "$where $property = \'$value\'";
		}

		// ADD WHERE TO STATEMENT
		$sql = "$sql $where";
	}

	// ADD LIMIT
	if ($limit > 0){

		// ADD LIMIT TO STATEMENT
		$sql = "$sql LIMIT $limit";
	}

	// QUERY DATABASE
	return $client->query($sql);
}