📕
Sprnva Docs
  • Introduction
  • What's New?
  • Installation
    • Requirements
    • Download Sprnva zip no composer required
    • Install Sprnva Using Composer
    • Setup Config
  • Deployment
  • File Structure
  • Database
    • Select
    • SelectLoop
    • Insert
    • Update
    • Delete
    • Query
    • Seeder
    • Paginate
    • With
    • andFilter
    • withCount
    • get
  • Query Builder
  • Migration
    • INSTANCES
      • NEW
      • RENAMETABLE
      • DROP
      • CHANGE
    • DUMPS
      • dump
      • dump prune
    • MAKE
    • MIGRATE
      • migrate
      • migrate fresh
    • ROLLBACK
  • Routing
    • with parameter
    • multiple parameters
    • with closure
    • group
    • controller grouping
  • Controllers
    • methods
  • Views
    • Passing Parameters
  • Validation
    • validate
      • validation type
  • Authentication
  • Alert Messages
  • Default Helpers
  • CSRF Protection
  • Email
  • Packages
    • Fortify
  • Themes and Templates
Powered by GitBook
On this page

Database

Sprnva has a query builder that is flexible and easy enough to use. Sprnva database connection uses PDO and you don't have to do anything.

The database connection and querybuilder instance is accessible using the DB() helper.

Sprnva query builder has:

  • select

  • selectLoop

  • insert

  • update

  • delete

  • query

  • seeder

  • with

  • andFilter

  • withCount

  • get

How to use this database querybuilder?

Declare the querybuilder and connection instance first then the method.

PreviousFile StructureNextSelect

Last updated 2 years ago