Odp: [PHP-DB] Migrating from InterBase 4.0 to 6.0

2001-05-03 Thread Jarek Zgoda

Od: "Steve Farmer" [EMAIL PROTECTED]
Temat: [PHP-DB] Migrating from InterBase 4.0 to 6.0


 I need to migrate a database from InterBase 4.0 to 6.0 .  Question is
 has anybody done this and what are the snafus !!

 The migration docs for 6.0 only seem to mention migration from 5.0 !!

 I would imagine a complete export from 4.0 and import into 6.0 would
 be the way to go.

It is not directly "in topic"...
There should be no problem with migration, if you have IB 4.0.2 - after
restoring database in IB 6 you will get the same result. For specific IB
help go to www.mers.com site or try asking at one of their newsgroups at
news.mers.com

Cheers
Jarek Zgoda


-- 
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] updating database on internet server

2001-05-03 Thread Marko Lesnik

That's exactly I'm trying to do. It seems that if you supply an IP of the
server instead 'localhost' in mysql_connect that you would connect directly
to the Mysql database on the server. Where are you programming the update
module and what database are you using on local computer?

Benny [EMAIL PROTECTED] je napisal v sporocilo
[EMAIL PROTECTED]">news:[EMAIL PROTECTED] ...
 I have 2 systems, local and internet.
 I want my Internet database is updated from local database.
 How can I make this?

 Regards;

 Benny.


 --
 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] LDAP : retrieving structure

2001-05-03 Thread Gianluca M

Hi , I need to ask how to retrieving a LDAP db structure.
I've reached this point:
making a serach by ONE_LEVEL, and retrievind all objects in the first level
using a base DN...
after that , how i can see each structure of theese objects in their
sub-levels? i've tried with a ldap_first_entry( ...on the search
result... ) and a ldap_get_attributes and i get a multidim. array that
represents my record-list of each object of my ONE_LEVEL scopethats
right, but now, if I would to see each sub-tructure, witch scope and DN-type
i must use into a ldap_search?
Someone can giveme an algorithm???
plz, help me.
Greetings, Gianluca.



-- 
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] Excluding values of one array from another (sort of)

2001-05-03 Thread Howard Picken

I have the following code

?php

$alphalist = array (A=A, B=B, C=C, D=D, E=E,
F=F, G=G, H=H, I=I, J=J, K=K, L=L,
M=M, N=N, O=O, P=P, Q=Q, R=R, S=S,
T=T, U=U, V=V, W=W, X=X, Y=Y, Z=Z);

$exemptlist = array (Q=Q, V=V, X=X, Z=Z);

reset ($alphalist);
reset ($exemptlist);

while (list ($val) = each ($alphalist)) {

if ($currltr  $val) {

$smlval = strtolower($val);

  echo a
href=\http://www.some.com/page_$smlval.htm\;$val/anbsp;nbsp;\n;

} Else {

  echo $valnbsp;nbsp;\n;

}

}

?

This a header and footer for a bunch of pages. A quick explanation is...

For the page that is displayed don't show the letter as a link.

Now what I want to do is show the letters in the $exemptlist as non links as
well
(because there a no pages for these letters, and yes I still want them
displayed)

Eventually I will pass the exempt values from the main page so the exempt
values
will change depending on what I'm doing with the pages.

PS I'm new to this so please be gentle 8-)

Any one have any ideas?

Thanks in advance

Howard Picken
[EMAIL PROTECTED]

- STRUGGLIN' ON -


-- 
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] SQL 2000

2001-05-03 Thread tcuhost

I just upgraded to the latest 4.05 and was having trouble getting my old
MSSQL pages to work. I run IIS in 2000 Server

I overwrote my php.ini file figuring there was so little to do to it that
all would be well..

Are there any pointes for loading the MSSQL extension again. it does not
seem to want to work properly?

Nick

-- 
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] SQL 2000

2001-05-03 Thread tcuhost

Nevermind... Silly Error on my part... (to tired) 

Thre are no problems with SQL


Nick

-- 
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] Simple query problem

2001-05-03 Thread Russ Michell

Hi all:

I have a seemingly simple SQL problem when using the following PHP4/MySQL-3.22.32 
query:

