Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

cubrid_result(3) [php man page]

CUBRID_RESULT(3)							 1							  CUBRID_RESULT(3)

cubrid_result - Return the value of a specific field in a specific row

SYNOPSIS
string cubrid_result (resource $result, int $row, [mixed $field]) DESCRIPTION
This function returns the value of a specific field in a specific row from a result set. PARAMETERS
o $result -$result comes from a call to cubrid_execute(3) o $row -The row number from the result that is being retrieved. Row numbers start at 0. o $field - The name or offset of the $field being retrieved. It can be the field's offset, the field's name, or the field's table dot field name (tablename.fieldname). If the column name has been aliased ('select foo as bar from...'), use the alias instead of the column name. If undefined, the first field is retrieved. RETURN VALUES
Value of a specific field, on success (NULL if value if null). FALSE on failure. EXAMPLES
Example #1 cubrid_result(3) example <?php $conn = cubrid_connect("localhost", 33000, "demodb"); $req = cubrid_execute($conn, "SELECT * FROM code"); $result = cubrid_result($req, 0); var_dump($result); $result = cubrid_result($req, 0, 1); var_dump($result); $result = cubrid_result($req, 5, "f_name"); var_dump($result); cubrid_close_request($req); cubrid_disconnect($conn); ?> The above example will output: string(1) "X" string(5) "Mixed" string(4) "Gold" PHP Documentation Group CUBRID_RESULT(3)

Check Out this Related Man Page

CUBRID_FREE_RESULT(3)							 1						     CUBRID_FREE_RESULT(3)

cubrid_free_result - Free the memory occupied by the result data

SYNOPSIS
bool cubrid_free_result (resource $req_identifier) DESCRIPTION
This function frees the memory occupied by the result data. It returns TRUE on success or FALSE on failure. Note that it can only frees the client fetch buffer now, and if you want free all memory, use function cubrid_close_request(3). PARAMETERS
o $req_identifier -This is the request identifier. RETURN VALUES
TRUE on success. FALSE on failure. EXAMPLES
Example #1 cubrid_free_result(3) example <?php $conn = cubrid_connect("localhost", 33000, "demodb"); $req = cubrid_execute($conn, "SELECT * FROM history WHERE host_year=2004 ORDER BY event_code"); $row = cubrid_fetch_assoc($req); var_dump($row); cubrid_free_result($req); cubrid_close_request($req); cubrid_disconnect($conn); ?> The above example will output: array(5) { ["event_code"]=> string(5) "20005" ["athlete"]=> string(12) "Hayes Joanna" ["host_year"]=> string(4) "2004" ["score"]=> string(5) "12.37" ["unit"]=> string(4) "time" } PHP Documentation Group CUBRID_FREE_RESULT(3)
Man Page

15 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

unix

Hi friends, I have on data file containing 3 coloums........... like this. **** ***** ***** *** ***** ***** *** ***** ***** 12.36 13,27 22.16 **** ***** ***** **** ***** ***** **** ***** ***** **** ***** ***** 12.35 32.46 34.56 now from... (9 Replies)
Discussion started by: rajan_ka1
9 Replies

2. Shell Programming and Scripting

help with this one please

Hallo All, this is my code below. The problem happens under section A because field $9 sometimes does not contain a number it contains a (:) and a number is contained in field $10 as result under sectionC we get a syntax error @ echo "scale=1; $aa+$ee+$ff"|bc > /tmp/pax/c3.txt So i need to... (5 Replies)
Discussion started by: kekanap
5 Replies

3. Shell Programming and Scripting

need help with replacing a certain field...

Hi, can anyone help me? This is what i want to do....I have a string UNB+UNOA:1+OOCLIES+RTTC+080408:0358+1' and i want to replace the "1" at the end (that specific field only) to 00001 such that the new output will be like this UNB+UNOA:1+OOCLIES+RTTC+080408:0358+00001' i tried using... (5 Replies)
Discussion started by: shennanigan83
5 Replies

4. Programming

how this works?

