|
|
|
|
Bookmark this on Delicious
Share on Facebook
 Slashdot It!
Digg  ibase_pconnect
Open a persistent connection to an InterBase database
(PHP 4, PHP 5)
Code Examples / Notes » ibase_pconnecthouston_roadrunner
To make a connection to a firebird database with pconnect many people like to use the SYSDBA, or database owner. example: $dbConnection = ibase_pconnect('path to db','SYSDBA','masterkey'); The above is fine unless you want to login in various user that have different permissions. To use permission make roles in the database, either as the database creator (or SYSDBA) and grant the roles to the various users. If you login with... $dbConnection = ibase_pconnect('path to db', 'USERNAME', 'userpassword'); ...interbase will default your user to the PUBLIC role, which is created when the database is create and usualy has select rights on tables only. To get the proper role you will need to use all the parameters, like this... $user='USERNAME'; $password='userpassword'; $role='MANAGER_HR'; $dbConnection = ibase_pconnect('path to db', $user, $password, '', 0, 3, $role, 0); BTW - The "path to db", is formed like this... --------------------- 'localhost:c:/firebird/test_db/test.fdb' --------------------- reading the interbase material, it states 3 connection methods, PHP appears to have selected the tcp type for us. So you can use localhost, or I suspect(never tested this myself) a ip address. |
Change Language
ibase_add_user ibase_affected_rows ibase_backup ibase_blob_add ibase_blob_cancel ibase_blob_close ibase_blob_create ibase_blob_echo ibase_blob_get ibase_blob_import ibase_blob_info ibase_blob_open ibase_close ibase_commit_ret ibase_commit ibase_connect ibase_db_info ibase_delete_user ibase_drop_db ibase_errcode ibase_errmsg ibase_execute ibase_fetch_assoc ibase_fetch_object ibase_fetch_row ibase_field_info ibase_free_event_handler ibase_free_query ibase_free_result ibase_gen_id ibase_maintain_db ibase_modify_user ibase_name_result ibase_num_fields ibase_num_params ibase_param_info ibase_pconnect ibase_prepare ibase_query ibase_restore ibase_rollback_ret ibase_rollback ibase_server_info ibase_service_attach ibase_service_detach ibase_set_event_handler ibase_timefmt ibase_trans ibase_wait_event |
