[PHP-DB] Re: Oracle/PHP Issue

2003-12-04 Thread Justin Patrin
I'm using the descriptor type of connection and it looks a bit different than yours. Try changing your CONNECT_DATA setion to: (CONNECT_DATA = (SID = BDB1) (GLOBAL_NAME = BDB1.world)) Paul Miller wrote: Hello, I am having a strange issue with Oracle and PHP. I am running PHP Version 4.3.4 on

[PHP-DB] Oracle/PHP Issue

2003-12-04 Thread Paul Miller
Hello, I am having a strange issue with Oracle and PHP. I am running PHP Version 4.3.4 on Red Hat AS 2.3 and trying to connect to Oracle 9i also on Red Hat AS 2.3. I compiled PHP successfully with OCI and oracle. My script uses the ocilogon($user, $password, $db); or ora_logon($user.'@'.$db, $p

Re: [PHP-DB] International Addresses and Telephones

2003-12-04 Thread Hans Lellelid
I have a form which captures US addresses ( address, city, state ) and telephone numbers ( 10 digit ) and am writing this data to a MySQL table. I need to expand this to capture non-US info, so I was hoping for some guidance on forms and table structures. I have googled this to death and still hav

[PHP-DB] Nevermind [was: [PHP-DB] Problem with mail()]

2003-12-04 Thread jeffreyb
Forget my post of a few moments ago - sudenly, it is working. Must be gremlins in the server. Sorry for the wasted bandwidth. Jeffrey Baumgartner From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date sent: Thu, 04 Dec 2003 20:34:26 +0100 Priorit

[PHP-DB] Problem with mail()

2003-12-04 Thread jeffreyb
I have an if statement which includes two mail() functions. Curiously, the second one works, in that it results in e-mails being received. But the first doesn't - and I cannot for the life of me figure out why. The code is below. It is part of the final sequence for registering for an on-line

Re: [PHP-DB] Dumping database/restoring

2003-12-04 Thread John W. Holmes
Dillon, John wrote: [from a post by Jon Benson on http://www.mysql.com/doc/en/mysqldump.html] It worries me that --opt includes a add-drop-table command. Since it is creating a new file, how does this affect anything. I just don't want to delete anything. Is it relevant on restoring only? Do yo

Re: [PHP-DB] PhpmyAdmin from external computers

2003-12-04 Thread mike karthauser
> I goto http://serverIP/phpmyadmin/index.php - and it logs me > inautomatically as localhost, i can see the database lists on the side panel > etc. > > I click on a database or create a new database and the login screen comes > up. > > I try entering the root password and username, but it just

Re: Fw: [PHP-DB] PhpmyAdmin from external computers

2003-12-04 Thread Richard Davey
Hello Andy, Thursday, December 4, 2003, 3:27:11 PM, you wrote: AL> Im afraid ive already tried that. Are you sure your MySQL server is actually configured to ALLOW someone to login remotely? I know most of the ones I work with aren't. This isn't a setting you'll find in phpMyAdmin btw. Most MySQ

[PHP-DB] postgresql and unicode

2003-12-04 Thread Didier Bretin
Hi, I would like to connect to a postgres server which is configured in unicode with php. In java, when I do the connexion, I specify the charset at the connexion. Apparently I have no option in pg_connect() function to specify this. How can I do this ? By the pg_set_client_encoding() function ?

Re: [PHP-DB] PhpmyAdmin from external computers

2003-12-04 Thread Daniel Brunner
Hello!! You need change your "Usernames'" host to your IP or simply change it to % (Any host). This is all changed in MYSQL. Good Luck!! Dan On Dec 4, 2003, at 9:36 AM, [EMAIL PROTECTED] wrote: Hello Andy, Thursday, December 4, 2003, 3:27:11 PM, you wrote: AL> Im afraid ive already tri

[PHP-DB] International Addresses and Telephones

2003-12-04 Thread Rankin, Randy
I have a form which captures US addresses ( address, city, state ) and telephone numbers ( 10 digit ) and am writing this data to a MySQL table. I need to expand this to capture non-US info, so I was hoping for some guidance on forms and table structures. I have googled this to death and still have

[PHP-DB] PhpmyAdmin from external computers

2003-12-04 Thread Andy Levy
Hi I have phpMyAdmin installed on my red hat 8 box with mysql 3. It works fine on that computer and phpmyadmin gives me full access to the database. However, when i connect to that computer from my windows computer and go to the phpmyadmin url it wont let me do anything. Ive set all the priveleg

Fw: [PHP-DB] PhpmyAdmin from external computers

2003-12-04 Thread Andy Levy
Im afraid ive already tried that. - Original Message - From: "mike karthauser" <[EMAIL PROTECTED]> To: <> Sent: Thursday, December 04, 2003 3:10 PM Subject: Re: [PHP-DB] PhpmyAdmin from external computers > > I goto http://serverIP/phpmyadmin/index.php - and it logs me > > inautomati

Fw: [PHP-DB] PhpmyAdmin from external computers

2003-12-04 Thread Andy Levy
I do not get an error message as such. I goto http://serverIP/phpmyadmin/index.php - and it logs me inautomatically as localhost, i can see the database lists on the side panel etc. I click on a database or create a new database and the login screen comes up. I try entering the root password a

Re: [PHP-DB] PhpmyAdmin from external computers

2003-12-04 Thread mike karthauser
> However, when i connect to that computer from my windows computer and go to > the phpmyadmin url it wont let me do anything. Ive set all the priveleges > to allow full access in every way, but it still wont let me access it What error do you get? -- Mike Karthauser Managing Director - Bright

Re: Re[2]: [PHP-DB] cookies

2003-12-04 Thread Maris Kalnins
thanks a lot Richard, now it's completely clear for me! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re[2]: [PHP-DB] cookies

2003-12-04 Thread Richard Davey
Hello Maris, Thursday, December 4, 2003, 12:24:10 PM, you wrote: MK> src=http://www.cookiedomain.com/cookies/cookies.php> MK> isnt it refering and setting cookie for www.cookiedomain.com MK> even if this HTML file is on another domain? No, because by that point the Header has already been sen

Re: [PHP-DB] cookies

2003-12-04 Thread Maris Kalnins
Right, but in my example HTML line http://www.cookiedomain.com/cookies/cookies.php> isnt it refering and setting cookie for www.cookiedomain.com even if this HTML file is on another domain? Maris "Richard Davey" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello Maris, > > Th

RE: Re[2]: [PHP-DB] Dumping database/restoring

2003-12-04 Thread Dillon, John
Hi Richard, > I simply login to my server and issue a command like: > mysqldump -hmysqlserverhost.com -utheusername -p dbname > dbname.sql > It will then prompt me for my password and dump the database (dbname) into dbname.sql > -h = the sql host (often localhost) > -u = a mysql account that ha

RE: Re[2]: [PHP-DB] Dumping database/restoring

2003-12-04 Thread Dillon, John
Hi Richard, > I simply login to my server and issue a command like: I think that's the bit I missed. I've managed to create the database-d web site (and live happily) without ever logging in to a shell-type area. I've begun to use Putty/SSH as Leech doesn't show me a shell to type commands to

Re: [PHP-DB] cookies

2003-12-04 Thread Richard Davey
Hello Maris, Thursday, December 4, 2003, 10:40:33 AM, you wrote: MK> Could you share with your experience and point out where MK> is the problem here. I tried different variations for MK> domain parameter in setcookie command but it didnt help It's a security mechanism built into cookies. They c

Re: [PHP-DB] Dreamweaver as PHP editor

2003-12-04 Thread Ian Fieldhouse
On 1 Dec 2003, at 21:11, [EMAIL PROTECTED] wrote: 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,

Re: [PHP-DB] Dumping database/restoring

2003-12-04 Thread Richard Davey
Hello John, Thursday, December 4, 2003, 11:01:20 AM, you wrote: DJ> The question is how do people out there DJ> back up their database residing on a server to a local file? Ideally I would DJ> download the database and save on a CD, and be able to restore from this if DJ> the worst happened. Per

[PHP-DB] Dumping database/restoring

2003-12-04 Thread Dillon, John
I use Mascon from scibit to view my database. It has a dump facility to dump to another database or to a local file. I am afraid of the first option lest it overwrites tables already on the other server. When I dump to a local file it is a text file and I can't work out how I would restore from

Re: [PHP-DB] character problem with mssql

2003-12-04 Thread Karsten Eichentopf
Hi, the problem is you use a different codepage for all those characters. If you use a char(100) in MSSQL it will be single byte and connected to a codepage used by this database. You than can only use chars that reside in this code page. This is true for MySQL as well. MSSQL has the nChar(100)

[PHP-DB] cookies

2003-12-04 Thread Maris Kalnins
Let's assume that we have an html page where we plant a call to cookie registering php script. This is done by the following html line which is placed on that page we would like to have cookies stats for: ... .. http://www.cookiedomain.com/cookies/cookies.php> .. Php cookie registering scr

Re: [PHP-DB] Re: Addslashes

2003-12-04 Thread Ng Hwee Hwee
hi, thanx! my magic_quotes_runtime is set to off. actually, i managed to do a double stripslashes to my form fields eg. stripslashes(stripslashes($field1)).. this worked well but still if the input box is a textbox and i have a value that has a double quote ( " ) as part of it, anything after the

Re: [PHP-DB] character problem with mssql

2003-12-04 Thread Ng Hwee Hwee
opps! i didn't read your question properly! i'm so so sorry.. i have not used mssql before, so many someone out there would be a better help to you.. by the way, your english is okay! i can understand it.. but i'm afraid i can't be much of a help to you =( - Original Message - From: "Gam