PHP: Difference between revisions
| Line 2: | Line 2: | ||
Returns an array of fieldnames for a table. | Returns an array of fieldnames for a table. | ||
==db_fetch_array== | ==db_fetch_array== | ||
<div style='font-size: | <div style='background-color:#F2F3F4;padding:5px;'> | ||
= | <div style='font-size:20px;background-color:#F2F3F4;padding:10px;color:#690497'>db_fetch_array</div> | ||
<div style='font-size:16px;background-color:#F2F3F4;padding:10px;color:grey'>Parameters</div> | |||
<div style='background-color:#F2F3F4;padding:10px'>A function for looping through the result of a SELECT query returned from [[PHP#nuRunQuery|nuRunQuery]].</div> | |||
<div style='font-size:16px;background-color:#F2F3F4;padding:10px;color:grey'>Description</div> | |||
::A function for looping through the result of a SELECT query returned from [[PHP#nuRunQuery|nuRunQuery]]. | |||
<div style='font-size:16px;background-color:#F2F3F4;padding:10px;color:grey'>Example</div> | |||
<source lang="php"> | <source lang="php"> | ||
| Line 18: | Line 21: | ||
} | } | ||
</source> | </source> | ||
= | |||
<div style='font-size:16px;background-color:#F2F3F4;padding:10px;color:grey'>Result</div> | |||
<code> | <code> | ||
[0] : His name is : Robert Paulson | [0] : His name is : Robert Paulson | ||
Revision as of 02:19, 10 July 2017
db_columns
Returns an array of fieldnames for a table.
db_fetch_array
- 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_array($t)){
nuDebug('His name is : ' . $r['cus_name']);
} </source>
[0] : His name is : Robert Paulson
db_fetch_object
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('The field value is : ' . $r->cus_name);
}
</source>
- Result
[0] = The field value is : Bob
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.
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 '__'.