CUBRID_FIELD_LEN(3) 1 CUBRID_FIELD_LEN(3)cubrid_field_len - Get the maximum length of the specified fieldSYNOPSIS
int cubrid_field_len (resource $result, int $field_offset)
DESCRIPTION
This function returns the maximum length of the specified field on success, or it returns FALSE on failure.
PARAMETERS
o $result
-$result comes from a call to cubrid_execute(3)
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
Maximum length, when process is successful.
FALSE on failure.
EXAMPLES
Example #1
cubrid_field_len(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$result = cubrid_execute($conn, "SELECT * FROM game WHERE host_year=2004 AND nation_code='AUS' AND medal='G'");
$column_names = cubrid_column_names($result);
$column_types = cubrid_column_types($result);
printf("%-30s %-30s %-15s
", "Column Names", "Column Types", "Column Maxlen");
for($i = 0, $size = count($column_names); $i < $size; $i++) {
$column_len = cubrid_field_len($result, $i);
printf("%-30s %-30s %-15s
", $column_names[$i], $column_types[$i], $column_len);
}
cubrid_disconnect($conn);
?>
The above example will output:
Column Names Column Types Column Maxlen
host_year integer 11
event_code integer 11
athlete_code integer 11
stadium_code integer 11
nation_code char 3
medal char 1
game_date date 10
PHP Documentation Group CUBRID_FIELD_LEN(3)
Check Out this Related Man Page
CUBRID_FIELD_NAME(3) 1 CUBRID_FIELD_NAME(3)cubrid_field_name - Return the name of the specified field indexSYNOPSIS
string cubrid_field_name (resource $result, int $field_offset)
DESCRIPTION
This function returns the name of the specified field index on success or it returns FALSE on failure.
PARAMETERS
o $result
-$result comes from a call to cubrid_execute(3)
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 specified field index, on success.
FALSE on failure.
EXAMPLES
Example #1
cubrid_field_name(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$result = cubrid_execute($conn, "SELECT * FROM game WHERE host_year=2004 AND nation_code='AUS' AND medal='G'");
$col_num = cubrid_num_cols($result);
printf("%-30s %s
", "Field Name", "Field Flags");
for($i = 0; $i < $col_num; $i++) {
printf("%-30s %s
", cubrid_field_name($result, $i), cubrid_field_flags($result, $i));
}
cubrid_disconnect($conn);
?>
The above example will output:
Field Name Field Flags
host_year not_null primary_key unique_key
event_code not_null primary_key unique_key foreign_key
athlete_code not_null primary_key unique_key foreign_key
stadium_code not_null
nation_code
medal
game_date
PHP Documentation Group CUBRID_FIELD_NAME(3)
I have a function
awkvarrep() {
awk -F'|' '$1~/$1/{printf "%-10s %-30s %-15s %-30s %-15s\n", $2,$3,$4,$5,$6}' testfile
}
I'm calling it by this
VARREP=XYZ
awkvarrep $VARREP
since i'm passing $VARREP to the awkvarrep() function I want to use this with $1 but it dosen't seem to be... (5 Replies)
hi,
i m having 2 files say F1 and F2.
there are some joining conditions like:
Column 4 from F1= Column 29 from F2;
Column 10 from F1= Column 165 in F2;
and if value in column 8 from F2='3'
than i should get Column 4,5,8,10 from F1 and 29,165 from F2.
I cant provide the files. but the... (4 Replies)
I have a text file in unix with a layout like this
Column 1 - 1-12
Column 2 - 13-39
Column 3 - 40-58
Column 4 - 59-85
Column 5 - 86-120
Columbn 6 - 121-131
The file also has a header on the first 6 lines of each page. Each page is 51 lines long. So I want to remove the header from each... (30 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)
I have 2 files that I would need from one file the 3rd column and put into the second file. Preferably in KSH . For example file one has
file1:
Column 1 Column 2 Column 3 Column 4 Column 5
file2:
Column 1 Column 2 Column 3 Column 4 Column 5
So take Column 3 and put into file1 making it... (4 Replies)
I have a 2 column file.
Column 1 is a road ID number.
Column 2 is the date that the road surface condition was inspected.
Some roads have been inspected only once, while some roads have been inspected multiple times.
I would like to re-arrange the following example list:
1001 2001_01_01... (5 Replies)
Hi,
I am using UBUNTU 12.04.
I have a dataset as follows:
Column#1 Column#2 Column#3 .... Column#50
1 154878
1 145145
2 189565
2 454121
... (5 Replies)
hi,
I have a script which is dispaying the output as below:
Column 3:value1
Column 4:value 4
column 8:value 8
column 9:value 9
column 13:value 13
Column 3:value10
Column 4:value 40
column 8:value 80
column 9:value 90
column 13:value 103
However,I need the output in tabular... (5 Replies)
Hi All,
How to fetch the particular row based on my search command. For example
Source Column
Column A Column B
001,56123456
002,57123456
003,123456
Expected Output:
003,123456
To get this output I tried below mentioned function
grep '123456' filename.txt (4 Replies)
Base of last two column i want to change may data
if Last two Column have A and C then Copy Column $4 to Column $3.
Input :-
DD142 0_1 DD142_A DD142_B A B
DD142 1_1 DD142_B DD142_C B C
DD142 2_1 DD142_A DD142_C A C
DD142 3_1 DD142_A A
DD142 3_2 DD142_A A
DD142 4_1 DD142_B B ... (4 Replies)
Identify the First Column Position in Second Column and add the position value in 3rd column.
Sample data:
a|c
b|d
c|a
d|b
e|e
f|g
g|f
|h
|i
Expected Output:
a|c|1
b|d|2
c|a|3
d|b|4 (6 Replies)
so, i want to tail about the last 3000 lines of a log file and find the column that has the same number of characters across all 3000 lines (or most of the 3000 lines)
tail -3000 logfile | while read line
do
ColumnCharCount=$(for eachwordorwhatever in "${echo $line}"
do
... (8 Replies)
Hi folks,
I've got a csv file called test.csv
Column A Column B
Apples 1900
Apples 1901
Pears 1902
Pears 1903I want to count and keep duplicates in the first column. Desired output
Column A Column B Column C
Apples 2 1900
Apples ... (5 Replies)
I have a text file in below format
First Column Header |Second Column Header| Third Column Header| Fourth Column Header| Fifth Column Header
DATA1| 1.4|22.80| 6.6|6.55
DATA2| 1.4|NA| 6.8|6.83
DATA3| 2.4|22.80| 4.5| 4.45
DATA4| 4.4|NA| 8.8| 8.77
DATA5| 5.4|22.80| NA| 10.93
I need to... (4 Replies)