cvs: phpdoc-ru /faq databases.xml obtaining.xml
| From: | George Miroshnikov | Date: | Sat, 05 Feb 2005 17:31:13 +0000 |
| Subject: | cvs: phpdoc-ru /faq databases.xml obtaining.xml | ||
| Groups: | php.doc.ru | ||
| Request: | Send a blank email to doc-ru+get-587@lists.php.net to get a copy of this message | ||
freespace Sat Feb 5 12:31:13 2005 EDT
Added files:
/phpdoc-ru/faq databases.xml obtaining.xml
Log:
add new translations by Irina Goble
http://cvs.php.net/co.php/phpdoc-ru/faq/databases.xml?r=1.1&p=1 Index: phpdoc-ru/faq/databases.xml +++ phpdoc-ru/faq/databases.xml <?xml version="1.0" encoding="windows-1251"?> <!-- EN-Revision: 1.27 Maintainer: irinagoble Status: ready --> <!-- $Revision: 1.1 $ --> <chapter id="faq.databases"> <title>Âîïðîñû ïî Áàçàì Äàííûõ</title> <titleabbrev>Âîïðîñû ïî Áàçàì Äàííûõ</titleabbrev> <para> Ýòîò ðàçäåë ñîäåðæèò îáùèå âîïðîñû î ñâÿçè ìåæäó PHP è áàçàìè äàííûõ. Äà, ñåãîäíÿ ïðàêòè÷åñêè ëþáàÿ áàçà äàííûõ ìîæåò áûòü äîñòóïíà èç PHP. </para> <qandaset> <qandaentry id="faq.databases.mssql"> <question> <para> ß ñëûøàë, ÷òî ìîæíî ïîëó÷èòü äîñòóï ê Microsoft SQL ñåðâåðó èç PHP. Êàê? </para> </question> <answer> <para> Íà Windows ìàøèíàõ, âû ïðîñòî èñïîëüçóåòå ïîääåðæêó ODBC è ñîîòâåòñâóþùèé ODBC äðàéâåð. </para> <para> Íà Unix ìàøèíàõ äëÿ äîñòóïà ê Microsoft SQL ñåðâåðàì âû ìîæåòå èñïîëüçîâàòü Sybase-CT äðàéâåð, òàê êàê îíè (ïî êðàéíåé ìåðå â îñíîâíîì) ñîâìåñòèìû ïî ïðîòîêîëó. Ó Sybase åñòü <ulink url="&url.sybase.ctlib;">áåñïëàòíàÿ âåðñèÿ íåîáõîäèìûõ áèáëèîòåê äëÿ Linux</ulink>. Äëÿ äðóãèõ Unix ñèñòåì âàì íåîáõîäèìî îáðàòèòüñÿ â Sybase çà ñîîòâåòñòâóþùèìè áèáëèîòåêàìè. Òàêæå ñìîòðèòå îòâåò íà ñëåäóþùèé âîïðîñ. </para> </answer> </qandaentry> <qandaentry id="faq.databases.access"> <question> <para>Ìîãó ëè ÿ ïîëó÷èòü äîñòóï ê áàçàì äàííûõ Microsoft Access?</para> </question> <answer> <para> Äà. Åñëè âñ¸ ïîëíîñòüþ âûïîëíÿåòñÿ ïîä Windows 9x/Me èëè NT/2000, òî ó âàñ óæå åñòü âñå íåîáõîäèìûå ñðåäñòâà, òàê êàê äëÿ áàç äàííûõ Microsoft Access âû ìîæåòå èñïîëüçîâàòü ODBC è äðàéâåðû ODBC îò Microsoft. </para> <para> Åñëè âû õîòèòå ñâÿçàòü PHP, âûïîëíÿþùèéñÿ íà Unix, è MS Access íà Windows, òî âàì áóäóò íóæíû äðàéâåðû ODBC äëÿ Unix. Òàêèå ODBC äðàéâåðû äëÿ Unix åñòü ó <ulink url="&url.openlink;">OpenLink Software</ulink>. Ïî áåñïëàòíîé ïèëîòíîé ïðîãðàììå âû ìîæåòå ñêà÷àòü ïðîáíóþ êîïèþ áåç ñðîêà èñòå÷åíèÿ, à öåíû íà êîìåð÷åñêè ïîääåðæèâàåìóþ âåðñèþ íà÷èíàþòñÿ îò 675$. </para> <para> Äðóãàÿ âîçìîæíîñòü - õðàíèòü äàííûå íà SQL ñåðâåðå, êîòîðûé èìååò ODBC äðàéâåðû äëÿ Windows, è çàòåì îáðàùàòüñÿ ê ýòîé áàçå äàííûõ èç Microsoft Access (èñïîëüçóÿ ODBC) è èç PHP (èñïîëüçóÿ âñòðîåííûå äðàéâåðû) èëè èñïîëüçîâàòü ïðîìåæóòî÷íûé ôîðìàò ïîíÿòíûé è äëÿ Access, è äëÿ PHP, êàê òî ïîñëåäîâàòåëüíûå ôàéëû èëè áàçû äàííûõ dBase. Ïî ýòîìó ïîâîäó Òèì Õýéç (Tim Hayes) èç OpenLink software ïèøåò: <blockquote> <para> Èñïîëüçîâàíèå ïðîìåæóòî÷íîé áàçû äàííûõ - íå î÷åíü õîðîøàÿ èäåÿ, êîãäà åñòü âîçìîæíîñòü ðàáîòàòü ñ áàçîé äàííûõ íà ïðÿìóþ èç PHP ÷åðåç ODBC, íàïðèìåð ñ äðàéâåðàìè îò OpenLink. Åñëè âàì âñ¸-òàêè íàäî èñïîëüçîâàòü ïðîìåæóòî÷íûé ôîðìàò, OpenLink âûïóñòèë Virtuoso (ìåõàíèçì âèðòóàëüíîé áàçû äàííûõ) äëÿ NT, Linux è äðóãèõ ïëàòôîðì Unix. Ïîæàëóéñòà, ïîñåòèòå íàø <ulink url="&url.openlink;">web ñàéò</ulink> äëÿ áåñïëàòíîé çàãðóçêè. </para> </blockquote> </para> <para> Äðóãîé ïðîâåðåííûé âàðèàíò - èñïîëüçîâàòü MySQL ñ å¸ MyODBC äðàéâåðàìè íà Windows è äåëàòü ñèíõðîíèçàöèþ áàç äàííûõ. Ñòèâ Ëîðåíñ (Steve Lawrence) ïèøåò: </para> <para> <itemizedlist> <listitem> <simpara> Óñòàíîâèòå MySQL ñîãëàñíî ïîñòàâëÿåìûì ñ íåé èíñòðóêöèÿì. Ïîñëåäíÿÿ âåðñèÿ äîñòóïíà ñ <ulink url="&url.mysql;">www.mysql.com</ulink> (ïîëó÷èòå å¸ ñ áëèæàéøåãî çåðêàëà!). Îñîáîé êîíôèãóðàöèè íå òðåáóåòñÿ, çà èñêëþ÷åíèåì òîãî, ÷òî ïðè íàñòðîéêå áàç äàííûõ è ñîçäàíèè ïîëüçîâàòåëÿ, â ïîëå õîñòà âû äîëæíû ïîìåñòèòü % èëè èìÿ Windows ìàøèíû, íà êîòîðóþ âû õîòèòå ïîëó÷èòü äîñòóï èç MySQL. Çàïèøèòå èìÿ âàøåãî ñåðâåðà, èìÿ ïîëüçîâàòåëÿ è ïàðîëü. </simpara> </listitem> <listitem> <simpara> Ñêà÷àéòå MyODBC äðàéâåð äëÿ Windows ñ ñàéòà MySQL. Ïîñëåäíèé ðåëèç - myodbc-2_50_19-win95.zip (äîñòóïåí òàêæå äëÿ NT è êàê èñõîäíûé êîä). Óñòàíîâèòå åãî íà âàøåé Windows ìàøèíå. Âû ìîæåòå ïðîâåðèòü åãî ðàáîòîñïîñîáíîñòü ñ ïîìîùüþ ïîñòàâëÿåìûõ ñ íèì óòèëèò. </simpara> </listitem> <listitem> <simpara> Ñîçäàéòå ïîëüçîâàòåëÿ èëè ñèñòåìíûé dsn â âàøåì àäìèíèñòðàòîðå ODBC, ðàñïîëîæåííîì â êîíòðîëüíîé ïàíåëè. Ñîçäàéòå dsn èìÿ, ââåäèòå èìÿ õîñòà, èìÿ ïîëüçîâàòåëÿ, ïàðîëü è ò.ä. äëÿ âàøåé áàçû äàííûõ MySQL, ñêîíôèãóðèðîâàííîé íà 1-îì øàãå. </simpara> </listitem> <listitem> <simpara> Çàïóñòèòå ïîëíóþ èíñòàëÿöèþ Access, ýòî äàñò âàì óâåðåííîñòü, ÷òî âû ïîëó÷èòå âñå íóæíûå äîáàâêè (add-ins). Ïî êðàéíåé ìåðå âàì áóäóò íåîáõîäèìû ïîääåðæêà ODBC è àäìèíèñòðàòîð ñâÿçàííûõ òàáëèö. </simpara> </listitem> <listitem> <simpara> È òåïåðü ñàìîå èíòåðåñíîå! Ñîçäàéòå íîâóþ áàçó äàííûõ Access.  îêíå òàáëèöû ù¸ëêíèòå ïðàâîé êíîïêîé ìûøêè è âûáåðèòå Link Tables (Ñâÿçàòü Òàáëèöû), ëèáî èç ôàéëîâîãî ìåíþ âûáåðèòå Get External Data (Ïîëó÷èòü Âíåøíèå Äàííûå) è çàòåì Link Tables.  ïîÿâèâøåìñÿ îêíå ïðîñìîòðà ôàéëîâ âûáåðèòå ôàéëû òèïà ODBC. Âûáåðèòå ñèñòåìíûé dsn è èìÿ âàøåãî dsn, ñîçäàííîãî íà 3-åì øàãå. Âûáåðèòå òàáëèöó äëÿ ñâÿçè, íàæìèòå OK è âóàëÿ! Òåïåðü âû ìîæåòå îòêðûòü òàáëèöó è äîáàâèòü/óäàëèòü/îòðåäàêòèðîâàòü äàííûå íà âàøåì MySQL ñåðâåðå! Âû òàêæå ìîæåòå ñòðîèòü çàïðîñû, èìïîðòèðîâàòü/ýêñïîðòèðîâàòü òàáëèöû â MySQL, ñîçäàâàòü ôîðìû è îò÷¸òû, è ò.ä. </simpara> </listitem> </itemizedlist> </para> <para> Ïîëåçíûå Ñîâåòû è Òðþêè: <itemizedlist> <listitem> <simpara> Âû ìîæåòå ïîñòðîèòü âàøè òàáëèöû â Access, ýêñïîðòèðîâàòü èõ â MySQL è çàòåì ïðèâÿçàòü èõ íàçàä. Ýòî óáûñòðÿåò ñîçäàíèå òàáëèö. </simpara> </listitem> <listitem> <simpara> Ïðè ñîçäàíèè òàáëèö â Access, âû äîëæíû îïðåäåëèòü ïåðâè÷íûé êëþ÷, ÷òîáû èìåòü äîñòóï ê òàáëèöå ïî çàïèñè. Óáåäèòåñü ÷òî âû ñîçäàëè ïåðâè÷íûé êëþ÷ â MySQL ïåðåä òåì êàê ïðèâÿçàòü òàáëèöó ê Access. </simpara> </listitem> <listitem> <simpara> Åñëè âû èçìåíÿåòå òàáëèöó â MySQL, òî âû äîëæíû ñâÿçàòü å¸ ñ Access ïî-íîâîé. Èäèòå â tools>add-ins>linked table manager, ñëåäóéòå ê âàøåìó ODBC DSN, è âûáåðèòå îòòóäà òàáëèöó äëÿ ïåðåñâÿçêè. Òàì æå âû ìîæåòå èçìåíèòü èñòî÷íèê âàøåãî dsn, äëÿ ýòîãî, ïåðåä òåì êàê íàæàòü OK, ïðîñòî ïîìåòüòå "always prompt for new location" (âñåãäà çàïðàøèâàòü íîâîå ìåñòîíàõîæäåíèå). </simpara> </listitem> </itemizedlist> </para> </answer> </qandaentry> <qandaentry id="faq.databases.upgraded"> <question> <para> ß îáíîâèëñÿ äî PHP 4 è òåïåðü mysql ïîñòîÿííî âûäàåò "Warning: MySQL: Unable to save result set in ..." (Ïðåäóïðåæäåíèå: MySQL: Íå ìîãó ñîõðàíèòü ðåçóëüòàò â ...). ×òî ýòî? </para> </question> <answer> <para> Âåðîÿòíåå âñåãî PHP 4 áûë ñêîìïèëèðîâàí ñ îïöèåé <option role="configure">--with-mysql</option> áåç çàäàíèÿ ïóòè ê MySQL. Ýòî îçíà÷àåò, ÷òî PHP èñïîëüçóåò åãî âñòðîåííóþ êëèåíòñêóþ áèáëèîòåêó MySQL. Åñëè íà âàøåé ñèñòåìå âûïîëíÿþòñÿ ïðèëîæåíèÿ (òàêèå êàê PHP 3, â âèäå ïàðàëåëüíîãî ìîäóëÿ Apache, èëè auth-mysql), êîòîðûå èñïîëüçóþò äðóãèå âåðñèè MySQL êëèåíòîâ, òî âîçíèêàåò êîíôëèêò ìåæäó äâóìÿ ðàçíûìè âåðñèÿìè ýòèõ êëèåíòîâ. </para> <para> Îáû÷íî, ïåðåêîìïèëÿöèÿ PHP 4 ñ óêàçàíèåì ïóòè ê MySQL â îïöèè '<link linkend="mysql.configure">--with-mysql=/your/path/to/mysql</link>' ðåøàåò ýòó ïðîáëåìó. </para> </answer> </qandaentry> <qandaentry id="faq.databases.mysql.php5"> <question> <para> Êëèåíòñêèå áèáëèîòåêè MySQL áîëüøå íå âêëþ÷åíû â PHP 5, êàê ýòî îòðàçèòñÿ íà ìíå? Ìîãó ëè ÿ âñ¸ òàê æå èñïîëüçîâàòü MySQL c PHP? ß ïûòàþñü ðàáîòàòü ñ MySQL è ïîëó÷àþ îøèáêè "function undefined" (ôóíêöèÿ íåîïðåäåëåíà), ÷òî âûäà¸ò èõ? </para> </question> <answer> <para> Äà. PHP âñåãäà áóäåò ïîääåðæèâàòü MySQL â òîì èëè èíîì âèäå. Åäèíñòâåííîå ÷òî èçìåíèëîñü â PHP 5 - ýòî òî, ÷òî ìû áîëüøå íå ïîñòàâëÿåì ñàìó êëèåíòñêóþ áèáëèîòåêó. Âîò íåêîòîðûå ïðè÷èíû äëÿ ýòîãî: </para> <itemizedlist> <listitem> <para> Ñåãîäíÿ êëèåíòñêèå áèáëèîòåêè óæå óñòàíîâëåíû íà áîëüøèíñòâå ñèñòåì. </para> </listitem> <listitem> <para> Ó÷èòûâàÿ ïðåäûäóùèé ïóíêò, èìåÿ íåñêîëüêî âåðñèé, ïðîùå çàïóòàòüñÿ. Íàïðèìåð, åñëè âû êîìïîíóåòå mod_auth_mysql ñ îäíîé âåðñèåé, à PHP ñ äðóãîé, è çàòåì ðàçðåøàåòå îáà â Apache, òî âû ïîëó÷èòå õîðîøèé æèðíûé êðàõ. Òàêæå, ïîñòàâëÿåìûå áèáëèîòåêè íå âñåãäà äðóæàò ñ óñòàíîâëåííîé ñåðâåðíîé âåðñèåé. Íàèáîëåå î÷åâèäíûé ñèìïòîì ýòîãî - ðàçíîãëàñèå ïî òîìó ãäå èñêàòü ôàéë mysql.socket (ôàéë Unix ñîêåòà). </para> </listitem> <listitem> <para> Òàêæå ïîääåðæêà áûëà âÿëîé è îòñòàâàëà îò ðåëèçîâ âñ¸ áîëüøå è áîëüøå. </para> </listitem> <listitem> <para> Ïîñëåäóþùèå âåðñèè áèáëèîòåêè áóäóò ïîä GPL è ìû íå ìîæåì ïîñòàâëÿòü áèáëèîòåêó ïîä GPL ñ ïðîåêòîì ëèöåíçèðóåìûì ïî òèïó BSD/Apache. Ïîýòîìó ïîëíûé ðàçðûâ â PHP 5 âèäèòñÿ êàê ñàìûé ëó÷øèé âàðèàíò. </para> </listitem> </itemizedlist> <para> Íà ñàìîì äåëå ýòî çàäåíåò íå òàê óæ ìíîãî ëþäåé. Ïîëüçîâàòåëè Unix, ïî êðàéíåé ìåðå òå, êòî çíàåò ÷òî îíè äåëàþò, âñåãäà áûëè ñêëîííû ñîáèðàòü PHP ñ óæå óñòàíîâëåííîé íà èõ ñèñòåìå áèáëèîòåêîé libmesqlclient, ïðîñòî çàäàâ îïöèþ <option role="configure">--with-mysql=/usr</option> ïðè ñáîðêå. Ïîëüçîâàòåëè Windows ìîãóò âêëþ÷èòü ðàñøèðåíèå <filename>php_mysql.dll</filename> âíóòðè &php.ini;. Òàêæå óáåäèòåñü, ÷òî <filename>libmysql.dll</filename> äîñòóïåí â ñèñòåìíîì PATH. Î òîì êàê - ÷èòàéòå FAQ: <link linkend="faq.installation.addtopath"> óñòàíîâêà ñèñòåìíîãî PATH â Windows</link>. Òàê êàê <filename>libmysql.dll</filename> (è ìíîãèå äðóãèå PHP ôàéëû) íàõîäèòñÿ â ïàïêå PHP, âàì ëó÷øå äîáàâèòü PHP ïàïêó â âàø ñèñòåìíûé PATH. </para> </answer> </qandaentry> <qandaentry id="faq.databases.shared-mysql"> <question> <para> Ïîñëå óñòàíîâêè ïîääåðæêè ðàçäåëåíèÿ â MySQL, Apache âûäà¸ò äàìïû ñðàçó ïîñëå çàãðóçêè libphp4.so. Ìîæíî ëè ýòî èñïðàâèòü? </para> </question> <answer> <para> Ýòî ïðîèñõîäèò åñëè âû ñêîìïîíîâàëè âàøè áèáëèîòåêè MySQL ñ pthreads. Ïðîâåðüòå èñïîëüçóÿ ldd. Åñëè ýòî òàê, ñêîìïèëèðóéòå MySQL èç èñõîäíèêîâ èëè ïåðåêîìïèëèðóéòå èñõîäíûé rpm, îòêëþ÷èâ ïîòî÷íûé êîä êëèåíòà â ôàéëå ñïåöèôèêàöèè. Ëþáîé èç ýòèõ âàðèàíòîâ èñïðàâèò ïðîáëåìó. Çàòåì ïåðåêîìïèëèðóéòå PHP ñ íîâûìè áèáëèîòåêàìè MySQL. </para> </answer> </qandaentry> <qandaentry id="faq.databases.mysqlresource"> <question> <para> Ïî÷åìó ÿ ïîëó÷àþ îøèáêè òèïà "Warning: 0 is not a MySQL result index in <file> on line <x>" èëè "Warning: Supplied argument is not a valid MySQL result resource in <file> on line <x>? </para> </question> <answer> <para> Âû ïûòàåòåñü èñïîëüçîâàòü èäåíòèôèêàòîð ðåçóëüòàòà, êîòîðûé ðàâåí 0. 0 îçíà÷àåò ÷òî âàø çàïðîñ íåóäàëñÿ ïî êàêîé-ëèáî ïðè÷èíå. Âàì íåîáõîäèìî ñäåëàòü ïðîâåðêó íà îøèáêè ïîñëå òîãî êàê âû ïîñëàëè âàø çàïðîñ è ïåðåä òåì êàê âû ïûòàåòåñü èñïîëüçîâàòü âîçâðàù¸ííûé èäåíòèôèêàòîð ðåçóëüòàòà. Ïðàâèëüíûé ñïîñîá äëÿ ýòîãî âûãëÿäèò ïðèìåðíî êàê ñëåäóþùèé êîä: <programlisting role="php"> <![CDATA[ <?php $result = mysql_query("SELECT * FROM tables_priv"); if (!$result) { echo mysql_error(); exit; } ?> ]]> </programlisting> èëè <programlisting role="php"> <![CDATA[ <?php $result = mysql_query("SELECT * FROM tables_priv") or die("Bad query: " . mysql_error()); ?> ]]> </programlisting> </para> </answer> </qandaentry> </qandaset> </chapter> <!-- 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-ru/faq/obtaining.xml?r=1.1&p=1 Index: phpdoc-ru/faq/obtaining.xml +++ phpdoc-ru/faq/obtaining.xml <?xml version="1.0" encoding="windows-1251"?> <!-- EN-Revision: 1.20 Maintainer: irinagoble Status: ready --> <!-- $Revision: 1.1 $ --> <chapter id="faq.obtaining"> <title>Ïîëó÷åíèå PHP</title> <titleabbrev>Ïîëó÷åíèå PHP</titleabbrev> <para> Ýòîò ðàçäåë ñîäåðæèò èíôîðìàöèþ î òîì ãäå ïîëó÷èòü PHP è âîïðîñû, êàñàþùèåñÿ OC. </para> <qandaset> <qandaentry id="faq.obtaining.where"> <question> <para>Ãäå ÿ ìîãó âçÿòü PHP?</para> </question> <answer> <para> Âû ìîæåòå ñêà÷àòü PHP ñ ëþáîãî ñàéòà èç PHP ñåòè. Ñàéòû ñåòè ìîæíî íàéòè íà <ulink url="&url.php;">&url.php;</ulink>. Âû òàêæå ìîæåòå âîñïîëüçîâàòüñÿ àíîíèìíûì CVS äëÿ ïîëó÷åíèÿ ñàìîé ïîñëåäíåé âåðñèè èñõîäíèêîâ. Äëÿ ïîäðîáíîñòåé çàéäèòå íà <ulink url="&url.php.anoncvs;">&url.php.anoncvs;</ulink>. </para> </answer> </qandaentry> <qandaentry id="faq.obtaining.precompiled"> <question> <para>Äîñòóïíû ëè ïðåêîìïèëèðîâàííûå áèíàðíèêè?</para> </question> <answer> <para> Ìû ðàñïðîñòðàíÿåì ïðåêîìïèëèðîâàííûå áèíàðíèêè òîëüêî äëÿ Windows, òàê êàê ìû íå â ñîñòîÿíèè êîìïèëèðîâàòü PHP ñî âñåìè âîçìîæíûìè êîìáèíàöèÿìè ðàñøèðåíèé äàæå äëÿ ñàìûõ îñíîâíûõ Linux/Unix ïëàòôîðì. Òàêæå çàìåòüòå, ÷òî íà ñåãîäíÿ ìíîãèå äèñòðèáóòèâû Linux ïîñòàâëÿþòñÿ ñ PHP. Áèíàðíèêè äëÿ Windows ìîæíî ñêà÷àòü ñ íàøåé ñòðàíèöû <ulink url="&url.php.downloads;">Downloads</ulink>, äëÿ áèíàðíèêîâ ïîä Linux, ïîæàëóéñòà, ïîñåòèòå web ñàéò âàøåãî äèñòðèáóòèâà. </para> </answer> </qandaentry> <qandaentry id="faq.obtaining.optional"> <question> <para> Ãäå ÿ ìîãó äîñòàòü áèáëèîòåêè, íåîáõîäèìûå äëÿ êîìïèëÿöèè íåêîòîðûõ äîïîëíèòåëüíûõ ðàñøèðåíèé PHP? </para> </question> <answer> <para> <note> <simpara> Çâ¸çäî÷êîé (*) ïîìå÷åíû áèáëèîòåêè, êîòîðûå íå ìîãóò áûòü èñïîëüçîâàíû ñ PHP, óñòàíîâëåííûì êàê ìîäóëü íà ìíîãîïîòî÷íûõ web ñåðâåðàõ (IIS, Netscape) ïîä Windows, òàê êàê îíè íåáåçîïàñíû â ìíîãîïîòî÷íîé ñðåäå. Ýòî íå îòíîñèòñÿ ê Unix ñðåäå. </simpara> </note> </para> <para> <itemizedlist> <listitem> <simpara> <ulink url="&url.ldap.openldap.source;">LDAP (Unix)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.ldap.mt;">LDAP* (Unix)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.ldap.netscape.sdk;">LDAP (Unix/Win)</ulink> : Netscape Directory (LDAP) SDK 1.1. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.ldap.netscape.sdk;">free LDAP server</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.sleepycat;">Berkeley DB2 (Unix/Win)</ulink> : &url.sleepycat;. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.net-snmp;">SNMP* (Unix): </ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.gd;">GD* (Unix/Win)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.msql;">mSQL* (Unix)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.pgsql;">PostgreSQL (Unix)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.imap;">IMAP* (Win/Unix)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.sybase;">Sybase-CT* (Linux, libc5)</ulink> : Äîñòóïíà ëîêàëüíî. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.freetype;">FreeType (libttf):</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.zlib;">ZLib (Unix/Win32)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.expat;">expat XML parser (Unix/Win32)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.pdf;">PDFLib</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.mcrypt;">mcrypt</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.mhash;">mhash</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.t1lib;">t1lib</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.dmalloc;">dmalloc</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.aspell;">aspell</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.readline;">readline</ulink>. </simpara> </listitem> </itemizedlist> </para> </answer> </qandaentry> <qandaentry id="faq.obtaining.how"> <question> <para>Êàê ïîäêëþ÷èòü ýòè áèáëèîòåêè?</para> </question> <answer> <para> Âàì íåîáõîäèìî ñëåäîâàòü èíñòðóêöèÿì, ñîïðîâîæäàþùèì áèáëèîòåêó. Ïðè çàïóñêå ñêðèïòà 'configure', íåêîòîðûå áèáëèîòåêè (òàêèå êàê áèáëèîòåêà GD) íàõîäÿòñÿ àâòîìàòè÷åñêè, äðóãèå äîëæíû áûòü âêëþ÷åíû ñ ïîìîùüþ îïöèè '<literal>--with-EXTENSION</literal>'. Çàïóñòèòå '<literal>configure --help</literal>' äëÿ ïîëó÷åíèÿ ñïèñêà âñåõ îïöèé '<literal>--with-EXTENSION</literal>' . </para> </answer> </qandaentry> <qandaentry id="faq.obtaining.compileNT"> <question> <para> ß ïîëó÷èë ïîñëåäíþþ âåðñèþ èñõîäíîãî êîäà PHP èç CVS. ×òî íóæíî äëÿ êîìïèëÿöèè åãî ïîä Windows? </para> </question> <answer> <para> Âî-ïåðâûõ, âàì áóäåò íóæåí Microsoft Visual C++ v6 (v5 ìîæåò òîæå ðàáîòàòü, íî ìû ïîëüçóåìñÿ v6), è âàì áóäóò íóæíû íåêîòîðûå ôàéëû ïîääåðæêè. Ñìîòðèòå ðàçäåë ðóêîâîäñòâà <link linkend="install.windows.building">ñáîðêà PHP èç èñõîäíèêîâ ïîä Windows</link>. </para> </answer> </qandaentry> <qandaentry id="faq.obtaining.browscap"> <question> <para>Ãäå íàéòè ôàéë âîçìîæíîñòåé áðàóçåðîâ (Browser Capabilities File)?</para> </question> <answer> <para> Ôàéë <filename>browscap.ini</filename> ìîæíî ñêà÷àòü ñ <ulink url="&url.browscap.download;">&url.browscap.download;</ulink>. </para> </answer> </qandaentry> </qandaset> </chapter> <!-- 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-ru/faq/databases.xml?r=1.1&p=1 Index: phpdoc-ru/faq/databases.xml +++ phpdoc-ru/faq/databases.xml <?xml version="1.0" encoding="windows-1251"?> <!-- EN-Revision: 1.27 Maintainer: irinagoble Status: ready --> <!-- $Revision: 1.1 $ --> <chapter id="faq.databases"> <title>Âîïðîñû ïî Áàçàì Äàííûõ</title> <titleabbrev>Âîïðîñû ïî Áàçàì Äàííûõ</titleabbrev> <para> Ýòîò ðàçäåë ñîäåðæèò îáùèå âîïðîñû î ñâÿçè ìåæäó PHP è áàçàìè äàííûõ. Äà, ñåãîäíÿ ïðàêòè÷åñêè ëþáàÿ áàçà äàííûõ ìîæåò áûòü äîñòóïíà èç PHP. </para> <qandaset> <qandaentry id="faq.databases.mssql"> <question> <para> ß ñëûøàë, ÷òî ìîæíî ïîëó÷èòü äîñòóï ê Microsoft SQL ñåðâåðó èç PHP. Êàê? </para> </question> <answer> <para> Íà Windows ìàøèíàõ, âû ïðîñòî èñïîëüçóåòå ïîääåðæêó ODBC è ñîîòâåòñâóþùèé ODBC äðàéâåð. </para> <para> Íà Unix ìàøèíàõ äëÿ äîñòóïà ê Microsoft SQL ñåðâåðàì âû ìîæåòå èñïîëüçîâàòü Sybase-CT äðàéâåð, òàê êàê îíè (ïî êðàéíåé ìåðå â îñíîâíîì) ñîâìåñòèìû ïî ïðîòîêîëó. Ó Sybase åñòü <ulink url="&url.sybase.ctlib;">áåñïëàòíàÿ âåðñèÿ íåîáõîäèìûõ áèáëèîòåê äëÿ Linux</ulink>. Äëÿ äðóãèõ Unix ñèñòåì âàì íåîáõîäèìî îáðàòèòüñÿ â Sybase çà ñîîòâåòñòâóþùèìè áèáëèîòåêàìè. Òàêæå ñìîòðèòå îòâåò íà ñëåäóþùèé âîïðîñ. </para> </answer> </qandaentry> <qandaentry id="faq.databases.access"> <question> <para>Ìîãó ëè ÿ ïîëó÷èòü äîñòóï ê áàçàì äàííûõ Microsoft Access?</para> </question> <answer> <para> Äà. Åñëè âñ¸ ïîëíîñòüþ âûïîëíÿåòñÿ ïîä Windows 9x/Me èëè NT/2000, òî ó âàñ óæå åñòü âñå íåîáõîäèìûå ñðåäñòâà, òàê êàê äëÿ áàç äàííûõ Microsoft Access âû ìîæåòå èñïîëüçîâàòü ODBC è äðàéâåðû ODBC îò Microsoft. </para> <para> Åñëè âû õîòèòå ñâÿçàòü PHP, âûïîëíÿþùèéñÿ íà Unix, è MS Access íà Windows, òî âàì áóäóò íóæíû äðàéâåðû ODBC äëÿ Unix. Òàêèå ODBC äðàéâåðû äëÿ Unix åñòü ó <ulink url="&url.openlink;">OpenLink Software</ulink>. Ïî áåñïëàòíîé ïèëîòíîé ïðîãðàììå âû ìîæåòå ñêà÷àòü ïðîáíóþ êîïèþ áåç ñðîêà èñòå÷åíèÿ, à öåíû íà êîìåð÷åñêè ïîääåðæèâàåìóþ âåðñèþ íà÷èíàþòñÿ îò 675$. </para> <para> Äðóãàÿ âîçìîæíîñòü - õðàíèòü äàííûå íà SQL ñåðâåðå, êîòîðûé èìååò ODBC äðàéâåðû äëÿ Windows, è çàòåì îáðàùàòüñÿ ê ýòîé áàçå äàííûõ èç Microsoft Access (èñïîëüçóÿ ODBC) è èç PHP (èñïîëüçóÿ âñòðîåííûå äðàéâåðû) èëè èñïîëüçîâàòü ïðîìåæóòî÷íûé ôîðìàò ïîíÿòíûé è äëÿ Access, è äëÿ PHP, êàê òî ïîñëåäîâàòåëüíûå ôàéëû èëè áàçû äàííûõ dBase. Ïî ýòîìó ïîâîäó Òèì Õýéç (Tim Hayes) èç OpenLink software ïèøåò: <blockquote> <para> Èñïîëüçîâàíèå ïðîìåæóòî÷íîé áàçû äàííûõ - íå î÷åíü õîðîøàÿ èäåÿ, êîãäà åñòü âîçìîæíîñòü ðàáîòàòü ñ áàçîé äàííûõ íà ïðÿìóþ èç PHP ÷åðåç ODBC, íàïðèìåð ñ äðàéâåðàìè îò OpenLink. Åñëè âàì âñ¸-òàêè íàäî èñïîëüçîâàòü ïðîìåæóòî÷íûé ôîðìàò, OpenLink âûïóñòèë Virtuoso (ìåõàíèçì âèðòóàëüíîé áàçû äàííûõ) äëÿ NT, Linux è äðóãèõ ïëàòôîðì Unix. Ïîæàëóéñòà, ïîñåòèòå íàø <ulink url="&url.openlink;">web ñàéò</ulink> äëÿ áåñïëàòíîé çàãðóçêè. </para> </blockquote> </para> <para> Äðóãîé ïðîâåðåííûé âàðèàíò - èñïîëüçîâàòü MySQL ñ å¸ MyODBC äðàéâåðàìè íà Windows è äåëàòü ñèíõðîíèçàöèþ áàç äàííûõ. Ñòèâ Ëîðåíñ (Steve Lawrence) ïèøåò: </para> <para> <itemizedlist> <listitem> <simpara> Óñòàíîâèòå MySQL ñîãëàñíî ïîñòàâëÿåìûì ñ íåé èíñòðóêöèÿì. Ïîñëåäíÿÿ âåðñèÿ äîñòóïíà ñ <ulink url="&url.mysql;">www.mysql.com</ulink> (ïîëó÷èòå å¸ ñ áëèæàéøåãî çåðêàëà!). Îñîáîé êîíôèãóðàöèè íå òðåáóåòñÿ, çà èñêëþ÷åíèåì òîãî, ÷òî ïðè íàñòðîéêå áàç äàííûõ è ñîçäàíèè ïîëüçîâàòåëÿ, â ïîëå õîñòà âû äîëæíû ïîìåñòèòü % èëè èìÿ Windows ìàøèíû, íà êîòîðóþ âû õîòèòå ïîëó÷èòü äîñòóï èç MySQL. Çàïèøèòå èìÿ âàøåãî ñåðâåðà, èìÿ ïîëüçîâàòåëÿ è ïàðîëü. </simpara> </listitem> <listitem> <simpara> Ñêà÷àéòå MyODBC äðàéâåð äëÿ Windows ñ ñàéòà MySQL. Ïîñëåäíèé ðåëèç - myodbc-2_50_19-win95.zip (äîñòóïåí òàêæå äëÿ NT è êàê èñõîäíûé êîä). Óñòàíîâèòå åãî íà âàøåé Windows ìàøèíå. Âû ìîæåòå ïðîâåðèòü åãî ðàáîòîñïîñîáíîñòü ñ ïîìîùüþ ïîñòàâëÿåìûõ ñ íèì óòèëèò. </simpara> </listitem> <listitem> <simpara> Ñîçäàéòå ïîëüçîâàòåëÿ èëè ñèñòåìíûé dsn â âàøåì àäìèíèñòðàòîðå ODBC, ðàñïîëîæåííîì â êîíòðîëüíîé ïàíåëè. Ñîçäàéòå dsn èìÿ, ââåäèòå èìÿ õîñòà, èìÿ ïîëüçîâàòåëÿ, ïàðîëü è ò.ä. äëÿ âàøåé áàçû äàííûõ MySQL, ñêîíôèãóðèðîâàííîé íà 1-îì øàãå. </simpara> </listitem> <listitem> <simpara> Çàïóñòèòå ïîëíóþ èíñòàëÿöèþ Access, ýòî äàñò âàì óâåðåííîñòü, ÷òî âû ïîëó÷èòå âñå íóæíûå äîáàâêè (add-ins). Ïî êðàéíåé ìåðå âàì áóäóò íåîáõîäèìû ïîääåðæêà ODBC è àäìèíèñòðàòîð ñâÿçàííûõ òàáëèö. </simpara> </listitem> <listitem> <simpara> È òåïåðü ñàìîå èíòåðåñíîå! Ñîçäàéòå íîâóþ áàçó äàííûõ Access.  îêíå òàáëèöû ù¸ëêíèòå ïðàâîé êíîïêîé ìûøêè è âûáåðèòå Link Tables (Ñâÿçàòü Òàáëèöû), ëèáî èç ôàéëîâîãî ìåíþ âûáåðèòå Get External Data (Ïîëó÷èòü Âíåøíèå Äàííûå) è çàòåì Link Tables.  ïîÿâèâøåìñÿ îêíå ïðîñìîòðà ôàéëîâ âûáåðèòå ôàéëû òèïà ODBC. Âûáåðèòå ñèñòåìíûé dsn è èìÿ âàøåãî dsn, ñîçäàííîãî íà 3-åì øàãå. Âûáåðèòå òàáëèöó äëÿ ñâÿçè, íàæìèòå OK è âóàëÿ! Òåïåðü âû ìîæåòå îòêðûòü òàáëèöó è äîáàâèòü/óäàëèòü/îòðåäàêòèðîâàòü äàííûå íà âàøåì MySQL ñåðâåðå! Âû òàêæå ìîæåòå ñòðîèòü çàïðîñû, èìïîðòèðîâàòü/ýêñïîðòèðîâàòü òàáëèöû â MySQL, ñîçäàâàòü ôîðìû è îò÷¸òû, è ò.ä. </simpara> </listitem> </itemizedlist> </para> <para> Ïîëåçíûå Ñîâåòû è Òðþêè: <itemizedlist> <listitem> <simpara> Âû ìîæåòå ïîñòðîèòü âàøè òàáëèöû â Access, ýêñïîðòèðîâàòü èõ â MySQL è çàòåì ïðèâÿçàòü èõ íàçàä. Ýòî óáûñòðÿåò ñîçäàíèå òàáëèö. </simpara> </listitem> <listitem> <simpara> Ïðè ñîçäàíèè òàáëèö â Access, âû äîëæíû îïðåäåëèòü ïåðâè÷íûé êëþ÷, ÷òîáû èìåòü äîñòóï ê òàáëèöå ïî çàïèñè. Óáåäèòåñü ÷òî âû ñîçäàëè ïåðâè÷íûé êëþ÷ â MySQL ïåðåä òåì êàê ïðèâÿçàòü òàáëèöó ê Access. </simpara> </listitem> <listitem> <simpara> Åñëè âû èçìåíÿåòå òàáëèöó â MySQL, òî âû äîëæíû ñâÿçàòü å¸ ñ Access ïî-íîâîé. Èäèòå â tools>add-ins>linked table manager, ñëåäóéòå ê âàøåìó ODBC DSN, è âûáåðèòå îòòóäà òàáëèöó äëÿ ïåðåñâÿçêè. Òàì æå âû ìîæåòå èçìåíèòü èñòî÷íèê âàøåãî dsn, äëÿ ýòîãî, ïåðåä òåì êàê íàæàòü OK, ïðîñòî ïîìåòüòå "always prompt for new location" (âñåãäà çàïðàøèâàòü íîâîå ìåñòîíàõîæäåíèå). </simpara> </listitem> </itemizedlist> </para> </answer> </qandaentry> <qandaentry id="faq.databases.upgraded"> <question> <para> ß îáíîâèëñÿ äî PHP 4 è òåïåðü mysql ïîñòîÿííî âûäàåò "Warning: MySQL: Unable to save result set in ..." (Ïðåäóïðåæäåíèå: MySQL: Íå ìîãó ñîõðàíèòü ðåçóëüòàò â ...). ×òî ýòî? </para> </question> <answer> <para> Âåðîÿòíåå âñåãî PHP 4 áûë ñêîìïèëèðîâàí ñ îïöèåé <option role="configure">--with-mysql</option> áåç çàäàíèÿ ïóòè ê MySQL. Ýòî îçíà÷àåò, ÷òî PHP èñïîëüçóåò åãî âñòðîåííóþ êëèåíòñêóþ áèáëèîòåêó MySQL. Åñëè íà âàøåé ñèñòåìå âûïîëíÿþòñÿ ïðèëîæåíèÿ (òàêèå êàê PHP 3, â âèäå ïàðàëåëüíîãî ìîäóëÿ Apache, èëè auth-mysql), êîòîðûå èñïîëüçóþò äðóãèå âåðñèè MySQL êëèåíòîâ, òî âîçíèêàåò êîíôëèêò ìåæäó äâóìÿ ðàçíûìè âåðñèÿìè ýòèõ êëèåíòîâ. </para> <para> Îáû÷íî, ïåðåêîìïèëÿöèÿ PHP 4 ñ óêàçàíèåì ïóòè ê MySQL â îïöèè '<link linkend="mysql.configure">--with-mysql=/your/path/to/mysql</link>' ðåøàåò ýòó ïðîáëåìó. </para> </answer> </qandaentry> <qandaentry id="faq.databases.mysql.php5"> <question> <para> Êëèåíòñêèå áèáëèîòåêè MySQL áîëüøå íå âêëþ÷åíû â PHP 5, êàê ýòî îòðàçèòñÿ íà ìíå? Ìîãó ëè ÿ âñ¸ òàê æå èñïîëüçîâàòü MySQL c PHP? ß ïûòàþñü ðàáîòàòü ñ MySQL è ïîëó÷àþ îøèáêè "function undefined" (ôóíêöèÿ íåîïðåäåëåíà), ÷òî âûäà¸ò èõ? </para> </question> <answer> <para> Äà. PHP âñåãäà áóäåò ïîääåðæèâàòü MySQL â òîì èëè èíîì âèäå. Åäèíñòâåííîå ÷òî èçìåíèëîñü â PHP 5 - ýòî òî, ÷òî ìû áîëüøå íå ïîñòàâëÿåì ñàìó êëèåíòñêóþ áèáëèîòåêó. Âîò íåêîòîðûå ïðè÷èíû äëÿ ýòîãî: </para> <itemizedlist> <listitem> <para> Ñåãîäíÿ êëèåíòñêèå áèáëèîòåêè óæå óñòàíîâëåíû íà áîëüøèíñòâå ñèñòåì. </para> </listitem> <listitem> <para> Ó÷èòûâàÿ ïðåäûäóùèé ïóíêò, èìåÿ íåñêîëüêî âåðñèé, ïðîùå çàïóòàòüñÿ. Íàïðèìåð, åñëè âû êîìïîíóåòå mod_auth_mysql ñ îäíîé âåðñèåé, à PHP ñ äðóãîé, è çàòåì ðàçðåøàåòå îáà â Apache, òî âû ïîëó÷èòå õîðîøèé æèðíûé êðàõ. Òàêæå, ïîñòàâëÿåìûå áèáëèîòåêè íå âñåãäà äðóæàò ñ óñòàíîâëåííîé ñåðâåðíîé âåðñèåé. Íàèáîëåå î÷åâèäíûé ñèìïòîì ýòîãî - ðàçíîãëàñèå ïî òîìó ãäå èñêàòü ôàéë mysql.socket (ôàéë Unix ñîêåòà). </para> </listitem> <listitem> <para> Òàêæå ïîääåðæêà áûëà âÿëîé è îòñòàâàëà îò ðåëèçîâ âñ¸ áîëüøå è áîëüøå. </para> </listitem> <listitem> <para> Ïîñëåäóþùèå âåðñèè áèáëèîòåêè áóäóò ïîä GPL è ìû íå ìîæåì ïîñòàâëÿòü áèáëèîòåêó ïîä GPL ñ ïðîåêòîì ëèöåíçèðóåìûì ïî òèïó BSD/Apache. Ïîýòîìó ïîëíûé ðàçðûâ â PHP 5 âèäèòñÿ êàê ñàìûé ëó÷øèé âàðèàíò. </para> </listitem> </itemizedlist> <para> Íà ñàìîì äåëå ýòî çàäåíåò íå òàê óæ ìíîãî ëþäåé. Ïîëüçîâàòåëè Unix, ïî êðàéíåé ìåðå òå, êòî çíàåò ÷òî îíè äåëàþò, âñåãäà áûëè ñêëîííû ñîáèðàòü PHP ñ óæå óñòàíîâëåííîé íà èõ ñèñòåìå áèáëèîòåêîé libmesqlclient, ïðîñòî çàäàâ îïöèþ <option role="configure">--with-mysql=/usr</option> ïðè ñáîðêå. Ïîëüçîâàòåëè Windows ìîãóò âêëþ÷èòü ðàñøèðåíèå <filename>php_mysql.dll</filename> âíóòðè &php.ini;. Òàêæå óáåäèòåñü, ÷òî <filename>libmysql.dll</filename> äîñòóïåí â ñèñòåìíîì PATH. Î òîì êàê - ÷èòàéòå FAQ: <link linkend="faq.installation.addtopath"> óñòàíîâêà ñèñòåìíîãî PATH â Windows</link>. Òàê êàê <filename>libmysql.dll</filename> (è ìíîãèå äðóãèå PHP ôàéëû) íàõîäèòñÿ â ïàïêå PHP, âàì ëó÷øå äîáàâèòü PHP ïàïêó â âàø ñèñòåìíûé PATH. </para> </answer> </qandaentry> <qandaentry id="faq.databases.shared-mysql"> <question> <para> Ïîñëå óñòàíîâêè ïîääåðæêè ðàçäåëåíèÿ â MySQL, Apache âûäà¸ò äàìïû ñðàçó ïîñëå çàãðóçêè libphp4.so. Ìîæíî ëè ýòî èñïðàâèòü? </para> </question> <answer> <para> Ýòî ïðîèñõîäèò åñëè âû ñêîìïîíîâàëè âàøè áèáëèîòåêè MySQL ñ pthreads. Ïðîâåðüòå èñïîëüçóÿ ldd. Åñëè ýòî òàê, ñêîìïèëèðóéòå MySQL èç èñõîäíèêîâ èëè ïåðåêîìïèëèðóéòå èñõîäíûé rpm, îòêëþ÷èâ ïîòî÷íûé êîä êëèåíòà â ôàéëå ñïåöèôèêàöèè. Ëþáîé èç ýòèõ âàðèàíòîâ èñïðàâèò ïðîáëåìó. Çàòåì ïåðåêîìïèëèðóéòå PHP ñ íîâûìè áèáëèîòåêàìè MySQL. </para> </answer> </qandaentry> <qandaentry id="faq.databases.mysqlresource"> <question> <para> Ïî÷åìó ÿ ïîëó÷àþ îøèáêè òèïà "Warning: 0 is not a MySQL result index in <file> on line <x>" èëè "Warning: Supplied argument is not a valid MySQL result resource in <file> on line <x>? </para> </question> <answer> <para> Âû ïûòàåòåñü èñïîëüçîâàòü èäåíòèôèêàòîð ðåçóëüòàòà, êîòîðûé ðàâåí 0. 0 îçíà÷àåò ÷òî âàø çàïðîñ íåóäàëñÿ ïî êàêîé-ëèáî ïðè÷èíå. Âàì íåîáõîäèìî ñäåëàòü ïðîâåðêó íà îøèáêè ïîñëå òîãî êàê âû ïîñëàëè âàø çàïðîñ è ïåðåä òåì êàê âû ïûòàåòåñü èñïîëüçîâàòü âîçâðàù¸ííûé èäåíòèôèêàòîð ðåçóëüòàòà. Ïðàâèëüíûé ñïîñîá äëÿ ýòîãî âûãëÿäèò ïðèìåðíî êàê ñëåäóþùèé êîä: <programlisting role="php"> <![CDATA[ <?php $result = mysql_query("SELECT * FROM tables_priv"); if (!$result) { echo mysql_error(); exit; } ?> ]]> </programlisting> èëè <programlisting role="php"> <![CDATA[ <?php $result = mysql_query("SELECT * FROM tables_priv") or die("Bad query: " . mysql_error()); ?> ]]> </programlisting> </para> </answer> </qandaentry> </qandaset> </chapter> <!-- 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-ru/faq/obtaining.xml?r=1.1&p=1 Index: phpdoc-ru/faq/obtaining.xml +++ phpdoc-ru/faq/obtaining.xml <?xml version="1.0" encoding="windows-1251"?> <!-- EN-Revision: 1.20 Maintainer: irinagoble Status: ready --> <!-- $Revision: 1.1 $ --> <chapter id="faq.obtaining"> <title>Ïîëó÷åíèå PHP</title> <titleabbrev>Ïîëó÷åíèå PHP</titleabbrev> <para> Ýòîò ðàçäåë ñîäåðæèò èíôîðìàöèþ î òîì ãäå ïîëó÷èòü PHP è âîïðîñû, êàñàþùèåñÿ OC. </para> <qandaset> <qandaentry id="faq.obtaining.where"> <question> <para>Ãäå ÿ ìîãó âçÿòü PHP?</para> </question> <answer> <para> Âû ìîæåòå ñêà÷àòü PHP ñ ëþáîãî ñàéòà èç PHP ñåòè. Ñàéòû ñåòè ìîæíî íàéòè íà <ulink url="&url.php;">&url.php;</ulink>. Âû òàêæå ìîæåòå âîñïîëüçîâàòüñÿ àíîíèìíûì CVS äëÿ ïîëó÷åíèÿ ñàìîé ïîñëåäíåé âåðñèè èñõîäíèêîâ. Äëÿ ïîäðîáíîñòåé çàéäèòå íà <ulink url="&url.php.anoncvs;">&url.php.anoncvs;</ulink>. </para> </answer> </qandaentry> <qandaentry id="faq.obtaining.precompiled"> <question> <para>Äîñòóïíû ëè ïðåêîìïèëèðîâàííûå áèíàðíèêè?</para> </question> <answer> <para> Ìû ðàñïðîñòðàíÿåì ïðåêîìïèëèðîâàííûå áèíàðíèêè òîëüêî äëÿ Windows, òàê êàê ìû íå â ñîñòîÿíèè êîìïèëèðîâàòü PHP ñî âñåìè âîçìîæíûìè êîìáèíàöèÿìè ðàñøèðåíèé äàæå äëÿ ñàìûõ îñíîâíûõ Linux/Unix ïëàòôîðì. Òàêæå çàìåòüòå, ÷òî íà ñåãîäíÿ ìíîãèå äèñòðèáóòèâû Linux ïîñòàâëÿþòñÿ ñ PHP. Áèíàðíèêè äëÿ Windows ìîæíî ñêà÷àòü ñ íàøåé ñòðàíèöû <ulink url="&url.php.downloads;">Downloads</ulink>, äëÿ áèíàðíèêîâ ïîä Linux, ïîæàëóéñòà, ïîñåòèòå web ñàéò âàøåãî äèñòðèáóòèâà. </para> </answer> </qandaentry> <qandaentry id="faq.obtaining.optional"> <question> <para> Ãäå ÿ ìîãó äîñòàòü áèáëèîòåêè, íåîáõîäèìûå äëÿ êîìïèëÿöèè íåêîòîðûõ äîïîëíèòåëüíûõ ðàñøèðåíèé PHP? </para> </question> <answer> <para> <note> <simpara> Çâ¸çäî÷êîé (*) ïîìå÷åíû áèáëèîòåêè, êîòîðûå íå ìîãóò áûòü èñïîëüçîâàíû ñ PHP, óñòàíîâëåííûì êàê ìîäóëü íà ìíîãîïîòî÷íûõ web ñåðâåðàõ (IIS, Netscape) ïîä Windows, òàê êàê îíè íåáåçîïàñíû â ìíîãîïîòî÷íîé ñðåäå. Ýòî íå îòíîñèòñÿ ê Unix ñðåäå. </simpara> </note> </para> <para> <itemizedlist> <listitem> <simpara> <ulink url="&url.ldap.openldap.source;">LDAP (Unix)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.ldap.mt;">LDAP* (Unix)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.ldap.netscape.sdk;">LDAP (Unix/Win)</ulink> : Netscape Directory (LDAP) SDK 1.1. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.ldap.netscape.sdk;">free LDAP server</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.sleepycat;">Berkeley DB2 (Unix/Win)</ulink> : &url.sleepycat;. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.net-snmp;">SNMP* (Unix): </ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.gd;">GD* (Unix/Win)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.msql;">mSQL* (Unix)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.pgsql;">PostgreSQL (Unix)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.imap;">IMAP* (Win/Unix)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.sybase;">Sybase-CT* (Linux, libc5)</ulink> : Äîñòóïíà ëîêàëüíî. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.freetype;">FreeType (libttf):</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.zlib;">ZLib (Unix/Win32)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.expat;">expat XML parser (Unix/Win32)</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.pdf;">PDFLib</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.mcrypt;">mcrypt</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.mhash;">mhash</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.t1lib;">t1lib</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.dmalloc;">dmalloc</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.aspell;">aspell</ulink>. </simpara> </listitem> <listitem> <simpara> <ulink url="&url.readline;">readline</ulink>. </simpara> </listitem> </itemizedlist> </para> </answer> </qandaentry> <qandaentry id="faq.obtaining.how"> <question> <para>Êàê ïîäêëþ÷èòü ýòè áèáëèîòåêè?</para> </question> <answer> <para> Âàì íåîáõîäèìî ñëåäîâàòü èíñòðóêöèÿì, ñîïðîâîæäàþùèì áèáëèîòåêó. Ïðè çàïóñêå ñêðèïòà 'configure', íåêîòîðûå áèáëèîòåêè (òàêèå êàê áèáëèîòåêà GD) íàõîäÿòñÿ àâòîìàòè÷åñêè, äðóãèå äîëæíû áûòü âêëþ÷åíû ñ ïîìîùüþ îïöèè '<literal>--with-EXTENSION</literal>'. Çàïóñòèòå '<literal>configure --help</literal>' äëÿ ïîëó÷åíèÿ ñïèñêà âñåõ îïöèé '<literal>--with-EXTENSION</literal>' . </para> </answer> </qandaentry> <qandaentry id="faq.obtaining.compileNT"> <question> <para> ß ïîëó÷èë ïîñëåäíþþ âåðñèþ èñõîäíîãî êîäà PHP èç CVS. ×òî íóæíî äëÿ êîìïèëÿöèè åãî ïîä Windows? </para> </question> <answer> <para> Âî-ïåðâûõ, âàì áóäåò íóæåí Microsoft Visual C++ v6 (v5 ìîæåò òîæå ðàáîòàòü, íî ìû ïîëüçóåìñÿ v6), è âàì áóäóò íóæíû íåêîòîðûå ôàéëû ïîääåðæêè. Ñìîòðèòå ðàçäåë ðóêîâîäñòâà <link linkend="install.windows.building">ñáîðêà PHP èç èñõîäíèêîâ ïîä Windows</link>. </para> </answer> </qandaentry> <qandaentry id="faq.obtaining.browscap"> <question> <para>Ãäå íàéòè ôàéë âîçìîæíîñòåé áðàóçåðîâ (Browser Capabilities File)?</para> </question> <answer> <para> Ôàéë <filename>browscap.ini</filename> ìîæíî ñêà÷àòü ñ <ulink url="&url.browscap.download;">&url.browscap.download;</ulink>. </para> </answer> </qandaentry> </qandaset> </chapter> <!-- 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 -->