PHP: Difference between revisions
| Line 6: | Line 6: | ||
{{Template:pdera | {{Template:pdera | ||
|syntax= | |syntax=<!-- ========= SYNTAX ======== --> | ||
<!-- =========SYNTAX======== --> | |||
db_columns | db_columns | ||
|parameters=<!-- =========PARAMETERS======== --> | |parameters=<!-- ========= PARAMETERS ======== --> | ||
<pre>$string1 : Database tablename</pre> | <pre>$string1 : Database tablename</pre> | ||
|description= | |description=<!-- ========= DESCRIPTION ======== --> | ||
<!-- =========DESCRIPTION======== --> | |||
<pre>Returns an array of fieldnames from a table.</pre> | <pre>Returns an array of fieldnames from a table.</pre> | ||
|example= | |example=<!-- ========= EXAMPLE ======== --> | ||
<!-- =========EXAMPLE======== --> | |||
<pre style="background-color:#F2EBFF"> | <pre style="background-color:#F2EBFF"> | ||
| Line 35: | Line 32: | ||
</pre> | </pre> | ||
|result= | |result=<!-- ========= RESULT ======== --> | ||
<!-- =========RESULT======== --> | |||
<pre><b>Result</b></hr> | <pre><b>Result</b></hr> | ||
| Line 42: | Line 38: | ||
</pre> | </pre> | ||
|alsosee= | |alsosee=<!-- ========= SEE ALSO ======== --> | ||
<!-- ========= | |||
<pre>66</pre> | <pre>66</pre> | ||
Revision as of 02:17, 11 July 2017
db_columns
db_columns
Parameters
$string1 : Database tablename
Return Value
{{{return}}}
Description
Returns an array of fieldnames from a table.
Example
$s = "SELECT * FROM customer";
$t = nuRunQuery($s);
while($r = db_fetch_array($t)){
nuDebug('His name is : ' . $r->cus_name);
}
<b>Result</b></hr> 5555
Also See :
66
db_fetch_object
- 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.
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 '__'.