I've posted notes on PHP Manual
http://www.php.net/manual/en/install-windows.php
It might help.
--
Yasuo Ohgaki
""Shahmat Dahlan"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have IIS 4 with PHP 4pl1 run
I think it's time to read the manual.
http://jp.php.net/manual/en/langref.php
http://jp.php.net/manual/en/language.variables.scope.php
http://jp.php.net/manual/en/functions.php
--
Yasuo Ohgaki
""olinux"" <[EMAIL PROTECTED]> wrote in message
000f01c0b83
pends on your DB.
--
Yasuo Ohgaki
""Matt Braynard"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have created a news script and to my dismay, the script is breaking when
> there is a single quote - ' - in
lation instruction closely (PostgreSQL, Apache, PHP)
there would be no problems.
Make sure you build/install them with this order. PostgreSQL->Apache->PHP.
>
> Is there an easy way to do this sort of stuff on Linux or is it better to
> just buy off the shelf products that work?
no matter what I pass to pg_FieldNum(), I get -1 (error) in
> return.
>
> Anyone spot what I am doing wrong?
>
> I am using PostgreSQL 7.0.2 and PHP 4.0.3 on RH Linux 7.0.
>
I think you need to upgrade your PHP versoin.
I'm using 4.2.0-dev/PostgreSQL 7.1.3. I do not
have
Read current manual page.
If you still have problem, let me know what's the problem.
http://www.php.net/manual/en/ref.session.php
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
r that.
> I can't use Large Object cause I connecting to Postgres via ODBC
> ( there is no support for large objects ).
> Have anybody solved this problem? is there any alternative datatypes or ways
> of solution?
If you are using PostgreSQL and PHP, just use pgsql extension.
--
Y
r that.
> I can't use Large Object cause I connecting to Postgres via ODBC
> ( there is no support for large objects ).
> Have anybody solved this problem? is there any alternative datatypes or ways
> of solution?
If you are using PostgreSQL and PHP, just use pgsql extension.
--
Y
Could you post backtrace and CC the meesage to me?
I'm almost sure pgsql module will never cause segfault
like this, I can tell more if you send backtrace.
PS: If you don't know how to get backtrace, visit
http://bugs.php.net/
--
Yasuo Ohgaki
Kevin Traas wrote:
> Greet
you can replace old PostgreSQL
module by new one. There are many new functions that will be
avaiable in PHP 4.2.0 also.
Bug reports and comments are welcome.
Enjoy.
--
Yasuo Ohgaki
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
; sometimes my windows counterparts (who write in ASP or iHTML)
> think it's funny PHP has so many ways to do certain things, and so
> few ways to do other things. =)
Oh no. You are saying PHP is like a PERL.
PHP stands for "People Hate PERL".
(Just kidding, I like PERL and other
Adam Voigt wrote:
> think it's funny PHP has so many ways to do certain things, and so
> few ways to do other things. =)
I forgot to ask.
May I ask what kind of features/functions are missing?
It does not have to be about PostgreSQL module.
--
Yasuo Ohgaki
--
PHP Database Mailing
ne.
> 2. Weak Error Handling, We could not get the custom error
PHP5 has "try", "catch".
However, there are many rooms for improvements...
> in ASP or iHTML for that matter, I'm a pure PHP evangelist from
> top to bottom.
:)
--
Yasuo Ohgaki
>
> Adam Voi
ficient? Is it my modelling-scheme that
> sucks or could it be that mysql is leaking memory in some way?
> Would it help to move mysql to a separate machine?
If you do normal query, mysql store whole result in memory!
You can avoid that. It's in the manual.
--
Yasuo Ohgaki
server
process can allocate...
--
Yasuo Ohgaki
Trond Erling Hundal wrote:
> Thanks Yasuo Ohgaki and Gurhan Ozen.
>
> My system has 256mb of DDR ram, it's a Intel PIII 900Mhz processor.
>
> Ps -aux | grep mysql shows that about all of the mysql connections uses
> about 15mb o
Does this happen with latest PHP? If yes, please report
this as a bug.
PS: Current PostgreSQL module is trying to rollback
uncommitted transactions when request is finished.
This is old postgresql module issue, probably.
--
Yasuo Ohgaki
Max Buvry wrote:
> Hi,
>
> I use Postgresql
print all records in
a result set.
--
Yasuo Ohgaki
Brown wrote:
> # Sorry to my poor English
>
> I have a procedure ( named by select_table )
>
> ##
> BEGIN;
> select select_table('select_cur','tab
Don't cross post such question...
All you need to understand is how cookie is managed unless
you are passing session id via URL.
Read RFC2965 and RFC2964.
You probably want to read netscape cookie spec also.
--
Yasuo Ohgaki
Youngie wrote:
> Why would my session data not be deleted
Matthew Newby wrote:
> I am having trouble with the pg_fetch_result function when trying to access
> a boolean field in a PostgreSQL database. Here's the code snippet:
It's a spec.
PostgresSQL's boolean is returned as 't' or 'f' and both are string.
T
table ttt ("ThisIsNumber" int);
CREATE
test=# \d ttt
Table "ttt"
Column| Type | Modifiers
--+-+---
ThisIsNumber | integer |
test=# create table (ThisIsNumber int);
CREATE
test=# \d
Table ""
Column| T
xplicitly
> states:
I didn't notice this documentation error. (I suppose it was correct
when it is written, but psql return 't' or 'f' now)
Thanks. It is fixed.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
.postgresql.org/idocs/
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
; UPDATE the second bank account with v+1 (debit)
> COMMIT WORK
It works for me. (at least with CVS version)
If there is uncommitted transaction, pgsql module
rollback automatically.
BTW, if you have too long timeout limit, your site
became weaker for DoS attack.
--
Yasuo Ohga
Edwin Robertson wrote:
> With psql you can get all your output in HTML format. Anyone know of a way
> to do this in PHP?
It's psql feature and there is no automatic HTML format
in PHP's pgsql module.
If really would like, you can use passthru() and psql.
where
ould like, you can use passthru() and psql.
>
> passthru('/usr/local/pgsql/bin/psql -f select.sql -H -U yohgaki -d test');
> ?>
>
> where "select.sql" is query you need.
>
> --
> Yasuo Ohgaki
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
IIRC, someone added automatic rollback to MySQL from PHP 4.3.0 just
like PostgreSQL.
BTW, PostgreSQL module rollbacks uncommitted transaction automatically
from PHP3.
--
Yasuo Ohgaki
John W. Holmes wrote:
I Am using the latest PHP version 4.2.3 with MySQL 3.23.51-max. I use
InnoDB tables for
Why you want to create MAC address type? It's already there in V7.
macaddr| XX:XX:XX:XX:XX, MAC address
Besides, do you have functions defined for INPUT and OUTPUT?
You must define them. Refer to PostgreSQL User Manual for details.
Regards,
--
Yasuo Ohgaki
"Olivier Thauvi
PHP takes care of closing it, just like other resources. However, it seems there
is bug in closing none persistent PgSQL link in current version. 4.0.5 hopefully
fix this.
Regards,
--
Yasuo Ohgaki
"Sharmad Naik" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]"&
ively faster, I think it's acceptable to use
pg_Connect() in most cases.
I haven't tested how transaction will be performed on persistent link.
Does anyone know transaction issues on persistent link?
What happens if there are multiple transactions on the same database link?
Thanks,
this helps.
--
Yasuo Ohgaki
"John Starkey" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I've been using mysql too much lately.
>
> Can anyone tell me how to set up an auto increment in postgres? I need
> to select a r
Did you have install pgsql.dll in your system directory? and load the extension?
I noticed pg_cmdtuples() is missing, though.
--
Yasuo Ohgaki
""Jerome O Macaranas"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> using PHP 4.0 under Win2K IIS 5.0
pg_cmdtuples(), it would be really nice.
--
Yasuo Ohgaki
""Jerome O Macaranas"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> using PHP 4.0 under Win2K IIS 5.0
>
> got this error
> -> Fatal error: Call to undefined function: pg_connect() in
C
It not related to database. Anyway,
If you use $HTTP_SESSION_VARS, forget about session_(un)register(). (Do not use
them)
Just use $HTTP_SESSION_VARS. It's known issue.
(If you use global vars, only use global vars and use session_(un)register())
Regards,
--
Yasuo Ohgaki
""
h 7.1 libpq for PHP4.0.4pl1, could you tell where to get or
send it to me?)
--
Yasuo Ohgaki
--
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]
pq7.1. With 7.0, it will gives you a lot of troubles.
Regards,
--
Yasuo Ohgaki
""Marc Blum"" <[EMAIL PROTECTED]> wrote in message
9c64tv$k7u$[EMAIL PROTECTED]">news:9c64tv$k7u$[EMAIL PROTECTED]...
> Hello
>
> We're trying to get this running. ph
E_ALL for one,
different setting for other.
Regards,
--
Yasuo Ohgaki
""Brad Hubbard"" <[EMAIL PROTECTED]> wrote in message
015301c0cdfc$bc211030$3200a8c0@BADNOTE">news:015301c0cdfc$bc211030$3200a8c0@BADNOTE...
> Does anyone know what causes PHP to generate the
gards,
--
Yasuo Ohgaki
"Ron Patterson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi there,
I'm building the new PHP-4.0.5 with support for PostgreSQL 7.1 database and
get the following build error:
gmake[3]: Entering directory `/
o post your problem in PostgreSQL list.
If you are not using 7.1.2, upgrade to 7.1.2 see if you have problem.
If you get core file, confiugre/build PostgreSQL with debug and post
back trace to list.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail:
I have very smilar code and they are working for me.
I'm using
- PHP4.0.6 and PHP4.0.7RC1
- PostgreSQL 7.1.3
They are built from source.
Your PHP might be linked against older libpq(?) than your PostgreSQL?
--
Yasuo Ohgaki
Justin Buist wrote:
> I recently did a re-install of Postgr
I have very smilar code and they are working for me.
I'm using
- PHP4.0.6 and PHP4.0.7RC1
- PostgreSQL 7.1.3
They are built from source.
Your PHP might be linked against older libpq(?) than your PostgreSQL?
--
Yasuo Ohgaki
Justin Buist wrote:
> I recently did a re-install of Postgr
php-dev list ([EMAIL PROTECTED])
Someone will takes care of your patch.
If you really would like to know who is the maintainer, take a look at
EXTENTIONS file in source.
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional com
>
> Anyone hints, tips or just downright solutions would be greatly appreciated
> :)
> -torrent
How about take a look at the manual page?
http://www.php.net/manual/en/ref.errorfunc.php
You may also be interested in output buffering.
Look for ob_start(), ob_end_clean(), etc.
--
Yasuo
ill have problem with 4.1.0RC5, submit bug report.
Regards,
--
Yasuo Ohgaki
--
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]
ad php.ini-dist or php.ini-recommened)
--
Yasuo Ohgaki
--
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]
ten, no need to report
this.
BTW, it seems dbase extesion does not require any external lib.
You should be able to use it under UNIX, if it is working :)
Use of dbase for production system is not recommended as
described in the manual.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://w
me here..
>
It sounds like memory limmit and bailout problem.
Get rid of memory limit or increase memory limit,
it this is the case.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROT
[EMAIL PROTECTED] wrote:
> Where I can get PHP Library Extensions for linux redhat 7.1, i need
> dbase library
>
> Thanks
>
>
Accoding to config.m4, dbase extension does not require external lib.
I might be worng, though.
--
Yasuo Ohgaki
--
PHP Database Mailing List (
ve extension php_db and php_dba (and some others) included in as
> modules. so.. what's wrong?
>
> - Juffe
>
If you are using PostgreSQL module, do not use PostgreSQL for now.
I'll work on conflict issue later, but I don't think it will be
fixed any time soon
--
Y
odule() function in the so
file. Strange, since it is in source. Which PHP version are you using?
Try 4.1.0 or 4.2.0-dev see if it helps.
--
Yasuo Ohgaki
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
PHP
#x27;, value = '$value'
>WHERE sesskey = '$SID' AND expiry > " . time();
> $result = mysql_query($qry);
> }
> }
>
> function sess_destroy($SID) {
> global $SESS_TABLE;
>
> $qry = "DELETE FROM $SESS_TABLE WHERE sesskey = '$SID'";
> $result = mysql_query($qry);
> }
>
> function sess_gc($SESS_LIFE) {
> global $SESS_TABLE;
>
> $qry = "DELETE FROM $SESS_TABLE WHERE expiry < " . time() - $SESS_LIFE;
> $result = mysql_query($qry);
>
> return mysql_affected_rows($result);
> }
>
> session_set_save_handler(
> "sess_open",
> "sess_close",
> "sess_read",
> "sess_write",
> "sess_destroy",
> "sess_gc");
> ?>
>
--
Yasuo Ohgaki
--
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]
haring
database server with many users until PostgreSQL 7.3)
--
Yasuo Ohgaki
Boaz Yahav wrote:
This is why i was amazed to see this : http://www.mysql.com/eweek/index.html
-Original Message-
From: David Bryant [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 10:43 PM
To: &#x
ought original poster would like to compare PostgreSQL
and MySQL.
What's this got to do with PHP? Nada... Happy New Year!
Compare performance PostgreSQL and MySQL using PHP?
Have a happy new year.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, v
broken.
Are you using the same version of libpq?
i.e. When you connect to 7.3 backend, use libpq comes with 7.3.
7.3 is not compatible with earlier versions of libpq as noted in
PostgreSQL documents.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
53 matches
Mail list logo
