CUBRID_NUM_COLS(3) 1 CUBRID_NUM_COLS(3)cubrid_num_cols - Return the number of columns in the result setSYNOPSIS
int cubrid_num_cols (resource $result)
DESCRIPTION
The cubrid_num_cols(3) function is used to get the number of columns from the query result. It can only be used when the query executed is
a select statement.
PARAMETERS
o $result
-Result.
RETURN VALUES
Number of columns, when process is successful.
FALSE, if SQL statement is not SELECT.
EXAMPLES
Example #1
cubrid_num_cols(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb", "dba");
$req = cubrid_execute($conn, "SELECT * FROM code");
$row_num = cubrid_num_rows($req);
$col_num = cubrid_num_cols($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
SEE ALSO cubrid_execute(3), cubrid_num_rows(3).
PHP Documentation Group CUBRID_NUM_COLS(3)
Check Out this Related Man Page
CUBRID_FIELD_TYPE(3) 1 CUBRID_FIELD_TYPE(3)cubrid_field_type - Return the type of the column corresponding to the given field offsetSYNOPSIS
string cubrid_field_type (resource $result, int $field_offset)
DESCRIPTION
This function returns the type of the column corresponding to the given field offset. The returned field type could be one of the follow-
ing: "int", "real", "string", etc.
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
Type of the column, on success.
FALSE when invalid field_offset value.
-1 if SQL sentence is not SELECT.
EXAMPLES
Example #1
cubrid_field_type(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_TYPE(3)
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 all,
I have a data in a script like this.
First coloumn Second coloumn Third Coloumn
A*****************C****************D
*****************B****************E
L****************M****************N ... (4 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)
Hi Frndz,
I have req in which i need to run the query stored in some file and then store the resultset of the query in some other file.
PFB the code i have written:
#----Start job log---
SQLLOG='/opt/app/vertica2/cdr_dev/logs/conn_orac_db.log'
ORA_USER='abc'
ORA_PASSWD='xyz'
... (7 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)
Hello All,
I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns.
So my requirement is to generate a output query which will have 20 columns all the... (7 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)
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 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)