[PHP-DB] [PHP-ORACLE] a lot of errors!!!

2001-08-24 Thread Matteo

I have a server with Linux 6.2 kernel 2.2.19 with apache 1.3.20

i configure php in this mode

 './configure' '--with-apache=/home/apache/apache_1.3.20' '--with-mysql'
'--with-gd' '--enable-track-vars' '--enable-force-cgi-redirect'
'--enable-discard-path' '--enable-safe-mode' '--enable-calendar'
'--with-gdbm' '--enable-ftp' '--with-regex=php' '--with-gnu-ld'
'--with-oci8' '--with-imap' '--with-kerberos'
'--with-openssl=/usr/local/ssl'

i have installed Oracle 8.1.7.  server and client and i configure correctly
listener.ora e tnsnames.ora. It works

But when i try an SQL test, it displays this messages:


Warning: _oci_open_server: Error while trying to retrieve text for error
ORA-12154 in /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 180

Warning: Supplied argument is not a valid OCI8-Connection resource in
/home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 181

Warning: Supplied argument is not a valid OCI8-Statement resource in
/home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 183
Error: Oracle Error: ---

Fatal error: Call to undefined function: blu_log() in
/home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 187


What is the problem?

Thankx very much for answers.

Matteo
ITALY




-- 
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] PHP development with PostgreSQL

2001-08-24 Thread Lester June Cabrera

Hi,

We've been using MySQL for 2 years now in all the PHP systems we have 
developed for our clients. We're thinking of using PostgreSQL now. What is 
your experience with PostgreSQL? Any comments? The reason why we want to 
shift is because we have encountered some problems with one of our 
databases whose table contains more than 20K records. Somehow, it took so 
long to query the database. Is PosgtreSQL a good substitute? We're 
expecting a million records for our new project.


Thanks,
Lester


-- 
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 development with PostgreSQL

2001-08-24 Thread Dreamvale

I've been using MySQL with database about 600k records... and it's running
good.
Dont think PostgreSQL can help if you're concern about size.

Dreamvale
- Original Message -
From: Lester June Cabrera [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 24, 2001 4:06 PM
Subject: [PHP-DB] PHP development with PostgreSQL


 Hi,

 We've been using MySQL for 2 years now in all the PHP systems we have
 developed for our clients. We're thinking of using PostgreSQL now. What is
 your experience with PostgreSQL? Any comments? The reason why we want to
 shift is because we have encountered some problems with one of our
 databases whose table contains more than 20K records. Somehow, it took so
 long to query the database. Is PosgtreSQL a good substitute? We're
 expecting a million records for our new project.


 Thanks,
 Lester


 --
 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 development with PostgreSQL

2001-08-24 Thread Yves Glodt

On Friday 24 August 2001 10:06, you wrote:
 Hi,

 We've been using MySQL for 2 years now in all the PHP systems we have
 developed for our clients. We're thinking of using PostgreSQL now.
 What is your experience with PostgreSQL? Any comments? The reason why
 we want to shift is because we have encountered some problems with
 one of our databases whose table contains more than 20K records.
 Somehow, it took so long to query the database. Is PosgtreSQL a good
 substitute? We're expecting a million records for our new project.


 Thanks,
 Lester


This seems more like a problem in database design like in the database 
itself.

yves

--
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 development with PostgreSQL

2001-08-24 Thread Jason Brooke

 This seems more like a problem in database design like in the database
itself.

 yves

how come?






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

2001-08-24 Thread Russ Michell

Hi there folks - this isn't *entirley* a DB question so I'm putting on my flack Jacket 
right now:

I keep getting this error and have never seen it before:
Fatal error: Cannot redeclare parse_dir() in intranet/bin/includes/functions.php on 
line 47

It gives me this error for every function I have (written). I know for a fact that 
this function 
('parse_dir') has only been declared once, so why is php lying to me!!?

Feel free *not to answer* instead of wasting your own time giving me jip for an off 
topic query.
Cheers

Russ

#---#

  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]




Re: [PHP-DB] Fatal error

2001-08-24 Thread * RzE:

--- Original message ---
From: Russ Michell [EMAIL PROTECTED]
Date: Fri, Aug 24, 2001 at 12:47:42PM +0100
Message-ID: SIMEON.10108241242.N@k1c. anglia.ac.uk
Subject: [PHP-DB] Fatal error


 Hi there folks - this isn't *entirley* a DB question so I'm putting on my flack 
Jacket right now:
 
 I keep getting this error and have never seen it before:
 Fatal error: Cannot redeclare parse_dir() in intranet/bin/includes/functions.php on 
line 47
 
 It gives me this error for every function I have (written). I know for a fact that 
this function 
 ('parse_dir') has only been declared once, so why is php lying to me!!?
 
 Feel free *not to answer* instead of wasting your own time giving me jip for an off 
topic query.
 Cheers
 
 Russ
 
 #---#
   
   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
   
 #---#

--- End of original message ---

Reply

