Download the PHP package lazarusphp/querybuilder without Composer

LazarusQB

What is LazarusQB ?

Lazarus QB Is a small Library Designed to write Sql Statements into a readable format.

Requirements

• Knowelege of php
• A webserver with support for php and composer
• lazarusphp/dbmanager Scripts (downloaed with composer install)

How to install ?

If you wish to modify this script to work with your own Database Setu You can just download the files from the Releases sections

Whats included ?

• Select
  • findorfail({id});
  • findbyid({$id});
• Insert
• Update
• Delete
• Joins (inner,left,right and cross)
• Where Statments
  • where
  • orwhere
  • in and not in
  • between and orBetween
  • like and not like orlike orNotlike
• Having
• Order by (support Multiple values)
• Group by

How to use ?

As this script is designed to work with lazarusphp framework the following examples and guides will apply to QB

Instantiating a Connection ?

LazarusQb is designed as a model Driven Query Builder, this means a Class is required in order to connect with the database.

Creating the class (Users.php)

User.php once created is extended to Model, the Model class which eventually extends to the database via the QueryBuilder Core class

The Purpose of the Users.php is mainly to allow the user to Create and apply custom Query Builder Functions More on Custom Code

Making the Connection

Once a Model Class has been created the connection simply needs to be instantiated

Upon making the initial Connection All Sql Statements Will be Accessible, it should also be noted it is not required to specify primary table name as this is done when the Model CLass is created

Users.php will connect to a table name called users, this means if you create a class called UserRoles a table called userroles will be required

Fetching Results (Select)

Obtaining the First Record

to get more control over results it is also possible to use the save() method the Save method is the base method used in both get() and first().

By calling save() access to built in methods like fetchAll() fetch() and rowCount(), this gives more flexibility and freedom with the Querybuilder

Limiting Values within the select statments

it is possible to select specific column from the table by adding values into the select statement

Leaving the select method empty will just call the wildcard (*) and select all values.

Using an alias

this would normally be used with joins but the query Builder also supports a table alias this is done using the as() method

Inserting values

in order to insert data into the database the user is required to specify the values, this is done using our key pair magic method

a new Replace method has been added and works in the same manner as insert

Retrieving last inserted id

Updating Data

Like Insert the update uses the key pair Magic method to pass data to the database

Deleting records

in order to delete a record the delete() method is required.

Please be aware you are required to add a where when using update and delete other wise you will affect all rows For more information on Conditions Click here

the query builder has been implemented with a factory method option called DbQuery and can be used as a replacement to keep creating new instances.

using DBQuery also allows for more freedom when creating tables.