PHP

Template:function_header

db_columns

$array = db_columns($string1)

Parameters

$string1 : Database table name.

Return Value

$array   : Field names.

Description

Returns an array of field names from a database table.

Example

$a = db_columns('customer');
nuDebug($a);

nuDebug()

[0] : Array
(
    [0] => customer_id
    [1] => cus_name
    [2] => cus_phone
    [3] => cus_address
)

Also See : db_fetch_array, db_fetch_object, db_fetch_row, db_num_rows

db_fetch_object

$object = db_fetch_object($object1)

Parameters

$object1 : nuRunQuery() result.

Return Value

$object  : PDO object

Description

A function for looping through the result of a SELECT query returned from nuRunQuery.

Example

$s = "SELECT * FROM customer";
$t = nuRunQuery($s);

while($r = db_fetch_object($t)){

    nuDebug('His name is : ' . $r->cus_name);

}

nuDebug()

[0]: His name is : Robert Paulson

Also See : db_columns, db_fetch_array, db_fetch_row, db_num_rows, nuRunQuery

db_fetch_row

$object = db_fetch_row($object1)

Parameters

$object1  : nuRunQuery() result.

Return Value

$object   : PDO object. 

Description

A function for looping through the result of a SELECT query returned from nuRunQuery.

Example

$s = "SELECT * FROM customer";
$t = nuRunQuery($s);

while($r = db_fetch_row($t)){

    nuDebug('His name is : ' . $r[4]);

}

nuDebug()

[0]: His name is : Robert Paulson

Also See : db_columns, db_fetch_array, db_fetch_object, db_num_rows, nuRunQuery

db_fetch_array

$object = db_fetch_array($object1)

Parameters

$object1  : nuRunQuery() result.

Return Value

$object   : PDO object. 

Description

A function for looping through the result of a SELECT query returned from nuRunQuery.

Example

$s = "SELECT * FROM customer";
$t = nuRunQuery($s);

while($r = db_fetch_array($t)){

    nuDebug('His name is : ' . $r['cus_name']);

}

nuDebug()

[0]: His name is : Robert Paulson

Also See : db_columns, db_fetch_row, db_fetch_object, db_num_rows, nuRunQuery

db_num_rows

$integer = db_num_rows($object1)

Parameters

$object1  : PDO object. 

Return Value

$integer  : Number of records returned.

Description

The number of records in the result from nuRunQuery.

Example

	$s = "SELECT * FROM customer";
	$t = nuRunQuery($s);
	
	nuDebug(db_num_rows($t);

nuDebug()

[0]: 3453

Also See : db_columns, db_fetch_array, db_fetch_object, db_fetch_row, nuRunQuery

nuAddJavascript

nuAddJavascript($string1)

Parameters

$string1 : Javascript code.

Return Value

Description

Adds Javascript to a Form before it loads.

Example

$j = "console.log(1234);

nuAddJavascript($j);

nuDebug()

Also See :

nuDebug

nuDebug($anytype1, $anytype2..)

Parameters

$anytypes : string, object or array.

Return Value

Description

This function takes up to 10 parameters and creates a record in the Debug Form for testing purposes.

Example

$s = 'Hello world';
$a = [1,2,3,4];
$o = ['name' => 'Bob', 'phone' => '555 123456'];
nuDebug($s, $a, $o);

nuAddJavascript($j);

nuDebug()

[0] : Hello world

[1] : Array
(
    [0] => 1
    [1] => 2
    [2] => 3
    [3] => 4
)


[2] : Array
(
    [name] => Bob
    [phone] => 555 123456
)

Also See :

nuDisplayError

nuDisplayError($string1)

Parameters

$string1 : error.

Return Value

Description

This adds an error that will stop the current event running and display the error message.

Example

nuDisplayError('That did not work!');

nuDebug()

Also See :

nuDisplayMessage

nuDisplayMessage($string1)

Parameters

$string1 : message.

Return Value

Description

This adds a message that will be displayed after the current event completes.

Example

nuDisplayMessage('That did work!');

nuDebug()

Also See :

nuGetUserAccess

Returns an array of user information.

nuHasNewRecordID

Returns true or false.

nuID

Creates a random string.

nuIsGlobeadmin

Returns true or false.

nuRemoveNonCharacters

$string = nuRemoveNonCharacters($string1)

Parameters

$string1  : Astring with non characters

Return Value

$string  : A string with just characters

Description

Remove tabs, new lines, and carriage returns from a string.

example=

$s = "SELECT cus_name,
cus_phone,
cus_address
FROM customer
";

nuDebug(nuRemoveNonCharacters($s));

Example

{{{example}}}

nuDebug()

[0] : SELECT cus_name,cus_phone,cus_addressFROM customer

Also See :

nuRunQuery

$object = nuRunQuery($string1);

Parameters

$string1 : SQL query.

Return Value

$object  : PDO object.

Description

Runs an SQL query and returns an Object (for SELECT Statements).

This Object can be used by db_fetch_object, db_fetch_array, db_fetch_row, db_num_rows

Example

$s  = "SELECT * FROM customer WHERE customer_id = '#LOOKUP_RECORD_ID#'
        
        ";

$t  = nuRunQuery($s);
$r  = db_fetch_object($t);

nuSetFormValue('inv_address', $r->cus_address);

nuDebug()

Also See : db_fetch_object, db_fetch_array, db_fetch_row, db_num_rows

nuSetFormValue

nuSetFormValue($string1, $string2);

Parameters

$string1 = id of nuBuilder Object on current Edit Form.
$string2 = value used to update $string1's Object.

Return Value

Description

This function is only used in After Browse.

Updates an Object on an Edit Form After Browse after a Lookup value is chosen.

Example

$s  = "SELECT * FROM customer WHERE customer_id = '#LOOKUP_RECORD_ID#'
        
        ";

$t  = nuRunQuery($s);
$r  = db_fetch_object($t);

nuSetFormValue('inv_address', $r->cus_address);

nuDebug()

Also See :

nuSubformObject

Returns a PHP object that can be looped through.

nuTT

$string = nuTT()

Parameters

Return Value

$string  : name for temp table.

Description

Creates a unique ID starting with __nu.

Example

$tmp = nuTT();

$s   = "CREATE TABLE $t SELECT * FROM customer";

nuRunQuery($tmp);

nuDebug()

Also See :