CUBRID_NUM_FIELDS(3) 1 CUBRID_NUM_FIELDS(3)cubrid_num_fields - Return the number of columns in the result setSYNOPSIS
int cubrid_num_fields (resource $result)
DESCRIPTION
This function returns the number of columns in the result set, on success, or it returns FALSE on failure.
PARAMETERS
o $result
-$result comes from a call to cubrid_execute(3), cubrid_query(3) and cubrid_prepare(3)RETURN VALUES
Number of columns, on success.
-1 if SQL sentence is not SELECT.
FALSE when process is unsuccessful.
EXAMPLES
Example #1
cubrid_num_fields(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$req = cubrid_execute($conn, "SELECT * FROM code");
$row_num = cubrid_num_rows($req);
$col_num = cubrid_num_fields($req);
printf("Row Num: %d
Column Num: %d
", $row_num, $col_num);
cubrid_disconnect($conn);
?>
The above example will output:
Row Num: 6
Column Num: 2
PHP Documentation Group CUBRID_NUM_FIELDS(3)
Check Out this Related Man Page
CUBRID_FIELD_TABLE(3) 1 CUBRID_FIELD_TABLE(3)cubrid_field_table - Return the name of the table of the specified fieldSYNOPSIS
string cubrid_field_table (resource $result, int $field_offset)
DESCRIPTION
This function returns the name of the table of the specified field. This is useful when using large select queries with JOINS.
PARAMETERS
o $result
-Array type of the fetched result CUBRID_NUM, CUBRID_ASSOC, CUBRID_BOTH.
o $field_offset
- The numerical field offset. The $field_offset starts at 0. If $field_offset does not exist, an error of level E_WARNING is also
issued.
RETURN VALUES
Name of the table of the specified field, on success.
FALSE when invalid field_offset value.
-1 if SQL sentence is not SELECT.
EXAMPLES
Example #1
cubrid_field_table(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$result = cubrid_execute($conn, "SELECT * FROM code");
$col_num = cubrid_num_cols($result);
printf("%-15s %-15s %s
", "Field Table", "Field Name", "Field Type");
for($i = 0; $i < $col_num; $i++) {
printf("%-15s %-15s %s
",
cubrid_field_table($result, $i), cubrid_field_name($result, $i), cubrid_field_type($result, $i));
}
cubrid_disconnect($conn);
?>
The above example will output:
Field Table Field Name Field Type
code s_name char
code f_name varchar
PHP Documentation Group CUBRID_FIELD_TABLE(3)
Hi all,
I have a file with several columns of data, eg:
A B C D
1 2 5 1
2 2 2 2
8 4 4 4
4 2 3 4
10 9 4 4
9 7 1 2
I need to get the values from, say, column B and place them into a string separated by a semicolon, eg:
2;2;4;2;9;7
Does... (4 Replies)
Hello all,
I do not understand the meaning of some columns in the result of executing 'ls -l'. For example, i got the following result by run 'ls -l'
total 3531
-rw-r--r-- 1 root root 1351680 Oct 17 20:50 fileindex.rpm
-rw-r--r-- 1 root root 16384 Oct 17 20:50 groupindex.rpm ... (5 Replies)
I understand this question probably poses some child like stupidity, but I can't get this if statement to work for love or money.
#!/bin/ksh
echo "Input either 1 or 2"
read Num
if ; then
echo "Message 1"
if ; then
echo "Message 2"
else
echo "false"
fi
$ ksh decisions
Input either 1... (6 Replies)
Hi,
I cant seem to figure out how I add a character to an existing one. Heres my problem.
So I have a line that looks like this:
>56
584848392394958586858484849393
What I want to do is add Num in front of the 56. So basically I want to recognize the > and add Num in front of the... (6 Replies)
Hi,
I want to compare two columns and find out missing entries e:g
Column 1 Column 2
1 1
2 2
3 13
4
10
19
234
Results woud be 13. I will appreciate very much if anyone help me :). (12 Replies)
I have a tool which generates results in a file at every minute and which has following columns.
I need to create a script checks this file constantly and if Column ( QOM ) has value more then "30S" it should send an email.
Can anybody help ?
Thansk a lot.
Time MxML MxQD G P OIC OUC MDC... (11 Replies)
Hi,
I am fairly new to Unix scripting. We are running Solaris 5.10.
I have the following question: Assume a text file with one text
column, followed by 2 integer columns.
How would I generate a script or, preferably, a command that will output
the rows in which the value of the third... (6 Replies)
Hallo Fiends,
I have a .csv file which has 2 columns. 1st Column is the RATE and second is Destination. The 2 columns are separated by ,
Here is the example of how the file looks now:
2.35,38022|38038|38039|38044|38050|38057|3806|380700|38091|38093|38095|38096|38097|38098|38099
1.67,380... (6 Replies)
Hi,
I am selecting few columns from a table using select query in UNIX shell script ans sending the results as E-mail. But the column headings are not displayed fully. Instead it displays only a part of the heading. Please help as how to display it fully.
Thanks in advance for your help. (7 Replies)
HI Guys,
I just want to replace data for First Column and Row Cell(1,1)
Input :-
Hello A B C
X 1 2 3
Y 4 5 6
Z 7 8 9
Output:-
Byee A B C
X 1 2 3
Y 4 5 6
Z 7 8 9
From Hello to Byee .....And The Each file have Different String. (3 Replies)
Hello Team,
Need your expertise on following:
Here is the set of data:
C1|4|C1SP1|A1|C1BP1|T1
C1|4|C1SP2|A1|C1BP2|T2
C2|3|C2SP1|A2|C2BP1|T2
C3|3|C3SP1|A3|C3BP1|T2
C2|2|C2SP2|A2|C2BP2|T1
I need to filter above date base on following two steps:
1. Group them by column 1 and 4
2.... (12 Replies)
I have a file with two columns separated by white space.
Dog Cat
fido sneaky
dopey poptart
ears whisker
barky herd
Trying to list the words under the column named Dog. Tried a few variations of awk but can't... (4 Replies)
I am trying to fetch 1st column and last 10 columns.The code I am using is working fine but after using the code then output file becomes space delimited not tab delimited.
awk 'BEGIN {OFS="\t"}{printf("%s\t",$1)}{for(i=NF-9; i<=NF; i++) {printf("%s\t",$i)};printf "\n" } ' inputfile
... (11 Replies)