PHP: Difference between revisions
| Line 179: | Line 179: | ||
==nuDebug== | ==nuDebug== | ||
{{Template:php_sprera | |||
<!--PHP SYNTAX, PARAMETERS, RETURN, EXAMPLE, RESULT ALSOSEE--> | |||
|syntax=<!-- SYNTAX --><span style='color:#690497'> | |||
nuAddJavascript($string1) | |||
</span>|parameters=<!-- PARAMETERS --><pre> | |||
$string1 : Javascript code. | |||
</pre>|return=<!-- RETURN --><pre> | |||
</pre>|description=<!-- DESCRIPTION --> | |||
This function takes up to 10 parameters and creates a record in the '''Debug''' Form for testing purposes. | This function takes up to 10 parameters and creates a record in the '''Debug''' Form for testing purposes. | ||
|example=<!-- EXAMPLE --><pre style="background-color:#F2EBFF"> | |||
$s = 'Hello world'; | |||
$a = [1,2,3,4]; | |||
$o = ['name' => 'Bob', 'phpne' => '555 123456']; | |||
nuDebug($s, $a, $o); | |||
nuAddJavascript($j); | |||
</pre>|result=<!-- RESULT --><pre> | |||
</pre>|alsosee=<!-- SEE ALSO --> | |||
|}} | |||
==nuDisplayError== | ==nuDisplayError== | ||
This adds an error that will stop the current event running and display the error message. | This adds an error that will stop the current event running and display the error message. | ||
Revision as of 01:30, 12 July 2017
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_array, 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
nuAddJavascript($string1)
Parameters
$string1 : Javascript code.
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', 'phpne' => '555 123456']; nuDebug($s, $a, $o); nuAddJavascript($j);
Also See :
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.
nuRemoveNonCharacters
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 '__'.