Do you include these functions? If you do, you might want to check
if you include it more than once. You can then best use
include_once() instead of include(). That makes sure that the file
will only be included once and so your function will not be
redeclared.

/Reply

-- 

* RzE:


-- 
-- Renze Munnik
-- DataLink BV
--
-- E: [EMAIL PROTECTED]
-- W: +31 23 5326162
-- F: +31 23 5322144
-- M: +31 6 21811143
--
-- Stationsplein 82
-- 2011 LM  HAARLEM
-- Netherlands
--
-- http://www.datalink.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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] PHP development with PostgreSQL

2001-08-24 Thread Yves Glodt

On Friday 24 August 2001 12:27, Jason Brooke wrote:
  This seems more like a problem in database design like in the
  database

 itself.

  yves

 how come?

I would suggest that you give details about the table that is slow, or 
maybe post it to a mysql mailing-list directly.
Slowness on large tables is often index-related.

--
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: RE: [PHP-DB] Fatal error

2001-08-24 Thread Russ Michell

Try to include your files with the command include_once() ... and not
include() ...

Well Br me! Cheers..
That did the job...

I thank you sir!
Cheers

Russ

On Fri, 24 Aug 2001 13:04:15 +0200 Walter, Marcel [EMAIL PROTECTED] wrote:

 Try to include your files with the command include_once() ... and not
 include() ...
 Maybe this solves your problem... because you ARE trying to declare
 a function which is already declared ...
 
  -Original Message-
  From:   Russ Michell [SMTP:[EMAIL PROTECTED]]
  Sent:   Friday, August 24, 2001 13:48
  To: [EMAIL PROTECTED]
  Subject:[PHP-DB] Fatal error
  
  Hi there folks - this isn't *entirley* a DB question so I'm putting on my
  flack Jacket right now:
  
  I keep getting this error and have never seen it before:
  Fatal error: Cannot redeclare parse_dir() in
  intranet/bin/includes/functions.php on line 47
  
  It gives me this error for every function I have (written). I know for a
  fact that this function 
  ('parse_dir') has only been declared once, so why is php lying to me!!?
  
  Feel free *not to answer* instead of wasting your own time giving me jip
  for an off topic query.
  Cheers
  
  Russ
  
  #---#
  
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]

#---#

  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_fetch_object() with MYSQL_NUM or MYSQL_BOTH

2001-08-24 Thread rashkatsa

hello !

mysql_fetch_object() is like mysql_fetch_array() but it returns an 
object and not an array. so you can access field through this syntax :

$obj-fieldname (i.e $obj-amount)

you can provide a second parameter to this function :

MYSQL_ASSOC, MYSQL_NUM or MYSQL_BOTH.

if you use MYSQL_NUM or MYSQL_BOTH, you should be able to access fields 
through the column number... but how since in an PHP object a variable 
could not begin by a numerical character (i.e $obj-0, $obj-1... is 
forbidden) ?

if you use get_object_vars($obj) and print the object's properties, you 
could see this for example (MYSQL_BOTH used) :

0 = 'titi'
columnName1 = 'titi'
1 = 2
columnName2 = 2

so here $obj-columnName1 returns 'titi' and $obj-columnName2 returns 2 
but if i want to use numerical entries how to keep the object access 
behavior like $obj-... ? is it possible ? if not we should use a loop
with get_object_vars($obj) ? nothing more simple and beautiful ?

thanks for your feeebacks.

regards,

rashkatsa


-- 
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: OT (slightly): recommended procedure for backing up Postrgesql 7.0.3

2001-08-24 Thread Steve Brett

you can set up a job using cron that pg_dumps the date anywhere you need.

we use an automounted dir that links to a windoze server ...

Steve

Brad Hubbard [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Well, the subject really says it all. What procedures are people using to
 back up their Postgres databases?

 TIA,
 Brad



-- 
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] the most simple i have found...

2001-08-24 Thread rashkatsa

$obj-{0} or $obj-{'0'} works...

if you find more simple, please tell me.

regards,

rashkatsa



-- 
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 development with PostgreSQL

2001-08-24 Thread Miles Thompson

Lester,

Are you querying on indexed fields? That's the key to speed; check the 
MySQL docs on how it uses indexes. 20k records is not a large database.

Miles

At 04:06 PM 8/24/01 +0800, Lester June Cabrera wrote:
Hi,

We've been using MySQL for 2 years now in all the PHP systems we have 
developed for our clients. We're thinking of using PostgreSQL now. What is 
your experience with PostgreSQL? Any comments? The reason why we want to 
shift is because we have encountered some problems with one of our 
databases whose table contains more than 20K records. Somehow, it took so 
long to query the database. Is PosgtreSQL a good substitute? We're 
expecting a million records for our new project.


Thanks,
Lester


--
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: OT (slightly): recommended procedure for backing up Postrgesql 7.0.3

2001-08-24 Thread Steve Brett

yup,

the postmaster should be running all the time in any case.

30 7-19/4,23 * * * /backup/dumpit

