[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 just getting into PHP, and have found that as a PHP code editor, Dreamweaver works pretty well (with the extension I installed). My question is this, whenever I save an include file with the .inc extension, all of the color coding goes away, as does the PHP tab on the tool bar. Is there any way to make Dreamweaver see a .inc file as a PHP file? I looked on all the menus and in the preferences, but I couldn't find an obvious way to do this. Thanks! Susi Sloan ___ GRASS ROOTS SOFTWARE 350 Crown Point Circle, Suite 225 Grass Valley, CA 95945 1-877-274-7277 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 with both susseffuly, but when i try to connect with php can't. I have a Apache server with php 4.2.2 i'm trying the follow code: ? if ($conn=Ora_Logon( [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] , webmaster)) { echo BSUCCESS ! Connected to databaseB\n; } else { echo BFailed :-( Could not connect to databaseB\n; } Ora_Logoff($conn); ? And the error is: Warning: Oracle: Connection Failed: in C:\FoxServ\www\conectar.php on line 2 Failed :-( Could not connect to database Warning: ora_logoff(): supplied argument is not a valid Oracle-Connection resource in C:\FoxServ\www\conectar.php on line 7 Have you tried the newer oci8 extension, instead of the oracle one ? you need the oracle client installed onto you php server (I think it is already there, as you said your SQLPLUS is working correctly, but I'm not an oracle guru ;-( ), and uncomment php_oci8.dll instead of php_oracle. After that, you would be able to connect to your remote oracle db using ocilogon instead of ora_logon. Hope this helps. Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 test/demo system then having them on the same box is perfectly acceptable and removes some of the setup issues. The standard oracle (--with-oracle) extension provides basic oracle connectivity for versions 7, 8, and 9. The oci8 (--with-oci8) allows for Oracle 8i (and up) specific functions (LOBs and others). Just a note ... Your experience is interesting, thanks for the info Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 extension is not loaded. You need to compile php with it. BUT, you should use --with-oci8 and not --with-oracle. The oracle extension (ora_logon function and friends) is an old one, it can only connect to an oracle 7 database. With the oci extension (ocilogon function and friends), you can connect an oracle 7, 8 or 9 database (see http://fr.php.net/manual/en/ref.oci8.php) May be http://www.enderunix.org/documents/eng/php_oracle_en.html could help you too. 2) php compiled with oci extension is not enough. You need the oracle client. Unfortunately, for Linux, you can't download it alone. You need to download the entire oracle database : see http://otn.oracle.com/software/content.html or ask your DBA : he should be able to give you this oracle client for linux. In php.net describe some functions to connect to oracle,. but how i make to do work ??? I must install oracle on same server that runing php ?? no, you can have two servers. Tanks. Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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. Sure, most of our developments are under Oracle/php I've printed out the information posted by Thies C. Arntzen titled Making Efficient use of Oracle8i thru Apache and PHP 4 but I was wondering if I may see some other code examples. Very basic examples In my case, I don't use directly the oci functions, but I use ADODB, which is a wrapper, an abstraction layer. Thus, I code the same things, under Oracle or MySQL. See http://php.weblogs.com/adodb_manual Other abstraction layers exist : adodb, pear-db, metabase, etc. dealing with connections, queries and the such. Also, is there an application for Oracle databases that is similar to PHPMyAdmin for mysql databases? yes, you would try http:///phporacleadmin.org/ Thanks, Roger Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 to execute it manually everything goes as planned. i'm beginning to get desperate here... any ideas why it won't work? Sorry, I don't have an idea for you, but may be you would find help in the document Making efficient use of Oracle8i thru Apache and PHP 4 : http://conf.php.net/pres/slides/oci/paper.txt Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 ¿Puedo desde PHP acceder a Oracle? Yes, you can connect to a remote oracle. But you need the oracle client installed onto your servidor Linux con Apache+PHP. He leido en php.net que hay que compilar PHP para tener acceso a oracle, con --with-oracle[=DIR] donde DIR es ORACLE_HOME pero no se que poner ya que el Oracle esta en otra maquina, en la red local. ORACLE_HOME will refer to your oracle client. ¿Puede ayudarme? may be this link would help you : http://dehaese.free.fr/ Muchas gracias Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.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 give you this oci8 client (located on the oracle cd). Or, you can download from http://otn.oracle.com/software/content.html the entire oracle 8 db (500 Mb!!). The oci8 client is inside of it. AFAIK, it is impossible to find only the client. Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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) that can be you to me will help. Server DB - serverORACLE 9.2. Web-server - Win XP, IIS 5.1, PHP 4.3.2, client ORACLE 9.2. environment variables oracle_sid=test1 oracle_home=c:\oracle\ora92 nls_lang=american_america.cl8mswin1251 tns_admin=c:\oracle\ora92\network\admin load php_oci8.dll oci8 OCI8 Support enableds Revision $Revision: 1.183.2.5$s db = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST =192.168.1.9) (PORT=1521)) (CONNECT_DATA = (SERVICE_NAME=test1))) ; con=OCILogon (test, test, $db); Gives out a mistake 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 How to establish oci connection? Filippov Evgeny -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 = (ADDRESS = (PROTOCOL = TCP) (HOST =192.168.1.9) (PORT=1521)) (CONNECT_DATA = (SERVICE_NAME=test1))) ; Here is what I use in my case : $db= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = ip_address) (Port = 1521) ) (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = ip_address) (Port = 1526) ) ) (CONNECT_DATA = (SID = ORCL) ) ) ; Note the difference in CONNECT_DATA. Would it come from that ? Hope it will help. Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 : http://www.thickbook.com/extra/php_oracle.phtml a webbased Oracle Object Manager : http://phporacleadmin.org/ a course Making efficient use of Oracle8i thru Apache and PHP 4 : http://conf.php.net/pres/slides/oci/paper.txt Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 test $access = '\path\to\mydatabase.mdb'; $myDSN = PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=$access;USER ID=;PASSWORD=;; $conn-PConnect($myDSN, '', '', ''); $recordSet = $conn-Execute('select * from products'); if (!$recordSet) { echo $conn-ErrorMsg();} Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 = NewADOConnection('mysql'); Look at the adodb manual : http://php.weblogs.com/adodb_manual $db = NewADOConnection('access'); (Microsoft Access/Jet. You need to create an ODBC DSN) or $db = NewADOConnection('ado_access'); (Microsoft Access/Jet using ADO. Allows DSN-less connections. For best performance, use an OLEDB provider.) Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 that php version ? it's the newer and better module for oracle (both oracle 7 and 8). Look at ocilogon() function and friends. At first I was getting the ORA-12154 TNS:could not resolve service name error almost every time. I then followed the instructions to set the ORACLE_HOME and TNS_ADMIN environment variables in apaches http.conf. I've also tried using the putenv function to set the variables. I had also trouble with ora12154. I use now a workaround : when I use : $connection = OCILogon($user, $pass, $tns) or die(No Connection); for the third parameter ($tns), I don't use the name found in tnsnames.ora, but directly the entire syntax something like : (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = ip address) (Port = 1521) ) (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = ip address) (Port = 1526) ) ) (CONNECT_DATA = (SID = ORCL) ) ) Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 try ADODB 2.5 instead since it's listed as being more stable on the site? I use without any problem adodb 3.10, but with oracle 7.3. IMHO, I don't think adodb 2.5 would help you. Have you posted a message in http://phplens.com/lens/lensforum/topics.php?id=4 ? Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 better than the older ora functions. I suggest you to avoid using php_oracle.dll. With php_oci.dll, you can access both oracle 7 and oracle 8 databases. It had error Unable to load dynamic libaray - 'C:\php\extensions\php_oracle.dll' - The specified module could not be found. When I tried another DLL php_oci8.dll. I also met that erro. In fact those files DLL are already existed. I don't know why. You have to uncomment php_oci.dll in php.ini if you are on windows Maybe it needs some configurations but I don't know how to configure. the oracle client is needed : your dba should be able to help you to install it. You can download it from www.oracle.com. See http://www.thickbook.com/extra/php_oracle.phtml for a simple tutorial Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 stuff from one of our DBAs. You definitively need the oracle client installed onto your webserver. Don't worry, you should find it for free, AFAIK. Ask your dba, he would be able to help you. Otherwise, you should download it from www.oracle.com (download / archived products / oracle8). you can't download just the client, you have to get the entire oracle (500 Mb!!). database to perform my query? I notice that there is a Oracle function in PHP called ora_logon. This function description mentions something about about Ora_logon : this comes from the old oracle extension (php_oracle.dll). You would rather use Ocilogon and friends, from the newer php_oci.dll. It's much better. oci* functions can be used against a Oracle7 or an Oracle8 database. ora$ functions are limited to Oracle 7, and with less features. Finally, try this simple tutorial http://www.thickbook.com/extra/php_oracle.phtml to connect to Oracle. An other one at http://www.phpworld.com/articles/2000.03/oracle_000.html. See also http://phporacleadmin.org/ to manage a remote oracle database. hope this helps ! Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 tables, just execute this query : select table_name from sys.all_tables where owner = 'MYOWNER'; Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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? well, any down side ? may be slower for example. So, if you don't plan to switch db system, the speed of the layer could be your criteria. ADOdb is a good one. PEAR also has an abstraction class. Once you get used to using them, they make things easier over all. I've never actually switched databases with them, so I don't know how much easier it makes that. I find them ideal for error catching and reporting. I agreed. ADOdb (http://php.weblogs.com/ADODB) is quite nice, fast, (the fatest ?) and very helpful even if you don't change db. See benchmark at http://phplens.com/lens/adodb/. Well, it's from adodb, may be you would find an other one written by those using pear_db. Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 = explode( , microtime()); $TIMER_START = $TIMER_START[1] + $TIMER_START[0]; ## Do some stuff here: $TIMER_END = explode( , microtime()); $TIMER_END = $TIMER_END[1] + $TIMER_END[0]; echo br, $TIMER_END - $TIMER_START, secs; Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 export data from any database accessible through the ODBC interface. It exports data into text files (CSV, TAB delimited, fixed length, SQL INSERT statements and XML are supported formats), generates native DDL (Data Definition Language) and import/load scripts for various databases. See also Genio (http://www.hummingbird.com/products/dirs/genio/index.html), and http://www.quest.com/schema_manager/index.asp Regards, Philippe Pedro M. S. Oliveira [EMAIL PROTECTED] a écrit dans le message news: 006c01c1d009$6fd83d10$[EMAIL PROTECTED] hi all, i need to migrate an oracle database (+-1gb) to a mysql one, but i don't have a clue how to do this. i'm thinking in dumping the whole content of the oracle database to a txt file but i don't know if there is a better way any ideias on this one. btw the oracle machine is running on windows 2000 server and the mysql one is running on linux i don't have php on either machines but the mysql i'll have a connection to an apache running machine. the prob here is... what is the better way to migrate the data? thanx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 your webserver. This oracle 8 client is set up with the Oracle Installer. To create databases, you can use the oracle tools (oracle navigator, server manager, ...). To access them from PHP, you would see http://www.thickbook.com/extra/php_oracle.phtml for a simple tutorial. The php function to log to oracle is OCILogon. Note that in my case, I've trouble using OCILogon with its third argument, for example '@mydb'. I have to use the complete syntax you found in the oracle file tnsnames.ora. Hope you won't have this problem. Otherwise, search Googles for a lot of threads about it. One more thing. If you hear about oralogon function and friends, they refer to the oracle extension of PHP. In your case, you should use the latest one, i.e. oci8 extension (php_oci8.dll). Oracle extension (php_oracle.dll) was used for Oracle 7 databases. Hope it will help you ! Best regards, Philippe Todd Williamsen [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] I would like to try Oracle as a backend. I do have a copy of Oracle 8 server, Oracle Application Server, Oracle Internet Commerce Server. I am running Windows 2000 server, so all these will and should run on Win2k. I never used Oracle, so I would like to know: 1. What is the procedure of logging into the DB 2. creating databases 3. Default username and password I don't necessarily need the info off the bat, but more like where to look for this information I looked all over Oracle's website and I tell you its crap, just like Microsoft's search engine...sucks! Anyways, any help would be much appreciated! Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 friends). Regards, Philippe Paulo Cesar [EMAIL PROTECTED] a écrit dans le message news: 003201c1ad7c$4fe14d80$[EMAIL PROTECTED] I'm trying to connect to a Oracle database but i'm receiving the following error message in the browser: Fatal error: Call to undefined function: ora_logon() in /home/httpd/html/restrito/testes/teste_bd.php on line 17 I'm starting to learn PHP now, so I don't know what does it means or what I need to do to make it work -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 = 201.1.1.445) (Port = 1521) ) (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = 201.1.1.445) (Port = 1526) ) ) (CONNECT_DATA = (SID = ORCL) ) ); // instead of $oracletns = mydb_tcp $Conn=OCILogon($oracleusername, $oraclepassword,$oracletns) or die(connexion impossible); Regards, Philippe Yuwin [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Help, i'm trying to connect to a remote oracle database from win98/apache/php4 and win2k/iis/php4 but it always gives me tns error. Other apps however, works fine with the tns configuration. the php oracle module was loaded successfully on both platforms. I've tried all sorts of possibilities. path to tnsnames.ora is correct. I've even tried with ODBC but when i used it with php, i get server refused connection. However, ODBC test was successfull and other apps can work with it. Thanks in advance. -- yuwin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 PROTECTED] Can anybody help me! I've been getting a error message like this for the last few days. Warning: OCIStmtExecute: ORA-01722: invalid number on line 49 Array Every time I try to enter a project using a HTML form Line 49 in apparently the line that says: $result = OCIExecute(ins_statement); Below is the code I am trying to use: //insert relevant values into the project table $insert = insert into PROJECT values ('$projectID', '$moduleID', $keyID, '$title', '$originator', '$softwareHardware', '$specialSkills', '$status', '$externalAgreement', '$background', '$tasks', '$steps', '$references'); //formulate the query $query = select projectID, moduleID, title, originator, softwareHardware, specialSkills, status, externalAgreement, background, tasks, steps, references from PROJECT WHERE projectID='$projectID'; //parse the two statements $ins_statement = OCIParse ($connection, $insert); $qry_statement = OCIParse ($connection, $query); //execute the first insert statement and print error message if there is an error $result = OCIExecute($ins_statement); if (!$result) { echo OCIError($ins_statement).p; exit; } //execute the query statement OCIExecute($qry_statement); //retrieve the results of the query statement and present them in the following way while (ocifetch($qry_statement)) { etc.etc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Hello. I have a unix box which doesn't have anything related to Oracle installed on it. Now I have another remote machine: NT w/ Oracle Server 8. What software/Libraries do i need to install on my linux box in order to access Oracle database on that NT machine? Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle via php under windows 2k
See http://www.thickbook.com/extra/php_oracle.phtml for a simple tutorial. Note that in my case, I've trouble using OCILogon with its third argument, for example '@mydb'. I have to use the complete syntax you found in the oracle file tnsnames.ora, something like mydb.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = IP address) (Port = port 1) ) (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = IP address) (Port = port 1) ) ) (CONNECT_DATA = (SID = oracle ID) ) ) Hope this helps. et bon courage ! Philippe Titanesk [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] ok, that was already done, ive an Oracle server with database on a computer and on another i ve apache + php +oci8 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 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 Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 écrit : Hi All, Does any one know the difference between OCI* functions from PHP_OCI8.DLL and ORA_* functions from PHP_ORACLE.DLL? Which one is better in terms of speed and which one is better for future compatibility?. Thanks in advance Sridhar Moparthy. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 PROTECTED]">news:[EMAIL PROTECTED]... G'Day All, I need to establish connectivity between a Debain Linux box running PHP 4.06 and Oracle 8i running on a Win32 box. Can someone point me at some FAQ's or other help. At present I have managed to get MS-SQL 2K going using TDS (Tabular Data Stream). Could TDS also be used for Oracle? .. I'm not an expert on Oracle by any means, but what is wrong with ora_logon(user@tns, pwd); using the standard PHP Oracle drivers? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 Saladin [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] 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 commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 PROTECTED] With reference to my previous problem in connecting to the oracle database, I found out some additional information. I defined the TNS_ADMIN variable in the startup file and added this line to my php-script: putenv(TNS_ADMIN=/ora1/app/oracle/product/8.1.6/network/admin); and when I tried to echo this variable echo($TNS_ADMIN); The value is not being printed, it is not defined.When I tried the same thing at the command prompt the value was defined.What is the reason that the value of TNS_ADMIN is not being available to the php-script. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 on another platform, sorry. Best regards, Philippe Martin Langlois [EMAIL PROTECTED] a écrit dans le message news: 9go9fn$1e3$[EMAIL PROTECTED] I want to make a query from a oracle database with php. That's what I do: $link=Ora_Logon(user,1234); $query = select * from sales; $cursor = ora_do($link,$query); while(ora_fetch($cursor)) { print $cursor; } I have an arror, it's doesn't recongnize ora_logon() function. Do i have to include something special? -- Martin Langlois Programmeur-analyste Inter.net Canada 5252, boul. de Maisonneuve Ouest bureau 200 Montréal,Qc H4A 3S5 http://www.ca.inter.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 on another platform, sorry. Best regards, Philippe Martin Langlois [EMAIL PROTECTED] a écrit dans le message news: 9go9fn$1e3$[EMAIL PROTECTED] I want to make a query from a oracle database with php. That's what I do: $link=Ora_Logon(user,1234); $query = select * from sales; $cursor = ora_do($link,$query); while(ora_fetch($cursor)) { print $cursor; } I have an arror, it's doesn't recongnize ora_logon() function. Do i have to include something special? -- Martin Langlois Programmeur-analyste Inter.net Canada 5252, boul. de Maisonneuve Ouest bureau 200 Montréal,Qc H4A 3S5 http://www.ca.inter.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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! I'm novice on Oracle(OCI).In mysql has mysql_num_rows(). When i try to find OCI function about num rows i see OCIRowCount(). But in the manual told me that it cannot use with select statement. How can i know the number of selected row? Thanks in advance -Worawisut -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 current setting of session.save_path is correct (/tmp) where is the tmp folder? do I have to create it? Thanks in advance, Best regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]