Documentation

Database extends AbstractModel
in package

Database model class

Tags
category

Pop\Kettle

author

Nick Sagona, III dev@nolainteractive.com

copyright

Copyright (c) 2009-2024 NOLA Interactive, LLC. (http://www.nolainteractive.com)

license

http://www.popphp.org/license New BSD License

version
2.3.2

Table of Contents

Properties

$data  : mixed
Array data

Methods

__construct()  : mixed
Constructor
__get()  : mixed
Get a value
__isset()  : bool
Is value set
__serialize()  : mixed
Serialize magic method
__set()  : static
Magic method to set the property to the value of $this->data[$name]
__unserialize()  : ArrayObject
Unserialize magic method
__unset()  : void
Unset a value
clear()  : Database
Clear database
configure()  : Database
Configure database
contains()  : bool
Determine if an item exists in the array
count()  : int
Method to get the count of data in the collection
createAdapter()  : AbstractAdapter
Create database adapter
createFromJson()  : ArrayObject
Create array object from JSON string
createFromSerialized()  : ArrayObject
Create array object from serialized string
current()  : mixed
Get the current item of the array
export()  : Database
Export database
first()  : mixed
Get the first item of the array
getIterator()  : ArrayIterator
Method to iterate over the array object
import()  : Database
Import database
install()  : Database
Install SQL
join()  : string
Join the array values into a string
jsonSerialize()  : string
JSON serialize the array object
jsonUnserialize()  : ArrayObject
Unserialize a JSON string
key()  : mixed
Get the key of the current item of the array
ksort()  : array<string|int, mixed>
Sort array by keys
ksortDesc()  : static
Sort array by keys, descending
last()  : mixed
Get the last item of the array
next()  : mixed
Get the next item of the array
offsetExists()  : bool
ArrayAccess offsetExists
offsetGet()  : mixed
ArrayAccess offsetGet
offsetSet()  : void
ArrayAccess offsetSet
offsetUnset()  : void
ArrayAccess offsetUnset
reset()  : Database
Reset database
seed()  : Database
Seed database
serialize()  : string
Serialize the array object
sort()  : array<string|int, mixed>
Sort array
sortDesc()  : static
Sort array descending
split()  : static
Split a string into an array object
test()  : string|bool
Test database connection
toArray()  : array<string|int, mixed>
Get the values as an array
uksort()  : array<string|int, mixed>
Sort array by user-defined callback using keys
unserialize()  : ArrayObject
Unserialize a string
usort()  : static
Sort array by user-defined callback

Properties

Methods

__construct()

Constructor

public __construct([mixed|null $data = null ]) : mixed

Instantiate the array object

Parameters
$data : mixed|null = null
Tags
throws
Exception

__get()

Get a value

public __get(string $name) : mixed
Parameters
$name : string

__isset()

Is value set

public __isset(string $name) : bool
Parameters
$name : string
Return values
bool

__serialize()

Serialize magic method

public __serialize() : mixed

__set()

Magic method to set the property to the value of $this->data[$name]

public __set([string|null $name = null ][, mixed $value = null ]) : static
Parameters
$name : string|null = null
$value : mixed = null
Return values
static

__unserialize()

Unserialize magic method

public __unserialize(array<string|int, mixed> $data) : ArrayObject
Parameters
$data : array<string|int, mixed>
Return values
ArrayObject

__unset()

Unset a value

public __unset(string $name) : void
Parameters
$name : string

clear()

Clear database

public clear(Console $console, string $location[, string $database = 'default' ]) : Database
Parameters
$console : Console
$location : string
$database : string = 'default'
Return values
Database

configure()

Configure database

public configure(Console $console, string $location[, string $database = 'default' ]) : Database
Parameters
$console : Console
$location : string
$database : string = 'default'
Return values
Database

contains()

Determine if an item exists in the array

public contains(mixed $key[, bool $strict = false ]) : bool
Parameters
$key : mixed
$strict : bool = false
Return values
bool

count()

Method to get the count of data in the collection

public count() : int
Return values
int

createAdapter()

Create database adapter

public createAdapter(array<string|int, mixed> $database) : AbstractAdapter
Parameters
$database : array<string|int, mixed>
Return values
AbstractAdapter

createFromJson()

Create array object from JSON string

public static createFromJson(string $jsonString[, int $depth = 512 ][, int $options = 0 ]) : ArrayObject
Parameters
$jsonString : string
$depth : int = 512
$options : int = 0
Return values
ArrayObject

createFromSerialized()

Create array object from serialized string

public static createFromSerialized(string $string) : ArrayObject
Parameters
$string : string
Tags
throws
Exception
Return values
ArrayObject

current()

Get the current item of the array

public current() : mixed

export()

Export database

public export(Console $console, string $location[, string $database = 'default' ]) : Database
Parameters
$console : Console
$location : string
$database : string = 'default'
Return values
Database

first()

Get the first item of the array

public first() : mixed

getIterator()

Method to iterate over the array object

public getIterator() : ArrayIterator
Return values
ArrayIterator

import()

Import database

public import(Console $console, string $location, string $importFile[, string $database = 'default' ]) : Database
Parameters
$console : Console
$location : string
$importFile : string
$database : string = 'default'
Return values
Database

install()

Install SQL

public install(array<string|int, mixed> $database, string $sqlFile) : Database
Parameters
$database : array<string|int, mixed>
$sqlFile : string
Return values
Database

join()

Join the array values into a string

public join(string $glue[, string $finalGlue = '' ]) : string
Parameters
$glue : string
$finalGlue : string = ''
Return values
string

jsonSerialize()

JSON serialize the array object

public jsonSerialize([int $options = 0 ][, int $depth = 512 ]) : string
Parameters
$options : int = 0
$depth : int = 512
Return values
string

jsonUnserialize()

Unserialize a JSON string

public jsonUnserialize(string $jsonString[, int $depth = 512 ][, int $options = 0 ]) : ArrayObject
Parameters
$jsonString : string
$depth : int = 512
$options : int = 0
Return values
ArrayObject

key()

Get the key of the current item of the array

public key() : mixed

ksort()

Sort array by keys

public ksort([int $flags = SORT_REGULAR ][, bool $descending = false ]) : array<string|int, mixed>
Parameters
$flags : int = SORT_REGULAR
$descending : bool = false
Return values
array<string|int, mixed>

ksortDesc()

Sort array by keys, descending

public ksortDesc([int $flags = SORT_REGULAR ]) : static
Parameters
$flags : int = SORT_REGULAR
Return values
static

offsetExists()

ArrayAccess offsetExists

public offsetExists(mixed $offset) : bool
Parameters
$offset : mixed
Return values
bool

offsetGet()

ArrayAccess offsetGet

public offsetGet(mixed $offset) : mixed
Parameters
$offset : mixed

offsetSet()

ArrayAccess offsetSet

public offsetSet(mixed $offset, mixed $value) : void
Parameters
$offset : mixed
$value : mixed

offsetUnset()

ArrayAccess offsetUnset

public offsetUnset(mixed $offset) : void
Parameters
$offset : mixed

reset()

Reset database

public reset(Console $console, string $location[, string $database = 'default' ]) : Database
Parameters
$console : Console
$location : string
$database : string = 'default'
Return values
Database

seed()

Seed database

public seed(Console $console, string $location[, string $database = 'default' ]) : Database
Parameters
$console : Console
$location : string
$database : string = 'default'
Return values
Database

serialize()

Serialize the array object

public serialize([bool $self = false ]) : string
Parameters
$self : bool = false
Return values
string

sort()

Sort array

public sort([int $flags = SORT_REGULAR ][, bool $assoc = true ][, bool $descending = false ]) : array<string|int, mixed>
Parameters
$flags : int = SORT_REGULAR
$assoc : bool = true
$descending : bool = false
Return values
array<string|int, mixed>

sortDesc()

Sort array descending

public sortDesc([int $flags = SORT_REGULAR ][, bool $assoc = true ]) : static
Parameters
$flags : int = SORT_REGULAR
$assoc : bool = true
Return values
static

split()

Split a string into an array object

public static split(string $string, string $separator[, int $limit = PHP_INT_MAX ]) : static
Parameters
$string : string
$separator : string
$limit : int = PHP_INT_MAX
Return values
static

test()

Test database connection

public test(array<string|int, mixed> $database) : string|bool
Parameters
$database : array<string|int, mixed>
Return values
string|bool

toArray()

Get the values as an array

public toArray() : array<string|int, mixed>
Return values
array<string|int, mixed>

uksort()

Sort array by user-defined callback using keys

public uksort(mixed $callback) : array<string|int, mixed>
Parameters
$callback : mixed
Return values
array<string|int, mixed>

usort()

Sort array by user-defined callback

public usort(mixed $callback[, bool $assoc = true ]) : static
Parameters
$callback : mixed
$assoc : bool = true
Return values
static 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results