DBI

DataBase Independent package - Unified database access. Extends PHP PDO class.
DataSourceName (dsn) structure: driver://user.password@host/database
Null PHP variable value is treated as database NULL value.

dbi::FETCH_ASSOC_ARRAY

Constant same as PDO::FETCH_ASSOC | PDO::FETCH_GROUP | PDO::FETCH_UNIQUE
return array resultset where key of a record row array is not numeric index but first field value

<?php
  $rows = $db->select ("SELECT ID, Name, Currency, ISOCode FROM Countries", null, null, null, dbi::FETCH_ASSOC_ARRAY);
?>
// $rows value:
Array
(
    [SI] => Array
        (
            [Name] => Slovenija
            [Currency] => EUR
            [ISOCode] => 978
        )
    [IT] => Array
        (
            [Name] => Italia
            [Currency] => EUR
            [ISOCode] => 978
        )
    [GB] => Array
        (
            [Name] => United Kingdom
            [Currency] => GBP
            [ISOCode] => 826
        )
)

dbi::$debug

Global static boolean property to turn on or off debug info dump (shows how SQL is composed and how parameters are bind)

array dbi::splitDSN (string $dsn)

Splits data source name into array parts (driver, db, host, port, user, password)

array dbi::expr (string $value)

Builds internal array structure of database expression for field value.

<?php
$fieldValue = dbi::expr("CURDATE()");
?>

array dbi::exprNull (any $value = null, bool $strict = false)

Creates NULL expresion. Optional can test $value value.
<?php
$fieldValue = dbi::exprNull(); // NULL
$fieldValue = dbi::exprNull("test"); // test
$fieldValue = dbi::exprNull(0); // NULL
$fieldValue = dbi::exprNull(0, true); // 0
?>

array dbi::isExpr ($value)

Tests if $value is internal array structure of database expression for field value.

string dbi::getExpr ($value)

If $value is expression return expression as string value or else database NULL expression.
<?php
$result = dbi::getExpr(dbi::expr ("CURDATE()"); // "CURDATE()"
$result = dbi::getExpr(12); // "NULL"
?>

__construct (string $dsn, bool $ownStatementClass = false)

Constructor of class










Common parameters to all functions:

 

string form::hidden (string $name, string $value = null, array $attributes = array())

Builds HTML hidden input element.
<?php
// Outputs: <input type="hidden" name="actionID" value="save");
echo form::hidden ("actionID", "save");

// Outputs: <input type="hidden" name="actionID" id="actionID" value="save");
echo form::hidden ("#actionID", "save");
?>

string password (string $name, string $value = null, array $attributes = array())

Builds HTML password input element.

string select (string $name, mixed $value = null, array $options = array(), array $attributes = array())

Builds HTML select input element. Options can be grouped. Parameter $value can be string (single select or dropdown) or array type (multi select).

string selectMulti (string $name, mixed $value = null, array $options = array(), array $attributes = array())

Builds jQuery multi select dropdown widget. In dropdown is included filtering, user can select one or more options.
For list of options see authors page.

string selectFilter (string $name, string $select, array $attributes = array())

Builds HTML text input element with $name and binds it to HTML select element. $select can be select element id or any jQuery selector. $attributes are HTML text input element attributes and/or filtering options.
data-filtergroup => false: default; apply filter on select options
data-filtergroup => true: apply filter on select group options (all options of filtered groups are displayed)
<?php
  // creates and binds text input with id "countryFilter" to select with id "countries"
  echo form::selectFilter("#countryFilter", "#countries").
       form::select("#countries", $selectedCountry, $countriesOpt, array ("size" => 40));
?>

string text (string $name, string $value = null, array $attributes = array())

Builds HTML text input element.

.
 

© 2003-18 iNeta d.o.o. | Koroška cesta 31, SI-4000 Kranj | info@ineta.si | Pravno obvestilo
Powered by BravoCMS