$sql=SELECT * FROM $table_users WHERE usrName='$username' AND 
usrPswd=password('$password') AND affiliation='$aff_sport';
$result = mysql_query($sql, $connection) or header(Location: error.php?err=query);
$num = mysql_num_rows($result);
//User hasn't been found in DB with current details:
if ($num != 1) {
header(Location: error.php?err=n_player);
exit;
}
//Else get vars and authenticate
else {
//while loop get's vars etc etc
}

My error checking mechanism check's if the inputted details can be found in the DB if 
not you are taken to an error page.
The table $table_users, at present has 2 rows where the same username/password crops 
up, but different data 
(other than the username and password) in their respective rows.

At it stands, I am taken to the error page. If I remove one of the same-name users it 
works fine. 
What can I do to this query or even my table to remedy this so I can have multiple 
same-name users/pswds but with different data,
such as 'affiliation' as above for example??

Please help - as I have nearly completed the projectjust some fiddly lil' things 
need to be sorted..
Many thanks.

Russ

#---#

 Believe nothing - consider everything
   Web Developers do it on-the-fly.

  Russ Michell
  Anglia Polytechnic University Webteam
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam
  t: +44 (0)1223 363271 x 2331

  www.theruss.com

#---#


-- 
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] INSERT into mySQL over PHP (internet)

2001-05-03 Thread Nils Wetterich

Hi NG

Now that I finally realy work with the combination mySQL  PHP on a
Windows-machine I began to just love it. There's only one problem I still
have:
How can I INSERT data from a HTML-form to the database on the server? I'd
like to have some kind of a GUI on the internet so I could administer and
manage the database from everywhere I want.
Please look at what I have yet. Maybe you can find the prob and help me. (I
have the idea that mysql_query() can't work with the variables ($uName 
$eMail).)

Thanx in advance,

Yours Nils.
-

$con = @mysql_connect(host, user, password) or die(Oops... no
connect.);
$qry = SELECT name, mail FROM TUsers;
$res = mysql_db_query(database, $qry, $con);
// $ins = INSERT INTO TUsers (name, mail)
//VALUES ($uName, $eMail);  // ---  doesn't work!
$ins = INSERT INTO TUsers (name, mail)
VALUES (\Any Name\, \and eMail\);  // --   works
perfect!

mysql_query($ins) or die(Sorry. Couldn't execute INSERT.);

form action=script.php method=post
Name: input type=text name=uNamebr
eMail: input type=text name=eMailbr
input type=submit
/form




-- 
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] INSERT into mySQL over PHP (internet)

2001-05-03 Thread Russ Michell

 I'd like to have some kind of a GUI on the internet
Could you not use phpMyAdmin??

Download it for free from http://www.phpwizard.net/projects/phpMyAdmin/

Cheers.
Russ

On Thu, 3 May 2001 15:43:11 +0200 Nils Wetterich [EMAIL PROTECTED] wrote:

 Hi NG
 
 Now that I finally realy work with the combination mySQL  PHP on a
 Windows-machine I began to just love it. There's only one problem I 
 still have:
 How can I INSERT data from a HTML-form to the database on the server? 
 I'd like to have some kind of a GUI on the internet so I could 
 administer and manage the database from everywhere I want.
 Please look at what I have yet. Maybe you can find the prob and help 
 me. (I have the idea that mysql_query() can't work with the variables 
 ($uName  $eMail).)
 
 Thanx in advance,
 
 Yours Nils.
 -
 
 $con = @mysql_connect(host, user, password) or die(Oops... no
 connect.);
 $qry = SELECT name, mail FROM TUsers;
 $res = mysql_db_query(database, $qry, $con);
 // $ins = INSERT INTO TUsers (name, mail)
 //VALUES ($uName, $eMail);  // ---  doesn't 
 work! $ins = INSERT INTO TUsers (name, mail)
 VALUES (\Any Name\, \and eMail\);  // --   
 works perfect!
 
 mysql_query($ins) or die(Sorry. Couldn't execute INSERT.);
 
 form action=script.php method=post
 Name: input type=text name=uNamebr eMail: input type=text 
 name=eMailbr input type=submit
 /form
 
 
 
 
 -- 
 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]
 

#---#

  Believe nothing - consider everything   
  
  Russ Michell
  Anglia Polytechnic University Webteam
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam
  t: +44 (0)1223 363271 x 2331

  www.theruss.com

#---#


-- 
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] mysql/php select using date in where clause

2001-05-03 Thread Dan Eskildsen

