PHP: Difference between revisions
Line 66: | Line 66: | ||
|syntax=<!-- SYNTAX --><span style='color:#690497'> | |syntax=<!-- SYNTAX --><span style='color:#690497'> | ||
$array = | $array = db_fetch_row($object1) | ||
</span>|parameters=<!-- PARAMETERS --><pre> | </span>|parameters=<!-- PARAMETERS --><pre> | ||
$object1 : nuRunQuery() result. | $object1 : nuRunQuery() result. | ||
Line 79: | Line 79: | ||
while($r = db_fetch_array($t)){ | while($r = db_fetch_array($t)){ | ||
nuDebug('His name is : ' . $r[ | nuDebug('His name is : ' . $r[4]); | ||
} | } | ||
Line 86: | Line 86: | ||
[0]: His name is : Robert Paulson | [0]: His name is : Robert Paulson | ||
</pre>|alsosee=<!-- SEE ALSO --> | </pre>|alsosee=<!-- SEE ALSO --> | ||
[[PHP#db_columns|db_columns]], [[PHP#db_fetch_array|db_fetch_array]], [[PHP#db_fetch_object|db_fetch_object]], [[PHP#db_num_rows|db_num_rows]], [[PHP#nurunquery|nuRunQuery]] | |||
|}} | |}} |
Revision as of 04:36, 11 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
$array = db_fetch_row($object1)
Parameters
$object1 : nuRunQuery() result.
Return Value
$array : 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[4]); }
[0]: His name is : Robert Paulson
Also See :
db_columns, db_fetch_array, db_fetch_object, db_num_rows, nuRunQuery
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.
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 '__'.