is the line i have in cron ( 30 mins past the hour between 7am and 7pm every
4 hours and again at 11pm )

and 

#!/bin/sh

backdate=$(date +%Y%m%d%H%M.gz)

/usr/local/pgsql/bin/pg_dump edb | gzip  /backup/edb-backup_$backdate

cp /backup/edb-backup_$backdate /var/autofs/misc/ecalnet/

are the contents of the file dumpit.

this creates a gzipped dump of the database with a name of
edb-backup_200108240730 for example, then copies it to another directory.



HTH

Steve

Steve Brett [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 you can set up a job using cron that pg_dumps the date anywhere you need.

 we use an automounted dir that links to a windoze server ...

 Steve

 Brad Hubbard [EMAIL PROTECTED] wrote in message
 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
  Well, the subject really says it all. What procedures are people using
to
  back up their Postgres databases?
 
  TIA,
  Brad





-- 
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: pg_exec question.

2001-08-24 Thread Steve Brett

i don't thing 99% sure that it can be done.

you can decalre a transaction and then [begin statement 1statement
2statement n commit]


[EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello,

I'm new with PHP and PostgreSQL, and can't find a solution to the
 following problem.  I'd like to combine multiple SQL commands into one
 pg_exec call.  For example, I've tried delete ...; insert ...; insert
 ..; with the appropriate values in the ..., but I'm receiving this
 error:

Warning: Supplied argument is not a valid PostgreSQL link resource

Does anyone have any suggestions for this problem?  Thanks in advance.





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

2001-08-24 Thread Guilherme Bresser

Hi... I'm from Brazil my english is bad!!!

Can I connect one Script PHP with a TopSpeed Database (*.tps)??

How can I do

Thank's

Guilherme Bresser
Sao Paulo - Brazil



-- 
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: how should i test my php program performance?

2001-08-24 Thread Michael Kumar

have a look at the excellent DBG PHP Debugger by Dmitri Dmitrienko.
it comes with a profiler, which lets you track down bottlenecks far 
easier than with normal output.

you can find it at http://dd.cron.ru

hint: in usual php/mysql applications almost always the database is the 
bottleneck, which means you should put most effort in optimizing the 
queries.

regards, mike.

--
mfG, Michael Kumar (michael.kumar_at_nme.at, m.kumar_at_hushmail.com)
PGP: 30FE 3AB9 5077 C554 5D9E  B5CC 0B0F CFB2 55D6 AA75 
.: know your nme :.


In article [EMAIL PROTECTED], [EMAIL PROTECTED] 
says...
 Dear all:
 
 I have wrote a php program and use mysql database.
 Is there a way to test its performance?
 Thanks.
 
 haheho
 
 
 

-- 
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 development with PostgreSQL

2001-08-24 Thread Steve Brett

i use postgresql at work and the reson we chose it baove mysql (which i also
use for developement @ home) was scalability.

from our investigations mysql does not scale well wehn having 100+ users.

BUT before i start a pointless debate on the merits of either both DB's seem
to have 'converged' over thelast year or so.

the db we run at work has 500K+ records and runs very quickly. i'm not so
sure mysql would perform like this for the 100+ users that are connected
most of the time.

postgresql has a better feel to it as well, and has better SQL support
(inner selects are 'mising' in mysql)

Steve

Miles Thompson [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Lester,

 Are you querying on indexed fields? That's the key to speed; check the
 MySQL docs on how it uses indexes. 20k records is not a large database.

 Miles

 At 04:06 PM 8/24/01 +0800, Lester June Cabrera wrote:
 Hi,
 
 We've been using MySQL for 2 years now in all the PHP systems we have
 developed for our clients. We're thinking of using PostgreSQL now. What
is
 your experience with PostgreSQL? Any comments? The reason why we want to
 shift is because we have encountered some problems with one of our
 databases whose table contains more than 20K records. Somehow, it took so
 long to query the database. Is PosgtreSQL a good substitute? We're
 expecting a million records for our new project.
 
 
 Thanks,
 Lester
 
 
 --
 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] Re: Photo Album Schema

2001-08-24 Thread Sheridan Saint-Michel

He suggested a DB redesign to allow a Many to Many relationship between
users and images.
I was trying to show that there was no reason to do so and at least one good
reason not to do so  =)

Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com


- Original Message -
From: Hugh Bothwell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 8:02 PM
Subject: Re: [PHP-DB] Re: Photo Album Schema



 Sheridan Saint-Michel [EMAIL PROTECTED] wrote in message
 03a901c12c02$c60d4640$[EMAIL PROTECTED]">news:03a901c12c02$c60d4640$[EMAIL PROTECTED]...
  I don't know if having multiple users associated with a single image is
  at all beneficial, and I can see where it might cause all sorts of
 problems.
 
  For example, you and I both have the same image in our album (we are
   both assciated with it in the DB).  What happens when I change the
  description?  Do you change the description field, thus changing the
  description on both our pages?  Do you now have to create another entry
  in your Image table?

 Just to be nitpicky: I don't see where this would be
 useful - allowing users to share/transfer pictures? - but
 it's not overly difficult either.  Just split the information
 between an Image table and an ImageOwner
 table.




 --
 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] Zend IDE anyone?