***NEWBIE ALERT***  (I am only very new at this)

PHP and MySQL

OK - I have a table with data and one of the fields is a Date field.

Now I would like to SELECT all records where the date is less that 45 days
old.

Eh, How do I do that?

I have tried this:

#Declaring variables
$today=date(Y-m-d);
$lastmonth = $today-30

$query = SELECT * FROM customers WHERE Site='egebjergnet' AND
DatoOprettet'$lastmonth' ORDER BY FirmaNavn;


AND I get an error, of course.  hmmm
--
==
Regards from Denmark, Europe
Please cc your reply to [EMAIL PROTECTED]
==
I haven't lost my mind, I've got it backed up on TAPE somewhere...




-- 
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] postgres tutorials?

2001-05-03 Thread Miles Thompson

There were some on www.postgresql.org, buried down in either documentation 
or users. I'd also try devshed or webmonkey for  using it with PHP

HTH - Miles

At 10:26 AM 5/3/01 -0400, Jaxon wrote:
Hi,

Can anyone point me towards tutorials for using postresql with PHP?

cheers!
jaxon

--
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] mysql/php select using date in where clause

2001-05-03 Thread martin helie

Here's how I'd do it:

SELECT * FROM customers WHERE Site='egebjergnet' AND

TO_DAYS(NOW()) - TO_DAYS(date_column) = '45'

where date_column contains record dates...

Martin



Dan Eskildsen [EMAIL PROTECTED] wrote in message
9crq7l$mfb$[EMAIL PROTECTED]">news:9crq7l$mfb$[EMAIL PROTECTED]...
 ***NEWBIE ALERT***  (I am only very new at this)

 PHP and MySQL

 OK - I have a table with data and one of the fields is a Date field.

 Now I would like to SELECT all records where the date is less that 45 days
 old.

 Eh, How do I do that?

 I have tried this:

 #Declaring variables
 $today=date(Y-m-d);
 $lastmonth = $today-30

 $query = SELECT * FROM customers WHERE Site='egebjergnet' AND
 DatoOprettet'$lastmonth' ORDER BY FirmaNavn;


 AND I get an error, of course.  hmmm
 --
 ==
 Regards from Denmark, Europe
 Please cc your reply to [EMAIL PROTECTED]
 ==
 I haven't lost my mind, I've got it backed up on TAPE somewhere...




 --
 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] mysql/php select using date in where clause

2001-05-03 Thread Dan Eskildsen

IT works!

Thanks!


martin helie [EMAIL PROTECTED] skrev i en meddelelse
9crqud$voj$[EMAIL PROTECTED]">news:9crqud$voj$[EMAIL PROTECTED]...
 Here's how I'd do it:

 SELECT * FROM customers WHERE Site='egebjergnet' AND

 TO_DAYS(NOW()) - TO_DAYS(date_column) = '45'

 where date_column contains record dates...

 Martin



 Dan Eskildsen [EMAIL PROTECTED] wrote in message
 9crq7l$mfb$[EMAIL PROTECTED]">news:9crq7l$mfb$[EMAIL PROTECTED]...
  ***NEWBIE ALERT***  (I am only very new at this)
 
  PHP and MySQL
 
  OK - I have a table with data and one of the fields is a Date field.
 
  Now I would like to SELECT all records where the date is less that 45
days
  old.
 
  Eh, How do I do that?
 
  I have tried this:
 
  #Declaring variables
  $today=date(Y-m-d);
  $lastmonth = $today-30
 
  $query = SELECT * FROM customers WHERE Site='egebjergnet' AND
  DatoOprettet'$lastmonth' ORDER BY FirmaNavn;
 
 
  AND I get an error, of course.  hmmm
  --
  ==
  Regards from Denmark, Europe
  Please cc your reply to [EMAIL PROTECTED]
  ==
  I haven't lost my mind, I've got it backed up on TAPE somewhere...
 
 
 
 
  --
  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 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] Newbie question

2001-05-03 Thread ~BD~

I've gone thru everything I can find, and I'm sure I'm just missing it (it's
happened before), but...

at the end of my script, I run a set of closing and clean-up procedures..
what I would like to be able to do is that when a user bails out of the
script by closing the browser or leaving the site/page, detect that they've
gone, and then go ahead and run my closing procedures.. is this possible?

I'd appreciate a point in the right direction, with or without an RTFM ...
:)

TIA
~BD~

