[PHP-DB] storing checkbox data in DB - very cool

hi all, I read this great article about storing checkbox data in a DB, it looks very useful to me. [generates checkbox form from DB and then allows inserting and editing] http://phpbuilder.com/columns/laflamme20001016.php3?page=1 I am having trouble figuring how to get the stupid thing to wo

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 unde

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

[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 c

[PHP-DB] InterBase 6, PHP & Windows 9x

Hi there, I would like to know if it is possible do develop a Interbase-driven web site with PHP under Windows 98. If it's possible, which web server do you recommend? Any guidelines or on-line docs I should read? Many thanks in advance, Jorge Alvarez -- PHP Database Mailing List (http://w

[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. THANKS Mike P [EMAIL PROTECTED] -- P

[PHP-DB] Interbase INSERTION error?

hey all.. I really don't get why I am getting this error.. Can somebody help me out? what does a parse error mean? Error: Parse error: parse error in /home/httpd/html/test/php-test/CVzenden.php on line 35 CVzenden.php: $conn=ibase_connect("localhost:/home/httpd/html/test/php-test/CV.gdb", "SY

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 Brown"

[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, --columns

[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, but

[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 th

[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., b

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)? :

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

Wouldn't you also need the datatype of the new column (ie. Varchar)? :-) - Sean Finkel - [EMAIL PROTECTED] |H|eretik - Pain in the ass for Clan |H|avoc http://www.webdrenalin.com/ubbcgi/ Webmaster - R

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, 200

[PHP-DB] parse error

what is a parse error?

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: [EMA

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 = "UPDA

[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] 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 ftp

[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 ex

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 som

[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, e

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 Co

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

so ... Virtual Web Site Hosting* 250 MB - $199.99/year & one time setup fee. if i divide 199 by 12 i get 5 -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 14:39 To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Using text files ins

[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

[PHP-DB] Sure it's simple but.............

I've got a several links(each with a seperate article number) on a page which call the following cms/offer.php?new=yes offer.php is only offers except when new exists when new.php is included Up to here no problems but in new I've got a loop which includes a form field. I want this form field wi

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 4.0.3

[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 ex

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 Bleicherstraße 20 D-

AW: [PHP-DB] Naming cookies

Hi Tristan, I'm not sure about this, but try to use ob_start() at the beginning. This tells php to execute the page in cache and put it to the client when it's execution is finish. It enables you, to use cookies not only before html, but from every position in html... maybe this works... Stefan

[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';"; $testr

[PHP-DB] Naming cookies

Afternoon guys and girls I have a queston regarding cookies... I have a login form that takes the member name and password from a MySQL Database. I have three fields: member pw userlevel I want to set a cokkie to remember the user and thier user level, so I named the cookie - authlevel$use

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

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 ac

[PHP-DB] Really strange behaviour of PHP with Sybase ASE 11.9.2 + ODBC + Linux

Hi there... I have experienced really strange behaviour of PHP and Sybase. Our configuration: Linux (Suse Linux 7.0), Apache 1.3.17, PHP 4.0.4pl1, Sybase ASE 11.9.2 on an Linux Box, unixODBC with a Sybase ODBC - Driver. It was hard work, to get this working, but after some time we got it runnin

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 don'

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 PR

[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 2.3

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- Fr

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

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- From: David W. Fenton [mailto:[EMAIL PROTECTED]] Se

RE: [PHP-DB] please help

This error means that mysql is not installed. Or that the module which links PHP and mysql is not installed. I ahd the same error in my RedHat 5.2 machine. Unfortunately, there was no RPM for to provide this interconnectivity between PHP and MySQL. I upgraded to RedHat 7.0; installed the MySQL

Re: [PHP-DB] serialize

do you have register_globals enabled in your php.ini? you also have to have the class definition available when unserializing it to properly reconstruct the class with all the methods. if you're using PHP4 it's quite handy to use the built-in session functionality to implement persistent classes.

[PHP-DB] Session variables

I'm experimenting with sessions and note that you seem to able pass a query result id via an include but not via an . Is this correct or have I got it wrong? Do I need to do something to $session[result] before passing it via ? Example scripts: session.phtml: $connection = mysql_connect($DBHost,

[PHP-DB] bout mysql

Hello php-db, can i grant a user to access two database in mySQL? does mysql has function DECODE like oracle ? how can i know which table or database that user can access if i am admin ? -- Best regards, andrie mailto:[EMAIL PROTECTED] -- PHP Database Ma

[PHP-DB] ANN: OpenLink Press Release

Hi PHPers, OpenLink is pleased to announce the commercial availability of its new version 4.0 high-performance ODBC Drivers for PHP. Features Summary: ODBC 3.5 Compliance JDBC 2.0 Compliance Multithreaded Drivers for ODBC and JDBC Full Scrollable Cursor Model implementation, including Mixed and

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

Ron, Good points all, and I was looking at the issue from a stand alone server, plus experience with only one ISP which provides MySQL services. The $50 monthly fee still seems pretty steep. Can you give us an idea of how RAM requirements scale with database size, and what is reasonable to ex

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

are the settings for iis correct ? it may be the fact that windoze can't find the php ('cos the pah isn't right in iis settings) and is looking in the current dir ... looks a bit strange though . in the php install dir there is an install doc that details the changes that the php installer make

Re: [PHP-DB] IBM DB2 connectction problems

hello, > $i = odbc_connect( "sample", "db2inst1", "ibmdb2" ); I changed, but got same (= none) result. > Please provide more detailed information on the SQL error and SQL state. > Otherwise it is not really easy to tell, what the problem is. Well, as I posted, my SQL error is null and state is r

[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

[PHP-DB] serialize

Hello php-db, if i have a class class myDog { VAR $name; Function bark(); } $dog = new myDog; and i want to pass this class over page. someone in this forum said to me to use serialize and pass it using cookies. setcookie("dog", $dog); the que

[PHP-DB] dbx module (database abstraction) available

Hi! The dbx module (database abstraction module in C, supports ODBC and MySQL (for now :-)) is available at http://www.guidance.nl/php/dbx/ Source is available in zip and tar.gz formats. Documentation (both user docs and docs about extending the database support) is also available is zip and tar

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] directrory browsing

Hello I want to see all *.jpg AND *.gif in a directory. Can Somehelp me, please. Thx Walter Franssen http://waltersworld.nl -- 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 adm

[PHP-DB] test

fdsfds -- 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] [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 extension=ph