My PHP runs under:
Windows 2000 Professional + Apache/1.3.20 + PHP4.0.6 + MySql3.23.32
when i compile the following code:
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.
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
inde
"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 a
on slashdot.org today...
;)
http://software.tangent.org/article.pl?sid=01/08/23/0817244&mode=
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-m
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
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 Acces
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 auth
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
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 f
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
"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
Wo
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: Fr
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,
"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
>
> we used the windoze ide clients whihc install easily if you have JRE. if
not
> you need to downoad/install.
>
If this is an exact copy of your script, then you've surrounded each
variable name in the VALUES(...) with back-ticks. Why?
-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
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]> wr
Can you show us your OCIConnect statement? It returns a handle to a variable
that you should use as your connection resource...
> From: "Matteo" <[EMAIL PROTECTED]>
> Date: Fri, 24 Aug 2001 10:03:46 +0200
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] [PHP-ORACLE] a lot of errors!!!
>
> I have a s
"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
> > 03a
"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
http://www.php.net/manual/en/function.mysql-list-tables.php
> -Original Message-
> From: kelvin [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 24, 2001 5:09 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] How to show table???
>
>
> Hi there,
>
> I just wonder how to list all the
"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/)
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
[
Hmmm try something like:
"$sql = "EXPLAIN dbame.table_name";
This will show something like:
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
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/)
T
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
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
re
"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 t
"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).
>
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 recommendation
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
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' ov
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
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 comma
i don't thing <99% sure> that it can be done.
you can decalre a transaction and then [begin 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 l
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 | gz
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
>dev
$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
well...
$zero = "0";
$one = "1";
$obj->$zero and $obj->$one works... but
$obj->"0" or $obj->'0' doesn't... :((
esthetically, it is not great ! you have to provide vars to access
properties' object ! $zero, $one, ... $ten, $eleven, ...
something more simple or easier to access these kind of pr
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 a
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_NU
the "satanic" sql.safe_mode was On... :(
put it Off and it's works...
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]
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
--
>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_o
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 administrato
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
---< Original message >---
From: Russ Michell <[EMAIL PROTECTED]>
Date: Fri, Aug 24, 2001 at 12:47:42PM +0100
Message-ID:
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 n
show us some lines around the line 47
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Russ
> Michell
> Sent: Freitag, 24. August 2001 13:48
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Fatal error
>
>
> Hi there folks - this isn't *entirley* a DB
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 h
> 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: [E
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 h
Hi all,
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 ne
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
Subjec
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
data
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'
'
55 matches
Mail list logo