2001-08-24 Thread Grant Boggs

Does anyone use the Zend IDE for development?

My code is getting complicated enough that I need a step-execute capable
debugger.  Where I can set breakpoints, watches, etc.  The normal type stuff
with any other language's IDE.

Zend IDE looks to fill the gap.  Any other recommendations?

--
==
Grant Boggs
http://www.cornersonesoftware.ws



-- 
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: Installation problem w MySQL

2001-08-24 Thread Grant Boggs

George Pitcher [EMAIL PROTECTED] wrote in message
01e501c12c7d$e9c831f0$[EMAIL PROTECTED]">news:01e501c12c7d$e9c831f0$[EMAIL PROTECTED]...
 I'm trying to compile PHP 4.0.6 on LinuxPPC and I keep tripping over the
 MySQL part. It just won't compile (can't find headers during the MySQL
bit).

 All the documentation points to there being a /usr/local/mysql/ folder but
 after my MySQL install (rpm) I don't have such a folder. The nearest I
have
 is:

 /usr/bin/which seems to have all the client stuff;
 /usr/bin/include which has several files with '.h' extensions
(headers?)
 /var/lib/mysqlwhich has the server/engine stuff
 /usr/local/php-4.0.6/ext/libmysql/  which appears to have more '.h' files.

Do a

locate mysqld

And see what that pops up.  If you did it by rpm, mysql is probably in a
/etc/mysql  directory.

--
==
Grant Boggs
http://www.cornersonesoftware.ws



-- 
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: Zend IDE anyone?

2001-08-24 Thread Grant Boggs

Grant Boggs [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Does anyone use the Zend IDE for development?

 My code is getting complicated enough that I need a step-execute
capable
 debugger.  Where I can set breakpoints, watches, etc.  The normal type
stuff
 with any other language's IDE.

 Zend IDE looks to fill the gap.  Any other recommendations?

I guess I should also note that I'm using Red Hat 7.1, Apache, mySQL,
and PHP 4.0.6.

--
==
Grant Boggs
http://www.cornersonesoftware.ws




-- 
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 development with PostgreSQL

2001-08-24 Thread grant

This does not sound like a MySQL problem, but more likely a poor indexes
problem.  PostgreSQL does scale bigger than MySQL (more users) but you are
probably nowhere near that limit.  When you have more than 25 concurrent
users (remember that the web server is probably only one or 2 unless it is
really getting slammed) then start thinking about switching.

__

  Your mouse has moved.
   You must restart Windows for your changes to take effect.

#!/usr/bin/perl
print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);



-- 
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] Another Interbase question

2001-08-24 Thread Balak, Frank

yves,

Start the transaction with ibase_trans() before you call ibase_execute. 

As to how is it possible, I don't really know for sure. I would presume it
has to do with how Interbase handles transactions. 

Frank
--
Franklin J. Balak Jr.
Quality Assurance Data Analyst
Brown Printing Company
Waseca Division
Waseca, MN. 56093
Voice: 507-835-0253
Fax: 507-835-0293
-- 

-Original Message-
From: Yves Glodt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 14:11
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Another Interbase question


Look at this:

?php
include('include.php');

$dbh = connectdb();
$sth = ibase_prepare('INSERT INTO LOG 
(DATETIME,REMOTE_ADDR,HTTP_HOST,QUERY_STRING,HTTP_USER_AGENT,REQUEST_URI,HTT
P_REFERER) 
VALUES (?,?,?,?,?,?,?)');
ibase_execute($sth,
$now,
$HTTP_SERVER_VARS['REMOTE_ADDR'],
$HTTP_SERVER_VARS['HTTP_HOST'],
$HTTP_SERVER_VARS['QUERY_STRING'],
$HTTP_SERVER_VARS['HTTP_USER_AGENT'],
$HTTP_SERVER_VARS['REQUEST_URI'],
$HTTP_SERVER_VARS['HTTP_REFERER']);
ibase_commit();
ibase_close($dbh);

?

when it gets called, and I do a select in isql, I do not see any of the 
records. Only after doing a manual commit in isql, I can see the new 
data.

How is that possible?

yves

-- 
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] How to show table???

2001-08-24 Thread kelvin

Hi there,

I just wonder how to list all the table when using PHP script.
I know how to call when I in linux system. (show table) or (mysqlshow
db_name)

But don't know how to do it in PHP Please Help...

Many Thanks.
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] How to show table???

2001-08-24 Thread Russ Michell

Hmmm try something like:

$sql = EXPLAIN dbame.table_name;

This will show something like:

+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra  |
+---+-+--+-+-++
| id| smallint(3) |  | PRI | 0   | auto_increment |
| firstName | varchar(30) |  | | ||
| lastName  | varchar(30) |  | | ||
| email | varchar(30) |  | | ||
| username  | varchar(12) |  | | ||
| password  | varchar(12) |  | | ||
+---+-+--+-+-++
6 rows in set (0.00 sec)

