Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

cubrid_field_len(3) [php man page]

CUBRID_FIELD_LEN(3)							 1						       CUBRID_FIELD_LEN(3)

cubrid_field_len - Get the maximum length of the specified field

SYNOPSIS
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 index

SYNOPSIS
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)
Man Page

15 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk variable replacement

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)
Discussion started by: iAm4Free
5 Replies

2. Shell Programming and Scripting

Printing specified lines only

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)
Discussion started by: Mohit623
4 Replies

3. Shell Programming and Scripting

Removing Headers and a Column

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)
Discussion started by: DerangedNick
30 Replies

4. UNIX for Dummies Questions & Answers

Column query

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)
Discussion started by: navjotmannan
4 Replies

5. Shell Programming and Scripting

Get a column from one file and put it in another

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)
Discussion started by: bombcan1
4 Replies

6. UNIX for Dummies Questions & Answers

[SOLVED] re-parse duplicate horizontally

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)
Discussion started by: kenneth.mcbride
5 Replies

7. Shell Programming and Scripting

Putting values into order in a field using awk

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)
Discussion started by: Homa
5 Replies

8. Shell Programming and Scripting

Dispaying output in tabular form

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)
Discussion started by: Vivekit82
5 Replies

9. Shell Programming and Scripting

Fetch Valid String

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)
Discussion started by: suresh_target
4 Replies

10. Shell Programming and Scripting

Change Data base on Column

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)
Discussion started by: pareshkp
4 Replies

11. Shell Programming and Scripting

Identify the First Column Position in Second Column and add the position value

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)
Discussion started by: BrahmaNaiduA
6 Replies

12. Shell Programming and Scripting

Add Column base on other Column Data

HI Guys, I want add one extra Column base on 3rd Column . Input :- M204 MS204_154 :vsDataUeMe M204 MS204_154 es:sMeasure 0 M204 MS204_154 es:90ilterCoe 9 M204 MS204_154 es:searchE9090ortTime 40 M204 MS204_154 es:servOrPrioI90HoTimer 4000 M204 MS204_154 es:ueMeajllls154545 TRUE... (5 Replies)
Discussion started by: pareshkp
5 Replies

13. Shell Programming and Scripting

Get column number with the same character length

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)
Discussion started by: SkySmart
8 Replies

14. Shell Programming and Scripting

Count and keep duplicates in Column

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)
Discussion started by: pshields1984
5 Replies

15. Shell Programming and Scripting

Column sum

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)
Discussion started by: ctrld
4 Replies