FBSQL_DATABASE_PASSWORD(3) 1 FBSQL_DATABASE_PASSWORD(3)fbsql_database_password - Sets or retrieves the password for a FrontBase databaseSYNOPSIS
string fbsql_database_password (resource $link_identifier, [string $database_password])
DESCRIPTION
Sets and retrieves the database password used by the connection. If a database is protected by a database password, the user must call
this function before calling fbsql_select_db(3).
If no link is open, the function will try to establish a link as if fbsql_connect(3) was called, and use it.
This function does not change the database password in the database nor can it be used to retrieve the database password for a database.
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.
o $database_password
- The database password, as a string. If given, the function sets the database password for the specified link identifier.
RETURN VALUES
Returns the database password associated with the link identifier.
EXAMPLES
Example #1
fbsql_create_clob(3) example
<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
or die("Could not connect");
fbsql_database_password($link, "secret db password");
fbsql_select_db($database, $link);
?>
SEE ALSO fbsql_connect(3), fbsql_pconnect(3), fbsql_select_db(3).
PHP Documentation Group FBSQL_DATABASE_PASSWORD(3)
Check Out this Related Man Page
FBSQL_READ_CLOB(3) 1 FBSQL_READ_CLOB(3)fbsql_read_clob - Read a CLOB from the databaseSYNOPSIS
string fbsql_read_clob (string $clob_handle, [resource $link_identifier])
DESCRIPTION
Reads CLOB data from the database.
If a select statement contains BLOB and/or CLOB columns FrontBase will return the data directly when data is fetched. This default behav-
ior can be changed with fbsql_set_lob_mode(3) so the fetch functions will return handles to BLOB and CLOB data. If a handle is fetched a
user must call fbsql_read_clob(3) to get the actual CLOB data from the database.
PARAMETERS
o $clob_handle
- A CLOB handle, returned by fbsql_create_clob(3).
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 a string containing the specified CLOB data.
EXAMPLES
Example #1
fbsql_read_clob(3) example
<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
or die("Could not connect");
$sql = "SELECT CLOB_COLUMN FROM CLOB_TABLE;";
$rs = fbsql_query($sql, $link);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain the clob data for the first row
fbsql_free_result($rs);
$rs = fbsql_query($sql, $link);
fbsql_set_lob_mode($rs, FBSQL_LOB_HANDLE);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain a handle to the CLOB data in the first row
$clob_data = fbsql_read_clob($row_data[0]);
fbsql_free_result($rs);
?>
SEE ALSO fbsql_create_clob(3), fbsql_read_blob(3), fbsql_set_lob_mode(3).
PHP Documentation Group FBSQL_READ_CLOB(3)
I'm trying to run phpBB2 software on Apache2, all was fine with setups except I had no password protecting my database.
After researching how to do it, I attempted to set password "freddy" to root (for obvious reasons "freddy" isn't the actual pw I used).
I now can't login to MYSQL4 using... (1 Reply)
hello all,
I need to create a password change utility for a database. I need to gather at the command line the username, password and database sid. I have the program currently doing this. What I would like to do is not have the new password appear on the screen when I do my read command.... (2 Replies)
how can we connect to database(psql) using c language?.
Any one help.Pls say the hader file and function's avilable in C for database operation(like connecting,selecting,etc...). (3 Replies)
I am trying to locate a password database for use at work. I have looked at several open source packages but all that I have found are for a single user and we need to allow multiple user access with view restrictions.
Does anyone know of a program that fits these requirements?
Thanks... (2 Replies)
KSH - Unix -AIX - db2
**************
Get the input from the user say '123' (It varies)
Then i want to connect to a database say "D1"
then i want th extract from the database by giving "select * from tablename where input = '123'
I also want to connect to another database "D2"
then i... (3 Replies)
I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
i have a little pro*c code (as shown below)
to connect an oracle database. (in unix solaris platform)
in the preprocessor compilation step everything is ok.
but when i try to compile the code using cc i get the
error below:
ld:
Unresolved:
sqlcxt
i think there is a problem while linking... (3 Replies)
How to write a shell script to retrieve datas from database after that this database are redirect to a excell sheet and then i got a mail that gives details about the database with the column name and data..
I m using oracle 9i...
Thanks,
Anup Das (2 Replies)
i have a file that contains:
xxxx
xxxxxx
xxxxxxx
## database.password=OBF:qpdauyrnavsl
database.password=OBF:qpdauyrnavsl
## app.password=OBF:1lte1jmv1yfc1xtv1xtn1yeu1jkn1lqk
app.password=OBF:1lte1jmv1yfc1xtv1xtn1yeu1jkn1lqk
xxxxxxx
xxxxxxxxxxxx
xxxxxxxxxxxxxxx
i'd like to replace... (5 Replies)
hello all, i am trying to find a better to do what i am doing right now...
i have a file called sidlist...which has my database_name and password to the respective database
so something like below.. file is called sidlist and entry is below...
test, abc123
kes12, abcd12
pss, abcd1234... (5 Replies)
Hi,
Sorry i can't find what particular forum should i post my question.
I was given a username and password for the database, but i was not given the hostname, SID and the port to were i can connect to with.
Is there a way for me to get the following details in unix, by the way i am using... (5 Replies)
Hi All.
Does anybody here know the System I database? it's from IBM. because i don't know how to connect on the database using unix. How do i know what parameter will i use?
Thanks, (2 Replies)
Hi,
I need help in creating script for "User password reset in database" by logging into database from linux server and resetting the user password.
Could you please provide the script for this task?
Steps are given below.
1. Login into database from server
sqlplus... (5 Replies)