cvs: peardoc /ja/package/database/db intro-connect.xml intro-dsn.xml intro-query.xml intro-sequences.xml
| From: | Tadashi Jokagi | Date: | Tue, 25 Nov 2003 04:21:31 +0000 |
| Subject: | cvs: peardoc /ja/package/database/db intro-connect.xml intro-dsn.xml intro-query.xml intro-sequences.xml | ||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-2005@lists.php.net to get a copy of this message | ||
elf Mon Nov 24 23:21:31 2003 EDT
Added files:
/peardoc/ja/package/database/db intro-connect.xml intro-dsn.xml
intro-query.xml intro-sequences.xml
Log:
o added japanese manual
Index: peardoc/ja/package/database/db/intro-connect.xml +++ peardoc/ja/package/database/db/intro-connect.xml <!-- $Revision: 1.1 $ --> <!-- Sync: 1.5 --> <refentry id="package.database.db.intro-connect"> <refnamediv> <refname>å°å ¥ - Connect</refname> <refpurpose>æ¥ç¶ããã³æ¥ç¶ã®çµäº</refpurpose> </refnamediv> <refsect1 id="package.database.db.intro-connect.desc"> <title>説æ</title> <simpara> ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ããéã«ã¯ã颿°<link linkend="package.database.db.db.connect"> <function>DB::connect</function></link>ã使ç¨ãã¾ãã ãã®é¢æ°ã¯ãæå¹ãª<link linkend="package.database.db.intro-dsn">DSN</link> ããã©ã¡ã¼ã¿ã¨ãã¦æå®ããããã¨ãå¿ è¦ã¨ãã ãªãã·ã§ã³å¼æ°ã¨ãã¦æç¶çæ¥ç¶ãã©ãããå®ç¾©ããè«çå¤ãã¨ãã¾ãã æåæã«ãã¼ã¿ãã¼ã¹ã¯ã©ã¹ã®æ°è¦ã¤ã³ã¹ã¿ã³ã¹ãåå¾åºæ¥ã¾ãã <link linkend="package.database.db.db.iserror"><function>DB::isError</function></link> ã«ãããã®è¿ãå¤ã確èªãããã¨ãå¼·ãæ¨å¥¨ãã¾ãã ãã¼ã¿ãã¼ã¹ã¯ã©ã¹ã®ã¤ã³ã¹ã¿ã³ã¹ããæ¥ç¶ãåæããã«ã¯ã颿°<link linkend="package.database.db.db-common.disconnect"><function>disconnect</function></link> ã使ç¨ãã¾ãã </simpara> <example> <title>Connect and disconnect</title> <programlisting role="php"> <![CDATA[ <?php require_once 'DB.php'; $user = 'foo'; $pass = 'bar'; $host = 'localhost'; $db_name = 'clients_db'; // Data Source Name: ããã¯æ¥ç¶ç¨ãã©ã¡ã¼ã¿æååã§ã $dsn = "mysql://$user:$pass@$host/$db_name"; // DB::connect ã¯ãæåæã«PEAR DBãªãã¸ã§ã¯ãã // ã¨ã©ã¼ã®å ´åã«PEAR DB Errorãªãã¸ã§ã¯ããè¿ãã¾ã $db = DB::connect($dsn); // DB::isError ã«ãããã¨ã©ã¼ã¨æå¹ãªæ¥ç¶ãåºå¥ãããã¨ãå¯è½ã§ãã if (DB::isError($db)) { die ($db->getMessage()); } .... // ãã¼ã¿ãã¼ã¹ã¨ã®æ¥ç¶ãåæãã¾ã $db->disconnect(); ?> ]]> </programlisting> </example> </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 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 --> Index: peardoc/ja/package/database/db/intro-dsn.xml +++ peardoc/ja/package/database/db/intro-dsn.xml <!-- $Revision: 1.1 $ --> <!-- Sync: 1.3 --> <!-- Sync: 1.3 --> <refentry id="package.database.db.intro-dsn"> <refnamediv> <refname>Introduction - DSN</refname> <refpurpose>The Data Source Name</refpurpose> </refnamediv> <refsect1 id="package.database.db.intro-dsn.desc"> <title>Description</title> <simpara> PEAR::DBã«ããããã¼ã¿ãã¼ã¹ã«æ¥ç¶ããã«ã¯ãæå¹ãª <acronym>DSN - data source name</acronym> ã使ããå¿ è¦ãããã¾ãã ãã®DSNã¯ã以ä¸ã®è¦ç´ ãããªãã¾ãã </simpara> <para> <simplelist> <member> <parameter>phptype</parameter>: PHPã§ä½¿ç¨ããããã¼ã¿ãã¼ã¹ããã¯ã¨ã³ãã (ããªãã¡<parameter>mysql</parameter>ã<parameter>odbc</parameter>ç) </member> <member> <parameter>dbsyntax</parameter>: SQLæ§æçã®ãã¼ã¿ãã¼ã¹é¢é£æ§æã </member> <member> <parameter>protocol</parameter>: 使ç¨ããéä¿¡ãããã³ã«ã (ããªãã¡ã<parameter>tcp</parameter>ã<parameter>unix</parameter>ç) </member> <member> <parameter>hostspec</parameter>: ãã¹ãæå®ã (<parameter>hostname[:port]</parameter>) </member> <member> <parameter>database</parameter>: DBMSãµã¼ãä¸ã®ãã¼ã¿ãã¼ã¹ä½¿ç¨æ¹æ³ã </member> <member> <parameter>username</parameter>: ãã°ã¤ã³ç¨ã¦ã¼ã¶åã </member> <member> <parameter>password</parameter>: ãã°ã¤ã³ç¨ã®ãã¹ã¯ã¼ãã </member> <member> <parameter>proto_opts</parameter>: <parameter>protocol</parameter>ã§ä½¿ç¨ããããªãã·ã§ã³ã </member> </simplelist> </para> <para> 以ä¸ã®ããã«å¤ãã®ããªã¨ã¼ã·ã§ã³ã許ããã¦ãã¾ãã <programlisting role="url"> phptype(dbsyntax)://username:password@protocol+hostspec/database </programlisting> Most variations are allowed: <programlisting role="url"> phptype://username:password@protocol+hostspec:110//usr/db_file.db phptype://username:password@hostspec/database_name phptype://username:password@hostspec phptype://username@hostspec phptype://hostspec/database phptype://hostspec phptype(dbsyntax) phptype </programlisting> ç¾å¨ããµãã¼ãããã¦ãããã¼ã¿ãã¼ã¹ããã¯ã¨ã³ãã¯ã 以ä¸ã®ã¨ããã«ãªãã¾ãã <programlisting role="configure"> mysql -> MySQL pgsql -> PostgreSQL ibase -> InterBase msql -> Mini SQL mssql -> Microsoft SQL Server oci8 -> Oracle 7/8/8i odbc -> ODBC (Open Database Connectivity) sybase -> SyBase ifx -> Informix fbsql -> FrontBase </programlisting> </para> <para> ææ°çã®<classname>DB</classname>ã§ã¯ã 第2ã®DSNå½¢å¼ã使ç¨ããã㨠ãå¯è½ã§ãã <programlisting role="url"> phptype(syntax)://user:pass@protocol(proto_opts)/database </programlisting> <example> <title>ã½ã±ããã«ãããã¼ã¿ãã¼ã¹ã«æ¥ç¶ãã</title> <programlisting role="url"> mysql://user@unix(/path/to/socket)/pear </programlisting> </example> <example> <title>æ¨æºä»¥å¤ã®ãã¼ãã§ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ãã</title> <programlisting role="url"> pgsql://user:pass@word@tcp(localhost:5555)/pear </programlisting> </example> </para> <warning> <para> ããã¤ãã®æ©è½ã¯ã å ¨ã¦ã®ãã¼ã¿ãã¼ã¹ããã¯ã¨ã³ãã§ãµãã¼ãããã¦ãã¾ããã ã©ã®æ©è½ãã©ã®ããã¯ã¨ã³ãã§ãµãã¼ãããã¦ãããã«é¢ãã詳細ãªãªã¹ãã åå¾ããã«ã¯ <filename><pear base dir>/DB/STATUS</filename> ã«ããPEAR DBæ¡å¼µ ã®ã¹ãã¼ã¿ã¹ããã¥ã¡ã³ããåç §ãã¦ä¸ããã </para> </warning> </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 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 --> Index: peardoc/ja/package/database/db/intro-query.xml +++ peardoc/ja/package/database/db/intro-query.xml <!-- $Revision: 1.1 $ --> <!-- Sync: 1.5 --> <refentry id="package.database.db.intro-query"> <refnamediv> <refname>å°å ¥ - Query</refname> <refpurpose>ãã¼ã¿ãã¼ã¹ã§ã¯ã¨ãªãå®è¡ãã</refpurpose> </refnamediv> <refsect1 id="package.database.db.intro-query.desc"> <title>説æ</title> <simpara> 使ç¨ãããã¼ã¿ãã¼ã¹ã«å¯¾ãã¦ã¯ã¨ãªãå®è¡ããã«ã¯ã ã¯ã¨ãªæååã弿°ã¨ãã¦<link linkend="package.database.db.db-common.query"><function>query</function></link> 颿°ã使ç¨ããå¿ è¦ãããã¾ãã 失æããå ´åã¯ã<link linkend="package.database.db.db-error"><classname>DB_Error</classname></link> ãªãã¸ã§ã¯ããè¿ããã¾ãã®ã§ã<link linkend="package.database.db.db.iserror"><function>DB::isError</function></link> ã§ç¢ºèªãã¦ä¸ããã æåæã«ã¯ã <constant>DB_OK</constant>(å®ç¾©æ¸ã¿ã®PEAR::DBã®å®æ°) ã¾ãã¯ã<parameter>SELECT</parameter>å½ä»¤ãè¨å®ããå ´åã<link linkend="package.database.db.db-result"><classname>DB_Result</classname></link> ãªãã¸ã§ã¯ããè¿ããã¾ãã </simpara> <example> <title>queryãè¡ã</title> <programlisting role="php"> <![CDATA[ <?php // æå¹ãªDBãªãã¸ã§ã¯ããæãã¦ããå ´å... $sql = "select * from clients"; $result = $db->query($sql); // $resultãã¨ã©ã¼ã§ãªãã常ã«ãã§ãã¯ãã¦ä¸ãã if (DB::isError($result)) { die ($result->getMessage()); } .... ?> ]]> </programlisting> </example> </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 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 --> Index: peardoc/ja/package/database/db/intro-sequences.xml +++ peardoc/ja/package/database/db/intro-sequences.xml <!-- $Revision: 1.1 $ --> <!-- Sync: 1.6 --> <refentry id="package.database.db.intro-sequences"> <refnamediv> <refname>å°å ¥ - Sequences</refname> <refpurpose>ãã¼ã¿ãã¼ã¹ ã·ã¼ã±ã³ã¹</refpurpose> </refnamediv> <refsect1 id="package.database.db.intro-sequences.desc"> <title>説æ</title> <para> ã·ã¼ã±ã³ã¹ã¯ããã¼ã¿ã¬ã³ã¼ãç¨ã«ã¦ãã¼ã¯ãªIDãåå¾ããææ®µã§ãã å¤ãã®æ¥åãä¾ãã°MySQLã§è¡ã£ã¦ããå ´åãã·ã¼ã±ã³ã¹ã¯ã <constant>AUTO_INCREMENT</constant> ãè¡ãå¥ã®ææ®µã¨èãã§ããã¨èãã¦ä¸ããã ã·ã¼ã±ã³ã¹å¦çã¯ããªãç°¡åã§ãæåã«IDããªã¯ã¨ã¹ããã 使ããæ°è¦ã¬ã³ã¼ãã®IDãã£ã¼ã«ãã«å¤ãæ¿å ¥ãã¾ãã å ¨ã¦ã®ãã¼ãã«ã«è¤æ°ã®ã·ã¼ã±ã³ã¹ãæãããã¨ãå¯è½ã§ãã ãã ããç¹å®ã®ãã¼ãã«ã«ã¤ãã¦ã¯ åãã·ã¼ã±ã³ã¹ã常ã«ä½¿ç¨ããå¿ è¦ããããã¨ã«æ³¨æãã¦ä¸ããã ãã®ã¦ãã¼ã¯ãªIDã®å¤ãåå¾ããã«ã¯ã<link linkend="package.database.db.db-common.nextid"><function>nextId</function></link> ã使ç¨ãã¦ãã ããã ãããã·ã¼ã±ã³ã¹ãåå¨ããªãå ´åã¯ãèªåã§ä½æããã¾ãã <example> <title>sequenceã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ ... $id = $db->nextId('mySequence'); // INSERTã¯ã¨ãªã§IDã使ç¨ãã¾ã $res = $db->query("INSERT INTO myTable (id,text) VALUES ($id,'foo')"); ... ]]> </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 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 -->
Index: peardoc/ja/package/database/db/intro-connect.xml +++ peardoc/ja/package/database/db/intro-connect.xml <!-- $Revision: 1.1 $ --> <!-- Sync: 1.5 --> <refentry id="package.database.db.intro-connect"> <refnamediv> <refname>å°å ¥ - Connect</refname> <refpurpose>æ¥ç¶ããã³æ¥ç¶ã®çµäº</refpurpose> </refnamediv> <refsect1 id="package.database.db.intro-connect.desc"> <title>説æ</title> <simpara> ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ããéã«ã¯ã颿°<link linkend="package.database.db.db.connect"> <function>DB::connect</function></link>ã使ç¨ãã¾ãã ãã®é¢æ°ã¯ãæå¹ãª<link linkend="package.database.db.intro-dsn">DSN</link> ããã©ã¡ã¼ã¿ã¨ãã¦æå®ããããã¨ãå¿ è¦ã¨ãã ãªãã·ã§ã³å¼æ°ã¨ãã¦æç¶çæ¥ç¶ãã©ãããå®ç¾©ããè«çå¤ãã¨ãã¾ãã æåæã«ãã¼ã¿ãã¼ã¹ã¯ã©ã¹ã®æ°è¦ã¤ã³ã¹ã¿ã³ã¹ãåå¾åºæ¥ã¾ãã <link linkend="package.database.db.db.iserror"><function>DB::isError</function></link> ã«ãããã®è¿ãå¤ã確èªãããã¨ãå¼·ãæ¨å¥¨ãã¾ãã ãã¼ã¿ãã¼ã¹ã¯ã©ã¹ã®ã¤ã³ã¹ã¿ã³ã¹ããæ¥ç¶ãåæããã«ã¯ã颿°<link linkend="package.database.db.db-common.disconnect"><function>disconnect</function></link> ã使ç¨ãã¾ãã </simpara> <example> <title>Connect and disconnect</title> <programlisting role="php"> <![CDATA[ <?php require_once 'DB.php'; $user = 'foo'; $pass = 'bar'; $host = 'localhost'; $db_name = 'clients_db'; // Data Source Name: ããã¯æ¥ç¶ç¨ãã©ã¡ã¼ã¿æååã§ã $dsn = "mysql://$user:$pass@$host/$db_name"; // DB::connect ã¯ãæåæã«PEAR DBãªãã¸ã§ã¯ãã // ã¨ã©ã¼ã®å ´åã«PEAR DB Errorãªãã¸ã§ã¯ããè¿ãã¾ã $db = DB::connect($dsn); // DB::isError ã«ãããã¨ã©ã¼ã¨æå¹ãªæ¥ç¶ãåºå¥ãããã¨ãå¯è½ã§ãã if (DB::isError($db)) { die ($db->getMessage()); } .... // ãã¼ã¿ãã¼ã¹ã¨ã®æ¥ç¶ãåæãã¾ã $db->disconnect(); ?> ]]> </programlisting> </example> </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 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 --> Index: peardoc/ja/package/database/db/intro-dsn.xml +++ peardoc/ja/package/database/db/intro-dsn.xml <!-- $Revision: 1.1 $ --> <!-- Sync: 1.3 --> <!-- Sync: 1.3 --> <refentry id="package.database.db.intro-dsn"> <refnamediv> <refname>Introduction - DSN</refname> <refpurpose>The Data Source Name</refpurpose> </refnamediv> <refsect1 id="package.database.db.intro-dsn.desc"> <title>Description</title> <simpara> PEAR::DBã«ããããã¼ã¿ãã¼ã¹ã«æ¥ç¶ããã«ã¯ãæå¹ãª <acronym>DSN - data source name</acronym> ã使ããå¿ è¦ãããã¾ãã ãã®DSNã¯ã以ä¸ã®è¦ç´ ãããªãã¾ãã </simpara> <para> <simplelist> <member> <parameter>phptype</parameter>: PHPã§ä½¿ç¨ããããã¼ã¿ãã¼ã¹ããã¯ã¨ã³ãã (ããªãã¡<parameter>mysql</parameter>ã<parameter>odbc</parameter>ç) </member> <member> <parameter>dbsyntax</parameter>: SQLæ§æçã®ãã¼ã¿ãã¼ã¹é¢é£æ§æã </member> <member> <parameter>protocol</parameter>: 使ç¨ããéä¿¡ãããã³ã«ã (ããªãã¡ã<parameter>tcp</parameter>ã<parameter>unix</parameter>ç) </member> <member> <parameter>hostspec</parameter>: ãã¹ãæå®ã (<parameter>hostname[:port]</parameter>) </member> <member> <parameter>database</parameter>: DBMSãµã¼ãä¸ã®ãã¼ã¿ãã¼ã¹ä½¿ç¨æ¹æ³ã </member> <member> <parameter>username</parameter>: ãã°ã¤ã³ç¨ã¦ã¼ã¶åã </member> <member> <parameter>password</parameter>: ãã°ã¤ã³ç¨ã®ãã¹ã¯ã¼ãã </member> <member> <parameter>proto_opts</parameter>: <parameter>protocol</parameter>ã§ä½¿ç¨ããããªãã·ã§ã³ã </member> </simplelist> </para> <para> 以ä¸ã®ããã«å¤ãã®ããªã¨ã¼ã·ã§ã³ã許ããã¦ãã¾ãã <programlisting role="url"> phptype(dbsyntax)://username:password@protocol+hostspec/database </programlisting> Most variations are allowed: <programlisting role="url"> phptype://username:password@protocol+hostspec:110//usr/db_file.db phptype://username:password@hostspec/database_name phptype://username:password@hostspec phptype://username@hostspec phptype://hostspec/database phptype://hostspec phptype(dbsyntax) phptype </programlisting> ç¾å¨ããµãã¼ãããã¦ãããã¼ã¿ãã¼ã¹ããã¯ã¨ã³ãã¯ã 以ä¸ã®ã¨ããã«ãªãã¾ãã <programlisting role="configure"> mysql -> MySQL pgsql -> PostgreSQL ibase -> InterBase msql -> Mini SQL mssql -> Microsoft SQL Server oci8 -> Oracle 7/8/8i odbc -> ODBC (Open Database Connectivity) sybase -> SyBase ifx -> Informix fbsql -> FrontBase </programlisting> </para> <para> ææ°çã®<classname>DB</classname>ã§ã¯ã 第2ã®DSNå½¢å¼ã使ç¨ããã㨠ãå¯è½ã§ãã <programlisting role="url"> phptype(syntax)://user:pass@protocol(proto_opts)/database </programlisting> <example> <title>ã½ã±ããã«ãããã¼ã¿ãã¼ã¹ã«æ¥ç¶ãã</title> <programlisting role="url"> mysql://user@unix(/path/to/socket)/pear </programlisting> </example> <example> <title>æ¨æºä»¥å¤ã®ãã¼ãã§ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ãã</title> <programlisting role="url"> pgsql://user:pass@word@tcp(localhost:5555)/pear </programlisting> </example> </para> <warning> <para> ããã¤ãã®æ©è½ã¯ã å ¨ã¦ã®ãã¼ã¿ãã¼ã¹ããã¯ã¨ã³ãã§ãµãã¼ãããã¦ãã¾ããã ã©ã®æ©è½ãã©ã®ããã¯ã¨ã³ãã§ãµãã¼ãããã¦ãããã«é¢ãã詳細ãªãªã¹ãã åå¾ããã«ã¯ <filename><pear base dir>/DB/STATUS</filename> ã«ããPEAR DBæ¡å¼µ ã®ã¹ãã¼ã¿ã¹ããã¥ã¡ã³ããåç §ãã¦ä¸ããã </para> </warning> </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 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 --> Index: peardoc/ja/package/database/db/intro-query.xml +++ peardoc/ja/package/database/db/intro-query.xml <!-- $Revision: 1.1 $ --> <!-- Sync: 1.5 --> <refentry id="package.database.db.intro-query"> <refnamediv> <refname>å°å ¥ - Query</refname> <refpurpose>ãã¼ã¿ãã¼ã¹ã§ã¯ã¨ãªãå®è¡ãã</refpurpose> </refnamediv> <refsect1 id="package.database.db.intro-query.desc"> <title>説æ</title> <simpara> 使ç¨ãããã¼ã¿ãã¼ã¹ã«å¯¾ãã¦ã¯ã¨ãªãå®è¡ããã«ã¯ã ã¯ã¨ãªæååã弿°ã¨ãã¦<link linkend="package.database.db.db-common.query"><function>query</function></link> 颿°ã使ç¨ããå¿ è¦ãããã¾ãã 失æããå ´åã¯ã<link linkend="package.database.db.db-error"><classname>DB_Error</classname></link> ãªãã¸ã§ã¯ããè¿ããã¾ãã®ã§ã<link linkend="package.database.db.db.iserror"><function>DB::isError</function></link> ã§ç¢ºèªãã¦ä¸ããã æåæã«ã¯ã <constant>DB_OK</constant>(å®ç¾©æ¸ã¿ã®PEAR::DBã®å®æ°) ã¾ãã¯ã<parameter>SELECT</parameter>å½ä»¤ãè¨å®ããå ´åã<link linkend="package.database.db.db-result"><classname>DB_Result</classname></link> ãªãã¸ã§ã¯ããè¿ããã¾ãã </simpara> <example> <title>queryãè¡ã</title> <programlisting role="php"> <![CDATA[ <?php // æå¹ãªDBãªãã¸ã§ã¯ããæãã¦ããå ´å... $sql = "select * from clients"; $result = $db->query($sql); // $resultãã¨ã©ã¼ã§ãªãã常ã«ãã§ãã¯ãã¦ä¸ãã if (DB::isError($result)) { die ($result->getMessage()); } .... ?> ]]> </programlisting> </example> </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 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 --> Index: peardoc/ja/package/database/db/intro-sequences.xml +++ peardoc/ja/package/database/db/intro-sequences.xml <!-- $Revision: 1.1 $ --> <!-- Sync: 1.6 --> <refentry id="package.database.db.intro-sequences"> <refnamediv> <refname>å°å ¥ - Sequences</refname> <refpurpose>ãã¼ã¿ãã¼ã¹ ã·ã¼ã±ã³ã¹</refpurpose> </refnamediv> <refsect1 id="package.database.db.intro-sequences.desc"> <title>説æ</title> <para> ã·ã¼ã±ã³ã¹ã¯ããã¼ã¿ã¬ã³ã¼ãç¨ã«ã¦ãã¼ã¯ãªIDãåå¾ããææ®µã§ãã å¤ãã®æ¥åãä¾ãã°MySQLã§è¡ã£ã¦ããå ´åãã·ã¼ã±ã³ã¹ã¯ã <constant>AUTO_INCREMENT</constant> ãè¡ãå¥ã®ææ®µã¨èãã§ããã¨èãã¦ä¸ããã ã·ã¼ã±ã³ã¹å¦çã¯ããªãç°¡åã§ãæåã«IDããªã¯ã¨ã¹ããã 使ããæ°è¦ã¬ã³ã¼ãã®IDãã£ã¼ã«ãã«å¤ãæ¿å ¥ãã¾ãã å ¨ã¦ã®ãã¼ãã«ã«è¤æ°ã®ã·ã¼ã±ã³ã¹ãæãããã¨ãå¯è½ã§ãã ãã ããç¹å®ã®ãã¼ãã«ã«ã¤ãã¦ã¯ åãã·ã¼ã±ã³ã¹ã常ã«ä½¿ç¨ããå¿ è¦ããããã¨ã«æ³¨æãã¦ä¸ããã ãã®ã¦ãã¼ã¯ãªIDã®å¤ãåå¾ããã«ã¯ã<link linkend="package.database.db.db-common.nextid"><function>nextId</function></link> ã使ç¨ãã¦ãã ããã ãããã·ã¼ã±ã³ã¹ãåå¨ããªãå ´åã¯ãèªåã§ä½æããã¾ãã <example> <title>sequenceã®ä½¿ç¨æ³</title> <programlisting role="php"> <![CDATA[ ... $id = $db->nextId('mySequence'); // INSERTã¯ã¨ãªã§IDã使ç¨ãã¾ã $res = $db->query("INSERT INTO myTable (id,text) VALUES ($id,'foo')"); ... ]]> </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 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 -->