PHP

Template:function_header Template:function_footer

db_columns

Template:js_sprera

Template:php_sprera

Template:pdera

Template:dera

Template:pda

db_columns

Parameters:

   .

$s = "SELECT * FROM customer";$t = nuRunQuery($s);while($r = db_fetch_array($t)){nuDebug('His name is : ' . $r->cus_name);}

Description

   Returns an array of fieldnames for a table.

Example <source lang="php">

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

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

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

} </source> Result

   .

Also see

   .

db_fetch_object

{{{1}}}

• Parameters

• Description

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

• Example

<source lang="php">

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

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

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

} </source>

• Result

   .

• Also see

   .

db_fetch_row

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

<source lang="php">

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

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

   nuDebug('The field value is : ' . $r[0]);

}

</source>

db_field_array

A function for looping through the result from nuRunQuery. $r[0]

db_num_rows

The number of records in the result from nuRunQuery.

nuAddJavascript

Adds Javascript to a Form as it is built.

nuDebug

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

nuDisplayError

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

nuDisplayMessage

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

nuGetUserAccess

Returns an array of user information.

nuHasNewRecordID

Returns true or false.

nuID

Creates a random string.

nuIsGlobeadmin

Returns true or false.

nuRunPHP

Run a Procedure.

nuRunPHPHidden

Run a Procedure.

nuRunQuery

Run an SQL query.

nuSetFormValue

Updates Objects after a Lookup value is chosen.

nuSubformObject

Returns a PHP object that can be looped through.

nuTT

Creates a unique ID starting with '__'.