PHP
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);
[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);
}
[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]);
}
[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']);
}
[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);
[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);
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);
[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 message.
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!');
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!');
Also See :
nuHasNewRecordID
Returns true or false.
nuID
$string = nuID()
Parameters
Return Value
$string : random string.
Description
Creates a random string.
Example
nuDebug(nuID());
[0] : s14998774217939
Also See :
nuRemoveNonCharacters
$string = nuRemoveNonCharacters($string1)
Parameters
$string1 : A string 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}}}
[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);
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);
Also See :
nuSubformObject
$object = nuSubformObject($string1)
Parameters
$string1 : subform id.
Return Value
$object : subform properties
Description
Returns a PHP object that can be looped through.
Example
nuDebug(nuSubformObject('invoice_item_sf'));
[0] : stdClass Object
(
[id] => invoice_item
[foreign_key] => ite_invoice_id
[primary_key] => invoice_item_id
[object_id] => 58a09180222faae
[table] => invoice_item
[action] => save
[rows] => Array
(
[0] => Array
(
[0] => s14941671441215
[1] => 6
[2] => thing1
[3] => 3
[4] => 18
[5] => 0
)
[1] => Array
(
[0] => s14998769369058
[1] => 4
[2] => thing2
[3] => 2
[4] => 8
[5] => 0
)
[2] => Array
(
[0] => -1
[1] =>
[2] =>
[3] =>
[4] =>
[5] => 1
)
)
[edited] => Array
(
[0] => Array
(
[0] => 0
[1] => 0
[2] => 0
[3] => 0
[4] => 0
[5] => 0
)
[1] => Array
(
[0] => 0
[1] => 0
[2] => 0
[3] => 0
[4] => 0
[5] => 0
)
[2] => Array
(
[0] => 0
[1] => 0
[2] => 0
[3] => 0
[4] => 0
[5] => 0
)
)
[deleted] => Array
(
[0] => 0
[1] => 0
[2] => 1
)
[fields] => Array
(
[0] => ID
[1] => ite_units
[2] => ite_thing
[3] => ite_unit_price
[4] => ite_total
[5] => nuDelete
)
)
Also See :
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);
Also See :