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'
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
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:
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
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:
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
--- 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
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
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()
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
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
$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
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
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 |
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
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
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,
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'
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
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
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
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
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
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
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/)
Hmmm try something like:
$sql = EXPLAIN dbame.table_name;
This will show something like:
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
|
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
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
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
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
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
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:
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
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
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
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
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
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
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
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,
on slashdot.org today...
;)
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
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
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!
--
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
45 matches
Mail list logo