cvs: peardoc /ja/package/database db-dataobject.xml /ja/package/database/db-dataobject/db-dataobject count.xml free.xml selectas.xml
| From: | Haruki Setoyama | Date: | Thu, 07 Jul 2005 10:24:50 +0000 |
| Subject: | cvs: peardoc /ja/package/database db-dataobject.xml /ja/package/database/db-dataobject/db-dataobject count.xml free.xml selectas.xml | ||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-6471@lists.php.net to get a copy of this message | ||
haruki Thu Jul 7 06:24:50 2005 EDT
Added files:
/peardoc/ja/package/database/db-dataobject/db-dataobject free.xml
Modified files:
/peardoc/ja/package/database db-dataobject.xml
/peardoc/ja/package/database/db-dataobject/db-dataobject
selectas.xml
count.xml
Log:
sync with en
http://cvs.php.net/diff.php/peardoc/ja/package/database/db-dataobject.xml?r1=1.1&r2=1.2&ty=u Index: peardoc/ja/package/database/db-dataobject.xml diff -u peardoc/ja/package/database/db-dataobject.xml:1.1 peardoc/ja/package/database/db-dataobject.xml:1.2 --- peardoc/ja/package/database/db-dataobject.xml:1.1 Fri Apr 1 18:47:46 2005 +++ peardoc/ja/package/database/db-dataobject.xml Thu Jul 7 06:24:50 2005 @@ -1,115 +1,116 @@ -<?xml version="1.0" encoding="utf-8" ?> -<!-- $Revision: 1.1 $ --> -<!-- EN-Revision: 1.11 Maintainer: shimooka Status: ready --> - -<sect1 id="package.database.db-dataobject"> - <title>DB_DataObject</title> - - <para> - SQL ãã«ãã¨ãã¼ã¿ã¢ãã«å±¤ - </para> - <para> - ãã®ç« ã§ã¯ãDB_DataObject SQL - ãã«ãã¨ãã¼ã¿ã¢ãã«å±¤ã®ä½¿ç¨æ¹æ³ã«ã¤ãã¦èª¬æãã¦ãã¾ãã - </para> - - &package.database.db-dataobject.intro-purpose; - &package.database.db-dataobject.intro-configuration; - &package.database.db-dataobject.intro-autobuilding; - - &package.database.db-dataobject.db-dataobject.factory; - &package.database.db-dataobject.db-dataobject.get; - &package.database.db-dataobject.db-dataobject.staticget; - &package.database.db-dataobject.db-dataobject.staticget2; - &package.database.db-dataobject.db-dataobject.find; - &package.database.db-dataobject.db-dataobject.fetch; - &package.database.db-dataobject.db-dataobject.count; - - <!-- Depreciated ? - &package.database.db-dataobject.db-dataobject.fetchrow; - --> - - - - - &package.database.db-dataobject.db-dataobject.insert; - &package.database.db-dataobject.db-dataobject.update; - &package.database.db-dataobject.db-dataobject.delete; - - - &package.database.db-dataobject.intro-filters; - - &package.database.db-dataobject.db-dataobject.query; - &package.database.db-dataobject.db-dataobject.selectadd; - &package.database.db-dataobject.db-dataobject.whereadd; - &package.database.db-dataobject.db-dataobject.escape; - &package.database.db-dataobject.db-dataobject.limit; - &package.database.db-dataobject.db-dataobject.orderby; - &package.database.db-dataobject.db-dataobject.groupby; - - - - - &package.database.db-dataobject.intro-relations; - &package.database.db-dataobject.db-dataobject.getlink; - &package.database.db-dataobject.db-dataobject.getlinks; - <!-- - not sure if this should be public... - and it may be replaced eventually.. - &package.database.db-dataobject.db-dataobject.getlinkarray; - - --> - &package.database.db-dataobject.db-dataobject.selectas; - &package.database.db-dataobject.db-dataobject.joinadd; - - <!-- other usefull stuff --> - &package.database.db-dataobject.db-dataobject.settersgetters; - - &package.database.db-dataobject.db-dataobject.setfrom; - &package.database.db-dataobject.db-dataobject.toarray; - &package.database.db-dataobject.db-dataobject.validate; - - &package.database.db-dataobject.db-dataobject.tablename; - &package.database.db-dataobject.db-dataobject.database; - &package.database.db-dataobject.db-dataobject.table; - &package.database.db-dataobject.db-dataobject.keys; - - &package.database.db-dataobject.db-dataobject.getdatabaseconnection; - &package.database.db-dataobject.db-dataobject.getdatabaseresult; - - -<!-- staticAutoLoad is missing?? --> - - - - &package.database.db-dataobject.db-dataobject.debuglevel; - &package.database.db-dataobject.db-dataobject.debug; - &package.database.db-dataobject.db-dataobject.raiseerror; - -<!-- casting.. a little experimental at present --> - &package.database.db-dataobject.intro-casting; - - <!-- This shouldnt really be public.... - &package.database.db-dataobject.db-dataobject.staticinitialize; - --> - - - </sect1> -<!-- 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 ---> +<?xml version="1.0" encoding="utf-8" ?> +<!-- $Revision: 1.2 $ --> +<!-- EN-Revision: 1.12 Maintainer: shimooka Status: ready --> + +<sect1 id="package.database.db-dataobject"> + <title>DB_DataObject</title> + + <para> + SQL ãã«ãã¨ãã¼ã¿ã¢ãã«å±¤ + </para> + <para> + ãã®ç« ã§ã¯ãDB_DataObject SQL + ãã«ãã¨ãã¼ã¿ã¢ãã«å±¤ã®ä½¿ç¨æ¹æ³ã«ã¤ãã¦èª¬æãã¦ãã¾ãã + </para> + + &package.database.db-dataobject.intro-purpose; + &package.database.db-dataobject.intro-configuration; + &package.database.db-dataobject.intro-autobuilding; + + &package.database.db-dataobject.db-dataobject.factory; + &package.database.db-dataobject.db-dataobject.get; + &package.database.db-dataobject.db-dataobject.staticget; + &package.database.db-dataobject.db-dataobject.staticget2; + &package.database.db-dataobject.db-dataobject.find; + &package.database.db-dataobject.db-dataobject.fetch; + &package.database.db-dataobject.db-dataobject.count; + + <!-- Depreciated ? + &package.database.db-dataobject.db-dataobject.fetchrow; + --> + + + + + &package.database.db-dataobject.db-dataobject.insert; + &package.database.db-dataobject.db-dataobject.update; + &package.database.db-dataobject.db-dataobject.delete; + + + &package.database.db-dataobject.intro-filters; + + &package.database.db-dataobject.db-dataobject.query; + &package.database.db-dataobject.db-dataobject.free; + &package.database.db-dataobject.db-dataobject.selectadd; + &package.database.db-dataobject.db-dataobject.whereadd; + &package.database.db-dataobject.db-dataobject.escape; + &package.database.db-dataobject.db-dataobject.limit; + &package.database.db-dataobject.db-dataobject.orderby; + &package.database.db-dataobject.db-dataobject.groupby; + + + + + &package.database.db-dataobject.intro-relations; + &package.database.db-dataobject.db-dataobject.getlink; + &package.database.db-dataobject.db-dataobject.getlinks; + <!-- + not sure if this should be public... - and it may be replaced eventually.. + &package.database.db-dataobject.db-dataobject.getlinkarray; + + --> + &package.database.db-dataobject.db-dataobject.selectas; + &package.database.db-dataobject.db-dataobject.joinadd; + + <!-- other usefull stuff --> + &package.database.db-dataobject.db-dataobject.settersgetters; + + &package.database.db-dataobject.db-dataobject.setfrom; + &package.database.db-dataobject.db-dataobject.toarray; + &package.database.db-dataobject.db-dataobject.validate; + + &package.database.db-dataobject.db-dataobject.tablename; + &package.database.db-dataobject.db-dataobject.database; + &package.database.db-dataobject.db-dataobject.table; + &package.database.db-dataobject.db-dataobject.keys; + + &package.database.db-dataobject.db-dataobject.getdatabaseconnection; + &package.database.db-dataobject.db-dataobject.getdatabaseresult; + + +<!-- staticAutoLoad is missing?? --> + + + + &package.database.db-dataobject.db-dataobject.debuglevel; + &package.database.db-dataobject.db-dataobject.debug; + &package.database.db-dataobject.db-dataobject.raiseerror; + +<!-- casting.. a little experimental at present --> + &package.database.db-dataobject.intro-casting; + + <!-- This shouldnt really be public.... + &package.database.db-dataobject.db-dataobject.staticinitialize; + --> + + + </sect1> +<!-- 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 +--> http://cvs.php.net/diff.php/peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml?r1=1.1&r2=1.2&ty=u Index: peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml diff -u peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml:1.1 peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml:1.2 --- peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml:1.1 Fri Apr 1 18:47:47 2005 +++ peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml Thu Jul 7 06:24:50 2005 @@ -1,178 +1,178 @@ -<?xml version="1.0" encoding="utf-8" ?> -<!-- $Revision: 1.1 $ --> -<!-- EN-Revision: 1.2 Maintainer: shimooka Status: ready --> -<refentry id="package.database.db-dataobject.db-dataobject.selectas"> - <refnamediv> - <refname>->selectAs()</refname> - <refpurpose>ã¯ã¨ãªã®åå¾ ã³ã³ãã¼ãã³ããæ§ç¯ãã (é常ã¯çµåã®ãã)</refpurpose> - </refnamediv> - <refsynopsisdiv> - <funcsynopsis> - - <funcprototype> - <funcdef>void <function>$DB_DataObject->selectAs</function></funcdef> - - <paramdef> - object | array <parameter><optional>$columns_or_object</optional></parameter> - string <parameter><optional>$format</optional></parameter> - string <parameter><optional>$table_name</optional></parameter> - </paramdef> - - </funcprototype> - </funcsynopsis> - </refsynopsisdiv> - <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.desc"> - &title.desc; - <para> - ç¾å¨ã®ãªãã¸ã§ã¯ãã®ã«ã©ã åãæä¾ããããªãã¸ã§ã¯ããããã¯é åã«åºã¥ãã - åå¾ã¢ã¤ãã ãèªåçæãã¾ãã - </para> - <para> - ããã¯ãã«ã©ã åã®è¡çªãèµ·ããã¦ããæ - (両æ¹ã®è¡¨ã« 'id' ã«ã©ã ãåå¨ãããªã©) ã主ã«åºå®ãã©ã¼ãããã§ã«ã©ã ã®æ¹åãå¯è½ã«ããããã® joinAdd ãç¨ããçµåã§ä½¿ç¨ããã¾ãã - </para> - <para> - selectAs ã«ãã©ã¡ã¼ã¿ã渡ããªãå ´åãç¾å¨ã® SELECT - (é常ããã©ã«ãã® *) ããªã»ããããç¾å¨ã®ãªãã¸ã§ã¯ãã®ã«ã©ã åã«åºã¥ãã - åå¾ãªã¹ããæ§ç¯ãã¾ãã - </para> - - </refsect1> - - <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.parameter"> - &title.param; - <para> - <itemizedlist> - - <listitem> - <para> - <parameter>object | array $column_or_object</parameter> - - ãã¼ã¿ãªãã¸ã§ã¯ããããã¯ã«ã©ã åã®é åãæå®ãã¾ã - </para> - </listitem> - - <listitem> - <para> - <parameter>string $format</parameter> - - ã«ã©ã ãç¾ããã¨ãã«ä½¿ç¨ãããã©ã¼ãããã§ãsprintf - ãã©ã¼ããããæå®ãã¾ãã - %s ã¯ã«ã©ã åã«ç½®æããã¾ãã®ã§ãcar_%s 㯠SQL ä¸ã§ - 'car.name as car_name' ãçæããããã¨ãªãã¾ãã - </para> - </listitem> - - <listitem> - <para> - <parameter>string $tableName</parameter> - - ããã¯1çªç®ã®å¼æ°ã¨ãã¦é åãæå®ãããã - ãããã¯ãã¼ãã«ãä»ã®ååã§çµåãã¦ããå ´åã«ä½¿ç¨ããã¾ãã - </para> - </listitem> - - </itemizedlist> - </para> - </refsect1> - - - - - <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.note"> - &title.note; - - ¬e.notstatic; - - - - <simpara></simpara> - </refsect1> - - - <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.example"> - &title.example; - <example> - <title><function>selectAs</function> ã®ä½¿ç¨</title> - <programlisting role="php"> - <![CDATA[ -<?php -// ok lets see what is going on.. -DB_DataObject::debugLevel(1); - -$person = new DataObjects_Person; - - -// to generate "person.id as id , person.name as name ......." -$person->selectAs(); - -// to generate a restricted list.. "person.age as age , person.name as name" -$person->selectAs(array('age','name')); - -// using another object. -$car = new DataObjects_Car; - -// this is the first car ( -$car->use = 'first'; - - -// using the joinadd add the car.. -$person->joinAdd($car); - -// now add all the select columsn for the car eg. "car.id as car_id, car.name as car_name ...." -$person->selectAs($car, 'car_%s'); - - -// select only a few columns from the car table. -// note you have to use the table name at the end.. -$person->selectAs(array('color','topspeed'), 'car_%s','car'); - - - - -// now the user can have a second car.... -$secondcar = new DataObjects_Car; -$secondcar->use = 'second'; - -// now since we alreay have one car, the sql statement would get messy -// so we are joining this as the second car "FROM person INNER JOIN car ..... , car as secondcar WHERE ..... -$person->joinAdd($secondcar,'','secondcar'); - -// and we can now add all the columns -// "secondcar.id as secondcar_id, secondcar.name as secondcar_name ........ -// note that you must use the last field as the SECONDCAR.ID format uses the 'AS' name, rather than the -// objects real table name 'car' -$person->selectAs($secondcar, 'secondcar_%s','secondcar'); - - - -// ok fire of a query... -$person->find(); -while ($person->fetch()) { - ...... -} - - -?> -]]> - </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 ---> +<?xml version="1.0" encoding="utf-8" ?> +<!-- $Revision: 1.2 $ --> +<!-- EN-Revision: 1.3 Maintainer: shimooka Status: ready --> +<refentry id="package.database.db-dataobject.db-dataobject.selectas"> + <refnamediv> + <refname>->selectAs()</refname> + <refpurpose>ã¯ã¨ãªã®åå¾ ã³ã³ãã¼ãã³ããæ§ç¯ãã (é常ã¯çµåã®ãã)</refpurpose> + </refnamediv> + <refsynopsisdiv> + <funcsynopsis> + + <funcprototype> + <funcdef>void <function>$DB_DataObject->selectAs</function></funcdef> + + + <paramdef> object | array <parameter><optional>$columns_or_object</optional></parameter></paramdef> + <paramdef> string <parameter><optional>$format</optional></parameter></paramdef> + <paramdef> string <parameter><optional>$table_name</optional></parameter></paramdef> + + + </funcprototype> + </funcsynopsis> + </refsynopsisdiv> + <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.desc"> + &title.desc; + <para> + ç¾å¨ã®ãªãã¸ã§ã¯ãã®ã«ã©ã åãæä¾ããããªãã¸ã§ã¯ããããã¯é åã«åºã¥ãã + åå¾ã¢ã¤ãã ãèªåçæãã¾ãã + </para> + <para> + ããã¯ãã«ã©ã åã®è¡çªãèµ·ããã¦ããæ + (両æ¹ã®è¡¨ã« 'id' ã«ã©ã ãåå¨ãããªã©) ã主ã«åºå®ãã©ã¼ãããã§ã«ã©ã ã®æ¹åãå¯è½ã«ããããã® joinAdd ãç¨ããçµåã§ä½¿ç¨ããã¾ãã + </para> + <para> + selectAs ã«ãã©ã¡ã¼ã¿ã渡ããªãå ´åãç¾å¨ã® SELECT + (é常ããã©ã«ãã® *) ããªã»ããããç¾å¨ã®ãªãã¸ã§ã¯ãã®ã«ã©ã åã«åºã¥ãã + åå¾ãªã¹ããæ§ç¯ãã¾ãã + </para> + + </refsect1> + + <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.parameter"> + &title.param; + <para> + <itemizedlist> + + <listitem> + <para> + <parameter>object | array $column_or_object</parameter> - + ãã¼ã¿ãªãã¸ã§ã¯ããããã¯ã«ã©ã åã®é åãæå®ãã¾ã + </para> + </listitem> + + <listitem> + <para> + <parameter>string $format</parameter> - + ã«ã©ã ãç¾ããã¨ãã«ä½¿ç¨ãããã©ã¼ãããã§ãsprintf + ãã©ã¼ããããæå®ãã¾ãã + %s ã¯ã«ã©ã åã«ç½®æããã¾ãã®ã§ãcar_%s 㯠SQL ä¸ã§ + 'car.name as car_name' ãçæããããã¨ãªãã¾ãã + </para> + </listitem> + + <listitem> + <para> + <parameter>string $tableName</parameter> - + ããã¯1çªç®ã®å¼æ°ã¨ãã¦é åãæå®ãããã + ãããã¯ãã¼ãã«ãä»ã®ååã§çµåãã¦ããå ´åã«ä½¿ç¨ããã¾ãã + </para> + </listitem> + + </itemizedlist> + </para> + </refsect1> + + + + + <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.note"> + &title.note; + + ¬e.notstatic; + + + + <simpara></simpara> + </refsect1> + + + <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.example"> + &title.example; + <example> + <title><function>selectAs</function> ã®ä½¿ç¨</title> + <programlisting role="php"> + <![CDATA[ +<?php +// ok lets see what is going on.. +DB_DataObject::debugLevel(1); + +$person = new DataObjects_Person; + + +// to generate "person.id as id , person.name as name ......." +$person->selectAs(); + +// to generate a restricted list.. "person.age as age , person.name as name" +$person->selectAs(array('age','name')); + +// using another object. +$car = new DataObjects_Car; + +// this is the first car ( +$car->use = 'first'; + + +// using the joinadd add the car.. +$person->joinAdd($car); + +// now add all the select columsn for the car eg. "car.id as car_id, car.name as car_name ...." +$person->selectAs($car, 'car_%s'); + + +// select only a few columns from the car table. +// note you have to use the table name at the end.. +$person->selectAs(array('color','topspeed'), 'car_%s','car'); + + + + +// now the user can have a second car.... +$secondcar = new DataObjects_Car; +$secondcar->use = 'second'; + +// now since we alreay have one car, the sql statement would get messy +// so we are joining this as the second car "FROM person INNER JOIN car ..... , car as secondcar WHERE ..... +$person->joinAdd($secondcar,'','secondcar'); + +// and we can now add all the columns +// "secondcar.id as secondcar_id, secondcar.name as secondcar_name ........ +// note that you must use the last field as the SECONDCAR.ID format uses the 'AS' name, rather than the +// objects real table name 'car' +$person->selectAs($secondcar, 'secondcar_%s','secondcar'); + + + +// ok fire of a query... +$person->find(); +while ($person->fetch()) { + ...... +} + + +?> +]]> + </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 +--> http://cvs.php.net/diff.php/peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml?r1=1.1&r2=1.2&ty=u Index: peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml diff -u peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml:1.1 peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml:1.2 --- peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml:1.1 Fri Apr 1 18:47:47 2005 +++ peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml Thu Jul 7 06:24:50 2005 @@ -1,116 +1,161 @@ -<?xml version="1.0" encoding="utf-8" ?> -<!-- $Revision: 1.1 $ --> -<!-- EN-Revision: 1.5 Maintainer: shimooka Status: ready --> -<refentry id="package.database.db-dataobject.db-dataobject.count"> - <refnamediv> - <refname>->count()</refname> - <refpurpose>select count() ãªã¯ã¨ã¹ããå®è¡ãã</refpurpose> - </refnamediv> - <refsynopsisdiv> - <funcsynopsis> - - <funcprototype> - <funcdef>int <function>$DB_DataObject->count</function></funcdef> - - - <paramdef></paramdef> - - </funcprototype> - </funcsynopsis> - </refsynopsisdiv> - <refsect1 id="package.database.db-dataobject.db-dataobject.count.desc"> - &title.desc; - <para> - ããã¯ã表ã®ãã¼ã«ã©ã ã«ãã select count() ãªã¯ã¨ã¹ããå®è¡ãã - çµæã®è¡æ°ãè¿ãã¾ãã - count() ã«é©ç¨ãããããã©ã«ãã®æ¡ä»¶ã¯ããªãã¸ã§ã¯ã夿°ã¨ whereAdd - ã®è¨å®å 容ã®çµã¿åããã§ãã - ããã宿° DB_DATAOBJECT_WHEREADD_ONLY ã第1ãã©ã¡ã¼ã¿ã«æå®ãããå ´åã - whereAdd ã®è¨å®å 容ã ãã使ç¨ããã¾ãã - - - </para> - </refsect1> - - <refsect1 id="package.database.db-dataobject.db-dataobject.count.parameter"> - &title.param; - <para> - <itemizedlist> - - <listitem> - <para> - <parameter>boolean $useWhereAddOnly</parameter> - - whereAdd æ¡ä»¶ã®ã¿ä½¿ç¨ãããã©ãããæå®ãã¾ã - (ããã©ã«ãã§ã¯ãcount ãªãã¸ã§ã¯ãã®è¨å®å 容㨠- whereAdd ã®æ¡ä»¶ã®ä¸¡æ¹ã使ç¨ããã¾ã) ã - </para> - </listitem> - - </itemizedlist> - </para> - </refsect1> - - - <refsect1 id="package.database.db-dataobject.db-dataobject.count.return"> - &title.returns; - <para> - <parameter>int</parameter> - çµæã®æ° - </para> - </refsect1> - - - - <refsect1 id="package.database.db-dataobject.db-dataobject.count.note"> - &title.note; - - ¬e.notstatic; - - - - <simpara></simpara> - </refsect1> - - <refsect1 id="package.database.db-dataobject.db-dataobject.count.example"> - &title.example; - <example> - <title>ãªãã¸ã§ã¯ã夿°ã«åºã¥ãããã¼ã¿ã®ç°¡åãªæ¤ç´¢ã¨ãã§ãã</title> - <programlisting role="php"> - <![CDATA[ -$person = new DataObjects_Person; - -$person->whereAdd('name like '%test%'); -$total = $person->count(); - -echo "There are {$total} people with a name like test"; -]]> - </programlisting> - </example> - <example> - <title>çµæã® SQL </title> - <programlisting> - <![CDATA[ -SELECT count(id) FROM person WHERE name like '%test%' -]]> - </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 ---> +<?xml version="1.0" encoding="utf-8" ?> +<!-- $Revision: 1.2 $ --> +<!-- EN-Revision: 1.8 Maintainer: shimooka Status: ready --> +<refentry id="package.database.db-dataobject.db-dataobject.count"> + <refnamediv> + <refname>->count()</refname> + <refpurpose>select count() ãªã¯ã¨ã¹ããå®è¡ãã</refpurpose> + </refnamediv> + <refsynopsisdiv> + <funcsynopsis> + + <funcprototype> + <funcdef>int <function>$DB_DataObject->count</function></funcdef> + <paramdef>string|boolean <parameter><optional>$countWhat|$whereAddOnly</optional></parameter></paramdef> + <paramdef>boolean <parameter><optional>$whereAddOnly</optional></parameter></paramdef> + + </funcprototype> + </funcsynopsis> + </refsynopsisdiv> + <refsect1 id="package.database.db-dataobject.db-dataobject.count.desc"> + &title.desc; + <para> + ããã¯ã表ã®ãã¼ã«ã©ã ã«ãã select count() ãªã¯ã¨ã¹ããå®è¡ãã + çµæã®è¡æ°ãè¿ãã¾ãã + count() ã«é©ç¨ãããããã©ã«ãã®æ¡ä»¶ã¯ããªãã¸ã§ã¯ã夿°ã¨ whereAdd + ã®è¨å®å 容ã®çµã¿åããã§ãã + ããã宿° DB_DATAOBJECT_WHEREADD_ONLY ã第1ãã©ã¡ã¼ã¿ã«æå®ãããå ´åã + whereAdd ã®è¨å®å 容ã ãã使ç¨ããã¾ãã + + + </para> + </refsect1> + + <refsect1 id="package.database.db-dataobject.db-dataobject.count.parameter"> + &title.param; + <para> + <itemizedlist> + + <listitem> + <para> + <parameter>string $countWhat</parameter> - + ããã©ã«ãã«ã¦ã³ãã¯ã主ãã¼ãã«ã¦ã³ããã¾ãã + ããä½ãä»ãã«ã¦ã³ãããå¿ è¦ãããå ´åã§ãåç´ã« DISTINCT + ãæå®ããå ´å㯠DISTINCT ãåã«ä»ãã主ãã¼ãã«ã¦ã³ããã¾ãã + ãã®ä»ã®å ´åã¯ç¬èªã®å¤ãã«ã¦ã³ããã¾ã + (ã¨ã¹ã±ã¼ããå¿ è¦ãªå ´åãå¿ããªãããã«ãã¦ãã ãã) ã + + </para> + </listitem> + <listitem> + <para> + <parameter>boolean $useWhereAddOnly</parameter> - + whereAdd æ¡ä»¶ã®ã¿ä½¿ç¨ãããã©ãããæå®ãã¾ã + (ããã©ã«ãã§ã¯ãcount ãªãã¸ã§ã¯ãã®è¨å®å 容㨠+ whereAdd ã®æ¡ä»¶ã®ä¸¡æ¹ã使ç¨ããã¾ã) ã + </para> + </listitem> + + </itemizedlist> + </para> + </refsect1> + + + <refsect1 id="package.database.db-dataobject.db-dataobject.count.return"> + &title.returns; + <para> + <parameter>int|false</parameter> - çµæã®æ°ãããã¯å¤±ææã« false + </para> + </refsect1> + + + + <refsect1 id="package.database.db-dataobject.db-dataobject.count.note"> + &title.note; + + ¬e.notstatic; + + + + <simpara></simpara> + </refsect1> + + <refsect1 id="package.database.db-dataobject.db-dataobject.count.example"> + &title.example; + <example> + <title>ãªãã¸ã§ã¯ã夿°ã«åºã¥ãããã¼ã¿ã®ç°¡åãªæ¤ç´¢ã¨ãã§ãã</title> + <programlisting role="php"> + <![CDATA[ +<?php + +/* using property values */ +$person = new DataObjects_Person; +$person->name = "test" +$total = $person->count(); +echo "There are {$total} people with a name like test"; + +/* using countWhat */ +$person = new DataObjects_Person; +$total = $person->count('DISTINCT name'); +echo "There are {$total} names in the database"; + +/* using countWhat value = DISTINCT */ +$person = new DataObjects_Person; +$total = $person->count('DISTINCT'); +echo "There are {$total} names in the database"; + +/* using whereOnly */ +$person = new DataObjects_Person; +$person->name = "test"; +$person->whereAdd("name like '%test%"); +$total = $person->count(DB_DATAOBJECT_WHEREADD_ONLY); +echo "There are {$total} names in the database"; + +?> +]]> + </programlisting> + </example> + <example> + <title>çµæã® SQL </title> + <programlisting> + <![CDATA[ +SELECT count(person.id) AS DATAOBJECT_NUM + FROM person + WHERE person.name = 'test'; + +SELECT count(DISTINCT name) AS DATAOBJECT_NUM + FROM person; + +SELECT count(DISTINCT person.id) AS DATAOBJECT_NUM + FROM person; + +SELECT count(person.id) AS DATAOBJECT_NUM + FROM person + WHERE name like '%test%'; + + + +]]> + </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 +--> http://cvs.php.net/co.php/peardoc/ja/package/database/db-dataobject/db-dataobject/free.xml?r=1.1&p=1 Index: peardoc/ja/package/database/db-dataobject/db-dataobject/free.xml +++ peardoc/ja/package/database/db-dataobject/db-dataobject/free.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.1 Maintainer: shimooka Status: ready --> <refentry id="package.database.db-dataobject.db-dataobject.free"> <refnamediv> <refname>->free()</refname> <refpurpose>ãªã½ã¼ã¹ãè§£æ¾ãã</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcprototype> <funcdef>object <function>$DB_DataObject->free</function></funcdef> <paramdef></paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.database.db-dataobject.db-dataobject.free.desc"> &title.desc; <para> DataObject ã¯ãã©ã¤ãã¼ããªã°ãã¼ãã«å¤æ°ã¨ãã¦çµæã»ãããä¿æãã¦ãã¾ãã é常ããã¯çµæãå¦çããå¾ããããã¯ãªã¯ã¨ã¹ãã®çµäºæã«è§£æ¾ããã¾ãã ããããã¯ã¨ãªãç´æ¥å®è¡ãã¦ããããã¼ã¿ãæ¿å ¥ãã¦ãããªã©ã® ããã¤ãã®ç¶æ³ã§ã¯ãã¼ã¿ããã£ãã·ã¥ããå¿ è¦ãããã¾ããã </para> <para> ãã®ã¡ã½ããã使ç¨ãããã¨ã§ãå ¨ã¦ã®çµæã»ãããè§£æ¾ãããã¨ãã§ãã¾ã (注æãã¦ãã ãã) ! ãã®ã¡ã½ããã¯ãå®è¡ä¸ã® fetch() ã«ã¼ãã忢ããã¾ãã </para> <para> é常ã大éã®æ¿å ¥ãã¯ã¨ãªãå®è¡ãã¦ããå ´åã®ã¿ã ãã®ã¡ã½ããã使ç¨ããå¿ è¦ãããã¾ãã </para> </refsect1> <refsect1 id="package.database.db-dataobject.db-dataobject.free.note"> &title.note; ¬e.notstatic; </refsect1> <refsect1 id="package.database.db-dataobject.db-dataobject.free.example"> &title.example; <example> <title>ã«ã¼ãå ã§ãªã½ã¼ã¹ãè§£æ¾ãã</title> <programlisting role="php"><![CDATA[ <?php for ($i = 0; i< 10000; $i++) { $person = new DataObjects_Person; $person->query(' ... do something ... '); $person->free(); } ?> ]]> </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 -->
http://cvs.php.net/diff.php/peardoc/ja/package/database/db-dataobject.xml?r1=1.1&r2=1.2&ty=u Index: peardoc/ja/package/database/db-dataobject.xml diff -u peardoc/ja/package/database/db-dataobject.xml:1.1 peardoc/ja/package/database/db-dataobject.xml:1.2 --- peardoc/ja/package/database/db-dataobject.xml:1.1 Fri Apr 1 18:47:46 2005 +++ peardoc/ja/package/database/db-dataobject.xml Thu Jul 7 06:24:50 2005 @@ -1,115 +1,116 @@ -<?xml version="1.0" encoding="utf-8" ?> -<!-- $Revision: 1.1 $ --> -<!-- EN-Revision: 1.11 Maintainer: shimooka Status: ready --> - -<sect1 id="package.database.db-dataobject"> - <title>DB_DataObject</title> - - <para> - SQL ãã«ãã¨ãã¼ã¿ã¢ãã«å±¤ - </para> - <para> - ãã®ç« ã§ã¯ãDB_DataObject SQL - ãã«ãã¨ãã¼ã¿ã¢ãã«å±¤ã®ä½¿ç¨æ¹æ³ã«ã¤ãã¦èª¬æãã¦ãã¾ãã - </para> - - &package.database.db-dataobject.intro-purpose; - &package.database.db-dataobject.intro-configuration; - &package.database.db-dataobject.intro-autobuilding; - - &package.database.db-dataobject.db-dataobject.factory; - &package.database.db-dataobject.db-dataobject.get; - &package.database.db-dataobject.db-dataobject.staticget; - &package.database.db-dataobject.db-dataobject.staticget2; - &package.database.db-dataobject.db-dataobject.find; - &package.database.db-dataobject.db-dataobject.fetch; - &package.database.db-dataobject.db-dataobject.count; - - <!-- Depreciated ? - &package.database.db-dataobject.db-dataobject.fetchrow; - --> - - - - - &package.database.db-dataobject.db-dataobject.insert; - &package.database.db-dataobject.db-dataobject.update; - &package.database.db-dataobject.db-dataobject.delete; - - - &package.database.db-dataobject.intro-filters; - - &package.database.db-dataobject.db-dataobject.query; - &package.database.db-dataobject.db-dataobject.selectadd; - &package.database.db-dataobject.db-dataobject.whereadd; - &package.database.db-dataobject.db-dataobject.escape; - &package.database.db-dataobject.db-dataobject.limit; - &package.database.db-dataobject.db-dataobject.orderby; - &package.database.db-dataobject.db-dataobject.groupby; - - - - - &package.database.db-dataobject.intro-relations; - &package.database.db-dataobject.db-dataobject.getlink; - &package.database.db-dataobject.db-dataobject.getlinks; - <!-- - not sure if this should be public... - and it may be replaced eventually.. - &package.database.db-dataobject.db-dataobject.getlinkarray; - - --> - &package.database.db-dataobject.db-dataobject.selectas; - &package.database.db-dataobject.db-dataobject.joinadd; - - <!-- other usefull stuff --> - &package.database.db-dataobject.db-dataobject.settersgetters; - - &package.database.db-dataobject.db-dataobject.setfrom; - &package.database.db-dataobject.db-dataobject.toarray; - &package.database.db-dataobject.db-dataobject.validate; - - &package.database.db-dataobject.db-dataobject.tablename; - &package.database.db-dataobject.db-dataobject.database; - &package.database.db-dataobject.db-dataobject.table; - &package.database.db-dataobject.db-dataobject.keys; - - &package.database.db-dataobject.db-dataobject.getdatabaseconnection; - &package.database.db-dataobject.db-dataobject.getdatabaseresult; - - -<!-- staticAutoLoad is missing?? --> - - - - &package.database.db-dataobject.db-dataobject.debuglevel; - &package.database.db-dataobject.db-dataobject.debug; - &package.database.db-dataobject.db-dataobject.raiseerror; - -<!-- casting.. a little experimental at present --> - &package.database.db-dataobject.intro-casting; - - <!-- This shouldnt really be public.... - &package.database.db-dataobject.db-dataobject.staticinitialize; - --> - - - </sect1> -<!-- 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 ---> +<?xml version="1.0" encoding="utf-8" ?> +<!-- $Revision: 1.2 $ --> +<!-- EN-Revision: 1.12 Maintainer: shimooka Status: ready --> + +<sect1 id="package.database.db-dataobject"> + <title>DB_DataObject</title> + + <para> + SQL ãã«ãã¨ãã¼ã¿ã¢ãã«å±¤ + </para> + <para> + ãã®ç« ã§ã¯ãDB_DataObject SQL + ãã«ãã¨ãã¼ã¿ã¢ãã«å±¤ã®ä½¿ç¨æ¹æ³ã«ã¤ãã¦èª¬æãã¦ãã¾ãã + </para> + + &package.database.db-dataobject.intro-purpose; + &package.database.db-dataobject.intro-configuration; + &package.database.db-dataobject.intro-autobuilding; + + &package.database.db-dataobject.db-dataobject.factory; + &package.database.db-dataobject.db-dataobject.get; + &package.database.db-dataobject.db-dataobject.staticget; + &package.database.db-dataobject.db-dataobject.staticget2; + &package.database.db-dataobject.db-dataobject.find; + &package.database.db-dataobject.db-dataobject.fetch; + &package.database.db-dataobject.db-dataobject.count; + + <!-- Depreciated ? + &package.database.db-dataobject.db-dataobject.fetchrow; + --> + + + + + &package.database.db-dataobject.db-dataobject.insert; + &package.database.db-dataobject.db-dataobject.update; + &package.database.db-dataobject.db-dataobject.delete; + + + &package.database.db-dataobject.intro-filters; + + &package.database.db-dataobject.db-dataobject.query; + &package.database.db-dataobject.db-dataobject.free; + &package.database.db-dataobject.db-dataobject.selectadd; + &package.database.db-dataobject.db-dataobject.whereadd; + &package.database.db-dataobject.db-dataobject.escape; + &package.database.db-dataobject.db-dataobject.limit; + &package.database.db-dataobject.db-dataobject.orderby; + &package.database.db-dataobject.db-dataobject.groupby; + + + + + &package.database.db-dataobject.intro-relations; + &package.database.db-dataobject.db-dataobject.getlink; + &package.database.db-dataobject.db-dataobject.getlinks; + <!-- + not sure if this should be public... - and it may be replaced eventually.. + &package.database.db-dataobject.db-dataobject.getlinkarray; + + --> + &package.database.db-dataobject.db-dataobject.selectas; + &package.database.db-dataobject.db-dataobject.joinadd; + + <!-- other usefull stuff --> + &package.database.db-dataobject.db-dataobject.settersgetters; + + &package.database.db-dataobject.db-dataobject.setfrom; + &package.database.db-dataobject.db-dataobject.toarray; + &package.database.db-dataobject.db-dataobject.validate; + + &package.database.db-dataobject.db-dataobject.tablename; + &package.database.db-dataobject.db-dataobject.database; + &package.database.db-dataobject.db-dataobject.table; + &package.database.db-dataobject.db-dataobject.keys; + + &package.database.db-dataobject.db-dataobject.getdatabaseconnection; + &package.database.db-dataobject.db-dataobject.getdatabaseresult; + + +<!-- staticAutoLoad is missing?? --> + + + + &package.database.db-dataobject.db-dataobject.debuglevel; + &package.database.db-dataobject.db-dataobject.debug; + &package.database.db-dataobject.db-dataobject.raiseerror; + +<!-- casting.. a little experimental at present --> + &package.database.db-dataobject.intro-casting; + + <!-- This shouldnt really be public.... + &package.database.db-dataobject.db-dataobject.staticinitialize; + --> + + + </sect1> +<!-- 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 +--> http://cvs.php.net/diff.php/peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml?r1=1.1&r2=1.2&ty=u Index: peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml diff -u peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml:1.1 peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml:1.2 --- peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml:1.1 Fri Apr 1 18:47:47 2005 +++ peardoc/ja/package/database/db-dataobject/db-dataobject/selectas.xml Thu Jul 7 06:24:50 2005 @@ -1,178 +1,178 @@ -<?xml version="1.0" encoding="utf-8" ?> -<!-- $Revision: 1.1 $ --> -<!-- EN-Revision: 1.2 Maintainer: shimooka Status: ready --> -<refentry id="package.database.db-dataobject.db-dataobject.selectas"> - <refnamediv> - <refname>->selectAs()</refname> - <refpurpose>ã¯ã¨ãªã®åå¾ ã³ã³ãã¼ãã³ããæ§ç¯ãã (é常ã¯çµåã®ãã)</refpurpose> - </refnamediv> - <refsynopsisdiv> - <funcsynopsis> - - <funcprototype> - <funcdef>void <function>$DB_DataObject->selectAs</function></funcdef> - - <paramdef> - object | array <parameter><optional>$columns_or_object</optional></parameter> - string <parameter><optional>$format</optional></parameter> - string <parameter><optional>$table_name</optional></parameter> - </paramdef> - - </funcprototype> - </funcsynopsis> - </refsynopsisdiv> - <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.desc"> - &title.desc; - <para> - ç¾å¨ã®ãªãã¸ã§ã¯ãã®ã«ã©ã åãæä¾ããããªãã¸ã§ã¯ããããã¯é åã«åºã¥ãã - åå¾ã¢ã¤ãã ãèªåçæãã¾ãã - </para> - <para> - ããã¯ãã«ã©ã åã®è¡çªãèµ·ããã¦ããæ - (両æ¹ã®è¡¨ã« 'id' ã«ã©ã ãåå¨ãããªã©) ã主ã«åºå®ãã©ã¼ãããã§ã«ã©ã ã®æ¹åãå¯è½ã«ããããã® joinAdd ãç¨ããçµåã§ä½¿ç¨ããã¾ãã - </para> - <para> - selectAs ã«ãã©ã¡ã¼ã¿ã渡ããªãå ´åãç¾å¨ã® SELECT - (é常ããã©ã«ãã® *) ããªã»ããããç¾å¨ã®ãªãã¸ã§ã¯ãã®ã«ã©ã åã«åºã¥ãã - åå¾ãªã¹ããæ§ç¯ãã¾ãã - </para> - - </refsect1> - - <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.parameter"> - &title.param; - <para> - <itemizedlist> - - <listitem> - <para> - <parameter>object | array $column_or_object</parameter> - - ãã¼ã¿ãªãã¸ã§ã¯ããããã¯ã«ã©ã åã®é åãæå®ãã¾ã - </para> - </listitem> - - <listitem> - <para> - <parameter>string $format</parameter> - - ã«ã©ã ãç¾ããã¨ãã«ä½¿ç¨ãããã©ã¼ãããã§ãsprintf - ãã©ã¼ããããæå®ãã¾ãã - %s ã¯ã«ã©ã åã«ç½®æããã¾ãã®ã§ãcar_%s 㯠SQL ä¸ã§ - 'car.name as car_name' ãçæããããã¨ãªãã¾ãã - </para> - </listitem> - - <listitem> - <para> - <parameter>string $tableName</parameter> - - ããã¯1çªç®ã®å¼æ°ã¨ãã¦é åãæå®ãããã - ãããã¯ãã¼ãã«ãä»ã®ååã§çµåãã¦ããå ´åã«ä½¿ç¨ããã¾ãã - </para> - </listitem> - - </itemizedlist> - </para> - </refsect1> - - - - - <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.note"> - &title.note; - - ¬e.notstatic; - - - - <simpara></simpara> - </refsect1> - - - <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.example"> - &title.example; - <example> - <title><function>selectAs</function> ã®ä½¿ç¨</title> - <programlisting role="php"> - <![CDATA[ -<?php -// ok lets see what is going on.. -DB_DataObject::debugLevel(1); - -$person = new DataObjects_Person; - - -// to generate "person.id as id , person.name as name ......." -$person->selectAs(); - -// to generate a restricted list.. "person.age as age , person.name as name" -$person->selectAs(array('age','name')); - -// using another object. -$car = new DataObjects_Car; - -// this is the first car ( -$car->use = 'first'; - - -// using the joinadd add the car.. -$person->joinAdd($car); - -// now add all the select columsn for the car eg. "car.id as car_id, car.name as car_name ...." -$person->selectAs($car, 'car_%s'); - - -// select only a few columns from the car table. -// note you have to use the table name at the end.. -$person->selectAs(array('color','topspeed'), 'car_%s','car'); - - - - -// now the user can have a second car.... -$secondcar = new DataObjects_Car; -$secondcar->use = 'second'; - -// now since we alreay have one car, the sql statement would get messy -// so we are joining this as the second car "FROM person INNER JOIN car ..... , car as secondcar WHERE ..... -$person->joinAdd($secondcar,'','secondcar'); - -// and we can now add all the columns -// "secondcar.id as secondcar_id, secondcar.name as secondcar_name ........ -// note that you must use the last field as the SECONDCAR.ID format uses the 'AS' name, rather than the -// objects real table name 'car' -$person->selectAs($secondcar, 'secondcar_%s','secondcar'); - - - -// ok fire of a query... -$person->find(); -while ($person->fetch()) { - ...... -} - - -?> -]]> - </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 ---> +<?xml version="1.0" encoding="utf-8" ?> +<!-- $Revision: 1.2 $ --> +<!-- EN-Revision: 1.3 Maintainer: shimooka Status: ready --> +<refentry id="package.database.db-dataobject.db-dataobject.selectas"> + <refnamediv> + <refname>->selectAs()</refname> + <refpurpose>ã¯ã¨ãªã®åå¾ ã³ã³ãã¼ãã³ããæ§ç¯ãã (é常ã¯çµåã®ãã)</refpurpose> + </refnamediv> + <refsynopsisdiv> + <funcsynopsis> + + <funcprototype> + <funcdef>void <function>$DB_DataObject->selectAs</function></funcdef> + + + <paramdef> object | array <parameter><optional>$columns_or_object</optional></parameter></paramdef> + <paramdef> string <parameter><optional>$format</optional></parameter></paramdef> + <paramdef> string <parameter><optional>$table_name</optional></parameter></paramdef> + + + </funcprototype> + </funcsynopsis> + </refsynopsisdiv> + <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.desc"> + &title.desc; + <para> + ç¾å¨ã®ãªãã¸ã§ã¯ãã®ã«ã©ã åãæä¾ããããªãã¸ã§ã¯ããããã¯é åã«åºã¥ãã + åå¾ã¢ã¤ãã ãèªåçæãã¾ãã + </para> + <para> + ããã¯ãã«ã©ã åã®è¡çªãèµ·ããã¦ããæ + (両æ¹ã®è¡¨ã« 'id' ã«ã©ã ãåå¨ãããªã©) ã主ã«åºå®ãã©ã¼ãããã§ã«ã©ã ã®æ¹åãå¯è½ã«ããããã® joinAdd ãç¨ããçµåã§ä½¿ç¨ããã¾ãã + </para> + <para> + selectAs ã«ãã©ã¡ã¼ã¿ã渡ããªãå ´åãç¾å¨ã® SELECT + (é常ããã©ã«ãã® *) ããªã»ããããç¾å¨ã®ãªãã¸ã§ã¯ãã®ã«ã©ã åã«åºã¥ãã + åå¾ãªã¹ããæ§ç¯ãã¾ãã + </para> + + </refsect1> + + <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.parameter"> + &title.param; + <para> + <itemizedlist> + + <listitem> + <para> + <parameter>object | array $column_or_object</parameter> - + ãã¼ã¿ãªãã¸ã§ã¯ããããã¯ã«ã©ã åã®é åãæå®ãã¾ã + </para> + </listitem> + + <listitem> + <para> + <parameter>string $format</parameter> - + ã«ã©ã ãç¾ããã¨ãã«ä½¿ç¨ãããã©ã¼ãããã§ãsprintf + ãã©ã¼ããããæå®ãã¾ãã + %s ã¯ã«ã©ã åã«ç½®æããã¾ãã®ã§ãcar_%s 㯠SQL ä¸ã§ + 'car.name as car_name' ãçæããããã¨ãªãã¾ãã + </para> + </listitem> + + <listitem> + <para> + <parameter>string $tableName</parameter> - + ããã¯1çªç®ã®å¼æ°ã¨ãã¦é åãæå®ãããã + ãããã¯ãã¼ãã«ãä»ã®ååã§çµåãã¦ããå ´åã«ä½¿ç¨ããã¾ãã + </para> + </listitem> + + </itemizedlist> + </para> + </refsect1> + + + + + <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.note"> + &title.note; + + ¬e.notstatic; + + + + <simpara></simpara> + </refsect1> + + + <refsect1 id="package.database.db-dataobject.db-dataobject.selectas.example"> + &title.example; + <example> + <title><function>selectAs</function> ã®ä½¿ç¨</title> + <programlisting role="php"> + <![CDATA[ +<?php +// ok lets see what is going on.. +DB_DataObject::debugLevel(1); + +$person = new DataObjects_Person; + + +// to generate "person.id as id , person.name as name ......." +$person->selectAs(); + +// to generate a restricted list.. "person.age as age , person.name as name" +$person->selectAs(array('age','name')); + +// using another object. +$car = new DataObjects_Car; + +// this is the first car ( +$car->use = 'first'; + + +// using the joinadd add the car.. +$person->joinAdd($car); + +// now add all the select columsn for the car eg. "car.id as car_id, car.name as car_name ...." +$person->selectAs($car, 'car_%s'); + + +// select only a few columns from the car table. +// note you have to use the table name at the end.. +$person->selectAs(array('color','topspeed'), 'car_%s','car'); + + + + +// now the user can have a second car.... +$secondcar = new DataObjects_Car; +$secondcar->use = 'second'; + +// now since we alreay have one car, the sql statement would get messy +// so we are joining this as the second car "FROM person INNER JOIN car ..... , car as secondcar WHERE ..... +$person->joinAdd($secondcar,'','secondcar'); + +// and we can now add all the columns +// "secondcar.id as secondcar_id, secondcar.name as secondcar_name ........ +// note that you must use the last field as the SECONDCAR.ID format uses the 'AS' name, rather than the +// objects real table name 'car' +$person->selectAs($secondcar, 'secondcar_%s','secondcar'); + + + +// ok fire of a query... +$person->find(); +while ($person->fetch()) { + ...... +} + + +?> +]]> + </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 +--> http://cvs.php.net/diff.php/peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml?r1=1.1&r2=1.2&ty=u Index: peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml diff -u peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml:1.1 peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml:1.2 --- peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml:1.1 Fri Apr 1 18:47:47 2005 +++ peardoc/ja/package/database/db-dataobject/db-dataobject/count.xml Thu Jul 7 06:24:50 2005 @@ -1,116 +1,161 @@ -<?xml version="1.0" encoding="utf-8" ?> -<!-- $Revision: 1.1 $ --> -<!-- EN-Revision: 1.5 Maintainer: shimooka Status: ready --> -<refentry id="package.database.db-dataobject.db-dataobject.count"> - <refnamediv> - <refname>->count()</refname> - <refpurpose>select count() ãªã¯ã¨ã¹ããå®è¡ãã</refpurpose> - </refnamediv> - <refsynopsisdiv> - <funcsynopsis> - - <funcprototype> - <funcdef>int <function>$DB_DataObject->count</function></funcdef> - - - <paramdef></paramdef> - - </funcprototype> - </funcsynopsis> - </refsynopsisdiv> - <refsect1 id="package.database.db-dataobject.db-dataobject.count.desc"> - &title.desc; - <para> - ããã¯ã表ã®ãã¼ã«ã©ã ã«ãã select count() ãªã¯ã¨ã¹ããå®è¡ãã - çµæã®è¡æ°ãè¿ãã¾ãã - count() ã«é©ç¨ãããããã©ã«ãã®æ¡ä»¶ã¯ããªãã¸ã§ã¯ã夿°ã¨ whereAdd - ã®è¨å®å 容ã®çµã¿åããã§ãã - ããã宿° DB_DATAOBJECT_WHEREADD_ONLY ã第1ãã©ã¡ã¼ã¿ã«æå®ãããå ´åã - whereAdd ã®è¨å®å 容ã ãã使ç¨ããã¾ãã - - - </para> - </refsect1> - - <refsect1 id="package.database.db-dataobject.db-dataobject.count.parameter"> - &title.param; - <para> - <itemizedlist> - - <listitem> - <para> - <parameter>boolean $useWhereAddOnly</parameter> - - whereAdd æ¡ä»¶ã®ã¿ä½¿ç¨ãããã©ãããæå®ãã¾ã - (ããã©ã«ãã§ã¯ãcount ãªãã¸ã§ã¯ãã®è¨å®å 容㨠- whereAdd ã®æ¡ä»¶ã®ä¸¡æ¹ã使ç¨ããã¾ã) ã - </para> - </listitem> - - </itemizedlist> - </para> - </refsect1> - - - <refsect1 id="package.database.db-dataobject.db-dataobject.count.return"> - &title.returns; - <para> - <parameter>int</parameter> - çµæã®æ° - </para> - </refsect1> - - - - <refsect1 id="package.database.db-dataobject.db-dataobject.count.note"> - &title.note; - - ¬e.notstatic; - - - - <simpara></simpara> - </refsect1> - - <refsect1 id="package.database.db-dataobject.db-dataobject.count.example"> - &title.example; - <example> - <title>ãªãã¸ã§ã¯ã夿°ã«åºã¥ãããã¼ã¿ã®ç°¡åãªæ¤ç´¢ã¨ãã§ãã</title> - <programlisting role="php"> - <![CDATA[ -$person = new DataObjects_Person; - -$person->whereAdd('name like '%test%'); -$total = $person->count(); - -echo "There are {$total} people with a name like test"; -]]> - </programlisting> - </example> - <example> - <title>çµæã® SQL </title> - <programlisting> - <![CDATA[ -SELECT count(id) FROM person WHERE name like '%test%' -]]> - </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 ---> +<?xml version="1.0" encoding="utf-8" ?> +<!-- $Revision: 1.2 $ --> +<!-- EN-Revision: 1.8 Maintainer: shimooka Status: ready --> +<refentry id="package.database.db-dataobject.db-dataobject.count"> + <refnamediv> + <refname>->count()</refname> + <refpurpose>select count() ãªã¯ã¨ã¹ããå®è¡ãã</refpurpose> + </refnamediv> + <refsynopsisdiv> + <funcsynopsis> + + <funcprototype> + <funcdef>int <function>$DB_DataObject->count</function></funcdef> + <paramdef>string|boolean <parameter><optional>$countWhat|$whereAddOnly</optional></parameter></paramdef> + <paramdef>boolean <parameter><optional>$whereAddOnly</optional></parameter></paramdef> + + </funcprototype> + </funcsynopsis> + </refsynopsisdiv> + <refsect1 id="package.database.db-dataobject.db-dataobject.count.desc"> + &title.desc; + <para> + ããã¯ã表ã®ãã¼ã«ã©ã ã«ãã select count() ãªã¯ã¨ã¹ããå®è¡ãã + çµæã®è¡æ°ãè¿ãã¾ãã + count() ã«é©ç¨ãããããã©ã«ãã®æ¡ä»¶ã¯ããªãã¸ã§ã¯ã夿°ã¨ whereAdd + ã®è¨å®å 容ã®çµã¿åããã§ãã + ããã宿° DB_DATAOBJECT_WHEREADD_ONLY ã第1ãã©ã¡ã¼ã¿ã«æå®ãããå ´åã + whereAdd ã®è¨å®å 容ã ãã使ç¨ããã¾ãã + + + </para> + </refsect1> + + <refsect1 id="package.database.db-dataobject.db-dataobject.count.parameter"> + &title.param; + <para> + <itemizedlist> + + <listitem> + <para> + <parameter>string $countWhat</parameter> - + ããã©ã«ãã«ã¦ã³ãã¯ã主ãã¼ãã«ã¦ã³ããã¾ãã + ããä½ãä»ãã«ã¦ã³ãããå¿ è¦ãããå ´åã§ãåç´ã« DISTINCT + ãæå®ããå ´å㯠DISTINCT ãåã«ä»ãã主ãã¼ãã«ã¦ã³ããã¾ãã + ãã®ä»ã®å ´åã¯ç¬èªã®å¤ãã«ã¦ã³ããã¾ã + (ã¨ã¹ã±ã¼ããå¿ è¦ãªå ´åãå¿ããªãããã«ãã¦ãã ãã) ã + + </para> + </listitem> + <listitem> + <para> + <parameter>boolean $useWhereAddOnly</parameter> - + whereAdd æ¡ä»¶ã®ã¿ä½¿ç¨ãããã©ãããæå®ãã¾ã + (ããã©ã«ãã§ã¯ãcount ãªãã¸ã§ã¯ãã®è¨å®å 容㨠+ whereAdd ã®æ¡ä»¶ã®ä¸¡æ¹ã使ç¨ããã¾ã) ã + </para> + </listitem> + + </itemizedlist> + </para> + </refsect1> + + + <refsect1 id="package.database.db-dataobject.db-dataobject.count.return"> + &title.returns; + <para> + <parameter>int|false</parameter> - çµæã®æ°ãããã¯å¤±ææã« false + </para> + </refsect1> + + + + <refsect1 id="package.database.db-dataobject.db-dataobject.count.note"> + &title.note; + + ¬e.notstatic; + + + + <simpara></simpara> + </refsect1> + + <refsect1 id="package.database.db-dataobject.db-dataobject.count.example"> + &title.example; + <example> + <title>ãªãã¸ã§ã¯ã夿°ã«åºã¥ãããã¼ã¿ã®ç°¡åãªæ¤ç´¢ã¨ãã§ãã</title> + <programlisting role="php"> + <![CDATA[ +<?php + +/* using property values */ +$person = new DataObjects_Person; +$person->name = "test" +$total = $person->count(); +echo "There are {$total} people with a name like test"; + +/* using countWhat */ +$person = new DataObjects_Person; +$total = $person->count('DISTINCT name'); +echo "There are {$total} names in the database"; + +/* using countWhat value = DISTINCT */ +$person = new DataObjects_Person; +$total = $person->count('DISTINCT'); +echo "There are {$total} names in the database"; + +/* using whereOnly */ +$person = new DataObjects_Person; +$person->name = "test"; +$person->whereAdd("name like '%test%"); +$total = $person->count(DB_DATAOBJECT_WHEREADD_ONLY); +echo "There are {$total} names in the database"; + +?> +]]> + </programlisting> + </example> + <example> + <title>çµæã® SQL </title> + <programlisting> + <![CDATA[ +SELECT count(person.id) AS DATAOBJECT_NUM + FROM person + WHERE person.name = 'test'; + +SELECT count(DISTINCT name) AS DATAOBJECT_NUM + FROM person; + +SELECT count(DISTINCT person.id) AS DATAOBJECT_NUM + FROM person; + +SELECT count(person.id) AS DATAOBJECT_NUM + FROM person + WHERE name like '%test%'; + + + +]]> + </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 +--> http://cvs.php.net/co.php/peardoc/ja/package/database/db-dataobject/db-dataobject/free.xml?r=1.1&p=1 Index: peardoc/ja/package/database/db-dataobject/db-dataobject/free.xml +++ peardoc/ja/package/database/db-dataobject/db-dataobject/free.xml <?xml version="1.0" encoding="utf-8"?> <!-- $Revision: 1.1 $ --> <!-- EN-Revision: 1.1 Maintainer: shimooka Status: ready --> <refentry id="package.database.db-dataobject.db-dataobject.free"> <refnamediv> <refname>->free()</refname> <refpurpose>ãªã½ã¼ã¹ãè§£æ¾ãã</refpurpose> </refnamediv> <refsynopsisdiv> <funcsynopsis> <funcprototype> <funcdef>object <function>$DB_DataObject->free</function></funcdef> <paramdef></paramdef> </funcprototype> </funcsynopsis> </refsynopsisdiv> <refsect1 id="package.database.db-dataobject.db-dataobject.free.desc"> &title.desc; <para> DataObject ã¯ãã©ã¤ãã¼ããªã°ãã¼ãã«å¤æ°ã¨ãã¦çµæã»ãããä¿æãã¦ãã¾ãã é常ããã¯çµæãå¦çããå¾ããããã¯ãªã¯ã¨ã¹ãã®çµäºæã«è§£æ¾ããã¾ãã ããããã¯ã¨ãªãç´æ¥å®è¡ãã¦ããããã¼ã¿ãæ¿å ¥ãã¦ãããªã©ã® ããã¤ãã®ç¶æ³ã§ã¯ãã¼ã¿ããã£ãã·ã¥ããå¿ è¦ãããã¾ããã </para> <para> ãã®ã¡ã½ããã使ç¨ãããã¨ã§ãå ¨ã¦ã®çµæã»ãããè§£æ¾ãããã¨ãã§ãã¾ã (注æãã¦ãã ãã) ! ãã®ã¡ã½ããã¯ãå®è¡ä¸ã® fetch() ã«ã¼ãã忢ããã¾ãã </para> <para> é常ã大éã®æ¿å ¥ãã¯ã¨ãªãå®è¡ãã¦ããå ´åã®ã¿ã ãã®ã¡ã½ããã使ç¨ããå¿ è¦ãããã¾ãã </para> </refsect1> <refsect1 id="package.database.db-dataobject.db-dataobject.free.note"> &title.note; ¬e.notstatic; </refsect1> <refsect1 id="package.database.db-dataobject.db-dataobject.free.example"> &title.example; <example> <title>ã«ã¼ãå ã§ãªã½ã¼ã¹ãè§£æ¾ãã</title> <programlisting role="php"><![CDATA[ <?php for ($i = 0; i< 10000; $i++) { $person = new DataObjects_Person; $person->query(' ... do something ... '); $person->free(); } ?> ]]> </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 -->