http://www.bustdustr.net
Home of Radio Free Bd



-- 
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] interbase (?) field contents does not show

2001-05-03 Thread GMansky

Meir,

Thanks for the response.  I believe I tried it with caps but did not get any
message.  Anyway, I tried it again, and it's now working.

Why does $row-LASTNAME give me a result on an ibase_fetch_object() and not
on ibase_fetch_row()?

Thanks,
George




-- 
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] Newbie question

2001-05-03 Thread CC Zona

In article 034101c0d3f3$0dd747e0$41041dd8@winbox,
 [EMAIL PROTECTED] (~BD~) wrote:

 at the end of my script, I run a set of closing and clean-up procedures..
 what I would like to be able to do is that when a user bails out of the
 script by closing the browser or leaving the site/page, detect that they've
 gone, and then go ahead and run my closing procedures.. is this possible?

http://php.net/manual/en/features.connection-handling.php
http://php.net/register-shutdown-function

-- 
CC

-- 
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] Mystery variable query?

2001-05-03 Thread CC Zona

In article 9crr9l$4c4$[EMAIL PROTECTED],
 [EMAIL PROTECTED] (martin helie) wrote:

 assuming:
 
 $var=1234;(type does not seem to matter)
 
 this query returns no error, but no result either:
 
 mysql(database,SELECT * FROM table WHERE id='$var');

When you call mysql_query is it perhaps from inside a function, where 
variable $var has not been passed or made global?

(BTW, whenever you experience problems with a query, it's a good idea to 
echo the query string to the browser.  Often, this simple step makes it 
very clear where the problem lies.  Using mysql_error() and $php_errormsg 
on a query failure also can give you very useful information.)

-- 
CC

-- 
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] interbase (?) field contents does not show

2001-05-03 Thread Larry Rivera

Beacuse u are using an object structure, Check OOP in PHP, the pointer
$variable-name is for objects that why its used in the fetch object and not
fetch row fetch row would be $rs[rowname] or $rs[0]. Check the
documentation for more detailed info

-Original Message-
From: GMansky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 10:40 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] interbase (?) field contents does not show


Meir,

Thanks for the response.  I believe I tried it with caps but did not get any
message.  Anyway, I tried it again, and it's now working.

Why does $row-LASTNAME give me a result on an ibase_fetch_object() and not
on ibase_fetch_row()?

Thanks,
George




--
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] Newbie question

2001-05-03 Thread ~BD~

EXACTLY what I was looking for...
Thanks!

http://www.bustdustr.net
Home of Radio Free Bd


- Original Message -
From: CC Zona [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 03, 2001 1:42 PM
Subject: Re: [PHP-DB] Newbie question


 In article 034101c0d3f3$0dd747e0$41041dd8@winbox,
  [EMAIL PROTECTED] (~BD~) wrote:

  at the end of my script, I run a set of closing and clean-up
procedures..
  what I would like to be able to do is that when a user bails out of the
  script by closing the browser or leaving the site/page, detect that
they've
  gone, and then go ahead and run my closing procedures.. is this
possible?

 http://php.net/manual/en/features.connection-handling.php
 http://php.net/register-shutdown-function

 --
 CC

 --
 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] Mystery variable query?

2001-05-03 Thread Gyozo Papp

 I wish there were a php debugger.

maybe, this would satisfy you:

http://dd.cron.ru/dbg/home.php

best regards, 

Papp Gyozo 
- [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] Mystery variable query?

2001-05-03 Thread CC Zona

In article 9cs791$mn3$[EMAIL PROTECTED],
 [EMAIL PROTECTED] (martin helie) wrote:

 The problem, evidently, is that echoing the variable didn't show the html
 formatting (it was something like font color=black in an obvious way!

Look at it via source view next time.  Echoing the content wrapped in a 
pre tag can also be handy.

 I wish there were a php debugger.

http://php.net/manual/en/debugger.php There's a built-in for PHP3.  For 
PHP4, scroll down toward the bottom of the user annotations for a couple of 
options.

-- 
CC

-- 
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] ora_logon receive ora-12154

2001-05-03 Thread Miguel

Hi,

I'am having serious problems in put php acessing a remote oracle 8 database,
i have tried several configurations but always end up with

Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name in
/var/www/htdocs/support/teste.php on line 5

