[PHP-DB] Re: Dreamweaver as PHP editor

you could name your files *.inc.php - DW would see them as php files - and it can be safer (look if an internaut asks for the url www.yoursite.com/config.inc : he will see the source code...) Regards, Philippe Susi Sloan [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] I'm

[PHP-DB] Re: Help connecting with oracle

Sergio Barreira [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Hi: I have a Oracle 7.3.3 on Unix, but in my computer (client) Windows 2000 i have a php source code that try to connect with this database. I test with TNSPING and SQLPLUS commands line, and connect

Re: [PHP-DB] Re: Connect to Oracle DB

Roy A Jones [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] I just wanted to add my two cents ... (snip) I have compiled php with BOTH --with-oracle and --with-oci8. It is usually preferred to have your architectures/systems separate to prevent some performance issues. As a

[PHP-DB] Re: Connect to Oracle DB

Frederico Madeia [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] ... How i connect one server running PHP(linux) to other server running Oracle(linux) ?? when i tryed to connect with ora_logon, the server return me: Call to undefined function: ora_logon(). 1) the oracle

[PHP-DB] Re: Oracle and PHP

Roger Spears [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Hello, I was wondering if there are any PHP people out there that are really into using Oracle databases? I've always used mysql but now I find myself in a situation that requires the use of an Oracle database.

[PHP-DB] Re: OCIExecute very slow when Updating rows

Philipp Krueger [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] ... but it still wouldn't work - when i comment OCIExecute out the script works again - which is out of question of course since i need the damn script to execute. when i take the query and paste it in sqlplus

[PHP-DB] Re: Buenos dias - Pregunta Oracle

Quique Notelodigo [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Buenos dias Estoy empezando a trabajar con Oracle y php. Ya he trabajado con Postgres y PHP. Solo tengo una pregunta, muy concreta: Tengo Oracle en una máquina distinta al servidor Linux con Apache+PHP

[PHP-DB] Re: I looking for OCI8 client library files.

Soony [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Hi, phpers.. I looking for OCI8 client library files for using OCI function in PHP to control Oracle DB. I like any information about that. Ask your dba (database administrator). If you have oracle, he would be able to

[PHP-DB] Help with oci dll in PHP

A guy, Filippov Evgeny, mails directly to me with the following question. I answer in this group, to share the problem and the solution. Philippe S. From: evgeny Hi! Excuse please, I have seen your answers and has decided(solved)

[PHP-DB] Re: Help with oci dll in PHP

Warning: ocilogon (): _oci_open_server: Error while trying to retrieve text for error ORA-12538 in c:\inetpub\wwwroot\php\index.php on line 15 ORA-12538 means TNS : no such protocol - you have a problem in your TCP protocol ? - or there is a typo error in your line : $db = (DESCRIPTION =

[PHP-DB] Re: Oracle 8?

Heilo [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Hi there everybody! I'm running Win2000 an Oracle 8 server and PHP. Now - just a simple question: does anybody know any good FAQs or resources/references for specally this topic?? a simple connection to oracle tutorial

[PHP-DB] Re: question in ADODB

yes, but can you tell me how? I have read the manual, but they didn't tell how to do so! Look at testdatabases.inc.php in the adodb release. Basically, you would have to write something like : include(adodb.inc.php); $conn = NewADOConnection('ado_access'); $conn-debug = TRUE; // useful for

[PHP-DB] Re: question in ADODB

I found the following code on the internet. I'd like to know that what I need to do, if I want to use the actually Access file with out the DSN, how to use the Microsoft Jet? thx -- code include(adodb.inc.php); $db =

[PHP-DB] Re: PHP - Oracle 7.3.4 - ORA-12154

I set up PHP on a Sun Solaris box a week ago (see phpinfo output below). It has oracle 7.3.4 and php 4.0.4pl1 so I'm using the --with-oracle configure option. Due to a special module we're using we're stuck with using that php version (4.0.4pl1). Couldn't you use --with-oci, even with

[PHP-DB] Re: Oracle 9.2 + IIS 5.0 + Win2k server + PHP 4.3 + ADODB 3.10

$conn-NConnect('', 'usr', 'usr_pwd', 'TNSName'); # select machines from machinetable NConnect exists in adodb since version 2.43. Have you tried with PConnect() or Connect() instead of NConnect() ? they are older (october 2002), and may be they are more robust ? Is this a bug? Should I

[PHP-DB] Re: How to connect and select data from Oracle 8 Database

I also followed a guide showed on PHP website about ora_do functions. But when I tried that guide it did work. php_oracle.dll (deprecated) : for the ora_* function, like ora_logon for example. php_oci.dll : for the oci* functions, like ocilogon and friends. the oci functions are newest, and

Re: [PHP-DB] Remote Oracle database questions...

DOH!!! I am seriously hoping that I do not need to have the Oracle client installed on the webserver running the PHP queries. I have no idea about the client licensing, and if it involves money in any way it is pretty much out of the question. Oh well... Hopefully I can find out about this

[PHP-DB] Re: How do I list Oracle table names

[EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] I'm very new at this. Is there a way I can list all table names in an Oracle database? I thinl you know how to connect to Oracle via php (simple tutorial : http://www.thickbook.com/extra/php_oracle.phtml) To obtain a list of the

Re: [PHP-DB] Abstraction layer or not?

I'm working on a new site, and I'm wondering whether to use an abstraction layer or not. I don't have any plans to switch DB system, but you never know what the future holds. I figure that there's no reason not to, but are there any down sides? Which abstraction layers are good?

[PHP-DB] Re: Calendar

I want to put an event calendar on my site... Is there anyone her who happens to have a script like this?? Anyone wants to make it?? Or anyone got a link for one that maches my request?? Try http://sourceforge.net/search/?type=softexact=q=calendar+php, it will give you hundreds of scripts.

[PHP-DB] Re: timer

hi to all, how can I set up a timer that will tell me how long a query takes to run. for example, if I run the following query, I would like to know how long it takes. [...] Thanks in advanced Nato I don't remember where I 've found this snippet, but it works well. $TIMER_START =

[PHP-DB] Re: oracle-mysql

How many tables ? do you have the script that generated the oracle tables and their relationships ? what about the triggers, views, foreign keys, ... Are theses functionalities exist on MySQL (I don't know MySQL) ? You could have a look at Chyfo (http://www.ispirer.com/products/). Chyfo can

[PHP-DB] Re: Oracle... Beginner

PHP has to be compiled with the oci8 extension. If you use the win32 binaries of PHP, just uncomment the line extension=php_oci8.dll in php.ini. If your webserver and Oracle are on the same machine, that's all. In the other case you have to install the oracle 8 client onto the machine containing

[PHP-DB] Re: Oracle connection

The oracle extension is not installed. This is why PHP doesn't recognize ora_logon(). So you have to install PHP with oracle extension. BTW, you would prefer installing oci8 extension instead of oracle. oci8 is the newest extension to connect to an oracle 7 or 8 database (see ocilogon() and

[PHP-DB] Re: Help -- Oracle

Have you tried to replace the tnsname with its exact definition ? not the best thing to do, but it could be a workaround. Example : something like : $oracletns = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host =

[PHP-DB] Re: PHP and Oracle

Hi Georgina, If projectID or moduleID is a number and not a varchar, you would remove the ' enclosing the values. WHERE projectID=$projectID vs WHERE projectID='$projectID' Regards, Philippe Georgina Elaine Bailey [EMAIL PROTECTED] a écrit dans le message news: 000801c18272$8189aa10$[EMAIL

[PHP-DB] Re: What software do I need in order to access Oracle database on an NT server from my unix machine?

AFAIK, you need to install the oracle 8 client for linux onto your machine. Unfortunately, it can't be downloaded alone. you need the entire Oracle 8 database release for Linux, available at www.oracle.com Hope I'm not wrong. Please correct me there's an error Regards, Philippe Lallous [EMAIL

Re: [PHP-DB] Oracle via php under windows 2k

and the oracle client installed, what to do now for this work ? Philippe Saladin [EMAIL PROTECTED] a écrit dans le message de news: [EMAIL PROTECTED] If you were using it in linux you would need at last the oracle client installed locally, I don't know in windows. Yes, the oracle 8

Re: [PHP-DB] Oracle via php under windows 2k

If you were using it in linux you would need at last the oracle client installed locally, I don't know in windows. Yes, the oracle 8 client has to be installed onto the server : it's the middleware between Oracle and the client. See your oracle dba. Regards, Philippe -- PHP Database

Re: [PHP-DB] Difference between OCI* functions and ORA_* functions

FYI, You can use OCI8 on a Oracle 7 database, if the net8 client is configured Regards, Philippe B. Perrine [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] ORA are for Oracle7 OCI8 for Oracle8 Read the manual on www.php.net B. le jeu 04-10-2001 at 17:02 Sridhar Moparthy a

[PHP-DB] Re: [Q] PHP on Linux, Oracle on Win32

ora_logon and friends are the old way to connect to Oracle. With Oracle 8, we should use the OCI functions (ocilogon, ...) Philippe Hugh Bothwell [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Donovan J. Edye [EMAIL PROTECTED] wrote in message [EMAIL

[PHP-DB] Oracle and adodb recordcount

Hi, I've read that Oracle (oci8) doesn't support the adodb function RecordCount : it returns -1. Is it true with adodb 1.20 ? is there a smart workaround? thanks in advance, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP-DB] Re: Oracle and adodb recordcount

EOF shoud do the trick for my purpose (just want to know if my select returns a row or not). If not EOF just after a select, this means that the select returns at least one row. No more need to use recordcount. Thanks Philippe. Well, you're welcome, Philippe Regards, ... Philippe Philippe

Re: [PHP-DB] Oracle-PHP (contd.)

Are you sure you need an environment variable to store that? if yes, this script should do the trick : putenv(TNS_ADMIN=/ora1/app/oracle/product/8.1.6/network/admin); --- $tns = getenv(TNS_ADMIN); echo $tns; Regards, Philippe Vandana [EMAIL PROTECTED] a écrit dans le message news: [EMAIL

Re: [PHP-DB] php accessing oracle

If you use PHP on Windows NT, you have to uncomment extension=php_oracle.dll in your php.ini file, and copy php_oracle.dll to winnt\system32. If you have installed Oracle8 client, you can also use php_oci8.dll (even with a 7.3 database), with the OCILogon functions, etc... I don't know what to do

Re: [PHP-DB] php accessing oracle

If you use PHP on Windows NT, you have to uncomment extension=php_oracle.dll in your php.ini file, and copy php_oracle.dll to winnt\system32. If you have installed Oracle8 client, you can also use php_oci8.dll (even with a 7.3 database), with the OCILogon functions, etc... I don't know what to do

Re: [PHP-DB] Return Row count with OCI

ocifetchstatement() should do the trick. It returns the number of rows. See example at : http://dev.nexen.net/docs/php/annotee/manuel_function.ocifetchstatement.php Best regards, Philippe Worawisut Pinyoyang [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] To all PHP-db guruz!

Re: [PHP-DB] connection to Oracle 7.3 with ora_logon()

Thanks to Randall Barber, I've just to uncomment php_oci8.dll or php_oracle.dll in the php.ini file. It works now. I hadn't read enough the docs! Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

[PHP-DB] session.save_path

Hi, in my php.ini file, there is [session] save_path = /tmp When I try to start a session, I have an error : Warning: open(/tmp\sess_62626e8e61a06b3f22c4c1bb82a6c92d, O_RDWR) failed: m (2) in {pathofmyphpfile} on line 31 and Warning: Failed to write session data (files). Please verify that the

[PHP-DB] connection to Oracle 7.3 with ora_logon()

Hello, Newbie to PHP, I try to connect to an Oracle 7.3 database. Is there something special to do to use the oracle functions, as ora_logon?? I obtain a message fatal error : Call to undefined function: ora_logon() SqlNet Client is installed Best regards Philippe -- PHP Database Mailing