I hope this is what you wanted, can't think why though...

Russ

On Fri, 24 Aug 2001 11:09:06 -0400 kelvin [EMAIL PROTECTED] wrote:

 Hi there,
 
 I just wonder how to list all the table when using PHP script.
 I know how to call when I in linux system. (show table) or (mysqlshow
 db_name)
 
 But don't know how to do it in PHP Please Help...
 
 Many Thanks.
 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]
 

#---#

  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] Re: Zend IDE anyone?

2001-08-24 Thread Steve Brett

I have used the Zend IDE for php dev and found it to be superb.

unfortunately the company i work for takes an age to get license agreements
arranged so our eval period had run out.

it's very easy to set up - try the eval version first.

Steve

Grant Boggs [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Does anyone use the Zend IDE for development?

 My code is getting complicated enough that I need a step-execute
capable
 debugger.  Where I can set breakpoints, watches, etc.  The normal type
stuff
 with any other language's IDE.

 Zend IDE looks to fill the gap.  Any other recommendations?

 --
 ==
 Grant Boggs
 http://www.cornersonesoftware.ws





-- 
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: Zend IDE anyone?

2001-08-24 Thread Grant Boggs

Steve Brett [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 I have used the Zend IDE for php dev and found it to be superb.

 unfortunately the company i work for takes an age to get license
agreements
 arranged so our eval period had run out.

 it's very easy to set up - try the eval version first.

 Steve

Great!  Thanks!  I'm working on installing it now.

I'm a relative newbie to Linux, but it looks like because I use PHP with
Apache and mySQL, I have to recompile both of these products to get the Zend
debugger installed?

Recompiling now... heh

--
==
Grant Boggs
http://www.cornersonesoftware.ws



-- 
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] Re: Photo Album Schema

2001-08-24 Thread Hugh Bothwell


Sheridan Saint-Michel [EMAIL PROTECTED] wrote in message
00f601c12ca3$8bb26420$[EMAIL PROTECTED]">news:00f601c12ca3$8bb26420$[EMAIL PROTECTED]...

 From: Hugh Bothwell [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 
  Sheridan Saint-Michel [EMAIL PROTECTED] wrote in message
  03a901c12c02$c60d4640$[EMAIL PROTECTED]">news:03a901c12c02$c60d4640$[EMAIL PROTECTED]...
   I don't know if having multiple users associated with a single image
is
   at all beneficial, and I can see where it might cause all sorts of
  problems.
  
   For example, you and I both have the same image in our album (we are
both assciated with it in the DB).  What happens when I change the
   description?  Do you change the description field, thus changing the
   description on both our pages?  Do you now have to create another
entry
   in your Image table?
 
  Just to be nitpicky: I don't see where this would be
  useful - allowing users to share/transfer pictures? - but
  it's not overly difficult either.  Just split the information
  between an Image table and an ImageOwner
  table.

 He suggested a DB redesign to allow a Many to
 Many relationship between users and images.
 I was trying to show that there was no reason to
 do so and at least one good reason not to do so  =)

Yes, I followed that - I'm just playing Devil's Advocate
here.  I would rephrase your conclusion as
'no reason to do so, but no reason not to if you
really feel the need'.



-- 
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: Zend IDE anyone?

2001-08-24 Thread Steve Brett

no need to recompile.

the debug server is a .so and only needs added lines php.ini

we used the windoze ide clients whihc install easily if you have JRE. if not
you need to downoad/install.

def no need to recompile though ...

hop i'm not too late :-)

Steve

Grant Boggs [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Steve Brett [EMAIL PROTECTED] wrote in message
 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
  I have used the Zend IDE for php dev and found it to be superb.
 
  unfortunately the company i work for takes an age to get license
 agreements
  arranged so our eval period had run out.
 
  it's very easy to set up - try the eval version first.
 
  Steve

 Great!  Thanks!  I'm working on installing it now.

 I'm a relative newbie to Linux, but it looks like because I use PHP
with
 Apache and mySQL, I have to recompile both of these products to get the
Zend
 debugger installed?

 Recompiling now... heh

 --
 ==
 Grant Boggs
 http://www.cornersonesoftware.ws





-- 
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 transaction question

2001-08-24 Thread Yves Glodt

On Friday 24 August 2001 16:55, Balak, Frank wrote:
 yves,

 Start the transaction with ibase_trans() before you call
 ibase_execute.

 As to how is it possible, I don't really know for sure. I would
 presume it has to do with how Interbase handles transactions.

 Frank

Frank,
thank you, I've tried it, and even found something similar in the 
phpbuilder.com mailing list archives, but it sill doesn't work
This is my new code:

$dbh = connectdb();
$sth = ibase_prepare('INSERT INTO LOG 
(DATETIME,REMOTE_ADDR,HTTP_HOST,REQUEST_URI,HTTP_REFERER,HTTP_USER_AGENT) 
VALUES (?,?,?,?,?,?)');
$trans=ibase_trans();
ibase_execute($sth,
$now,
substr(get_var('REMOTE_ADDR','nbsp;'),0,24),
substr(get_var('HTTP_HOST','nbsp;'),0,24),
substr(get_var('REQUEST_URI','nbsp;'),0,99),
substr(get_var('HTTP_REFERER','nbsp;'),0,99),
substr(get_var('HTTP_USER_AGENT','nbsp;'),0,99));
ibase_commit($trans);
ibase_close($dbh);


The code I found on phpbuilder.com said the following:
$trans = ibase_trans();
ibase_query ($c, $sql);
ibase_commit( $trans);

heck, what do I do wrong?



 --
 Franklin J. Balak Jr.
 Quality Assurance Data Analyst
 Brown Printing Company
 Waseca Division
 Waseca, MN. 56093
 Voice: 507-835-0253
 Fax: 507-835-0293
 --

 -Original Message-
 From: Yves Glodt [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, August 23, 2001 14:11
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Another Interbase question


 Look at this:

 ?php
 include('include.php');

 $dbh = connectdb();
 $sth = ibase_prepare('INSERT INTO LOG
 (DATETIME,REMOTE_ADDR,HTTP_HOST,QUERY_STRING,HTTP_USER_AGENT,REQUEST_
URI,HTT P_REFERER)
 VALUES (?,?,?,?,?,?,?)');
 ibase_execute($sth,
 $now,
 $HTTP_SERVER_VARS['REMOTE_ADDR'],
 $HTTP_SERVER_VARS['HTTP_HOST'],
 $HTTP_SERVER_VARS['QUERY_STRING'],
 $HTTP_SERVER_VARS['HTTP_USER_AGENT'],
 $HTTP_SERVER_VARS['REQUEST_URI'],
 $HTTP_SERVER_VARS['HTTP_REFERER']);
 ibase_commit();
 ibase_close($dbh);

 ?

 when it gets called, and I do a select in isql, I do not see any of
 the records. Only after doing a manual commit in isql, I can see
 the new data.

 How is that possible?

 yves

--
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] Variables in MySQL Insert Queries

2001-08-24 Thread KSchneider

plague --

unfortunately i don't have the beginnings of this thread, but if your code 
below is verbatim, it looks as though you are missing the mysql_query() 
statement.  that should drop your information.  


kate

 -Original Message-
 From: plague [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 24, 2001 12:57 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Variables in MySQL Insert Queries
 
 
 I am using this code to connect to my database and insert form data from
 a
 user:
 
 $connect = mysql_connect(myhost,user,pass) or die ( not
 connected);
 @mysql_select_db(dbname);
 $sql=INSERT INTO tablename
 (id,first,last,age,email,sfuser,sfship,icq,ac,loca,ref)
 Values(,`$first`,`$last`,'$age',`$email`,`$sfuser`,`$sfship`,`$icq`,`$ac`,`$
 loca`,`$ref`);
 echo (mysql_affected_rows()?success:failure);
 mysql_close($connect);
 
 The script returns success except for it doesn't insert the data (
 from a
 form ).
 
 The age column is BLOB, not INT.
 
 I would really appreciate the help of someone, as this has really
 stumped
 me.
 
 Thanks,
 
 plague
 
 
 

-- 
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: Zend IDE anyone?

2001-08-24 Thread Grant Boggs

Grant Boggs [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Steve Brett [EMAIL PROTECTED] wrote in message
 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
  no need to recompile.
 
  the debug server is a .so and only needs added lines php.ini

Woohoo!!!

I had a typo in my php.ini file!

Works like a charm.  Very cool.  I think this is what I might be
needing.  Was testing some stuff with it.  I like it so far!  Thanks for the
helpful pointers and saving me the headaches of recompiling!!!

--
==
Grant Boggs
http://www.cornersonesoftware.ws



-- 
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: TopSpeed

2001-08-24 Thread Guilherme Bresser

I have one problem.. TopSpeed don't support ODBC..
:-\

Guilherme Bresser




Hugh Bothwell [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...

 Guilherme Bresser [EMAIL PROTECTED] wrote in message
 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
  Hi... I'm from Brazil my english is bad!!!
 
  Can I connect one Script PHP with a TopSpeed Database (*.tps)??

 Use ODBC 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 9i + apache

2001-08-24 Thread TDuquette


Hi

As anyone sucesfully compiled php4  with OCI  suport as an apache module on
a Oracle 9i database ?
if so i would be very intersted by some tips on how make it work.
i couldnt make it , on a linux Suse7.2, kernel 2.4.4


i have been able to suceffuly compile php statically,  making a symlink from
libclntsh.so.9.0 to libclntsh.so.8.0
if i run php as a comand interpreter for a script ,the script will
sucefully use OCI8 function.

hoever this does not seam to work for a php apache module.
apache wont start (at least for me)
i tried on the oracle apache java server, or on the suse pre installed one
..
i olso tried to compile php on this sytem, but using  withOCI=dir to an old
copy of oracle8 so it would really link with the v8 librarys ... it dont
works neither.

i havent tried yet to make php as static lib to build apache with it as a
static build-in module.
but this is not really an option i can have on production for that system.(i
have to use a third-party apache binary)







-- 
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] I am really stuck

2001-08-24 Thread Rick Emery

I don't believe anybody answered this, but here's an option:

1)   Assumes table mytable has defined a field as:  article_date date.
The following will purge anything before today.
$query = DELETE  FROM mytable WHERE article_date 
.date(Y-m-d,time());

2)  
   $query = SELECT DISTINCT article_date FROM mytable ORDER BY
article_date;
   $result = mysql_query($query) or die(Error message);
   while( $ddrec = mysql_fetch_array($result))
   {
 $dd = $ddrec['article_date'];
 print $dd;  #  you'll have to format this date
print statement
 $query = SELECT * FROM mytable WHERE article_date = $dd;
 $dresult = mysql_fetch_array($query) or die(error message);
 while( $irec = mysql_fetch_array($dresult) )
 {
 print $irec['item_text'].BR;
 }
 mysql_free_result($dresult);
   }
   mysql_free_result($result);

May require some additional tweaking

-Original Message-
From: Matt C [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 6:36 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] I am really stuck


I am extremely stuck with trying to do two things.

1) I would like to pull all entries out of a table that have dates that 
haven't occured yet. Basically forget anything before the current day. How 
do I do that?

2) I enter news into a table and would like to display a summary page. 
Basically it has a list of headlines under the date they were added.

Monday 10th August
*Item 1
*Item 2

Tuesday 11th August
*Item 1

etc

How do I do that?

Any help much appreciated,

Thanks, Matt

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
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] Re: Photo Album Schema