pls explain me how this works.... DECODE (SUBSTR (field, 1, 1),'''', '''''' || field || '''','''' || field || '''') here field is a column in an oracle table.... (7 Replies)
Discussion started by: vijay_0209
7 Replies

5. Shell Programming and Scripting

Extract data into file with specific field specs

:confused: I have a tab delimited file that I need to extract data from and into a file with specific field specs. Each field has to be a certain amount of characters. So, the name field (from delimited file) might have only 15 characters but needs to be 25 (in new file) so I need to insert spaces... (5 Replies)
Discussion started by: criddel
5 Replies

6. UNIX for Dummies Questions & Answers

To find the Row number

Hi Can any one tell me what is the command to find out the row id or row number for a particular record Thanks sri (6 Replies)
Discussion started by: laxmi131
6 Replies

7. Shell Programming and Scripting

To count distinct fields in a row

I have . dat file which contains data in a specific format: 0 3 892 921 342 1 3 921 342 543 2 4 817 562 718 765 3 3 819 562 717 761 i need to compare each field in a row with another field of the same column but different row and cont the... (8 Replies)
Discussion started by: Abhik
8 Replies

8. Shell Programming and Scripting

Help with grep at specific field of a file

hi, I would like to search for a specific string at a specific line in a file and would like to know the count of it. eg: samp.txt ABC 1234 BELL HNZ 4567 RING NNN 5673 BELL Please help with the command to find the count of BELL in the above file samp.txt at the specific line 10 with... (7 Replies)
Discussion started by: techmoris
7 Replies

9. Shell Programming and Scripting

substitute a string on a specific position for specific lines

I woud like to substitue a string on a specific position for specific lines I've got a file and I would like to change a specific string from "TOCHANGE" to "ABCABCAB" For every line (except 1,2, 3 and the last one) , I need to check between the 9th and the 16th digits. For the 3rd line, I... (7 Replies)
Discussion started by: BSF
7 Replies

10. Shell Programming and Scripting

awk how to replace specific field with new value

I need to replace specific field (x) in a table with new value (y): Input: 1 2 3 4 5 x 6 7 8 9 0 0 Output: 1 2 3 4 5 y 6 7 8 9 0 0 I have no idea how to do this. (10 Replies)
Discussion started by: setepo
10 Replies

11. Shell Programming and Scripting

How to read particular line in file from specific column?

Hi...friends.... I want to create inventory...information for that I need to read some specific row say 2nd row from 1st 3 column and and write data with particular file used, I have some more column also but I need only 3 column data of first entry after header I attached sample file..those... (12 Replies)
Discussion started by: nex_asp
12 Replies

12. UNIX for Dummies Questions & Answers

awk to sum column field from duplicate row/lines

Hello, I am new to Linux environment , I working on Linux script which should send auto email based on the specific condition from log file. Below is the sample log file Name m/c usage abc xxx 10 abc xxx 20 abc xxx 5 xyz ... (6 Replies)
Discussion started by: asjaiswal
6 Replies

13. UNIX for Dummies Questions & Answers

Sum based on certain column

I have file 1 1/1/2013 A 553.0763397 96 16582 X1 X3 X5 X7 X9 1/1/2013 B 600.8333588 195 11992 X2 X3 X6 X7 X9 1/1/2013 B 459.8333588 195 11992 X1 X3 X6 X7 X9 1/2/2013 A 844.2973022 306 19555 X1 ... (12 Replies)
Discussion started by: radius
12 Replies

14. Shell Programming and Scripting

Replace values

Gents, Please can you help me with this. When column 49 == 2 Need to do the following changes; Change previous row field (substr$0,45,4)-1 Change previous row field (substr$0,72,5)+2 Change actual row field (substr$0,40,4)+1 Change actual row field (substr$0,49,1)-1 Change actual... (6 Replies)
Discussion started by: jiam912
6 Replies

15. Shell Programming and Scripting

Print particular string in a field of csv file

Hi, all I need your help and suggestions. I want to print particular strings in a field of a csv file and show them in terminal. Here is an example of the csv file. SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw... (9 Replies)
Discussion started by: refrain
9 Replies