PHP: Difference between revisions
| Line 6: | Line 6: | ||
{{Template:pdera | {{Template:pdera | ||
<!-- SYNTAX --> | |syntax=<!-- SYNTAX --> | ||
$object = db_columns($string1) | $object = db_columns($string1) | ||
<!-- PARAMETERS --> | |parameters=<!-- PARAMETERS --><pre> | ||
$array : Field names. | $array : Field names. | ||
$string1 : Database table name. | $string1 : Database table name. | ||
</pre><!-- DESCRIPTION --> | </pre>|description=<!-- DESCRIPTION --><pre> | ||
Returns an array of field names from a database table. | Returns an array of field names from a database table. | ||
</pre><!-- EXAMPLE --> | </pre>|example=<!-- EXAMPLE --><pre style="background-color:#F2EBFF"> | ||
$a = db_columns('customer'); | $a = db_columns('customer'); | ||
| Line 25: | Line 25: | ||
nuDebug($a); | nuDebug($a); | ||
</pre><!-- RESULT --> | </pre>|result=<!-- RESULT --><pre> | ||
[0] : Array | [0] : Array | ||
| Line 35: | Line 35: | ||
) | ) | ||
</pre><!-- SEE ALSO --> | </pre>|alsosee=<!-- SEE ALSO --> | ||
[[PHP#db_num_rows|db_num_rows]], [[PHP#db_fetch_object|db_fetch_object]], [[PHP#db_fetch_row|db_fetch_row]], [[PHP#db_fetch_array|db_fetch_array]] | [[PHP#db_num_rows|db_num_rows]], [[PHP#db_fetch_object|db_fetch_object]], [[PHP#db_fetch_row|db_fetch_row]], [[PHP#db_fetch_array|db_fetch_array]] | ||
Revision as of 03:02, 11 July 2017
db_columns
$object = db_columns($string1)
Parameters
$array : Field names. $string1 : Database table name.
Return Value
{{{return}}}
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_num_rows, db_fetch_object, db_fetch_row, db_fetch_array
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 '__'.