Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

cubrid_field_type(3) [php 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 offset

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

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

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

printf question

can you take input from another command and do printf? such as awk '{print $2,$1}' | sort -k1,1 -k2,2 | printf "%-10s,%15s" this does not work.. but there must be a way.. please help me.. thank you. (3 Replies)
Discussion started by: hankooknara
3 Replies

2. 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

3. Shell Programming and Scripting

Field changes for sybase syslogins file

Hello, I have extracted the first line of the syslogins file and wish to use this as an example but the field change applies to the whole file. I wish to change the second field for all lines from 0 to 2 , the 0 field is constant for all lines. Also I wish to change the encrypted password field... (0 Replies)
Discussion started by: otasdemir
0 Replies

4. Shell Programming and Scripting

expr Field 1 + Field 2 Since when does 2 positives make a negative

Please help. I am adding 2 fields which are both positive and the result is negative. What am I missing? FileEHash=`expr ${Field1} + ${Field2}` >/dev/null Debug Results + expr 02100002 + 2009701914 EntryHash=2011801916 + expr 02100002 + 2146202044 FileEHash=-2146665250 How do... (2 Replies)
Discussion started by: ski
2 Replies

5. Shell Programming and Scripting

Sort based on Multiple Columns in UNIX

Hi, I would like to sort a list in different ways: 1> Unique based on Field 1 with highest Field 4 For Instance Input: 1678923450;11112222333344;11-1x;2_File.xml 1678923450;11112222333344;11-1x;5_File.xml 1234567890;11113333222244;11-1x;3_File.xml Output: ... (7 Replies)
Discussion started by: DevendraG
7 Replies

6. Shell Programming and Scripting

Validating the file

Hello All, I have the following file. The first column is Type. Always the file will have one H and one T type in between all D type reocrds. Need todo some validations. H|ABCD D|TAB N0003107809CD2013-11-14|RYAN|FRY|7 DR|RICHMOND HILL|GA|32431|X|C95|000009999|000000001|TAB||C0001 D|TAB... (3 Replies)
Discussion started by: karumudi7
3 Replies

7. Shell Programming and Scripting

Query cut informacion

query pgrep -lf ora_pmon | > while read p a; do > printf '%s %-15s => %s\n' "$p" "$a" \ > "$( dbhome "${a#ora_pmon_}" )" > done 10286 ora_pmon_bd1 => /oracle/10.2 10431 ora_pmon_bd2 => /oracle/10.2 11728 ora_pmon_bd3 => /oracle/10.2 11882 ora_pmon_bd4 => /oracle/10.2 12068... (4 Replies)
Discussion started by: ceciaide
4 Replies