2001-08-24 Thread Bill Zeller

Hi,

By saying id.gif, I obviously didn't mean the id of
the user, I meant the unique id of the image.

I assumed the person making this was going to have one
table setup like so:

id (unique id)
owner
name
description
jpg_or_gif, etc

Then a table with authors..

id
name
pass
email
etc

with author.id = picture.owner

I see no downside to doing that and it seems to be a
relatively effecient way to ensure the uniqueness of
all image names.

Best Regards,
Bill Zeller
--- Sheridan Saint-Michel [EMAIL PROTECTED]
wrote:
 I don't know if having multiple users associated
 with a single image is
 at all beneficial, and I can see where it might
 cause all sorts of problems.
 
 For example, you and I both have the same image in
 our album (we are
  both assciated with it in the DB).  What happens
 when I change the
 description?  Do you change the description field,
 thus changing the
 description on both our pages?  Do you now have to
 create another entry
 in your Image table?  In effect anytime I change the
 description either both
 of us have to live with my new description or you
 have to do a lot of work
 around code (checking to see if more than one person
 is associated with the
 image, Adding a new entry into image, changing all
 my info to reflect the
 new
 Image_Name) to avoid this.
 
 Therefore, I think for this project, the original DB
 structure works much
 better.
 
 Sheridan Saint-Michel
 Website Administrator
 FoxJet, an ITW Company
 www.foxjet.com
 
 - Original Message -
 From: grant [EMAIL PROTECTED]
 To: Sheridan Saint-Michel [EMAIL PROTECTED]
 Cc: Bill Zeller [EMAIL PROTECTED];
 [EMAIL PROTECTED]
 Sent: Thursday, August 23, 2001 1:48 PM
 Subject: Re: [PHP-DB] Re: Photo Album Schema
 
 
  The most useful schema would be to have the name
 of the document be system
  generated, like i123456789.img and make the
 database as follows:
 
  Image
  Image_Name varchar(50) primary key
  Original_Name varchar(50)
  Description text
 
  User
  User_ID int8 primary key
  Login char(8) uniques index
  password varchar(50) encrypted
 
  relation
  User_ID
  Image_Name
 
  Now you have duplicate anems OK, multiple users
 associated with any
  picture.  You just rename the file as it comes and
 goes.
 
 
 
 -- 
 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]
 


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.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]




