OpenForum RSS: PHP ��

PHP �� (Dmitriy)

Thu, 24 Jul 2008 13:09:20 GMT

�� ,

��

#!/usr/bin/perl -w

use DBI;

# $dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd);
my $host="192.168.20.1";
my $user="user";
my $passwd="password";
my $sid="ORACLE_SID";
my $dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passwd);
my $sql="select name from table where id='16771'";
my $sth=$dbh->prepare($sql);
$sth->execute();
my $value = $sth->ora_fetch_scroll(OCI_FETCH_LAST,0);
print "id=".$value->[0],"\n";

�� DBI, � �� sqlplus ��

PHP �� (us.master)

Thu, 24 Jul 2008 12:25:18 GMT

�ӣ. �� . :-)
�� (��).
� ��, �� , �� (�� ODBC, DBI, DBD).
��! :-)

PHP �� (us.master)

Thu, 24 Jul 2008 12:22:18 GMT

>�� pdo_oci.so � oci8.so
>

:-))))))))
� �� -��? �� PHP �� .
�� Oracle Client � �� Oracle ODBC driver �� .
� Σ� �� .
�� , �� ӣ �� .

>php-cgi �� php-��
>��
>
>Fatal error: Call to undefined function ocilogon() in /www/htdocs/script.php on line ��
>

��, �� . Oracle Client-�� .

>
>�� --with-oci8 �� php �� nGinx ��
>504 Gateway Time-out.

�� , �� .

#!/usr/local/bin/perl

print "Content-type: text/html\n\n";

# �� -�� /etc/init.d/dbora
# �� /etc/profile, � �� Oracle �� :

# ORACL

PHP �� (Dmitriy)

Thu, 24 Jul 2008 12:01:31 GMT

��/�� unixODBC ��

�� php ��

./configure --prefix=/usr/local/php \
--with-mcrypt=/usr/local/mcrypt \
--with-exec-dir=/usr/local/php/bin \
--enable-safe-mode \
--enable-calendar \
--enable-exif \
--enable-ftp \
--with-iconv \
--enable-mbstring \
--with-mime-magic \
--with-pdo-mysql=/usr/local/mysql \
--enable-ucd-snmp-hack \
--enable-sockets \
--enable-fastcgi \
--enable-force-cgi-redirect \
--with-pdo-odbc=unixODBC \
--with-oci=instantclient,/usr/include/oracle/11.1.0.1/client,/usr/lib/oracle/11.1.0.1/client \
--with-unixODBC

�� pdo_oci.so � oci8.so

php-cgi �� php-��

Fatal error: Call to undefined function ocilogon() in /www/htdocs/script.php on line ��

PHP �� (us.master)

Tue, 22 Jul 2008 12:22:17 GMT

��, � �ݣ:

� php.ini � �� :

extension=pdo_oci.so
extension=oci8.so
extension=/usr/local/lib/php/ext/pdo_mysql.so

PHP �� (us.master)

Tue, 22 Jul 2008 06:21:50 GMT

>�� 8-�� (--with-oci=) ��
>
>checking for ncurses support... no
>checking for Oracle (OCI8) support... no
>checking for unixODBC support... configure: error: ODBC header file '/usr/local/include/sqlext.h' not found!
>
>
>� �� sqlext.h - �� ODBC-�� ?

export ORACLE_HOME="/usr/local/oracle8-client"

./configure --with-mysql=/usr/local/mysql \
--with-apache2=/usr/local/apache \
--with-apxs2=/usr/local/apache/bin/apxs \
--with-iconv=/usr/local \
--with-ldap=/usr/local \
--with-snmp=/usr/local \
--with-pgsql=/usr/local/pgsql \
--enable-track-vars \
--enable-ftp \
--enable-sockets \
--without-pear \
--with-gd \
--with-zlib \
--with-ttf \
--with-freetype-dir=/usr/local/include/freetype2/freetype \
--with-pdo-odbc=unixODBC \
--with-pdo-oci=shared,/usr/local/oracle8-client \
--with-pdo-mysql=/usr/loca

PHP �� (Dmitriy)

Mon, 21 Jul 2008 12:06:45 GMT

�� 8-�� (--with-oci=) ��

checking for ncurses support... no
checking for Oracle (OCI8) support... no
checking for unixODBC support... configure: error: ODBC header file '/usr/local/include/sqlext.h' not found!

� �� sqlext.h - �� ODBC-�� ?

PHP �� (us.master)

Mon, 21 Jul 2008 11:40:43 GMT

��:

--with-oci=instantclient,/usr/include/oracle/11.1.0.1/client,/usr/lib/oracle/11.1.0.1/client

�� 8.

�� PDO.

PHP �� (Dmitriy)

Mon, 21 Jul 2008 09:04:05 GMT

'--with-mysql=/usr/local/mysql'
'--enable-fastcgi'
'--enable-force-cgi-redirect'
'--with-oci8=instantclient,/usr/include/oracle/11.1.0.1/client,/usr/lib/oracle/11.1.0.1/client'

�� ,
�.�. �� ?

OpenForum RSS: PHP �� ����� ��������� ����

PHP �� ����� ��������� ���� (Dmitriy)

PHP �� ����� ��������� ���� (us.master)

PHP �� ����� ��������� ���� (us.master)

PHP �� ����� ��������� ���� (Dmitriy)

PHP �� ����� ��������� ���� (us.master)

PHP �� ����� ��������� ���� (us.master)

PHP �� ����� ��������� ���� (Dmitriy)

PHP �� ����� ��������� ���� (us.master)

PHP �� ����� ��������� ���� (Dmitriy)

OpenForum RSS: PHP ��

PHP �� (Dmitriy)

PHP �� (us.master)

PHP �� (us.master)

PHP �� (Dmitriy)

PHP �� (us.master)

PHP �� (us.master)

PHP �� (Dmitriy)

PHP �� (us.master)

PHP �� (Dmitriy)