Download the PHP package jaxonrailey/vane without Composer
On this page you can find all versions of the php package jaxonrailey/vane. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package vane
Vane
Vane is a PHP package that allows you to query a document in nodes, therefore with the typical structure of a noSQL database, but using a familiar and intuitive syntax, through methods inspired by the SQL language.
Installation
To install the package, run this command from a terminal
How to use
Once installed, include the namespace
Initialize an instance of Vane
Example
Consider the following array on which we will do some queries:
Basic use
Select
Insert
Update
Delete
Truncate
Advanced use
Select elements based on whether a given value is contained in a property of type array:
Select elements based on whether a given value is not contained in a property of type array:
Select elements based on whether a given property exists:
Select elements based on whether a given property does not exist:
Select elements that have more than x elements in an array property:
Select a single item based on its identifier:
The select statement can also accept individual properties:
nested properties can be used via dot notation:
Sugar syntax
In both the counter method and the where method, you can pass as few as two parameters, the property name and the value to compare, thus suppressing the condition symbol. In this case it means that the condition operator is the equal sign (=)
is equivalent to:
The same is true for the counter method:
is equivalent to:
:star: If you liked what I did, if it was useful to you or if it served as a starting point for something more magical let me know with a star :green_heart: