downloads | documentation | faq | getting help | mailing lists | licenses | wiki | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

Our source is open

The syntax highlighted source is automatically generated by PHP from the plaintext script. If you're interested in what's behind the several functions we used, you can always take a look at the source of the following files:

Of course, if you want to see the source of this page, we have it available. You can also browse the SVN repository for this website on svn.php.net.

Source of: /manual/en/function.mysql-db-name.php

<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$PARENTS = array();
include_once
dirname(__FILE__) ."/toc/ref.mysql.inc";
$setup = array (
 
'home' =>
  array (
   
0 => 'index.php',
   
1 => 'PHP Manual',
  ),
 
'head' =>
  array (
   
0 => 'UTF-8',
   
1 => 'en',
  ),
 
'this' =>
  array (
   
0 => 'function.mysql-db-name.php',
   
1 => 'mysql_db_name',
  ),
 
'up' =>
  array (
   
0 => 'ref.mysql.php',
   
1 => 'MySQL Functions',
  ),
 
'prev' =>
  array (
   
0 => 'function.mysql-data-seek.php',
   
1 => 'mysql_data_seek',
  ),
 
'next' =>
  array (
   
0 => 'function.mysql-db-query.php',
   
1 => 'mysql_db_query',
  ),
);
$setup["toc"] = $TOC;
$setup["parents"] = $PARENTS;
manual_setup($setup);

manual_header();
?>
<div id="function.mysql-db-name" class="refentry">
 <div class="refnamediv">
  <h1 class="refname">mysql_db_name</h1>
  <p class="verinfo">(PHP 4, PHP 5)</p><p class="refpurpose"><span class="refname">mysql_db_name</span> &mdash; <span class="dc-title">Get result data</span></p>

 </div>

 <a name="function.mysql-db-name.description"></a><div class="refsect1 description">
  <h3 class="title">Description</h3>
  <div class="methodsynopsis dc-description">
   <span class="type">string</span> <span class="methodname"><b>mysql_db_name</b></span>
    ( <span class="methodparam"><span class="type">resource</span> <tt class="parameter">$result</tt></span>
   , <span class="methodparam"><span class="type">int</span> <tt class="parameter">$row</tt></span>
   [, <span class="methodparam"><span class="type"><a href="language.pseudo-types.php#language.types.mixed" class="type mixed">mixed</a></span> <tt class="parameter">$field</tt></span>
  ] )</div>

  <p class="para rdfs-comment">
   Retrieve the database name from a call to
   <a href="function.mysql-list-dbs.php" class="function">mysql_list_dbs()</a>.
  </p>
 </div>


 <a name="function.mysql-db-name.parameters"></a><div class="refsect1 parameters">
  <h3 class="title">Parameters</h3>
  <p class="para">
   </p><dl>

    <dt class="varlistentry">

     <span class="term"><i><tt class="parameter">result</tt></i>
</span>

     </dt><dd class="listitem">

      <p class="para">
       The result pointer from a call to <a href="function.mysql-list-dbs.php" class="function">mysql_list_dbs()</a>.
      </p>
     </dd>

   
    <dt class="varlistentry">

     <span class="term"><i><tt class="parameter">row</tt></i>
</span>

     </dt><dd class="listitem">

      <p class="para">
       The index into the result set.
      </p>
     </dd>

   
    <dt class="varlistentry">

     <span class="term"><i><tt class="parameter">field</tt></i>
</span>

     </dt><dd class="listitem">

      <p class="para">
       The field name.
      </p>
     </dd>

   
   </dl>
<p>
  </p>
 </div>

 
 <a name="function.mysql-db-name.returnvalues"></a><div class="refsect1 returnvalues">
  <h3 class="title">Return Values</h3>
  <p class="para">
   Returns the database name on success, and <b><tt class="constant">FALSE</tt></b> on failure. If <b><tt class="constant">FALSE</tt></b>
   is returned, use <a href="function.mysql-error.php" class="function">mysql_error()</a> to determine the nature
   of the error.
  </p>
 </div>

 
 <a name="function.mysql-db-name.examples"></a><div class="refsect1 examples">
  <h3 class="title">Examples</h3>
  <p class="para">
   </p><div class="example">
    <p><b>Example #1 <b>mysql_db_name()</b> example</b></p>
    <div class="example-contents programlisting">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php<br />error_reporting</span><span style="color: #007700">(</span><span style="color: #0000BB">E_ALL</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">$link&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">'dbhost'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'username'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'password'</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$db_list&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">mysql_list_dbs</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">$i&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">0</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$cnt&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">mysql_num_rows</span><span style="color: #007700">(</span><span style="color: #0000BB">$db_list</span><span style="color: #007700">);<br />while&nbsp;(</span><span style="color: #0000BB">$i&nbsp;</span><span style="color: #007700">&lt;&nbsp;</span><span style="color: #0000BB">$cnt</span><span style="color: #007700">)&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;</span><span style="color: #0000BB">mysql_db_name</span><span style="color: #007700">(</span><span style="color: #0000BB">$db_list</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$i</span><span style="color: #007700">)&nbsp;.&nbsp;</span><span style="color: #DD0000">"\n"</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$i</span><span style="color: #007700">++;<br />}<br /></span><span style="color: #0000BB">?&gt;</span>
</span>
</code></div>
    </div>

   </div><p>
  </p>
 </div>

 
 <a name="function.mysql-db-name.notes"></a><div class="refsect1 notes">
  <h3 class="title">Notes</h3>
  <blockquote><p><b class="note">Note</b>:
  
    For backward compatibility, the following
deprecated alias may be used:
    <b>mysql_dbname()</b>
   <br />
  </p></blockquote>
 </div>

 
 <a name="function.mysql-db-name.seealso"></a><div class="refsect1 seealso">
  <h3 class="title">See Also</h3>
  <p class="para">
   </p><ul class="simplelist">
    <li class="member"><a href="function.mysql-list-dbs.php" class="function" rel="rdfs-seeAlso">mysql_list_dbs()</a> - List databases available on a MySQL server</li>
    <li class="member"><a href="function.mysql-tablename.php" class="function" rel="rdfs-seeAlso">mysql_tablename()</a> - Get table name of field</li>
   </ul><p>
  </p>
 </div>

</div><?php manual_footer(); ?>
 
show source | credits | sitemap | contact | advertising | mirror sites