I can access this database from sqlplus and when I start apache all oracle
variables are set. If I get rid of the connect string and access my local
database then everything is ok.

My code is something like...

putenv(ORACLE_HOME=/apps/oracle/8.1.7);
putenv(TNS_ADMIN=/apps/oracle/8.1.7/network/admin);

// main
if(!($conn=ora_logon(user@SERVICE,pass)))

echo Error: Cannot connect to database\n;
exit;
}



Using:

apache: apache_1.3.19
php4: php-4.0.5
Linux: Red Hat 7.0 with latest patch's
Remote Oracle DB: Oracle 8.1.6 W2K
Local DB: Oracle 8.1.7 Linux

php build with: --with-oci8 --with-oracle

Any help would be apreciated...

Thanks,
Miguel



-- 
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] mp3 upload????

2001-05-03 Thread Kelvin

Hi,

   I want to setup a upload program thats only allow MP3 file type.

So,  this is my coding under the file


.
if ($imgfile_type == audio/mp3)
..
...

But when I upload my song, it said mp3 is not the format type   What
should I do?

Please help. I will be very appreciate.

Best regards,
Kelvin.



-- 
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] ora_logon receive ora-12154

2001-05-03 Thread Steve Farmer

Hi Miguel,

try

if(!($conn=ora_logon(user,pass,SERVICE)))

it always works for me

HTH
Steve


At 10:47 PM +0100 3/5/01, Miguel wrote:
Hi,

I'am having serious problems in put php acessing a remote oracle 8 database,
i have tried several configurations but always end up with

Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name in
/var/www/htdocs/support/teste.php on line 5

I can access this database from sqlplus and when I start apache all oracle
variables are set. If I get rid of the connect string and access my local
database then everything is ok.

My code is something like...

putenv(ORACLE_HOME=/apps/oracle/8.1.7);
putenv(TNS_ADMIN=/apps/oracle/8.1.7/network/admin);

// main
if(!($conn=ora_logon(user@SERVICE,pass)))

echo Error: Cannot connect to database\n;
exit;
}



Using:

apache: apache_1.3.19
php4: php-4.0.5
Linux: Red Hat 7.0 with latest patch's
Remote Oracle DB: Oracle 8.1.6 W2K
Local DB: Oracle 8.1.7 Linux

php build with: --with-oci8 --with-oracle

Any help would be apreciated...

Thanks,
Miguel



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

-- 
---
Minds are like parachutes, they work best when open
Support free speech; visit http://www.efa.org.au/

Heads Together Systems Pty Ltd http://www.hts.com.au
Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 

-- 
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] updating database on internet server

2001-05-03 Thread Benny

I want to update the internet server from my local computer. I used MySQL
both in local and internet server.

Regards;

Benny.

-Original Message-
From: Marko Lesnik [mailto:[EMAIL PROTECTED]]
Sent: 03 Mei 2001 14:39
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] updating database on internet server


That's exactly I'm trying to do. It seems that if you supply an IP of the
server instead 'localhost' in mysql_connect that you would connect directly
to the Mysql database on the server. Where are you programming the update
module and what database are you using on local computer?

Benny [EMAIL PROTECTED] je napisal v sporocilo
[EMAIL PROTECTED]">news:[EMAIL PROTECTED] ...
 I have 2 systems, local and internet.
 I want my Internet database is updated from local database.
 How can I make this?

 Regards;

 Benny.


 --
 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 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 and Access to DB2.

2001-05-03 Thread Chris Lee

Nicolas,

Take a look of the following link:
Hope this help.

AS/400
Connection from a Linux Box to AS/400 DB2
Connection from a Linux Box to IBM DB2 Mainframes
http://www.faqts.com/knowledge_base/view.phtml/aid/5613/fid/12

Can I use PHP to interface with an AS/400 database?
http://www.faqts.com/knowledge_base/view.phtml/aid/257/fid/14

Can you connect to an AS/400 DB2 database from a Linux web server? 
http://www.faqts.com/knowledge_base/view.phtml/aid/3536/fid/10

Regards,
Chris Lee


On 30 Apr 2001 08:40:42 -0700, [EMAIL PROTECTED] (Nicolas
Machado) wrote:

Hy, somebody knows if exist a driver for database access to DB2/400, running
on AS/400.
Something like a module.

Thanks.


---
Este Mail NO contiene Virus.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.250 / Virus Database: 123 - Release Date: 18/04/01


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