Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

fbsql_insert_id(3) [php man page]

FBSQL_INSERT_ID(3)							 1							FBSQL_INSERT_ID(3)

fbsql_insert_id - Get the id generated from the previous INSERT operation

SYNOPSIS
int fbsql_insert_id ([resource $link_identifier]) DESCRIPTION
Gets the id generated from the previous INSERT operation which created a DEFAULT UNIQUE value. Note The value of the FrontBase SQL function fbsql_insert_id(3) always contains the most recently generated DEFAULT UNIQUE value, and is not reset between queries. PARAMETERS
o $ link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if fbsql_connect(3) was called with no arguments. RETURN VALUES
Returns the ID generated from the previous INSERT query, or 0 if the previous query does not generate an DEFAULT UNIQUE value. If you need to save the value for later, be sure to call this function immediately after the query that generates the value. SEE ALSO
fbsql_affected_rows(3). PHP Documentation Group FBSQL_INSERT_ID(3)

Check Out this Related Man Page

FBSQL_ERRNO(3)								 1							    FBSQL_ERRNO(3)

fbsql_errno - Returns the error number from previous operation

SYNOPSIS
int fbsql_errno ([resource $link_identifier]) DESCRIPTION
Returns the numerical value of the error message from previous FrontBase operation. Errors coming back from the fbsql database backend don't issue warnings. Instead, use fbsql_errno(3) to retrieve the error code. Note that this function only returns the error code from the most recently executed fbsql function (not including fbsql_error(3) and fbsql_errno(3)), so if you want to use it, make sure you check the value before calling another fbsql function. PARAMETERS
o $ link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if fbsql_connect(3) was called with no arguments. RETURN VALUES
Returns the error number from the last fbsql function, or 0 (zero) if no error occurred. EXAMPLES
Example #1 fbsql_errno(3) Example <?php fbsql_connect("marliesle"); echo fbsql_errno() . ": " . fbsql_error() . "<br />"; fbsql_select_db("nonexistentdb"); echo fbsql_errno() . ": " . fbsql_error() . "<br />"; $conn = fbsql_query("SELECT * FROM nonexistenttable;"); echo fbsql_errno() . ": " . fbsql_error() . "<br />"; ?> SEE ALSO
fbsql_error(3), fbsql_warnings(3). PHP Documentation Group FBSQL_ERRNO(3)
Man Page

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk command for INSERT statement

Hi, I sometimes bulk upload data in oracle. The problem is that I sometimes get an INSERT statemnt like this: INSERT INTO ALL_USER_HOTSPOT_DETAILS (USR_LOGIN,USR_LASTNAME,USR_FIRSTNAME,USR_EMAIL, PROPERTYNR) VALUES ('SABRDAG','D'AGOS','SABRINA','sabrina_d'agos@sheraton.com',70) I... (4 Replies)
Discussion started by: nattynatty
4 Replies

2. Shell Programming and Scripting

Very Urgent guys!!!

insert_FileConfig="INSERT INTO FILECONFIG ( FILE_TYPE, FILE_DESC, FILE_SCHDL_TYPE, FILE_SCHDL, FILE_SCHDL_TIME, RESULTS ) \ VALUES action_list " i have to replace "action_list" with the contents of a variable but when i am using echo $insert_FileConfig | sed... (6 Replies)
Discussion started by: navojit dutta
6 Replies

3. Shell Programming and Scripting

Help with perl scripting on strings

Hai, I have strings as follows. 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0030166' (INDEX (UNIQUE)) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0029845' (INDEX (UNIQUE) 9 INDEX MODE: ANALYZED (RANGE SCAN) OF ... (2 Replies)
Discussion started by: sagarbsa
2 Replies

4. Forum Support Area for Unregistered Users & Account Problems

previous posts

Hi, is there a way I can display my previous question posted? I've had a look around but couldn't find anything. Thanks in advance, Simon. (2 Replies)
Discussion started by: james6
2 Replies

5. Shell Programming and Scripting

Delete line before pattern

Hi All, I want to delete partial line before the INSERT. Input: l_s := ' INSERT INTO TEST' Output: INSERT INTO TEST' (3 Replies)
Discussion started by: saurabhbaisakhi
3 Replies

6. Shell Programming and Scripting

sed string manipulation in shell script

Hello, I have 1000 of sql queries and i need to push column value in query. e.g. SET INSERT_ID=1 INSERT INTO test (id,name) VALUES ('a'); SET INSERT_ID=2 INSERT INTO test (id,name) VALUES ('b'); SET INSERT_ID=3 INSERT INTO test (id,name) VALUES ('c'); SET INSERT_ID=4 INSERT INTO test... (12 Replies)
Discussion started by: mirfan
12 Replies

7. Programming

Getting error in sql query

Hi All , I have tried many times am getting syntax error on 'UNION' can anybody tell me ... INSERT INTO table1 ( Type , num_items , num_letters , total_value ) (select type='1', num_items, num_letters=count(*), total_value=sum(letter_value) from table2 where num_items = 1 (1 Reply)
Discussion started by: Venkatesh1
1 Replies

8. Shell Programming and Scripting

Php server globals REQUEST_URI or HTTP_SERVER_VARS

Hi all, recently I found that $_SERVER does not deliver the complete url with query anymore on my server. http://www.example.org/search.php?stichwort=wiki echo $_SERVER; /search.phpHowever $GLOBALS works in this case. http://www.example.org/search.php?stichwort=wiki echo $GLOBALS;... (1 Reply)
Discussion started by: lowmaster
1 Replies

9. UNIX for Dummies Questions & Answers

Regular expression question

Hi guys, I need a help with a query. Basically i want to know the difference between (0+01)* and ((0+01)*)* . It seems whatever string can be generated by the first RE can also be generated by second and they should essentially be same. Am i missing something? (1 Reply)
Discussion started by: srkmish
1 Replies