<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <title>Sets or retrieves the password for a FrontBase database</title> </head> <body><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.fbsql-data-seek.html">fbsql_data_seek</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.fbsql-database.html">fbsql_database</a></div> <div class="up"><a href="ref.fbsql.html">FrontBase Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div><hr /><div id="function.fbsql-database-password" class="refentry"> <div class="refnamediv"> <h1 class="refname">fbsql_database_password</h1> <p class="verinfo">(PHP 4 >= 4.0.6, PHP 5)</p><p class="refpurpose"><span class="refname">fbsql_database_password</span> — <span class="dc-title">Sets or retrieves the password for a FrontBase database</span></p> </div> <div class="refsect1 description" id="refsect1-function.fbsql-database-password-description"> <h3 class="title">Description</h3> <div class="methodsynopsis dc-description"> <span class="type">string</span> <span class="methodname"><strong>fbsql_database_password</strong></span> ( <span class="methodparam"><span class="type">resource</span> <code class="parameter">$link_identifier</code></span> [, <span class="methodparam"><span class="type">string</span> <code class="parameter">$database_password</code></span> ] )</div> <p class="para rdfs-comment"> 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 <span class="function"><a href="function.fbsql-select-db.html" class="function">fbsql_select_db()</a></span>. </p> <p class="para"> If no link is open, the function will try to establish a link as if <span class="function"><a href="function.fbsql-connect.html" class="function">fbsql_connect()</a></span> was called, and use it. </p> <p class="para"> This function does not change the database password in the database nor can it be used to retrieve the database password for a database. </p> </div> <div class="refsect1 parameters" id="refsect1-function.fbsql-database-password-parameters"> <h3 class="title">Parameters</h3> <p class="para"> <dl> <dt> <span class="term"><em><code class="parameter"> link_identifier</code></em></span><dd> <p class="para">A FrontBase link identifier returned by <span class="function"><a href="function.fbsql-connect.html" class="function">fbsql_connect()</a></span> or <span class="function"><a href="function.fbsql-pconnect.html" class="function">fbsql_pconnect()</a></span>.</p><p class="para">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 <span class="function"><a href="function.fbsql-connect.html" class="function">fbsql_connect()</a></span> was called with no arguments.</p> </dd> </dt> <dt> <span class="term"><em><code class="parameter">database_password</code></em></span> <dd> <p class="para"> The database password, as a string. If given, the function sets the database password for the specified link identifier. </p> </dd> </dt> </dl> </p> </div> <div class="refsect1 returnvalues" id="refsect1-function.fbsql-database-password-returnvalues"> <h3 class="title">Return Values</h3> <p class="para"> Returns the database password associated with the link identifier. </p> </div> <div class="refsect1 examples" id="refsect1-function.fbsql-database-password-examples"> <h3 class="title">Examples</h3> <p class="para"> <div class="example" id="example-1120"> <p><strong>Example #1 <span class="function"><a href="function.fbsql-create-clob.html" class="function">fbsql_create_clob()</a></span> example</strong></p> <div class="example-contents"> <div class="phpcode"><code><span style="color: #000000"> <span style="color: #0000BB"><?php<br />$link </span><span style="color: #007700">= </span><span style="color: #0000BB">fbsql_pconnect</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">, </span><span style="color: #DD0000">"_SYSTEM"</span><span style="color: #007700">, </span><span style="color: #DD0000">"secret"</span><span style="color: #007700">)<br /> or die(</span><span style="color: #DD0000">"Could not connect"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">fbsql_database_password</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">, </span><span style="color: #DD0000">"secret db password"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">fbsql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$database</span><span style="color: #007700">, </span><span style="color: #0000BB">$link</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span> </span> </code></div> </div> </div> </p> </div> <div class="refsect1 seealso" id="refsect1-function.fbsql-database-password-seealso"> <h3 class="title">See Also</h3> <p class="para"> <ul class="simplelist"> <li class="member"> <span class="function"><a href="function.fbsql-connect.html" class="function" rel="rdfs-seeAlso">fbsql_connect()</a> - Open a connection to a FrontBase Server</span></li> <li class="member"> <span class="function"><a href="function.fbsql-pconnect.html" class="function" rel="rdfs-seeAlso">fbsql_pconnect()</a> - Open a persistent connection to a FrontBase Server</span></li> <li class="member"> <span class="function"><a href="function.fbsql-select-db.html" class="function" rel="rdfs-seeAlso">fbsql_select_db()</a> - Select a FrontBase database</span></li> </ul> </p> </div> </div><hr /><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.fbsql-data-seek.html">fbsql_data_seek</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.fbsql-database.html">fbsql_database</a></div> <div class="up"><a href="ref.fbsql.html">FrontBase Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div></body></html>