Re: [PHP-DB] Access tables to PostgreSQL

2001-08-24 Thread Alexandre Santos

Grant wrote:
 
 On Wed, 22 Aug 2001, Tim O'Brien wrote:
 
  What is the best method to move data from access tables to postgreSQL?
 
  Are there are php functions that are available?
 
 Unfortunately, only Access reads Access very well, but you can use ODBC
 and linked tables in Access to copy it to PostgreSQL.
I copied tables from Access to Postgres using this method:
1. Install the ODBC Driver in your Windows Box.
2. Export the tables to Postgres.
If the second pass doesn't work, create the tables in POstgres and then
link them in Access and build a append query that copies all the
information from the acess tables to the postgres tables.

Alex

-- 
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: Extensions on SuSE

2001-08-24 Thread Alexandre Santos

Ridai Govinda Pombo wrote:
 
 Does anyone know how to get the _binary_ extensions for PHP installed with
 SuSE 7.2 ?
 
 I think it needs to recompile... But I wanted a easier way to solve it...
 
 Thanks,
 
 Ridai Govinda

Do you mean doing in Linux the same as in Windows? Only doing some
comment in php.ini and another extension installed?
I installed the SAPDB extension recompiling the source code...

Alex

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

2001-08-24 Thread Alexandre Santos

