cvs: phpdoc-ja /reference/pgsql/functions pg-execute.xml pg-fetch-all-columns.xml pg-field-type-oid.xml pg-parameter-status.xml pg-prepare.xml
pg-query-params.xml pg-result-error-field.xml pg-send-execute.xml pg-send-prepare.xml pg-send-query-params.xml pg-set-error-verbosity.xml
pg-transaction-status.xml pg-version.xml
| From: | TAKAGI Masahiro | Date: | Fri, 19 Aug 2005 01:17:35 +0000 |
| Subject: | cvs: phpdoc-ja /reference/pgsql/functions pg-execute.xml pg-fetch-all-columns.xml pg-field-type-oid.xml pg-parameter-status.xml pg-prepare.xml pg-query-params.xml pg-result-error-field.xml pg-send-execute.xml pg-send-prepare.xml pg-send-query-params.xml pg-set-error-verbosity.xml pg-transaction-status.xml pg-version.xml |
||
| Groups: | php.doc.ja | ||
| Request: | Send a blank email to doc-ja+get-1133@lists.php.net to get a copy of this message | ||
takagi Thu Aug 18 21:17:35 2005 EDT
Added files:
/phpdoc-ja/reference/pgsql/functions pg-version.xml
pg-transaction-status.xml
pg-set-error-verbosity.xml
pg-send-query-params.xml
pg-send-prepare.xml
pg-send-execute.xml
pg-result-error-field.xml
pg-query-params.xml
pg-prepare.xml
pg-parameter-status.xml
pg-field-type-oid.xml
pg-fetch-all-columns.xml
pg-execute.xml
Log:
added japanese manual.
http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-version.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-version.xml +++ phpdoc-ja/reference/pgsql/functions/pg-version.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-version"> <refnamediv> <refname>pg_version</refname> <refpurpose> ã¯ã©ã¤ã¢ã³ãã»ãããã³ã«ã»ãµã¼ãã®ãã¼ã¸ã§ã³ãé åã§è¿ã </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>array</type><methodname>pg_version</methodname> <methodparam choice="opt"><type>resource</type><parameter>connection</parameter></methodparam> </methodsynopsis> <para> <function>pg_version</function> ã¯ã¯ã©ã¤ã¢ã³ãã»ãããã³ã« ããã³ãµã¼ãã®ãã¼ã¸ã§ã³ãé åã§è¿ãã¾ãããããã³ã«ããã³ãµã¼ãã® ãã¼ã¸ã§ã³ã¯ãPHP ã PostgreSQL 7.4 以éã¨ã¨ãã«ã³ã³ãã¤ã«ããã¦ãã å ´åã®ã¿æå¹ã§ãã </para> <para> 詳細ãªãµã¼ãæ å ±ãåå¾ããã«ã¯ <function>pg_parameter_status</function> ãåç §ãã ããã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> <literal>client</literal>, <literal>protocol</literal> ããã³ <literal>server_version</literal> ã®ãã¼ã¨ãã®å¤ãæã¤é åã è¿ãã¾ãï¼æå¹ãªå ´åï¼ãã¨ã©ã¼æãæ¥ç¶ãæ£å¸¸ã§ãªãå ´åã« &false; ãè¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_version</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("host=localhost port=5432 dbname=mary") or die("Could not connect"); $v = pg_version($dbconn); echo $v['client']; ?> ]]> </programlisting> &example.outputs; <screen> <![CDATA[ 7.4 ]]> </screen> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_parameter_status</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-transaction-status.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-transaction-status.xml +++ phpdoc-ja/reference/pgsql/functions/pg-transaction-status.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.5 Maintainer: takagi Status: ready --> <refentry id='function.pg-transaction-status'> <refnamediv> <refname>pg_transaction_status</refname> <refpurpose>ãµã¼ãä¸ã§å®è¡ä¸ã®ãã©ã³ã¶ã¯ã·ã§ã³ã®ç¶æ ãè¿ã</refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>int</type><methodname>pg_transaction_status</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> </methodsynopsis> <para> ãµã¼ãä¸ã§å®è¡ä¸ã®ãã©ã³ã¶ã¯ã·ã§ã³ã®ç¶æ ãè¿ãã¾ãã </para> <caution> <para> PostgreSQL 7.3 ãµã¼ãã§ <literal>autocommit</literal> ã off ã« è¨å®ãã¦ããå ´åã<function>pg_transaction_status</function> ã¯ ä¸æ£ç¢ºãªå¤ãè¿ãã¾ãããµã¼ãå´ã§ã®èªåã³ãããæ©è½ã¯éæ¨å¥¨ã¨ ããã¦ãããæè¿ã®ãã¼ã¸ã§ã³ã®ãµã¼ãã§ã¯åå¨ãã¾ããã </para> </caution> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹ã®æ¥ç¶ãªã½ã¼ã¹ã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para><constant>PGSQL_TRANSACTION_IDLE</constant>ï¼ã¢ã¤ãã«ç¶æ ï¼ã <constant>PGSQL_TRANSACTION_ACTIVE</constant>ï¼ã³ãã³ãã®å®è¡ä¸ï¼ã <constant>PGSQL_TRANSACTION_INTRANS</constant>ï¼æ£å¸¸ãªãã©ã³ã¶ã¯ã·ã§ã³å ã§ã¢ã¤ãã«ç¶æ ï¼ã ããã㯠<constant>PGSQL_TRANSACTION_INERROR</constant>ï¼å¤±æãããã©ã³ã¶ã¯ã·ã§ã³å ã§ã¢ã¤ãã«ç¶æ ï¼ ã®ãããããè¿ãã¾ãã æ¥ç¶ãç°å¸¸ãªå ´å㯠<constant>PGSQL_TRANSACTION_UNKNOWN</constant> ãè¿ãã¾ãã <constant>PGSQL_TRANSACTION_ACTIVE</constant> ãè¿ãããã®ã¯ãã¯ã¨ãªã ãµã¼ãã«éä¿¡ããå¾ã¾ã ãããå®äºãã¦ããªãå ´åã®ã¿ã§ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_transaction_status</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); $stat = pg_transaction_status($dbconn); if ($stat === PGSQL_TRANSACTION_UNKNOWN) { echo 'Connection is bad'; } else if ($stat === PGSQL_TRANSACTION_IDLE) { echo 'Connection is currently idle'; } else { echo 'Connection is in a transaction state'; } ?> ]]> </programlisting> </example> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-set-error-verbosity.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-set-error-verbosity.xml +++ phpdoc-ja/reference/pgsql/functions/pg-set-error-verbosity.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.6 Maintainer: takagi Status: ready --> <refentry id="function.pg-set-error-verbosity"> <refnamediv> <refname>pg_set_error_verbosity</refname> <refpurpose> <function>pg_last_error</function> ããã³ <function>pg_result_error</function> ãè¿ãã¡ãã»ã¼ã¸ã®è©³ç´°åº¦ãæå®ãã </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>int</type><methodname>pg_set_error_verbosity</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>int</type><parameter>verbosity</parameter></methodparam> </methodsynopsis> <methodsynopsis> <type>int</type><methodname>pg_set_error_verbosity</methodname> <methodparam><type>int</type><parameter>verbosity</parameter></methodparam> </methodsynopsis> <para> <function>pg_last_error</function> ããã³ <function>pg_result_error</function> ãè¿ãã¡ãã»ã¼ã¸ã®è©³ç´°åº¦ãæå®ãã¾ãã </para> <para> <function>pg_set_error_verbosity</function> ã¯è©³ç´°åº¦ãè¨å®ãããã®æ¥ç¶ã® ããã¾ã§ã®è¨å®ãè¿ãã¾ãã<constant>PGSQL_ERRORS_TERSE</constant> ã¢ã¼ãã§ã¯ãè¿ãããã¡ãã»ã¼ã¸ã¯æ·±å»åº¦ã»æ¦è¦ ããã³ çºçä½ç½®ã®ã¿ã§ãã ããã¯ããã¦ãã®å ´å 1 è¡ã«åã¾ãã¾ããããã©ã«ãã®ã¢ã¼ã ï¼<constant>PGSQL_ERRORS_DEFAULT</constant>ï¼ã§ã¯ãããã«å ãã¦ä½ãã㮠詳細æ å ±ã»ãã³ããããã¯ç¶æ³ãã£ã¼ã«ããå«ã¿ã¾ãï¼ãããã¯è¤æ°è¡ã« ã¾ãããå¯è½æ§ãããã¾ãï¼ã<constant>PGSQL_ERRORS_VERBOSE</constant> ã¢ã¼ãã¯ãæå¹ãªãã£ã¼ã«ãããã¹ã¦å«ã¿ã¾ãã詳細度ã®è¨å®å¤æ´å 容㯠ãã以éã«æ°ãã使ããçµæãªãã¸ã§ã¯ãã«ã®ã¿åæ ãããæ¢åã® çµæãªãã¸ã§ã¯ãã«ã¯å½±é¿ãä¸ãã¾ããã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>verbosity</parameter></term> <listitem> <para> æå®ãã詳細度ã<constant>PGSQL_ERRORS_TERSE</constant>ã <constant>PGSQL_ERRORS_DEFAULT</constant> ããã㯠<constant>PGSQL_ERRORS_VERBOSE</constant> ã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> 夿´åã®è©³ç´°åº¦ã¬ãã«ã<constant>PGSQL_ERRORS_TERSE</constant>ã <constant>PGSQL_ERRORS_DEFAULT</constant> ããã㯠<constant>PGSQL_ERRORS_VERBOSE</constant> ã®ããããã è¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_set_error_verbosity</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); if (!pg_connection_busy($dbconn)) { pg_send_query($dbconn, "select * from doesnotexist;"); } pg_set_error_verbosity($dbconn, PGSQL_ERRORS_VERBOSE); $res1 = pg_get_result($dbconn); echo pg_result_error($res1); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_last_error</function></member> <member><function>pg_result_error</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-send-query-params.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-send-query-params.xml +++ phpdoc-ja/reference/pgsql/functions/pg-send-query-params.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id='function.pg-send-query-params'> <refnamediv> <refname>pg_send_query_params</refname> <refpurpose>ã³ãã³ãã¨ãã©ã¡ã¼ã¿ãåå²ãã¦ãµã¼ãã«éä¿¡ãããã®çµæãå¾ ããªã</refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>bool</type><methodname>pg_send_query_params</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <para> ã³ãã³ãã¨ãã©ã¡ã¼ã¿ãåå²ãã¦ãµã¼ãã«éä¿¡ãã¾ãããã®çµæãå¾ ã¤ãã¨ã¯ ãã¾ããã </para> <para> ãã㯠<function>pg_send_query</function> ã¨ã»ã¼åãã§ããããã©ã¡ã¼ã¿ã <parameter>query</parameter> ã¨ã¯å¥ã«åããã¦ããç¹ãéãã¾ãã 颿°ã®ãã©ã¡ã¼ã¿ã¯ã<function>pg_query_params</function> ã«ãã£ã¦ å®å ¨ã«å¶å¾¡ããã¾ãã<function>pg_query_params</function> ã¨åæ§ã 7.4 ããåã® PostgreSQL ã§ã¯åä½ãã¾ãããã¾ãã¯ã¨ãªæååã«ã¯ ã²ã¨ã¤ã®ã³ãã³ãã®ã¿ãå«ãããã¨ãã§ãã¾ãã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹ã®æ¥ç¶ãªã½ã¼ã¹ã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>query</parameter></term> <listitem> <para> ãã©ã¡ã¼ã¿åãã SQL æãã²ã¨ã¤ã®æã®ã¿ã§ããå¿ è¦ãããã¾ã ï¼è¤æ°ã®æãã»ãã³ãã³ã§åºåãå½¢å¼ã¯ä½¿ç¨ã§ãã¾ããï¼ããã©ã¡ã¼ã¿ã 使ç¨ããé㯠$1ã$2 ãªã©ã®å½¢å¼ã§åç §ããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>params</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãä¸ã® $1ã$2 ãªã©ã®ãã¬ã¼ã¹ãã«ãã ç½®ãæãããã©ã¡ã¼ã¿ã®é åãé åã®è¦ç´ æ°ã¯ãã¬ã¼ã¹ãã«ãã® æ°ã¨ä¸è´ããå¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para>&return.success;</para> <para> ã¯ã¨ãªã®çµæã夿ããã«ã¯ <function>pg_get_result</function> ã使ç¨ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_send_query_params</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); // ãã©ã¡ã¼ã¿ã使ç¨ããããã©ã¡ã¼ã¿ã«ã¯ã¯ã©ã¼ããã¨ã¹ã±ã¼ãã // å¿ è¦ãªããã¨ã«æ³¨æ pg_send_query_params($dbconn, 'select count(*) from authors where city = $1', array('Perth')); // åºæ¬ç㪠pg_send_query ã®ä½¿ç¨æ³ã¨ã®æ¯è¼ $str = pg_escape_string('Perth'); pg_send_query($dbconn, "select count(*) from authors where city = '${str}'"); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_send_query</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-send-prepare.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-send-prepare.xml +++ phpdoc-ja/reference/pgsql/functions/pg-send-prepare.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-send-prepare"> <refnamediv> <refname>pg_send_prepare</refname> <refpurpose> æå®ãããã©ã¡ã¼ã¿ã§ããªãã¢ãã¹ãã¼ãã¡ã³ãã使ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ããªã </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>bool</type><methodname>pg_send_prepare</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> </methodsynopsis> <para> æå®ãããã©ã¡ã¼ã¿ã§ããªãã¢ãã¹ãã¼ãã¡ã³ãã使ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ã¡ã¾ããã </para> <para> ãã㯠<function>pg_prepare</function> ã®éåæãã¼ã¸ã§ã³ã§ãã ãªã¯ã¨ã¹ããåãä»ããããå ´åã« &true; ãããã§ãªãå ´åã« &false; ãè¿ãã¾ããã³ã¼ã«ãæåããå¾ãå®éã«ããªãã¢ãã¹ãã¼ãã¡ã³ãã 使ããããã©ããã調ã¹ãã«ã¯ <function>pg_get_result</function> ã使ç¨ãã¾ãã颿°ã®ãã©ã¡ã¼ã¿ã¯ <function>pg_prepare</function> ã¨åãããã«å¦çããã¾ãã<function>pg_prepare</function> ã¨åæ§ã 7.4 ããåã® PostgreSQL ã®ãã¼ã¸ã§ã³ã§ã¯æ£ããåä½ãã¾ããã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>stmtname</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãã«ã¤ããååãæ¥ç¶å ã§ä¸æã§ããå¿ è¦ãããã¾ãã "" ãæå®ãããå ´åã¯ç¡åã¹ãã¼ãã¡ã³ãã使ããã以åã«å®ç¾©ããã ç¡åã¹ãã¼ãã¡ã³ãã䏿¸ããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>query</parameter></term> <listitem> <para> ãã©ã¡ã¼ã¿åãã SQL æãã²ã¨ã¤ã®æã®ã¿ã§ããå¿ è¦ãããã¾ã ï¼è¤æ°ã®æãã»ãã³ãã³ã§åºåãå½¢å¼ã¯ä½¿ç¨ã§ãã¾ããï¼ããã©ã¡ã¼ã¿ã 使ç¨ããé㯠$1ã$2 ãªã©ã®å½¢å¼ã§åç §ããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para>æåããå ´åã« &true; ã失æããå ´åã« &false; ãè¿ãã¾ãã ã¯ã¨ãªã®çµæã確ãããã«ã¯ <function>pg_get_result</function> ã使ç¨ãã¾ãã</para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_send_prepare</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); // å®è¡ããã¯ã¨ãªãæºåãã if (!pg_connection_busy($dbconn)) { pg_send_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1'); $res1 = pg_get_result($dbconn); } // ããªãã¢ãã¯ã¨ãªãå®è¡ãããæåå "Joe's Widgets" 㯠// ã¨ã¹ã±ã¼ãã®å¿ è¦ããªããã¨ã«æ³¨æ if (!pg_connection_busy($dbconn)) { pg_send_execute($dbconn, "my_query", array("Joe's Widgets")); $res2 = pg_get_result($dbconn); } // åä¸ããªãã¢ãã¯ã¨ãªãå¥ã®ãã©ã¡ã¼ã¿ã§å®è¡ãã if (!pg_connection_busy($dbconn)) { pg_send_execute($dbconn, "my_query", array("Clothes Clothes Clothes")); $res3 = pg_get_result($dbconn); } ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_connect</function></member> <member><function>pg_pconnect</function></member> <member><function>pg_execute</function></member> <member><function>pg_send_execute</function></member> <member><function>pg_send_query_params</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-send-execute.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-send-execute.xml +++ phpdoc-ja/reference/pgsql/functions/pg-send-execute.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-send-execute"> <refnamediv> <refname>pg_send_execute</refname> <refpurpose> æå®ãããã©ã¡ã¼ã¿ã§ããªãã¢ãã¹ãã¼ãã¡ã³ããå®è¡ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ããªã </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>bool</type><methodname>pg_send_execute</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <para> æå®ãããã©ã¡ã¼ã¿ã§ããªãã¢ãã¹ãã¼ãã¡ã³ããå®è¡ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ã¡ã¾ããã </para> <para> ãã㯠<function>pg_send_query_params</function> ã¨ä¼¼ã¦ãã¾ãã ããããå®è¡ããã³ãã³ãã¯æå®ããã¯ã¨ãªæååã§æ±ºã¾ãã®ã§ã¯ãªã äºåã«æºåãããã¹ãã¼ãã¡ã³ãã®ååã§æ±ºã¾ãã¾ãã颿°ã®ãã©ã¡ã¼ã¿ã¯ <function>pg_execute</function> ã¨åãããã«å¦çããã¾ãã <function>pg_execute</function> ã¨åæ§ã«ã7.4 ããåã®ãã¼ã¸ã§ã³ã® PostgreSQL ã§ã¯åä½ãã¾ããã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>stmtname</parameter></term> <listitem> <para> å®è¡ããããªãã¢ãã¹ãã¼ãã¡ã³ãã®ååã"" ãæå®ãããå ´å㯠ç¡åã¹ãã¼ãã¡ã³ããå®è¡ããã¾ããååã¯ãäºåã« <function>pg_prepare</function>ã»<function>pg_send_prepare</function> ããã㯠<literal>PREPARE</literal> SQL ã³ãã³ãã§æºåããããã®ã§ãã å¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>params</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãä¸ã® $1ã$2 ãªã©ã®ãã¬ã¼ã¹ãã«ãã ç½®ãæãããã©ã¡ã¼ã¿ã®é åãé åã®è¦ç´ æ°ã¯ãã¬ã¼ã¹ãã«ãã® æ°ã¨ä¸è´ããå¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para>æåããå ´åã« &true; ã失æããå ´åã« &false; ãè¿ãã¾ãã ã¯ã¨ãªã®çµæã確èªããã«ã¯ <function>pg_get_result</function> ã使ç¨ãã¾ãã</para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_send_execute</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); // å®è¡ããã¯ã¨ãªãæºåãã if (!pg_connection_busy($dbconn)) { pg_send_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1'); $res1 = pg_get_result($dbconn); } // ããªãã¢ãã¯ã¨ãªãå®è¡ããã æåå "Joe's Widgets" 㯠// ã¨ã¹ã±ã¼ãã®å¿ è¦ããªããã¨ã«æ³¨æ if (!pg_connection_busy($dbconn)) { pg_send_execute($dbconn, "my_query", array("Joe's Widgets")); $res2 = pg_get_result($dbconn); } // åãããªãã¢ãã¯ã¨ãªãç°ãªããã©ã¡ã¼ã¿ã§å®è¡ãã if (!pg_connection_busy($dbconn)) { pg_send_execute($dbconn, "my_query", array("Clothes Clothes Clothes")); $res3 = pg_get_result($dbconn); } ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_prepare</function></member> <member><function>pg_send_prepare</function></member> <member><function>pg_execute</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-result-error-field.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-result-error-field.xml +++ phpdoc-ja/reference/pgsql/functions/pg-result-error-field.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.7 Maintainer: takagi Status: ready --> <refentry id='function.pg-result-error-field'> <refnamediv> <refname>pg_result_error_field</refname> <refpurpose>ã¨ã©ã¼å ±åã®åãã£ã¼ã«ããè¿ã</refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>string</type><methodname>pg_result_error_field</methodname> <methodparam><type>resource</type><parameter>result</parameter></methodparam> <methodparam><type>int</type><parameter>fieldcode</parameter></methodparam> </methodsynopsis> <para> <function>pg_result_error_field</function> ã¯ã<parameter>result</parameter> ãªã½ã¼ã¹ã«é¢ããã¨ã©ã¼ã¡ãã»ã¼ã¸ã®ç¹å®ã®ãã£ã¼ã«ããè¿ãã¾ãã PostgreSQL 7.4 以éã®ãµã¼ãã§ã®ã¿æå¹ã§ããã¨ã©ã¼ãã£ã¼ã«ã㯠<parameter>fieldcode</parameter> ã§å®ç¾©ãã¾ãã </para> <para> <function>pg_query</function> ã <function>pg_query_params</function> ã¯ã¯ã¨ãªã失æããå ´åã« &false; ãè¿ãã®ã§ãçµæã®ãã³ãã«ãå¾ãã«ã¯ <function>pg_send_query</function> ããã³ <function>pg_get_result</function> ã使ç¨ããå¿ è¦ãããã¾ãã </para> <para> 失æãã <function>pg_query</function> ã¯ã¨ãªãã詳細ãªã¨ã©ã¼æ å ±ã åå¾ããå¿ è¦ãããå ´åã¯ã<function>pg_set_error_verbosity</function> ããã³ <function>pg_last_error</function> ã使ç¨ãã¦ãã®çµæããã¼ã¹ ãã¾ãã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>result</parameter></term> <listitem> <para> å®è¡ããã¹ãã¼ãã¡ã³ãã®ã¯ã¨ãªçµæãªã½ã¼ã¹ã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>fieldcode</parameter></term> <listitem> <para> 以ä¸ã® <parameter>fieldcode</parameter> ã使ç¨å¯è½ã§ãã <constant>PGSQL_DIAG_SEVERITY</constant>ã <constant>PGSQL_DIAG_SQLSTATE</constant>ã<constant>PGSQL_DIAG_MESSAGE_PRIMARY</constant>ã <constant>PGSQL_DIAG_MESSAGE_DETAIL</constant>ã <constant>PGSQL_DIAG_MESSAGE_HINT</constant>ã<constant>PGSQL_DIAG_STATEMENT_POSITION</constant>ã <constant>PGSQL_DIAG_INTERNAL_POSITION</constant>ï¼PostgreSQL 8.0+ ã®ã¿ï¼ã <constant>PGSQL_DIAG_INTERNAL_QUERY</constant>ï¼PostgreSQL 8.0+ ã®ã¿ï¼ã <constant>PGSQL_DIAG_CONTEXT</constant>ã<constant>PGSQL_DIAG_SOURCE_FILE</constant>ã <constant>PGSQL_DIAG_SOURCE_LINE</constant> ããã㯠<constant>PGSQL_DIAG_SOURCE_FUNCTION</constant> ã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para>ã¨ã©ã¼ãã£ã¼ã«ãã®å 容ãæååã§è¿ãã¾ãã ãã£ã¼ã«ããåå¨ããªãå ´åã« &null; ã失æããå ´åã« &false; ãè¿ãã¾ãã</para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_result_error_field</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); if (!pg_connection_busy($dbconn)) { pg_send_query($dbconn, "select * from doesnotexist;"); } $res1 = pg_get_result($dbconn); echo pg_result_error_field($res1, PGSQL_DIAG_SQLSTATE); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_result_error</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-query-params.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-query-params.xml +++ phpdoc-ja/reference/pgsql/functions/pg-query-params.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-query-params"> <refnamediv> <refname>pg_query_params</refname> <refpurpose> SQL ã³ãã³ãã¨ãã©ã¡ã¼ã¿ãåå²ãã¦ãµã¼ãã«ãéä¿¡ãããã®çµæãå¾ ã¤ </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>resource</type><methodname>pg_query_params</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <methodsynopsis> <type>resource</type><methodname>pg_query_params</methodname> <methodparam><type>string</type><parameter>query</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <para> ã³ãã³ãããµã¼ãã«éä¿¡ãããã®çµæãå¾ ã¡ã¾ãããã©ã¡ã¼ã¿ã SQL ã³ãã³ã ã¨ã¯å¥ã«æ¸¡ããã¨ãå¯è½ã§ãã </para> <para> <function>pg_query_params</function> 㯠<function>pg_query</function> ã¨ä¼¼ã¦ãã¾ããã追å ã®æ©è½ãæãã¦ãã¾ããããã¯ãã©ã¡ã¼ã¿å¤ã ã³ãã³ãæååã¨åé¢ãã¦ããã¨ãããã¨ã§ãã <function>pg_query_params</function> 㯠PostgreSQL 7.4 以éã®æ¥ç¶ã§ã®ã¿ ãµãã¼ãããã¾ãããã以åã®ãã¼ã¸ã§ã³ã§ã¯å¤±æãã¾ãã </para> <para> ãã©ã¡ã¼ã¿ã使ç¨ããéã¯ã<parameter>query</parameter> æååå ã§ $1ã$2 ã®ããã«åç §ããã¾ãã<parameter>params</parameter> ã§ å®éã®å¤ãæå®ãã¾ãã&null; ãæå®ããã¨ãSQL ã® <literal>NULL</literal> ã¨ã¿ãªããã¾ãã </para> <para> <function>pg_query</function> ã«å¯¾ãã <function>pg_query_params</function> ã®æå¤§ã®å©ç¹ã¯ããã©ã¡ã¼ã¿ã®å¤ã <parameter>query</parameter> æååãã åé¢ã§ãããã¨ã§ãããã®ãããéå±ã§ã¨ã©ã¼ã®å ã¨ãªããããã¯ã©ã¼ãã» ã¨ã¹ã±ã¼ããªã©ãããªãã¦ããããªãã¾ãã<function>pg_query</function> ã¨ç°ãªãã<function>pg_query_params</function> ã§ã¯ã²ã¨ã¤ã® SQL ã³ãã³ãããå®è¡ã§ãã¾ããï¼ã¯ã¨ãªæååã«ã»ãã³ãã³ãå«ãããã¨ã¯ å¯è½ã§ããããããã以éã«ã³ãã³ããç¶ãããã¨ã¯ã§ãã¾ããï¼ã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>query</parameter></term> <listitem> <para> ãã©ã¡ã¼ã¿åãã SQL æãã²ã¨ã¤ã®æã®ã¿ã§ããå¿ è¦ãããã¾ã ï¼è¤æ°ã®æãã»ãã³ãã³ã§åºåãå½¢å¼ã¯ä½¿ç¨ã§ãã¾ããï¼ããã©ã¡ã¼ã¿ã 使ç¨ããé㯠$1ã$2 ãªã©ã®å½¢å¼ã§åç §ããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>params</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãä¸ã® $1ã$2 ãªã©ã®ãã¬ã¼ã¹ãã«ãã ç½®ãæãããã©ã¡ã¼ã¿ã®é åãé åã®è¦ç´ æ°ã¯ãã¬ã¼ã¹ãã«ãã® æ°ã¨ä¸è´ããå¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> æåããå ´åã«ã¯ã¨ãªçµæãªã½ã¼ã¹ã失æããå ´åã« &false; ãè¿ãã¾ãã</para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_query_params</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php // "mary"ã¨ããååã®ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ $dbconn = pg_connect("dbname=mary"); // Joe's Widgets ã¨ããååã®åºãæ¢ãã"Joe's Widgets" ã // ã¨ã¹ã±ã¼ãããå¿ è¦ããªããã¨ã«æ³¨æ $result = pg_query_params($dbconn, 'SELECT * FROM shops WHERE name = $1', array("Joe's Widgets")); // pg_query ã使ç¨ããå ´åã¨æ¯è¼ $str = pg_escape_string("Joe's Widgets"); $result = pg_query($dbconn, "SELECT * FROM shops WHERE name = '{$str}'"); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_query</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-prepare.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-prepare.xml +++ phpdoc-ja/reference/pgsql/functions/pg-prepare.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-prepare"> <refnamediv> <refname>pg_prepare</refname> <refpurpose> æå®ãããã©ã¡ã¼ã¿ã§ããªãã¢ãã¹ãã¼ãã¡ã³ãã使ãããªã¯ã¨ã¹ãã éä¿¡ãããã®å®äºãå¾ ã¤ </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>resource</type><methodname>pg_prepare</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> </methodsynopsis> <methodsynopsis> <type>resource</type><methodname>pg_prepare</methodname> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> </methodsynopsis> <para> <function>pg_prepare</function> ã¯ã <function>pg_execute</function> ããã㯠<function>pg_send_execute</function> ã§å¾ã«å®è¡ããããã®ããªãã¢ãã¹ãã¼ãã¡ã³ãã使ãã¾ããããã«ããã ç¹°ãè¿ã使ç¨ãããã³ãã³ãã«ã¤ãã¦ã®æ§æè§£æãå®è¡è¨ç»ä½æãæåã® ä¸åº¦ã ãã§ãã¿ã¾ãã<function>pg_prepare</function> 㯠PostgreSQL 7.4 以éã®æ¥ç¶ã§ã®ã¿ä½¿ç¨å¯è½ã§ãããã以åã®ãã¼ã¸ã§ã³ã§ã¯å¤±æãã¾ãã </para> <para> ãã®é¢æ°ã¯ <parameter>stmtname</parameter> ã¨ããååã® ããªãã¢ãã¹ãã¼ãã¡ã³ãã <parameter>query</parameter> æååãã使ãã¾ãã ãã®æååã«ã¯ 1 ã¤ã® SQL ã³ãã³ããå«ã¾ãã¦ããå¿ è¦ãããã¾ãã <parameter>stmtname</parameter> ã "" ã«ãããã¨ã§ç¡åã¹ãã¼ãã¡ã³ãã 使ãããã¨ãå¯è½ã§ãæ¢åã®ç¡åã¹ãã¼ãã¡ã³ãã¯èªåçã«ä¸æ¸ãããã¾ãã ãã以å¤ã®å ´åãããã«ã¬ã³ãã®ã»ãã·ã§ã³ã§æ¢ã«å®ç¾©æ¸ã¿ã®ã¹ãã¼ãã¡ã³ãåã 使ç¨ããå ´åã«ã¯ã¨ã©ã¼ã¨ãªãã¾ãããã©ã¡ã¼ã¿ã使ç¨ããéã¯ã <parameter>query</parameter> å ã§ $1ã$2 ã®ãããªå½¢å¼ã§åç §ããã¾ãã </para> <para> <function>pg_prepare</function> ã§ä½¿ç¨ããããªãã¢ãã¹ãã¼ãã¡ã³ãã¯ã SQLã® <literal>PREPARE</literal> æãå®è¡ãããã¨ã§ã使å¯è½ã§ã ï¼ãããããã©ã¡ã¼ã¿ã®åãäºåã«æå®ããå¿ è¦ããªãã¨ããç¹ã§ <function>pg_prepare</function> ã®ã»ããããæè»ã§ãï¼ã ã¾ããPHP ã«ã¯ããªãã¢ãã¹ãã¼ãã¡ã³ããåé¤ãã颿°ãããã¾ãããã ãã®ç®çã®ããã«ã¯ SQLã® <literal>DEALLOCATE</literal> æã使ç¨å¯è½ã§ãã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>stmtname</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãã«ã¤ããååãæ¥ç¶å ã§ä¸æã§ããå¿ è¦ãããã¾ãã "" ãæå®ãããå ´åã¯ç¡åã¹ãã¼ãã¡ã³ãã使ããã以åã«å®ç¾©ããã ç¡åã¹ãã¼ãã¡ã³ãã䏿¸ããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>query</parameter></term> <listitem> <para> ãã©ã¡ã¼ã¿åãã SQL æãã²ã¨ã¤ã®æã®ã¿ã§ããå¿ è¦ãããã¾ã ï¼è¤æ°ã®æãã»ãã³ãã³ã§åºåãå½¢å¼ã¯ä½¿ç¨ã§ãã¾ããï¼ããã©ã¡ã¼ã¿ã 使ç¨ããé㯠$1ã$2 ãªã©ã®å½¢å¼ã§åç §ããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> æåããå ´åã«ã¯ã¨ãªçµæãªã½ã¼ã¹ã失æããå ´åã« &false; ãè¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_prepare</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php // "mary"ã¨ããååã®ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ $dbconn = pg_connect("dbname=mary"); // å®è¡ããã¯ã¨ãªã®æºå $result = pg_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1'); // ããªãã¢ãã¯ã¨ãªãå®è¡ãããæåå "Joe's Widgets" 㯠// ã¨ã¹ã±ã¼ãã®å¿ è¦ããªããã¨ã«æ³¨æ $result = pg_execute($dbconn, "my_query", array("Joe's Widgets")); // åä¸ããªãã¢ãã¯ã¨ãªãå¥ã®ãã©ã¡ã¼ã¿ã§å®è¡ãã $result = pg_execute($dbconn, "my_query", array("Clothes Clothes Clothes")); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_execute</function></member> <member><function>pg_send_execute</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-parameter-status.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-parameter-status.xml +++ phpdoc-ja/reference/pgsql/functions/pg-parameter-status.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.9 Maintainer: takagi Status: ready --> <refentry id="function.pg-parameter-status"> <refnamediv> <refname>pg_parameter_status</refname> <refpurpose>ãµã¼ãã®ãã©ã¡ã¼ã¿è¨å®ãæ¤ç´¢ãã</refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>string</type><methodname>pg_parameter_status</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>param_name</parameter></methodparam> </methodsynopsis> <methodsynopsis> <type>string</type><methodname>pg_parameter_status</methodname> <methodparam><type>string</type><parameter>param_name</parameter></methodparam> </methodsynopsis> <para> ãµã¼ãã®ãã©ã¡ã¼ã¿è¨å®ãæ¤ç´¢ãã¾ãã </para> <para> ããã¤ãã®ãã©ã¡ã¼ã¿ã«ã¤ãã¦ã¯ãæ¥ç¶ã®ç¢ºç«æãå¤ã®å¤æ´æã«ãµã¼ããã èªåçã«éç¥ããã¾ãã<function>pg_parameter_status</function> 㯠ãããã®è¨å®åãåãããããã«ä½¿ç¨å¯è½ã§ããæå®ãããã©ã¡ã¼ã¿ãåå¨ãã å ´åã«ãã®å¤ããåå¨ããªãå ´åã« &false; ãè¿ãã¾ãã </para> <para> PostgreSQL 8.0 ã§æå®ã§ãããã©ã¡ã¼ã¿ã«ã¯ä»¥ä¸ãå«ã¾ãã¾ãã <literal>server_version</literal>ã <literal>server_encoding</literal>ã<literal>client_encoding</literal>ã <literal>is_superuser</literal>ã<literal>session_authorization</literal>ã <literal>DateStyle</literal>ã<literal>TimeZone</literal> ããã³ <literal>integer_datetimes</literal> ï¼<literal>server_encoding</literal>ã<literal>TimeZone</literal> ããã³ <literal>integer_datetimes</literal> 㯠8.0 ããåã®ãã¼ã¸ã§ã³ã§ã¯æå®ã§ãã¾ããï¼ã <literal>server_version</literal>ã<literal>server_encoding</literal> ããã³ <literal>integer_datetimes</literal> ã¯ãPostgreSQL ã®ç¨¼åä¸ã«ã¯å¤æ´ã§ããªããã¨ã«æ³¨æãã¾ãããã </para> <para> PostgreSQL 7.3 以åã®ãµã¼ãã¯ãã©ã¡ã¼ã¿è¨å®ãéç¥ããæ©è½ãæã£ã¦ãã¾ããã ãããã<function>pg_parameter_status</function> ã«ã¯ <literal>server_version</literal> ããã³ <literal>client_encoding</literal> ãåå¾ããæ©è½ãçµã¿è¾¼ãã§ãã¾ãããããã®å¤ãåå¾ããããã«ã¢ããªã±ã¼ã·ã§ã³ã§ ã¢ãããã¯ãªã³ã¼ããæ¸ãã®ã§ã¯ãªãã<function>pg_parameter_status</function> ã使ç¨ãããã¨ãæ¨å¥¨ãã¾ãã </para> <caution> <para> 7.4 ããåã® PostgreSQL ãµã¼ãã§ã¯ãæ¥ç¶ã®ç¢ºç«å¾ã« <literal>SET</literal> ãç¨ã㦠<literal>client_encoding</literal> ã夿´ãã¦ã <function>pg_parameter_status</function> ã«ã¯åæ ããã¾ããã </para> </caution> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>param_name</parameter></term> <listitem> <para> æå®å¯è½ãª <parameter>param_name</parameter> ã«ã¯ä»¥ä¸ãå«ã¾ãã¾ãã <literal>server_version</literal>ã <literal>server_encoding</literal>ã<literal>client_encoding</literal>ã <literal>is_superuser</literal>ã<literal>session_authorization</literal>ã <literal>DateStyle</literal>ã<literal>TimeZone</literal> ããã³ <literal>integer_datetimes</literal>ã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> ãã©ã¡ã¼ã¿ã®å¤ãæååã§è¿ãã¾ãã失æããå ´åã <parameter>param_name</parameter> ãééã£ã¦ããå ´åã«ã¯ &false; ãè¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_parameter_status</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); echo "Server encoding: ", pg_parameter_status($dbconn, "server_encoding"); ?> ]]> </programlisting> &example.outputs; <screen> <![CDATA[ Server encoding: SQL_ASCII ]]> </screen> </example> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-field-type-oid.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-field-type-oid.xml +++ phpdoc-ja/reference/pgsql/functions/pg-field-type-oid.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.5 Maintainer: takagi Status: ready --> <refentry id="function.pg-field-type-oid"> <refnamediv> <refname>pg_field_type_oid</refname> <refpurpose> ãã£ã¼ã«ãçªå·ã«å¯¾å¿ããå IDï¼OIDï¼ãè¿ã </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>int</type><methodname>pg_field_type_oid</methodname> <methodparam><type>resource</type><parameter>result</parameter></methodparam> <methodparam><type>int</type><parameter>field_number</parameter></methodparam> </methodsynopsis> <para> <function>pg_field_type_oid</function> ã¯ãæå®ãã PostgreSQL <parameter>result</parameter> ãªã½ã¼ã¹ã«ãããæå®ãã <parameter>field_number</parameter> ã®åã® OID ãè¿ãã¾ãã </para> <para> ãã£ã¼ã«ãåã«ã¤ãã¦ã®è©³ç´°ãªæ å ±ãå¾ãã«ã¯ãPostgreSQL ã®ã·ã¹ãã ãã¼ãã« <literal>pg_type</literal> ã«å¯¾ãã¦ããã®é¢æ°ã§åå¾ãã OID ãç¨ã㦠åãåããã¾ããPostgreSQL ã® <function>format_type</function> 颿°ã¯ã åã® OID ã SQL ã®ååã«å¤æãã¾ãã </para> <note> <para> ãã£ã¼ã«ããï¼åºæ¬åã§ã¯ãªãï¼PostgreSQL ãã¡ã¤ã³ã使ç¨ãã¦ããå ´åã¯ã ãã¡ã¤ã³ãã®ãã®ã® OID ã§ã¯ãªããã¡ã¤ã³ã®å ã¨ãªã£ã¦ããåã® OID ãè¿ãã¾ãã </para> </note> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>result</parameter></term> <listitem> <para> <function>pg_query</function>, <function>pg_query_params</function> ããã㯠<function>pg_execute</function> ããè¿ããã PostgreSQL ã® ã¯ã¨ãªçµæãªã½ã¼ã¹ã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>field_number</parameter></term> <listitem> <para> ãã£ã¼ã«ãçªå·ã0 ããå§ã¾ãã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> ãã£ã¼ã«ãã®åã«å¯¾å¿ãã OID ãè¿ãã¾ããã¨ã©ã¼æã«ã¯ &false; ãè¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title>ãã£ã¼ã«ãã®æ å ±ãå¾ã</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); // 'title' 㯠varchar åã§ããã¨ä»®å®ãã $res = pg_query($dbconn, "select title from authors where author = 'Orwell'"); echo "Title field type OID: ", pg_field_type_oid($res, 0); ?> ]]> </programlisting> &example.outputs; <screen> <![CDATA[ Title field type OID: 1043 ]]> </screen> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_field_type</function></member> <member><function>pg_field_prtlen</function></member> <member><function>pg_field_name</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-fetch-all-columns.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-fetch-all-columns.xml +++ phpdoc-ja/reference/pgsql/functions/pg-fetch-all-columns.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.1 Maintainer: takagi Status: ready --> <refentry id="function.pg-fetch-all-columns"> <refnamediv> <refname>pg_fetch_all_columns</refname> <refpurpose>æå®ããã«ã©ã ã®å ¨ã¦ã®è¡ãé åã¨ãã¦åå¾ãã</refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>array</type><methodname>pg_fetch_all_columns</methodname> <methodparam><type>resource</type><parameter>result</parameter></methodparam> <methodparam choice="opt"><type>int</type><parameter>column</parameter></methodparam> </methodsynopsis> <para> <function>pg_fetch_all_columns</function> ã¯ãçµæãªã½ã¼ã¹ã® æå®ããã«ã©ã ã«ã¤ãã¦å ¨ã¦ã®è¡ï¼ã¬ã³ã¼ãï¼ãå«ãé åãè¿ãã¾ãã </para> &database.fetch-null; </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>result</parameter></term> <listitem> <para> <function>pg_query</function>, <function>pg_query_params</function> ããã㯠<function>pg_execute</function> ããè¿ããã PostgreSQL ã® ã¯ã¨ãªçµæãªã½ã¼ã¹ã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>column</parameter></term> <listitem> <para> çµæãªã½ã¼ã¹ããåå¾ããã«ã©ã ã®çªå·ã0 ããå§ã¾ãã¾ãã æå®ããªãå ´åã®ããã©ã«ãã¯æåã®ã«ã©ã ã§ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> çµæã«ã©ã ã®å ¨ã¦ã®å¤ãé åã§è¿ãã¾ãã </para> <para> <parameter>column</parameter> ãçµæã®ã«ã©ã æ°ãã大ããå ´åã ãã®ä»ã®ã¨ã©ã¼ãçºçããå ´åã« &false; ãè¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_fetch_all_columns</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $conn = pg_pconnect("dbname=publisher"); if (!$conn) { echo "An error occured.\n"; exit; } $result = pg_query($conn, "SELECT title, name, address FROM authors"); if (!$result) { echo "An error occured.\n"; exit; } // å ¨ã¦ã®èè åãé åã§å¾ã $arr = pg_fetch_all_columns($result, 1); var_dump($arr); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_fetch_all</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-execute.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-execute.xml +++ phpdoc-ja/reference/pgsql/functions/pg-execute.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-execute"> <refnamediv> <refname>pg_execute</refname> <refpurpose> æå®ãããã©ã¡ã¼ã¿ãç¨ãã¦ããªãã¢ãã¹ãã¼ãã¡ã³ããå®è¡ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ã¤ </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>resource</type><methodname>pg_execute</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <methodsynopsis> <type>resource</type><methodname>pg_execute</methodname> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <para> æå®ãããã©ã¡ã¼ã¿ãç¨ãã¦ããªãã¢ãã¹ãã¼ãã¡ã³ããå®è¡ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ã¡ã¾ãã </para> <para> <function>pg_execute</function> 㯠<function>pg_query_params</function> ã¨ä¼¼ã¦ãã¾ããããããå®è¡ããã³ãã³ãã¯ã¯ã¨ãªãæå®ãããã¨ã§ 決ã¾ãã®ã§ã¯ãªããäºåã«æºåãããã¹ãã¼ãã¡ã³ãã«å¤ãæå®ãã ãã¨ã«ãã£ã¦æ±ºã¾ãã¾ãããã®æ©è½ã®ãããã§ãç¹°ãè¿ã使ç¨ããã ã³ãã³ãã«æ§æè§£æãå®è¡è¨ç»ä½æãæåã®ä¸åº¦ã ãã§æ¸ã¿ã¾ãã å®è¡ããã¹ãã¼ãã¡ã³ãã¯ãã«ã¬ã³ãã®ã»ãã·ã§ã³ã§äºåã«æºåãã¦ãã å¿ è¦ãããã¾ãã<function>pg_execute</function> ã¯ãPostgreSQL 7.4 以éã®ãã¼ã¸ã§ã³ã®æ¥ç¶ã«ã®ã¿å¯¾å¿ãã¦ãã¾ãããã以åã®ãã¼ã¸ã§ã³ã§ã¯ 失æãã¾ãã </para> <para> ãã©ã¡ã¼ã¿ã¯ <function>pg_query_params</function> ã¨åãã§ããã ã¯ã¨ãªæååã®ãããã«ããªãã¢ãã¹ãã¼ãã¡ã³ãã®ååãæå®ãã ã¨ããç¹ã ããéãã¾ãã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>stmtname</parameter></term> <listitem> <para> å®è¡ããããªãã¢ãã¹ãã¼ãã¡ã³ãã®ååã"" ãæå®ãããå ´å㯠ç¡åã¹ãã¼ãã¡ã³ããå®è¡ããã¾ããååã¯ãäºåã« <function>pg_prepare</function>ã»<function>pg_send_prepare</function> ããã㯠<literal>PREPARE</literal> SQL ã³ãã³ãã§æºåããããã®ã§ãã å¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>params</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãä¸ã® $1ã$2 ãªã©ã®ãã¬ã¼ã¹ãã«ãã ç½®ãæãããã©ã¡ã¼ã¿ã®é åãé åã®è¦ç´ æ°ã¯ãã¬ã¼ã¹ãã«ãã® æ°ã¨ä¸è´ããå¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> æåããå ´åã«ã¯ã¨ãªçµæãªã½ã¼ã¹ã失æããå ´åã« &false; ãè¿ãã¾ãã</para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_execute</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php // "mary"ã¨ããååã®ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ $dbconn = pg_connect("dbname=mary"); // å®è¡ããã¯ã¨ãªãæºå $result = pg_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1'); // ããªãã¢ãã¯ã¨ãªã®å®è¡ãæåå "Joe's Widgets" ã®ã¨ã¹ã±ã¼ãå¦ç㯠// ä¸åå¿ è¦ãªããã¨ã«æ³¨æ $result = pg_execute($dbconn, "my_query", array("Joe's Widgets")); // åãããªãã¢ãã¯ã¨ãªãéããã©ã¡ã¼ã¿ã§å®è¡ $result = pg_execute($dbconn, "my_query", array("Clothes Clothes Clothes")); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_prepare</function></member> <member><function>pg_send_prepare</function></member> <member><function>pg_query_params</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 -->
http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-version.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-version.xml +++ phpdoc-ja/reference/pgsql/functions/pg-version.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-version"> <refnamediv> <refname>pg_version</refname> <refpurpose> ã¯ã©ã¤ã¢ã³ãã»ãããã³ã«ã»ãµã¼ãã®ãã¼ã¸ã§ã³ãé åã§è¿ã </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>array</type><methodname>pg_version</methodname> <methodparam choice="opt"><type>resource</type><parameter>connection</parameter></methodparam> </methodsynopsis> <para> <function>pg_version</function> ã¯ã¯ã©ã¤ã¢ã³ãã»ãããã³ã« ããã³ãµã¼ãã®ãã¼ã¸ã§ã³ãé åã§è¿ãã¾ãããããã³ã«ããã³ãµã¼ãã® ãã¼ã¸ã§ã³ã¯ãPHP ã PostgreSQL 7.4 以éã¨ã¨ãã«ã³ã³ãã¤ã«ããã¦ãã å ´åã®ã¿æå¹ã§ãã </para> <para> 詳細ãªãµã¼ãæ å ±ãåå¾ããã«ã¯ <function>pg_parameter_status</function> ãåç §ãã ããã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> <literal>client</literal>, <literal>protocol</literal> ããã³ <literal>server_version</literal> ã®ãã¼ã¨ãã®å¤ãæã¤é åã è¿ãã¾ãï¼æå¹ãªå ´åï¼ãã¨ã©ã¼æãæ¥ç¶ãæ£å¸¸ã§ãªãå ´åã« &false; ãè¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_version</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("host=localhost port=5432 dbname=mary") or die("Could not connect"); $v = pg_version($dbconn); echo $v['client']; ?> ]]> </programlisting> &example.outputs; <screen> <![CDATA[ 7.4 ]]> </screen> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_parameter_status</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-transaction-status.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-transaction-status.xml +++ phpdoc-ja/reference/pgsql/functions/pg-transaction-status.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.5 Maintainer: takagi Status: ready --> <refentry id='function.pg-transaction-status'> <refnamediv> <refname>pg_transaction_status</refname> <refpurpose>ãµã¼ãä¸ã§å®è¡ä¸ã®ãã©ã³ã¶ã¯ã·ã§ã³ã®ç¶æ ãè¿ã</refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>int</type><methodname>pg_transaction_status</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> </methodsynopsis> <para> ãµã¼ãä¸ã§å®è¡ä¸ã®ãã©ã³ã¶ã¯ã·ã§ã³ã®ç¶æ ãè¿ãã¾ãã </para> <caution> <para> PostgreSQL 7.3 ãµã¼ãã§ <literal>autocommit</literal> ã off ã« è¨å®ãã¦ããå ´åã<function>pg_transaction_status</function> ã¯ ä¸æ£ç¢ºãªå¤ãè¿ãã¾ãããµã¼ãå´ã§ã®èªåã³ãããæ©è½ã¯éæ¨å¥¨ã¨ ããã¦ãããæè¿ã®ãã¼ã¸ã§ã³ã®ãµã¼ãã§ã¯åå¨ãã¾ããã </para> </caution> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹ã®æ¥ç¶ãªã½ã¼ã¹ã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para><constant>PGSQL_TRANSACTION_IDLE</constant>ï¼ã¢ã¤ãã«ç¶æ ï¼ã <constant>PGSQL_TRANSACTION_ACTIVE</constant>ï¼ã³ãã³ãã®å®è¡ä¸ï¼ã <constant>PGSQL_TRANSACTION_INTRANS</constant>ï¼æ£å¸¸ãªãã©ã³ã¶ã¯ã·ã§ã³å ã§ã¢ã¤ãã«ç¶æ ï¼ã ããã㯠<constant>PGSQL_TRANSACTION_INERROR</constant>ï¼å¤±æãããã©ã³ã¶ã¯ã·ã§ã³å ã§ã¢ã¤ãã«ç¶æ ï¼ ã®ãããããè¿ãã¾ãã æ¥ç¶ãç°å¸¸ãªå ´å㯠<constant>PGSQL_TRANSACTION_UNKNOWN</constant> ãè¿ãã¾ãã <constant>PGSQL_TRANSACTION_ACTIVE</constant> ãè¿ãããã®ã¯ãã¯ã¨ãªã ãµã¼ãã«éä¿¡ããå¾ã¾ã ãããå®äºãã¦ããªãå ´åã®ã¿ã§ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_transaction_status</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); $stat = pg_transaction_status($dbconn); if ($stat === PGSQL_TRANSACTION_UNKNOWN) { echo 'Connection is bad'; } else if ($stat === PGSQL_TRANSACTION_IDLE) { echo 'Connection is currently idle'; } else { echo 'Connection is in a transaction state'; } ?> ]]> </programlisting> </example> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-set-error-verbosity.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-set-error-verbosity.xml +++ phpdoc-ja/reference/pgsql/functions/pg-set-error-verbosity.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.6 Maintainer: takagi Status: ready --> <refentry id="function.pg-set-error-verbosity"> <refnamediv> <refname>pg_set_error_verbosity</refname> <refpurpose> <function>pg_last_error</function> ããã³ <function>pg_result_error</function> ãè¿ãã¡ãã»ã¼ã¸ã®è©³ç´°åº¦ãæå®ãã </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>int</type><methodname>pg_set_error_verbosity</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>int</type><parameter>verbosity</parameter></methodparam> </methodsynopsis> <methodsynopsis> <type>int</type><methodname>pg_set_error_verbosity</methodname> <methodparam><type>int</type><parameter>verbosity</parameter></methodparam> </methodsynopsis> <para> <function>pg_last_error</function> ããã³ <function>pg_result_error</function> ãè¿ãã¡ãã»ã¼ã¸ã®è©³ç´°åº¦ãæå®ãã¾ãã </para> <para> <function>pg_set_error_verbosity</function> ã¯è©³ç´°åº¦ãè¨å®ãããã®æ¥ç¶ã® ããã¾ã§ã®è¨å®ãè¿ãã¾ãã<constant>PGSQL_ERRORS_TERSE</constant> ã¢ã¼ãã§ã¯ãè¿ãããã¡ãã»ã¼ã¸ã¯æ·±å»åº¦ã»æ¦è¦ ããã³ çºçä½ç½®ã®ã¿ã§ãã ããã¯ããã¦ãã®å ´å 1 è¡ã«åã¾ãã¾ããããã©ã«ãã®ã¢ã¼ã ï¼<constant>PGSQL_ERRORS_DEFAULT</constant>ï¼ã§ã¯ãããã«å ãã¦ä½ãã㮠詳細æ å ±ã»ãã³ããããã¯ç¶æ³ãã£ã¼ã«ããå«ã¿ã¾ãï¼ãããã¯è¤æ°è¡ã« ã¾ãããå¯è½æ§ãããã¾ãï¼ã<constant>PGSQL_ERRORS_VERBOSE</constant> ã¢ã¼ãã¯ãæå¹ãªãã£ã¼ã«ãããã¹ã¦å«ã¿ã¾ãã詳細度ã®è¨å®å¤æ´å 容㯠ãã以éã«æ°ãã使ããçµæãªãã¸ã§ã¯ãã«ã®ã¿åæ ãããæ¢åã® çµæãªãã¸ã§ã¯ãã«ã¯å½±é¿ãä¸ãã¾ããã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>verbosity</parameter></term> <listitem> <para> æå®ãã詳細度ã<constant>PGSQL_ERRORS_TERSE</constant>ã <constant>PGSQL_ERRORS_DEFAULT</constant> ããã㯠<constant>PGSQL_ERRORS_VERBOSE</constant> ã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> 夿´åã®è©³ç´°åº¦ã¬ãã«ã<constant>PGSQL_ERRORS_TERSE</constant>ã <constant>PGSQL_ERRORS_DEFAULT</constant> ããã㯠<constant>PGSQL_ERRORS_VERBOSE</constant> ã®ããããã è¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_set_error_verbosity</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); if (!pg_connection_busy($dbconn)) { pg_send_query($dbconn, "select * from doesnotexist;"); } pg_set_error_verbosity($dbconn, PGSQL_ERRORS_VERBOSE); $res1 = pg_get_result($dbconn); echo pg_result_error($res1); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_last_error</function></member> <member><function>pg_result_error</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-send-query-params.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-send-query-params.xml +++ phpdoc-ja/reference/pgsql/functions/pg-send-query-params.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id='function.pg-send-query-params'> <refnamediv> <refname>pg_send_query_params</refname> <refpurpose>ã³ãã³ãã¨ãã©ã¡ã¼ã¿ãåå²ãã¦ãµã¼ãã«éä¿¡ãããã®çµæãå¾ ããªã</refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>bool</type><methodname>pg_send_query_params</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <para> ã³ãã³ãã¨ãã©ã¡ã¼ã¿ãåå²ãã¦ãµã¼ãã«éä¿¡ãã¾ãããã®çµæãå¾ ã¤ãã¨ã¯ ãã¾ããã </para> <para> ãã㯠<function>pg_send_query</function> ã¨ã»ã¼åãã§ããããã©ã¡ã¼ã¿ã <parameter>query</parameter> ã¨ã¯å¥ã«åããã¦ããç¹ãéãã¾ãã 颿°ã®ãã©ã¡ã¼ã¿ã¯ã<function>pg_query_params</function> ã«ãã£ã¦ å®å ¨ã«å¶å¾¡ããã¾ãã<function>pg_query_params</function> ã¨åæ§ã 7.4 ããåã® PostgreSQL ã§ã¯åä½ãã¾ãããã¾ãã¯ã¨ãªæååã«ã¯ ã²ã¨ã¤ã®ã³ãã³ãã®ã¿ãå«ãããã¨ãã§ãã¾ãã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹ã®æ¥ç¶ãªã½ã¼ã¹ã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>query</parameter></term> <listitem> <para> ãã©ã¡ã¼ã¿åãã SQL æãã²ã¨ã¤ã®æã®ã¿ã§ããå¿ è¦ãããã¾ã ï¼è¤æ°ã®æãã»ãã³ãã³ã§åºåãå½¢å¼ã¯ä½¿ç¨ã§ãã¾ããï¼ããã©ã¡ã¼ã¿ã 使ç¨ããé㯠$1ã$2 ãªã©ã®å½¢å¼ã§åç §ããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>params</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãä¸ã® $1ã$2 ãªã©ã®ãã¬ã¼ã¹ãã«ãã ç½®ãæãããã©ã¡ã¼ã¿ã®é åãé åã®è¦ç´ æ°ã¯ãã¬ã¼ã¹ãã«ãã® æ°ã¨ä¸è´ããå¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para>&return.success;</para> <para> ã¯ã¨ãªã®çµæã夿ããã«ã¯ <function>pg_get_result</function> ã使ç¨ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_send_query_params</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); // ãã©ã¡ã¼ã¿ã使ç¨ããããã©ã¡ã¼ã¿ã«ã¯ã¯ã©ã¼ããã¨ã¹ã±ã¼ãã // å¿ è¦ãªããã¨ã«æ³¨æ pg_send_query_params($dbconn, 'select count(*) from authors where city = $1', array('Perth')); // åºæ¬ç㪠pg_send_query ã®ä½¿ç¨æ³ã¨ã®æ¯è¼ $str = pg_escape_string('Perth'); pg_send_query($dbconn, "select count(*) from authors where city = '${str}'"); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_send_query</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-send-prepare.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-send-prepare.xml +++ phpdoc-ja/reference/pgsql/functions/pg-send-prepare.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-send-prepare"> <refnamediv> <refname>pg_send_prepare</refname> <refpurpose> æå®ãããã©ã¡ã¼ã¿ã§ããªãã¢ãã¹ãã¼ãã¡ã³ãã使ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ããªã </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>bool</type><methodname>pg_send_prepare</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> </methodsynopsis> <para> æå®ãããã©ã¡ã¼ã¿ã§ããªãã¢ãã¹ãã¼ãã¡ã³ãã使ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ã¡ã¾ããã </para> <para> ãã㯠<function>pg_prepare</function> ã®éåæãã¼ã¸ã§ã³ã§ãã ãªã¯ã¨ã¹ããåãä»ããããå ´åã« &true; ãããã§ãªãå ´åã« &false; ãè¿ãã¾ããã³ã¼ã«ãæåããå¾ãå®éã«ããªãã¢ãã¹ãã¼ãã¡ã³ãã 使ããããã©ããã調ã¹ãã«ã¯ <function>pg_get_result</function> ã使ç¨ãã¾ãã颿°ã®ãã©ã¡ã¼ã¿ã¯ <function>pg_prepare</function> ã¨åãããã«å¦çããã¾ãã<function>pg_prepare</function> ã¨åæ§ã 7.4 ããåã® PostgreSQL ã®ãã¼ã¸ã§ã³ã§ã¯æ£ããåä½ãã¾ããã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>stmtname</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãã«ã¤ããååãæ¥ç¶å ã§ä¸æã§ããå¿ è¦ãããã¾ãã "" ãæå®ãããå ´åã¯ç¡åã¹ãã¼ãã¡ã³ãã使ããã以åã«å®ç¾©ããã ç¡åã¹ãã¼ãã¡ã³ãã䏿¸ããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>query</parameter></term> <listitem> <para> ãã©ã¡ã¼ã¿åãã SQL æãã²ã¨ã¤ã®æã®ã¿ã§ããå¿ è¦ãããã¾ã ï¼è¤æ°ã®æãã»ãã³ãã³ã§åºåãå½¢å¼ã¯ä½¿ç¨ã§ãã¾ããï¼ããã©ã¡ã¼ã¿ã 使ç¨ããé㯠$1ã$2 ãªã©ã®å½¢å¼ã§åç §ããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para>æåããå ´åã« &true; ã失æããå ´åã« &false; ãè¿ãã¾ãã ã¯ã¨ãªã®çµæã確ãããã«ã¯ <function>pg_get_result</function> ã使ç¨ãã¾ãã</para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_send_prepare</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); // å®è¡ããã¯ã¨ãªãæºåãã if (!pg_connection_busy($dbconn)) { pg_send_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1'); $res1 = pg_get_result($dbconn); } // ããªãã¢ãã¯ã¨ãªãå®è¡ãããæåå "Joe's Widgets" 㯠// ã¨ã¹ã±ã¼ãã®å¿ è¦ããªããã¨ã«æ³¨æ if (!pg_connection_busy($dbconn)) { pg_send_execute($dbconn, "my_query", array("Joe's Widgets")); $res2 = pg_get_result($dbconn); } // åä¸ããªãã¢ãã¯ã¨ãªãå¥ã®ãã©ã¡ã¼ã¿ã§å®è¡ãã if (!pg_connection_busy($dbconn)) { pg_send_execute($dbconn, "my_query", array("Clothes Clothes Clothes")); $res3 = pg_get_result($dbconn); } ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_connect</function></member> <member><function>pg_pconnect</function></member> <member><function>pg_execute</function></member> <member><function>pg_send_execute</function></member> <member><function>pg_send_query_params</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-send-execute.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-send-execute.xml +++ phpdoc-ja/reference/pgsql/functions/pg-send-execute.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-send-execute"> <refnamediv> <refname>pg_send_execute</refname> <refpurpose> æå®ãããã©ã¡ã¼ã¿ã§ããªãã¢ãã¹ãã¼ãã¡ã³ããå®è¡ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ããªã </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>bool</type><methodname>pg_send_execute</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <para> æå®ãããã©ã¡ã¼ã¿ã§ããªãã¢ãã¹ãã¼ãã¡ã³ããå®è¡ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ã¡ã¾ããã </para> <para> ãã㯠<function>pg_send_query_params</function> ã¨ä¼¼ã¦ãã¾ãã ããããå®è¡ããã³ãã³ãã¯æå®ããã¯ã¨ãªæååã§æ±ºã¾ãã®ã§ã¯ãªã äºåã«æºåãããã¹ãã¼ãã¡ã³ãã®ååã§æ±ºã¾ãã¾ãã颿°ã®ãã©ã¡ã¼ã¿ã¯ <function>pg_execute</function> ã¨åãããã«å¦çããã¾ãã <function>pg_execute</function> ã¨åæ§ã«ã7.4 ããåã®ãã¼ã¸ã§ã³ã® PostgreSQL ã§ã¯åä½ãã¾ããã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>stmtname</parameter></term> <listitem> <para> å®è¡ããããªãã¢ãã¹ãã¼ãã¡ã³ãã®ååã"" ãæå®ãããå ´å㯠ç¡åã¹ãã¼ãã¡ã³ããå®è¡ããã¾ããååã¯ãäºåã« <function>pg_prepare</function>ã»<function>pg_send_prepare</function> ããã㯠<literal>PREPARE</literal> SQL ã³ãã³ãã§æºåããããã®ã§ãã å¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>params</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãä¸ã® $1ã$2 ãªã©ã®ãã¬ã¼ã¹ãã«ãã ç½®ãæãããã©ã¡ã¼ã¿ã®é åãé åã®è¦ç´ æ°ã¯ãã¬ã¼ã¹ãã«ãã® æ°ã¨ä¸è´ããå¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para>æåããå ´åã« &true; ã失æããå ´åã« &false; ãè¿ãã¾ãã ã¯ã¨ãªã®çµæã確èªããã«ã¯ <function>pg_get_result</function> ã使ç¨ãã¾ãã</para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_send_execute</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); // å®è¡ããã¯ã¨ãªãæºåãã if (!pg_connection_busy($dbconn)) { pg_send_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1'); $res1 = pg_get_result($dbconn); } // ããªãã¢ãã¯ã¨ãªãå®è¡ããã æåå "Joe's Widgets" 㯠// ã¨ã¹ã±ã¼ãã®å¿ è¦ããªããã¨ã«æ³¨æ if (!pg_connection_busy($dbconn)) { pg_send_execute($dbconn, "my_query", array("Joe's Widgets")); $res2 = pg_get_result($dbconn); } // åãããªãã¢ãã¯ã¨ãªãç°ãªããã©ã¡ã¼ã¿ã§å®è¡ãã if (!pg_connection_busy($dbconn)) { pg_send_execute($dbconn, "my_query", array("Clothes Clothes Clothes")); $res3 = pg_get_result($dbconn); } ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_prepare</function></member> <member><function>pg_send_prepare</function></member> <member><function>pg_execute</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-result-error-field.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-result-error-field.xml +++ phpdoc-ja/reference/pgsql/functions/pg-result-error-field.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.7 Maintainer: takagi Status: ready --> <refentry id='function.pg-result-error-field'> <refnamediv> <refname>pg_result_error_field</refname> <refpurpose>ã¨ã©ã¼å ±åã®åãã£ã¼ã«ããè¿ã</refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>string</type><methodname>pg_result_error_field</methodname> <methodparam><type>resource</type><parameter>result</parameter></methodparam> <methodparam><type>int</type><parameter>fieldcode</parameter></methodparam> </methodsynopsis> <para> <function>pg_result_error_field</function> ã¯ã<parameter>result</parameter> ãªã½ã¼ã¹ã«é¢ããã¨ã©ã¼ã¡ãã»ã¼ã¸ã®ç¹å®ã®ãã£ã¼ã«ããè¿ãã¾ãã PostgreSQL 7.4 以éã®ãµã¼ãã§ã®ã¿æå¹ã§ããã¨ã©ã¼ãã£ã¼ã«ã㯠<parameter>fieldcode</parameter> ã§å®ç¾©ãã¾ãã </para> <para> <function>pg_query</function> ã <function>pg_query_params</function> ã¯ã¯ã¨ãªã失æããå ´åã« &false; ãè¿ãã®ã§ãçµæã®ãã³ãã«ãå¾ãã«ã¯ <function>pg_send_query</function> ããã³ <function>pg_get_result</function> ã使ç¨ããå¿ è¦ãããã¾ãã </para> <para> 失æãã <function>pg_query</function> ã¯ã¨ãªãã詳細ãªã¨ã©ã¼æ å ±ã åå¾ããå¿ è¦ãããå ´åã¯ã<function>pg_set_error_verbosity</function> ããã³ <function>pg_last_error</function> ã使ç¨ãã¦ãã®çµæããã¼ã¹ ãã¾ãã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>result</parameter></term> <listitem> <para> å®è¡ããã¹ãã¼ãã¡ã³ãã®ã¯ã¨ãªçµæãªã½ã¼ã¹ã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>fieldcode</parameter></term> <listitem> <para> 以ä¸ã® <parameter>fieldcode</parameter> ã使ç¨å¯è½ã§ãã <constant>PGSQL_DIAG_SEVERITY</constant>ã <constant>PGSQL_DIAG_SQLSTATE</constant>ã<constant>PGSQL_DIAG_MESSAGE_PRIMARY</constant>ã <constant>PGSQL_DIAG_MESSAGE_DETAIL</constant>ã <constant>PGSQL_DIAG_MESSAGE_HINT</constant>ã<constant>PGSQL_DIAG_STATEMENT_POSITION</constant>ã <constant>PGSQL_DIAG_INTERNAL_POSITION</constant>ï¼PostgreSQL 8.0+ ã®ã¿ï¼ã <constant>PGSQL_DIAG_INTERNAL_QUERY</constant>ï¼PostgreSQL 8.0+ ã®ã¿ï¼ã <constant>PGSQL_DIAG_CONTEXT</constant>ã<constant>PGSQL_DIAG_SOURCE_FILE</constant>ã <constant>PGSQL_DIAG_SOURCE_LINE</constant> ããã㯠<constant>PGSQL_DIAG_SOURCE_FUNCTION</constant> ã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para>ã¨ã©ã¼ãã£ã¼ã«ãã®å 容ãæååã§è¿ãã¾ãã ãã£ã¼ã«ããåå¨ããªãå ´åã« &null; ã失æããå ´åã« &false; ãè¿ãã¾ãã</para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_result_error_field</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); if (!pg_connection_busy($dbconn)) { pg_send_query($dbconn, "select * from doesnotexist;"); } $res1 = pg_get_result($dbconn); echo pg_result_error_field($res1, PGSQL_DIAG_SQLSTATE); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_result_error</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-query-params.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-query-params.xml +++ phpdoc-ja/reference/pgsql/functions/pg-query-params.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-query-params"> <refnamediv> <refname>pg_query_params</refname> <refpurpose> SQL ã³ãã³ãã¨ãã©ã¡ã¼ã¿ãåå²ãã¦ãµã¼ãã«ãéä¿¡ãããã®çµæãå¾ ã¤ </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>resource</type><methodname>pg_query_params</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <methodsynopsis> <type>resource</type><methodname>pg_query_params</methodname> <methodparam><type>string</type><parameter>query</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <para> ã³ãã³ãããµã¼ãã«éä¿¡ãããã®çµæãå¾ ã¡ã¾ãããã©ã¡ã¼ã¿ã SQL ã³ãã³ã ã¨ã¯å¥ã«æ¸¡ããã¨ãå¯è½ã§ãã </para> <para> <function>pg_query_params</function> 㯠<function>pg_query</function> ã¨ä¼¼ã¦ãã¾ããã追å ã®æ©è½ãæãã¦ãã¾ããããã¯ãã©ã¡ã¼ã¿å¤ã ã³ãã³ãæååã¨åé¢ãã¦ããã¨ãããã¨ã§ãã <function>pg_query_params</function> 㯠PostgreSQL 7.4 以éã®æ¥ç¶ã§ã®ã¿ ãµãã¼ãããã¾ãããã以åã®ãã¼ã¸ã§ã³ã§ã¯å¤±æãã¾ãã </para> <para> ãã©ã¡ã¼ã¿ã使ç¨ããéã¯ã<parameter>query</parameter> æååå ã§ $1ã$2 ã®ããã«åç §ããã¾ãã<parameter>params</parameter> ã§ å®éã®å¤ãæå®ãã¾ãã&null; ãæå®ããã¨ãSQL ã® <literal>NULL</literal> ã¨ã¿ãªããã¾ãã </para> <para> <function>pg_query</function> ã«å¯¾ãã <function>pg_query_params</function> ã®æå¤§ã®å©ç¹ã¯ããã©ã¡ã¼ã¿ã®å¤ã <parameter>query</parameter> æååãã åé¢ã§ãããã¨ã§ãããã®ãããéå±ã§ã¨ã©ã¼ã®å ã¨ãªããããã¯ã©ã¼ãã» ã¨ã¹ã±ã¼ããªã©ãããªãã¦ããããªãã¾ãã<function>pg_query</function> ã¨ç°ãªãã<function>pg_query_params</function> ã§ã¯ã²ã¨ã¤ã® SQL ã³ãã³ãããå®è¡ã§ãã¾ããï¼ã¯ã¨ãªæååã«ã»ãã³ãã³ãå«ãããã¨ã¯ å¯è½ã§ããããããã以éã«ã³ãã³ããç¶ãããã¨ã¯ã§ãã¾ããï¼ã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>query</parameter></term> <listitem> <para> ãã©ã¡ã¼ã¿åãã SQL æãã²ã¨ã¤ã®æã®ã¿ã§ããå¿ è¦ãããã¾ã ï¼è¤æ°ã®æãã»ãã³ãã³ã§åºåãå½¢å¼ã¯ä½¿ç¨ã§ãã¾ããï¼ããã©ã¡ã¼ã¿ã 使ç¨ããé㯠$1ã$2 ãªã©ã®å½¢å¼ã§åç §ããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>params</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãä¸ã® $1ã$2 ãªã©ã®ãã¬ã¼ã¹ãã«ãã ç½®ãæãããã©ã¡ã¼ã¿ã®é åãé åã®è¦ç´ æ°ã¯ãã¬ã¼ã¹ãã«ãã® æ°ã¨ä¸è´ããå¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> æåããå ´åã«ã¯ã¨ãªçµæãªã½ã¼ã¹ã失æããå ´åã« &false; ãè¿ãã¾ãã</para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_query_params</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php // "mary"ã¨ããååã®ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ $dbconn = pg_connect("dbname=mary"); // Joe's Widgets ã¨ããååã®åºãæ¢ãã"Joe's Widgets" ã // ã¨ã¹ã±ã¼ãããå¿ è¦ããªããã¨ã«æ³¨æ $result = pg_query_params($dbconn, 'SELECT * FROM shops WHERE name = $1', array("Joe's Widgets")); // pg_query ã使ç¨ããå ´åã¨æ¯è¼ $str = pg_escape_string("Joe's Widgets"); $result = pg_query($dbconn, "SELECT * FROM shops WHERE name = '{$str}'"); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_query</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-prepare.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-prepare.xml +++ phpdoc-ja/reference/pgsql/functions/pg-prepare.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-prepare"> <refnamediv> <refname>pg_prepare</refname> <refpurpose> æå®ãããã©ã¡ã¼ã¿ã§ããªãã¢ãã¹ãã¼ãã¡ã³ãã使ãããªã¯ã¨ã¹ãã éä¿¡ãããã®å®äºãå¾ ã¤ </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>resource</type><methodname>pg_prepare</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> </methodsynopsis> <methodsynopsis> <type>resource</type><methodname>pg_prepare</methodname> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> </methodsynopsis> <para> <function>pg_prepare</function> ã¯ã <function>pg_execute</function> ããã㯠<function>pg_send_execute</function> ã§å¾ã«å®è¡ããããã®ããªãã¢ãã¹ãã¼ãã¡ã³ãã使ãã¾ããããã«ããã ç¹°ãè¿ã使ç¨ãããã³ãã³ãã«ã¤ãã¦ã®æ§æè§£æãå®è¡è¨ç»ä½æãæåã® ä¸åº¦ã ãã§ãã¿ã¾ãã<function>pg_prepare</function> 㯠PostgreSQL 7.4 以éã®æ¥ç¶ã§ã®ã¿ä½¿ç¨å¯è½ã§ãããã以åã®ãã¼ã¸ã§ã³ã§ã¯å¤±æãã¾ãã </para> <para> ãã®é¢æ°ã¯ <parameter>stmtname</parameter> ã¨ããååã® ããªãã¢ãã¹ãã¼ãã¡ã³ãã <parameter>query</parameter> æååãã使ãã¾ãã ãã®æååã«ã¯ 1 ã¤ã® SQL ã³ãã³ããå«ã¾ãã¦ããå¿ è¦ãããã¾ãã <parameter>stmtname</parameter> ã "" ã«ãããã¨ã§ç¡åã¹ãã¼ãã¡ã³ãã 使ãããã¨ãå¯è½ã§ãæ¢åã®ç¡åã¹ãã¼ãã¡ã³ãã¯èªåçã«ä¸æ¸ãããã¾ãã ãã以å¤ã®å ´åãããã«ã¬ã³ãã®ã»ãã·ã§ã³ã§æ¢ã«å®ç¾©æ¸ã¿ã®ã¹ãã¼ãã¡ã³ãåã 使ç¨ããå ´åã«ã¯ã¨ã©ã¼ã¨ãªãã¾ãããã©ã¡ã¼ã¿ã使ç¨ããéã¯ã <parameter>query</parameter> å ã§ $1ã$2 ã®ãããªå½¢å¼ã§åç §ããã¾ãã </para> <para> <function>pg_prepare</function> ã§ä½¿ç¨ããããªãã¢ãã¹ãã¼ãã¡ã³ãã¯ã SQLã® <literal>PREPARE</literal> æãå®è¡ãããã¨ã§ã使å¯è½ã§ã ï¼ãããããã©ã¡ã¼ã¿ã®åãäºåã«æå®ããå¿ è¦ããªãã¨ããç¹ã§ <function>pg_prepare</function> ã®ã»ããããæè»ã§ãï¼ã ã¾ããPHP ã«ã¯ããªãã¢ãã¹ãã¼ãã¡ã³ããåé¤ãã颿°ãããã¾ãããã ãã®ç®çã®ããã«ã¯ SQLã® <literal>DEALLOCATE</literal> æã使ç¨å¯è½ã§ãã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>stmtname</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãã«ã¤ããååãæ¥ç¶å ã§ä¸æã§ããå¿ è¦ãããã¾ãã "" ãæå®ãããå ´åã¯ç¡åã¹ãã¼ãã¡ã³ãã使ããã以åã«å®ç¾©ããã ç¡åã¹ãã¼ãã¡ã³ãã䏿¸ããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>query</parameter></term> <listitem> <para> ãã©ã¡ã¼ã¿åãã SQL æãã²ã¨ã¤ã®æã®ã¿ã§ããå¿ è¦ãããã¾ã ï¼è¤æ°ã®æãã»ãã³ãã³ã§åºåãå½¢å¼ã¯ä½¿ç¨ã§ãã¾ããï¼ããã©ã¡ã¼ã¿ã 使ç¨ããé㯠$1ã$2 ãªã©ã®å½¢å¼ã§åç §ããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> æåããå ´åã«ã¯ã¨ãªçµæãªã½ã¼ã¹ã失æããå ´åã« &false; ãè¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_prepare</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php // "mary"ã¨ããååã®ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ $dbconn = pg_connect("dbname=mary"); // å®è¡ããã¯ã¨ãªã®æºå $result = pg_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1'); // ããªãã¢ãã¯ã¨ãªãå®è¡ãããæåå "Joe's Widgets" 㯠// ã¨ã¹ã±ã¼ãã®å¿ è¦ããªããã¨ã«æ³¨æ $result = pg_execute($dbconn, "my_query", array("Joe's Widgets")); // åä¸ããªãã¢ãã¯ã¨ãªãå¥ã®ãã©ã¡ã¼ã¿ã§å®è¡ãã $result = pg_execute($dbconn, "my_query", array("Clothes Clothes Clothes")); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_execute</function></member> <member><function>pg_send_execute</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-parameter-status.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-parameter-status.xml +++ phpdoc-ja/reference/pgsql/functions/pg-parameter-status.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.9 Maintainer: takagi Status: ready --> <refentry id="function.pg-parameter-status"> <refnamediv> <refname>pg_parameter_status</refname> <refpurpose>ãµã¼ãã®ãã©ã¡ã¼ã¿è¨å®ãæ¤ç´¢ãã</refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>string</type><methodname>pg_parameter_status</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>param_name</parameter></methodparam> </methodsynopsis> <methodsynopsis> <type>string</type><methodname>pg_parameter_status</methodname> <methodparam><type>string</type><parameter>param_name</parameter></methodparam> </methodsynopsis> <para> ãµã¼ãã®ãã©ã¡ã¼ã¿è¨å®ãæ¤ç´¢ãã¾ãã </para> <para> ããã¤ãã®ãã©ã¡ã¼ã¿ã«ã¤ãã¦ã¯ãæ¥ç¶ã®ç¢ºç«æãå¤ã®å¤æ´æã«ãµã¼ããã èªåçã«éç¥ããã¾ãã<function>pg_parameter_status</function> 㯠ãããã®è¨å®åãåãããããã«ä½¿ç¨å¯è½ã§ããæå®ãããã©ã¡ã¼ã¿ãåå¨ãã å ´åã«ãã®å¤ããåå¨ããªãå ´åã« &false; ãè¿ãã¾ãã </para> <para> PostgreSQL 8.0 ã§æå®ã§ãããã©ã¡ã¼ã¿ã«ã¯ä»¥ä¸ãå«ã¾ãã¾ãã <literal>server_version</literal>ã <literal>server_encoding</literal>ã<literal>client_encoding</literal>ã <literal>is_superuser</literal>ã<literal>session_authorization</literal>ã <literal>DateStyle</literal>ã<literal>TimeZone</literal> ããã³ <literal>integer_datetimes</literal> ï¼<literal>server_encoding</literal>ã<literal>TimeZone</literal> ããã³ <literal>integer_datetimes</literal> 㯠8.0 ããåã®ãã¼ã¸ã§ã³ã§ã¯æå®ã§ãã¾ããï¼ã <literal>server_version</literal>ã<literal>server_encoding</literal> ããã³ <literal>integer_datetimes</literal> ã¯ãPostgreSQL ã®ç¨¼åä¸ã«ã¯å¤æ´ã§ããªããã¨ã«æ³¨æãã¾ãããã </para> <para> PostgreSQL 7.3 以åã®ãµã¼ãã¯ãã©ã¡ã¼ã¿è¨å®ãéç¥ããæ©è½ãæã£ã¦ãã¾ããã ãããã<function>pg_parameter_status</function> ã«ã¯ <literal>server_version</literal> ããã³ <literal>client_encoding</literal> ãåå¾ããæ©è½ãçµã¿è¾¼ãã§ãã¾ãããããã®å¤ãåå¾ããããã«ã¢ããªã±ã¼ã·ã§ã³ã§ ã¢ãããã¯ãªã³ã¼ããæ¸ãã®ã§ã¯ãªãã<function>pg_parameter_status</function> ã使ç¨ãããã¨ãæ¨å¥¨ãã¾ãã </para> <caution> <para> 7.4 ããåã® PostgreSQL ãµã¼ãã§ã¯ãæ¥ç¶ã®ç¢ºç«å¾ã« <literal>SET</literal> ãç¨ã㦠<literal>client_encoding</literal> ã夿´ãã¦ã <function>pg_parameter_status</function> ã«ã¯åæ ããã¾ããã </para> </caution> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>param_name</parameter></term> <listitem> <para> æå®å¯è½ãª <parameter>param_name</parameter> ã«ã¯ä»¥ä¸ãå«ã¾ãã¾ãã <literal>server_version</literal>ã <literal>server_encoding</literal>ã<literal>client_encoding</literal>ã <literal>is_superuser</literal>ã<literal>session_authorization</literal>ã <literal>DateStyle</literal>ã<literal>TimeZone</literal> ããã³ <literal>integer_datetimes</literal>ã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> ãã©ã¡ã¼ã¿ã®å¤ãæååã§è¿ãã¾ãã失æããå ´åã <parameter>param_name</parameter> ãééã£ã¦ããå ´åã«ã¯ &false; ãè¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_parameter_status</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); echo "Server encoding: ", pg_parameter_status($dbconn, "server_encoding"); ?> ]]> </programlisting> &example.outputs; <screen> <![CDATA[ Server encoding: SQL_ASCII ]]> </screen> </example> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-field-type-oid.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-field-type-oid.xml +++ phpdoc-ja/reference/pgsql/functions/pg-field-type-oid.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.5 Maintainer: takagi Status: ready --> <refentry id="function.pg-field-type-oid"> <refnamediv> <refname>pg_field_type_oid</refname> <refpurpose> ãã£ã¼ã«ãçªå·ã«å¯¾å¿ããå IDï¼OIDï¼ãè¿ã </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>int</type><methodname>pg_field_type_oid</methodname> <methodparam><type>resource</type><parameter>result</parameter></methodparam> <methodparam><type>int</type><parameter>field_number</parameter></methodparam> </methodsynopsis> <para> <function>pg_field_type_oid</function> ã¯ãæå®ãã PostgreSQL <parameter>result</parameter> ãªã½ã¼ã¹ã«ãããæå®ãã <parameter>field_number</parameter> ã®åã® OID ãè¿ãã¾ãã </para> <para> ãã£ã¼ã«ãåã«ã¤ãã¦ã®è©³ç´°ãªæ å ±ãå¾ãã«ã¯ãPostgreSQL ã®ã·ã¹ãã ãã¼ãã« <literal>pg_type</literal> ã«å¯¾ãã¦ããã®é¢æ°ã§åå¾ãã OID ãç¨ã㦠åãåããã¾ããPostgreSQL ã® <function>format_type</function> 颿°ã¯ã åã® OID ã SQL ã®ååã«å¤æãã¾ãã </para> <note> <para> ãã£ã¼ã«ããï¼åºæ¬åã§ã¯ãªãï¼PostgreSQL ãã¡ã¤ã³ã使ç¨ãã¦ããå ´åã¯ã ãã¡ã¤ã³ãã®ãã®ã® OID ã§ã¯ãªããã¡ã¤ã³ã®å ã¨ãªã£ã¦ããåã® OID ãè¿ãã¾ãã </para> </note> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>result</parameter></term> <listitem> <para> <function>pg_query</function>, <function>pg_query_params</function> ããã㯠<function>pg_execute</function> ããè¿ããã PostgreSQL ã® ã¯ã¨ãªçµæãªã½ã¼ã¹ã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>field_number</parameter></term> <listitem> <para> ãã£ã¼ã«ãçªå·ã0 ããå§ã¾ãã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> ãã£ã¼ã«ãã®åã«å¯¾å¿ãã OID ãè¿ãã¾ããã¨ã©ã¼æã«ã¯ &false; ãè¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title>ãã£ã¼ã«ãã®æ å ±ãå¾ã</title> <programlisting role="php"> <![CDATA[ <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); // 'title' 㯠varchar åã§ããã¨ä»®å®ãã $res = pg_query($dbconn, "select title from authors where author = 'Orwell'"); echo "Title field type OID: ", pg_field_type_oid($res, 0); ?> ]]> </programlisting> &example.outputs; <screen> <![CDATA[ Title field type OID: 1043 ]]> </screen> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_field_type</function></member> <member><function>pg_field_prtlen</function></member> <member><function>pg_field_name</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-fetch-all-columns.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-fetch-all-columns.xml +++ phpdoc-ja/reference/pgsql/functions/pg-fetch-all-columns.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.1 Maintainer: takagi Status: ready --> <refentry id="function.pg-fetch-all-columns"> <refnamediv> <refname>pg_fetch_all_columns</refname> <refpurpose>æå®ããã«ã©ã ã®å ¨ã¦ã®è¡ãé åã¨ãã¦åå¾ãã</refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>array</type><methodname>pg_fetch_all_columns</methodname> <methodparam><type>resource</type><parameter>result</parameter></methodparam> <methodparam choice="opt"><type>int</type><parameter>column</parameter></methodparam> </methodsynopsis> <para> <function>pg_fetch_all_columns</function> ã¯ãçµæãªã½ã¼ã¹ã® æå®ããã«ã©ã ã«ã¤ãã¦å ¨ã¦ã®è¡ï¼ã¬ã³ã¼ãï¼ãå«ãé åãè¿ãã¾ãã </para> &database.fetch-null; </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>result</parameter></term> <listitem> <para> <function>pg_query</function>, <function>pg_query_params</function> ããã㯠<function>pg_execute</function> ããè¿ããã PostgreSQL ã® ã¯ã¨ãªçµæãªã½ã¼ã¹ã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>column</parameter></term> <listitem> <para> çµæãªã½ã¼ã¹ããåå¾ããã«ã©ã ã®çªå·ã0 ããå§ã¾ãã¾ãã æå®ããªãå ´åã®ããã©ã«ãã¯æåã®ã«ã©ã ã§ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> çµæã«ã©ã ã®å ¨ã¦ã®å¤ãé åã§è¿ãã¾ãã </para> <para> <parameter>column</parameter> ãçµæã®ã«ã©ã æ°ãã大ããå ´åã ãã®ä»ã®ã¨ã©ã¼ãçºçããå ´åã« &false; ãè¿ãã¾ãã </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_fetch_all_columns</function> ã®ä¾</title> <programlisting role="php"> <![CDATA[ <?php $conn = pg_pconnect("dbname=publisher"); if (!$conn) { echo "An error occured.\n"; exit; } $result = pg_query($conn, "SELECT title, name, address FROM authors"); if (!$result) { echo "An error occured.\n"; exit; } // å ¨ã¦ã®èè åãé åã§å¾ã $arr = pg_fetch_all_columns($result, 1); var_dump($arr); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_fetch_all</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/co.php/phpdoc-ja/reference/pgsql/functions/pg-execute.xml?r=1.1&p=1 Index: phpdoc-ja/reference/pgsql/functions/pg-execute.xml +++ phpdoc-ja/reference/pgsql/functions/pg-execute.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.4 Maintainer: takagi Status: ready --> <refentry id="function.pg-execute"> <refnamediv> <refname>pg_execute</refname> <refpurpose> æå®ãããã©ã¡ã¼ã¿ãç¨ãã¦ããªãã¢ãã¹ãã¼ãã¡ã³ããå®è¡ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ã¤ </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>resource</type><methodname>pg_execute</methodname> <methodparam><type>resource</type><parameter>connection</parameter></methodparam> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <methodsynopsis> <type>resource</type><methodname>pg_execute</methodname> <methodparam><type>string</type><parameter>stmtname</parameter></methodparam> <methodparam><type>array</type><parameter>params</parameter></methodparam> </methodsynopsis> <para> æå®ãããã©ã¡ã¼ã¿ãç¨ãã¦ããªãã¢ãã¹ãã¼ãã¡ã³ããå®è¡ãããªã¯ã¨ã¹ãã éä¿¡ãããã®çµæãå¾ ã¡ã¾ãã </para> <para> <function>pg_execute</function> 㯠<function>pg_query_params</function> ã¨ä¼¼ã¦ãã¾ããããããå®è¡ããã³ãã³ãã¯ã¯ã¨ãªãæå®ãããã¨ã§ 決ã¾ãã®ã§ã¯ãªããäºåã«æºåãããã¹ãã¼ãã¡ã³ãã«å¤ãæå®ãã ãã¨ã«ãã£ã¦æ±ºã¾ãã¾ãããã®æ©è½ã®ãããã§ãç¹°ãè¿ã使ç¨ããã ã³ãã³ãã«æ§æè§£æãå®è¡è¨ç»ä½æãæåã®ä¸åº¦ã ãã§æ¸ã¿ã¾ãã å®è¡ããã¹ãã¼ãã¡ã³ãã¯ãã«ã¬ã³ãã®ã»ãã·ã§ã³ã§äºåã«æºåãã¦ãã å¿ è¦ãããã¾ãã<function>pg_execute</function> ã¯ãPostgreSQL 7.4 以éã®ãã¼ã¸ã§ã³ã®æ¥ç¶ã«ã®ã¿å¯¾å¿ãã¦ãã¾ãããã以åã®ãã¼ã¸ã§ã³ã§ã¯ 失æãã¾ãã </para> <para> ãã©ã¡ã¼ã¿ã¯ <function>pg_query_params</function> ã¨åãã§ããã ã¯ã¨ãªæååã®ãããã«ããªãã¢ãã¹ãã¼ãã¡ã³ãã®ååãæå®ãã ã¨ããç¹ã ããéãã¾ãã </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>connection</parameter></term> <listitem> <para> PostgreSQL ãã¼ã¿ãã¼ã¹æ¥ç¶ãªã½ã¼ã¹ã<parameter>connection</parameter> ãæå®ããã¦ããªãå ´åã¯ããã©ã«ãã®æ¥ç¶ã使ç¨ããã¾ãã ããã©ã«ãã®æ¥ç¶ã¯ãç´è¿ã® <function>pg_connect</function> ããã㯠<function>pg_pconnect</function> ã«ãã£ã¦ä½æããããã®ã§ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>stmtname</parameter></term> <listitem> <para> å®è¡ããããªãã¢ãã¹ãã¼ãã¡ã³ãã®ååã"" ãæå®ãããå ´å㯠ç¡åã¹ãã¼ãã¡ã³ããå®è¡ããã¾ããååã¯ãäºåã« <function>pg_prepare</function>ã»<function>pg_send_prepare</function> ããã㯠<literal>PREPARE</literal> SQL ã³ãã³ãã§æºåããããã®ã§ãã å¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> <varlistentry> <term><parameter>params</parameter></term> <listitem> <para> ããªãã¢ãã¹ãã¼ãã¡ã³ãä¸ã® $1ã$2 ãªã©ã®ãã¬ã¼ã¹ãã«ãã ç½®ãæãããã©ã¡ã¼ã¿ã®é åãé åã®è¦ç´ æ°ã¯ãã¬ã¼ã¹ãã«ãã® æ°ã¨ä¸è´ããå¿ è¦ãããã¾ãã </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> æåããå ´åã«ã¯ã¨ãªçµæãªã½ã¼ã¹ã失æããå ´åã« &false; ãè¿ãã¾ãã</para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title><function>pg_execute</function> ã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ <?php // "mary"ã¨ããååã®ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ $dbconn = pg_connect("dbname=mary"); // å®è¡ããã¯ã¨ãªãæºå $result = pg_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1'); // ããªãã¢ãã¯ã¨ãªã®å®è¡ãæåå "Joe's Widgets" ã®ã¨ã¹ã±ã¼ãå¦ç㯠// ä¸åå¿ è¦ãªããã¨ã«æ³¨æ $result = pg_execute($dbconn, "my_query", array("Joe's Widgets")); // åãããªãã¢ãã¯ã¨ãªãéããã©ã¡ã¼ã¿ã§å®è¡ $result = pg_execute($dbconn, "my_query", array("Clothes Clothes Clothes")); ?> ]]> </programlisting> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>pg_prepare</function></member> <member><function>pg_send_prepare</function></member> <member><function>pg_query_params</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 -->