PageRenderTime 52ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/php/function.maxdb-select-db.html

https://bitbucket.org/thncr/manuals
HTML | 105 lines | 88 code | 17 blank | 0 comment | 0 complexity | 212f08c4612c4471d441f5addb52622e MD5 | raw file
    

  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    2. 

  2. <html>
    3. 

  3.  <head>
    4. 

  4.   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
    5. 

  5.   <title>Selects the default database for database queries</title>
    6. 

  6. 

  7.  </head>
    8. 

  8.  <body><div class="manualnavbar" style="text-align: center;">
    9. 

  9.  <div class="prev" style="text-align: left; float: left;"><a href="function.maxdb-rpl-query-type.html">maxdb_rpl_query_type</a></div>
    10. 

  10.  <div class="next" style="text-align: right; float: right;"><a href="function.maxdb-send-long-data.html">maxdb_send_long_data</a></div>
    11. 

  11.  <div class="up"><a href="ref.maxdb.html">MaxDB 函数</a></div>
    12. 

  12.  <div class="home"><a href="index.html">PHP Manual</a></div>
    13. 

  13. </div><hr /><div id="function.maxdb-select-db" class="refentry">
    14. 

  14.  <div class="refnamediv">
    15. 

  15.   <h1 class="refname">maxdb_select_db</h1>
    16. 

  16.   <h1 class="refname">maxdb::select_db</h1>
    17. 

  17.   <p class="verinfo">(PECL maxdb &gt;= 1.0)</p><p class="refpurpose"><span class="refname">maxdb_select_db</span> -- <span class="refname">maxdb::select_db</span> &mdash; <span class="dc-title">Selects the default database for database queries</span></p>
    18. 

  18. 

  19.  </div>
    20. 

  20. 

  21.  <div class="refsect1 description" id="refsect1-function.maxdb-select-db-description">
    22. 

  22.   <h3 class="title">说明</h3>
    23. 

  23.   <div class="methodsynopsis dc-description">
    24. 

  24.    <span class="type">bool</span> <span class="methodname"><strong>maxdb_select_db</strong></span>
    25. 

  25.     ( <span class="methodparam"><span class="type">resource</span> <code class="parameter">$link</code></span>
    26. 

  26.    , <span class="methodparam"><span class="type">string</span> <code class="parameter">$dbname</code></span>
    27. 

  27.    )</div>
    28. 

  28. 

  29.   <p class="para rdfs-comment">
    30. 

  30.    The  <span class="function"><strong>maxdb_select_db()</strong></span> function selects the default
    31. 

  31.    database (specified by the <em><code class="parameter">dbname</code></em> parameter) to be
    32. 

  32.    used when performing queries against the database connection
    33. 

  33.    represented by the <em><code class="parameter">link</code></em> parameter.
    34. 

  34.   </p>
    35. 

  35.   <blockquote class="note"><p><strong class="note">Note</strong>: 
    36. 

  36.    <p class="para">
    37. 

  37.     This function should only be used to change the default database for the connection.
    38. 

  38.     You can select the default database with 4th parameter in  <span class="function"><a href="function.maxdb-connect.html" class="function">maxdb_connect()</a></span>.
    39. 

  39.    </p>
    40. 

  40.   </p></blockquote>
    41. 

  41.  </div>
    42. 

  42. 

  43. 

  44.  <div class="refsect1 returnvalues" id="refsect1-function.maxdb-select-db-returnvalues">
    45. 

  45.   <h3 class="title">返回值</h3>
    46. 

  46.   <p class="para">
    47. 

  47.    成功时返回 <strong><code>TRUE</code></strong>， 或者在失败时返回 <strong><code>FALSE</code></strong>.
    48. 

  48.   </p>
    49. 

  49.  </div>
    50. 

  50. 

  51. 

  52.  <div class="refsect1 examples" id="refsect1-function.maxdb-select-db-examples">
    53. 

  53.   <h3 class="title">范例</h3>
    54. 

  54.   <div class="example" id="example-1336">
    55. 

  55.    <p><strong>Example #1 面向对象风格</strong></p>
    56. 

  56.    <div class="example-contents">
    57. 

  57. <div class="phpcode"><code><span style="color: #000000">
    58. 

  58. <span style="color: #0000BB">&lt;?php<br />$maxdb&nbsp;</span><span style="color: #007700">=&nbsp;new&nbsp;</span><span style="color: #0000BB">maxdb</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"MONA"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"RED"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"DEMODB"</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/*&nbsp;check&nbsp;connection&nbsp;*/<br /></span><span style="color: #007700">if&nbsp;(</span><span style="color: #0000BB">maxdb_connect_errno</span><span style="color: #007700">())&nbsp;{<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Connect&nbsp;failed:&nbsp;%s\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">maxdb_connect_error</span><span style="color: #007700">());<br />&nbsp;&nbsp;&nbsp;exit();<br />}<br /><br /></span><span style="color: #FF8000">/*&nbsp;return&nbsp;name&nbsp;of&nbsp;current&nbsp;default&nbsp;database&nbsp;*/<br /></span><span style="color: #007700">if&nbsp;(</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$maxdb</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT&nbsp;SERVERDB&nbsp;FROM&nbsp;USERS&nbsp;WHERE&nbsp;USERNAME='MONA'"</span><span style="color: #007700">))&nbsp;{<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$row&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$result</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">fetch_row</span><span style="color: #007700">();<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Default&nbsp;database&nbsp;is&nbsp;%s.\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]);<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$result</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">close</span><span style="color: #007700">();<br />}<br /><br /></span><span style="color: #FF8000">/*&nbsp;change&nbsp;db&nbsp;to&nbsp;non&nbsp;existing&nbsp;db&nbsp;*/<br /></span><span style="color: #0000BB">$maxdb</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">select_db</span><span style="color: #007700">(</span><span style="color: #DD0000">"XXXXXXXX"</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/*&nbsp;return&nbsp;name&nbsp;of&nbsp;current&nbsp;default&nbsp;database&nbsp;*/<br /></span><span style="color: #007700">if&nbsp;(</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$maxdb</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT&nbsp;SERVERDB&nbsp;FROM&nbsp;USERS&nbsp;WHERE&nbsp;USERNAME='MONA'"</span><span style="color: #007700">))&nbsp;{<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$row&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$result</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">fetch_row</span><span style="color: #007700">();<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Default&nbsp;database&nbsp;is&nbsp;%s.\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]);<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$result</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">close</span><span style="color: #007700">();<br />}<br /><br /></span><span style="color: #0000BB">$maxdb</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">close</span><span style="color: #007700">();<br /></span><span style="color: #0000BB">?&gt;</span>
    59. 

  59. </span>
    60. 

  60. </code></div>
    61. 

  61.    </div>
    62. 

  62. 

  63.   </div>
    64. 

  64.   <div class="example" id="example-1337">
    65. 

  65.    <p><strong>Example #2 过程化风格</strong></p>
    66. 

  66.    <div class="example-contents">
    67. 

  67. <div class="phpcode"><code><span style="color: #000000">
    68. 

  68. <span style="color: #0000BB">&lt;?php<br />$link&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">maxdb_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"MONA"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"RED"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"DEMODB"</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/*&nbsp;check&nbsp;connection&nbsp;*/<br /></span><span style="color: #007700">if&nbsp;(</span><span style="color: #0000BB">maxdb_connect_errno</span><span style="color: #007700">())&nbsp;{<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Connect&nbsp;failed:&nbsp;%s\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">maxdb_connect_error</span><span style="color: #007700">());<br />&nbsp;&nbsp;&nbsp;exit();<br />}<br /><br /></span><span style="color: #FF8000">/*&nbsp;return&nbsp;name&nbsp;of&nbsp;current&nbsp;default&nbsp;database&nbsp;*/<br /></span><span style="color: #007700">if&nbsp;(</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">maxdb_query</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"SELECT&nbsp;SERVERDB&nbsp;FROM&nbsp;USERS&nbsp;WHERE&nbsp;USERNAME='MONA'"</span><span style="color: #007700">))&nbsp;{<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$row&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">maxdb_fetch_row</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Default&nbsp;database&nbsp;is&nbsp;%s.\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]);<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">maxdb_free_result</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">);<br />}<br /><br /></span><span style="color: #FF8000">/*&nbsp;change&nbsp;db&nbsp;to&nbsp;non&nbsp;existing&nbsp;db&nbsp;*/<br /></span><span style="color: #0000BB">maxdb_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"XXXXXXXX"</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/*&nbsp;return&nbsp;name&nbsp;of&nbsp;current&nbsp;default&nbsp;database&nbsp;*/<br /></span><span style="color: #007700">if&nbsp;(</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">maxdb_query</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"SELECT&nbsp;SERVERDB&nbsp;FROM&nbsp;USERS&nbsp;WHERE&nbsp;USERNAME='MONA'"</span><span style="color: #007700">))&nbsp;{<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$row&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">maxdb_fetch_row</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Default&nbsp;database&nbsp;is&nbsp;%s.\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]);<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">maxdb_free_result</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">);<br />}<br /><br /></span><span style="color: #0000BB">maxdb_close</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?&gt;</span>
    69. 

  69. </span>
    70. 

  70. </code></div>
    71. 

  71.    </div>
    72. 

  72. 

  73.   </div>
    74. 

  74.   <p class="para">以上例程的输出类似于：</p>
    75. 

  75.   <div class="example-contents screen">
    76. 

  76. <div class="cdata"><pre>
    77. 

  77. Default database is &lt;...&gt;.
    78. 

  78. 

  79. Warning: maxdb_select_db(): -10709 Connection failed (RTE:database not running) &lt;...&gt;
    80. 

  80. 

  81. Warning: maxdb_query(): -10821 Session not connected [] &lt;...&gt;
    82. 

  82. 

  83. Warning: maxdb_close(): -10821 Session not connected [] &lt;...&gt;
    84. 

  84. </pre></div>
    85. 

  85.   </div>
    86. 

  86.  </div>
    87. 

  87. 

  88. 

  89.  <div class="refsect1 seealso" id="refsect1-function.maxdb-select-db-seealso">
    90. 

  90.   <h3 class="title">参见</h3>
    91. 

  91.   <p class="para">
    92. 

  92.    <ul class="simplelist">
    93. 

  93.     <li class="member"> <span class="function"><a href="function.maxdb-connect.html" class="function" rel="rdfs-seeAlso">maxdb_connect()</a> - Open a new connection to the MaxDB server</span></li>
    94. 

  94.     <li class="member"> <span class="function"><a href="function.maxdb-real-connect.html" class="function" rel="rdfs-seeAlso">maxdb_real_connect()</a> - Opens a connection to a MaxDB server</span></li>
    95. 

  95.    </ul>
    96. 

  96.   </p>
    97. 

  97.  </div>
    98. 

  98. 

  99. 

  100. </div><hr /><div class="manualnavbar" style="text-align: center;">
    101. 

  101.  <div class="prev" style="text-align: left; float: left;"><a href="function.maxdb-rpl-query-type.html">maxdb_rpl_query_type</a></div>
    102. 

  102.  <div class="next" style="text-align: right; float: right;"><a href="function.maxdb-send-long-data.html">maxdb_send_long_data</a></div>
    103. 

  103.  <div class="up"><a href="ref.maxdb.html">MaxDB 函数</a></div>
    104. 

  104.  <div class="home"><a href="index.html">PHP Manual</a></div>
    105. 

  105. </div></body></html>
    106. 

  106.