Hi all,
I've been using SAPDB and PHP, but it doesn't have functions of it own.
It uses the Unified ODBC.
Is it something bad? MySql, Postgres, Oracle and others have functions
for that particular DB. Will it be slower?

Alex

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

2001-08-24 Thread tony . mccrory


on slashdot.org today...

;)
   

   

 http://software.tangent.org/article.pl?sid=01/08/23/0817244mode=threadthreshold=

   

   

 MySQL Gets Perl Stored Procedures 

   

   

   

 (Embedded image moved to file: pic22355.gif)Posted by CmdrTaco on Friday August 24, 
@11:52AM  
 from the well-isn't-that-special dept.

 ryarger writes Woo Hoo! After a seeming eternity of wait, there is finally an 
implementation of  
 stored procedures for MySQL. It uses Perl as the stored proc language, too! Also 
note that this  
 piece of work was done by OSDNs own Krow. Very cool work I must say.  

   

   

 ( Read More... | 155 of 221 comments )

   






   

Rick Emery 

remery@excelTo: 'Francisco Carvalho' 
[EMAIL PROTECTED],
.com'[EMAIL PROTECTED]' 
[EMAIL PROTECTED]   
 cc:   

08/23/2001   Subject: RE: [PHP-DB] Store Procedures

10:08 PM   

   

   





no

-Original Message-
From: Francisco Carvalho [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 4:20 PM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] Store Procedures


Newbie question.

I've been developing web application in IIS using ASP and Microsoft SQL
Server 7.0.
I use Stored Procedures  quite extensible is there an equivalent in MySQL

Thanks.
Francisco Carvalho

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




IMPORTANT NOTICE  The information in this e-mail is confidential and should
only be read by those persons to whom it is addressed and is not intended
to be relied upon by any person without subsequent written confirmation of
its contents.  Furthermore, the content of this e-mail is the personal view
of the sender and does not represent the advice, views or opinion of our
company.  Accordingly, our company disclaim all responsibility and accept
no liability (including in negligence) for the consequences of any person
acting, or refraining from acting, on such information prior to the receipt
by those persons of subsequent written confirmation.  In particular (but
not by way of limitation) our company disclaims all responsibility and
accepts no liability for any e-mails which are defamatory, offensive,
racist or in any other way are in breach of any third party's rights,
including breach of confidence, privacy or other rights.  If you have
received this e-mail message in error, please notify me immediately by
telephone.  Please also destroy and delete the message from your computer.
Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and/or publication of this e-mail message is strictly
prohibited.  Trinity Mirror plc is the holding company for the Trinity
Mirror group of companies and is registered in England No. 82548, with its
address at Kingsfield Court, Chester Business Park, Chester CH4 9RE.


-- 
PHP Database Mailing List 

[PHP-DB] Re: TopSpeed

2001-08-24 Thread Hugh Bothwell


Guilherme Bresser [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 I have one problem.. TopSpeed don't support ODBC..
 :-\

This is the only method I've seen for languages other than Clarion.
http://www.softclaim.com/odbc_interface.htm

If there ARE any other methods, I'd love to hear about them!



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

2001-08-24 Thread Grant Boggs

Anyone use Komodo to do remote debugging?

I can't get the remote debugger feature to work.  I have Linux Red Hat
7.1, apache, php 4.0.6.

When I start Komodo IDE, and load a web-page in my browser, the Komodo
IDE never seems to get connected.  It just sits in the listening mode
indefinitely.  The web page loads as normal BAH!
--
==
Grant Boggs
http://www.cornersonesoftware.ws



-- 
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] Can DBA(Database Abstract) function can work under Win2k?

2001-08-24 Thread Donald FEI

My PHP runs under:
 Windows 2000 Professional + Apache/1.3.20 + PHP4.0.6 + MySql3.23.32
when i compile the following code:
 ?php
$db=dba_open(database.db,c,db2);
?
There is the error:
Fatal error: Call to undefined function: dba_open() in
D:\Inetpub\WebSite/dba_test.php on line 2
Thank you!



-- 
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] PHP/MySQl Consultation

2001-08-24 Thread Randy Johnson

I am in need of someone that is very good at PHP and MySQL to view my
scripts and discuss with me in detail on how to speed up my scripts and how
to speed up mysql some.   if you are interested please send me credentials
and rates ASAP  please send them to [EMAIL PROTECTED]


Thank you,


Randy
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.268 / Virus Database: 140 - Release Date: 8/7/2001


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