[PHP-DB] [Fwd: [PHP-WIN] NSAPI, Win2K and Oracle]

Hi all, I am running PHP as NSAPI plugin in iPlanet Webserver 4.1 No problem there. But I want to use the php_oci8.dll to connect to Oracle. When I use php outside the webserver, I just do dl("php_oci8.dll") and it works. Now the dl() cannot be used inside the Webserver. I added

Re: [PHP-DB] directrory browsing

Ummm a bit more info on your part may be helpful for folk to help you Like in what context your problem lies, using which system and what it has to do with Databases working with PHP Russ #---#

[PHP-DB] PHP Bug or configuration error?

Hallo listmembers, i have a misterious error with php4.0.4 on windows-2000. If i call a script this lines will be displayed in the Adress-Part of my Browsers (IE5.0 Netscape 4.75/6): http://localhost/php/php.exe/test/funwin/normal.php3?show=10 I dont know why "/php/php.exe" is in the Adress. I

RE: [PHP-DB] Using text files instead of a DB

CORRECTION: (removed $ from in front of 250 meg) I use an ISP (http://intercession.net/specialoffers) who provides PHP and MySQL support on an Apache server (Cobalt Linux) for $5 per month...yes, $5 per month. No extra charges for either. 250 meg space. Full FTP. -Original Message-

[PHP-DB] Connecting to Oracle

Hello, I have problems connecting with PHP to Oracle. - Operating system is Windows 95 - Apache version is 1.3.14 - The PHP version is 4.04pl1 (NuSphere 1.13.6) - The line "extension=php_oracle.dll" is active in php.ini - De Oracle Database version is 7.3.4.0.0 - De SQL*NET client version is

RE: [PHP-DB] IBM DB2 connectction problems

If you're running off a unix platform, did you bind your database to CLI? I'm assuming you're trying to connect with CLI and not ODBC (ie you compiled with --with-ibm-db2) Chris -Original Message- From: ManieQ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 7:07 AM To: [EMAIL

RE: [PHP-DB] Using text files instead of a DB

http://phpclasses.upperdesign.com/browse.html/package/52 The above link will take you to a class to manipulate CSV files. This might help you understand file access in php. If you want to maintain a database within a text file using CSV file format may help. If you have specific questions

Re: [PHP-DB] bout mysql

can i grant a user to access two database in mySQL? Yes just use multiple... GRANT PRIVILEGES ON (or database you want to grant) TO user@"%" IDENTIFIED BY 'user_pass' does mysql has function DECODE like oracle ? don't know sorry how can i know which table or database that user can

Re: [PHP-DB] PHP Bug or configuration error?

Hi Pierre... I think the problem is, that you have configured php as cgi-apliction, and not as an ISAPI module. I'm not sure how to configure PHP this way (cause we run only linux - server, and no IIS..) but this should be the problem. Greetings, Stefan Siefert Hallo listmembers, i have a

[PHP-DB] Error prevention

I'm baffled (again ) In my mql database I'm doing: SELECT cl_login FROM client WHERE cl_login = "xxx"; and if "xxx" exists I get the result xxx while if it doesn't exist I get an empty string. In PHP I'm doing $querytest = "SELECT cl_login FROM client WHERE cl_login = '$txtLogin';";

RE: [PHP-DB] Error prevention

Hi Martin, ... you forgot to 'mysql_fetch_row' or 'mysql_result'. Read about it in the PHP-Manual in the MySQL Functions. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstrae 20

[PHP-DB] connecting to sybase

I have some difficulties trying to connect to a sybase-db using sybase_connect funciton. I have included the dll's from www.sybase.com, but I still get this warning. Warning: Sybase: Unable to allocate connection record in c:\internweb\html\trond\sybase.php on line 21 Is there anyone who have

Re: [PHP-DB] IBM DB2 connectction problems

OK, here are some important details about my system: 1. Linux (Mandrake 7.2) 2. Apache 1.3.14 (from distribution) 3. jre118 (rpm, IBM version) 4. IBM DB2 V7.1 Installed with default logins, directories, etc. 5. Added '/usr/IBMdb2/V7.1/lib' to '/etc/ld.so.conf'; 'ldconfig' executed 6. PHP

[PHP-DB] Newbie: MSSQL under PHP4?

Hello all, I'm an ASP centric webdeveloper moving to Linux and have made the first fwe baby steps in that direction. While I have a Linux server configure with Apache, PHP4 mySQL, I have need to use PHP4 under IIS 5.0 using an existing MSSQL 2000 db. Now I've downloaded

RE: [PHP-DB] Newbie: MSSQL under PHP4?

Built-in support under Windows version 4.0.4pl1 should be ODBC and MySQL. You need to uncomment driver mssql7.dll to connect using SQL Server driver. We use the ADODB library at http://php.weblogs.com/ADODB. I think you'll like its approach coming from ASP. Michael J. Upchurch Partner2Partner

[PHP-DB] connection id in mysql

Does any body know why the connection id in mysql will increase when you exit the mysql and login again? But I think the connection id should be cleared when user exit mysql. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

RE: [PHP-DB] Error prevention

Michael Rudel wrote: Hi Martin, ... you forgot to 'mysql_fetch_row' or 'mysql_result'. Read about it in the PHP-Manual in the MySQL Functions. Thanks Mike (and everyone else who pointed this out), Sometimes you're blind. When you think you pass the "complete-and-utter-newbie" phase

[PHP-DB] add a column to a table via PHP

Hi, I'm probably being a bit lazy asking what I should be able to figure out, but here goes anyway: What I want to do, in response to certain other actions having taken place, is add a column to a mySQL database (FocusShop) table (Prices) and set the default value of that column and update all

Re: [PHP-DB] Connecting to Oracle

I'm not looking forward to this... Due to circumstances beyond my control, I will be forced into a similar configuration soon. Try putenv("ORACLE_SID=WKDS.world"); If your sqlnet.ora does does not specify .world as the default domain, then that may be the problem. Was your TNSNAMES.ORA file

[PHP-DB] classes and operator

Hi, Has anyone done any work with classes in php, I have a large project using them, but all of a sudden a script I have crashes IIS (btw, I'm using WIN2K, PHP4), I would like to know if any of you have experienced this?, the funny is , by chance I tried to take off the operator from one of

RE: [PHP-DB] add a column to a table via PHP

The following assumes you've already selected the database and that $column contains the name of the new column and $defaultvalue is the value to be set. $query = "ALTER TABLE Prices ADD $column DEFAULT \"$defaultvalue\""; mysql_query($query) or die("Can't add column to Prices"); $query =

RE: [PHP-DB] add a column to a table via PHP

Thanks, Not being as lazy as I thought, I had coded this shortly after sending the e-mail. I was been really lazy as it only took a few moments thought and typing!!! Mr. Lazy! Thanks again. Martin -Original Message- From: ME [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 19:37 To:

[PHP-DB] parse error

what is a parse error?

RE: [PHP-DB] Using text files instead of a DB

Sir, you did NOT follow the link I mentioned: http://intercession.net/specialoffers. This offers the web-hosting at %59.40 for the year. Instead you followed the link on http://intercession.net. -Original Message- From: Steve Brett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13,

Re: [PHP-DB] add a column to a table via PHP

Yes, you're quite right. Mea culpa... -Original Message- From: Sean Finkel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 7:56 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] add a column to a table via PHP Wouldn't you also need the datatype of the new column (ie. Varchar)?

[PHP-DB] password checker - thanks

How do I add a password checker, so that the php checks the e-mail and password combo, and if not correct, does not allow user into the site? Using a pop up java window to frame the php scripts. Following is the portion of the script checking the email, and allowin subscribe / unsubscribe, etc.,

[PHP-DB] How to get rid of $PHP_AUTH_USER value?

I would like to make a php script that remove the values associated with $PHP_AUTH_USER and $PHP_AUTH_PW whenever a user accesses it. I tried unset($PHP_AUTH_PW), i tried sending a 401 header with the No cigar statement in it (header('HTTP/1.0 401 No cigar')) but it doesn't work: i still get in

[PHP-DB] mysql data into array

I fairly new to php and have a question about mysql and arrays. What I am trying to do is pull multiple rows of data out of a mysql database and I need to use that data as input for another table. I have tried to use mysql_fetch_array and have it write to the new table inside a while loop,

[PHP-DB] Newbie Question - Importing a table

I'm new to MySQL and am having trouble importing a table. The table is a text file. Where I think I'm having trouble is on the options. The table has no text delimiter and uses "," as a field separator. Where I think I'm having problems is with the options. What I'm using is [-c,

Re: [PHP-DB] Connecting to Oracle

Joe, I have had some tough problems changing SIDs in oracle via PHP. If your tnsnames.ora file correctly defines the SID, you may not need to declare it again via PHP. if you run phpinfo(), see if these values are already defined, and then try to connect with default values... -- ""Joe

[PHP-DB] SHOW COLUMNS

Im trying to use the SHOW COLUMNS Syntax from mysql in the folowing code. It is returning nothing.The Table name is correct and there are records in the table (not that that should matter).I dont get an error.I posted to php.general and got no response. ?php require("Connection.php");

[PHP-DB] Re: Connecting to Oracle

Hey, I'm using Oracle with PHP. I never could get the blasted thing to work right. What I ended up doing was something similar to this: $db = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.68.10.1)(PORT=1521))(CONNECT_DATA=(SID=TEST)))"; $conn = OCILogon("scott", "tiger", $db); From what I

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

Brian, Thanks for the solution, that is a good one. I imagine you can set the environment variable oracle_sid this way also. ORACLE_SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.68.10.1)(PORT=1521) )(CONNECT_DATA=(SID=TEST))) re: TNSNAMES.ORA It seems to be a fairly common occurence where

RE: [PHP-DB] Using text files instead of a DB

On 13 Mar 01, at 9:43, Robert V. Zwink wrote: http://phpclasses.upperdesign.com/browse.html/package/52 Thanks for this. Very simple and straightforward, but I don't see much in there that helps me. The above link will take you to a class to manipulate CSV files. This might help you