[PHP-DB] Anybody using PostgreSQL?

2004-04-14 Thread Tumurbaatar S.
In PHP5 manual, it says that when using large objects functions of PostgreSQL, a program should manually begin/end transaction. But what about other query/exec functions? Do I need to control transactions or every function call implicitly wrapped with transaction block? What if a command consists

[PHP-DB] PHP truncating data

2004-04-14 Thread Brock Jimmy D Contr DODHSR5
I have a couple of text data type fields in a MS SQL Server 2000 database. It stores the data in the table without any problem. However, when I go to display the data on a PHP page it is being truncated after 255 characters. Any suggestions? Jimmy This document may contain information

[PHP-DB] quotations in value field

2004-04-14 Thread Mikael Grön
Hey people! I have a problem with an email form of mine. I want the user to be able to preview his message before sending it off to the hundreds of subscribers. Problem is, if there's one or more double quotes () in the subject (for which I use an input text field) it gets f*cked up. Example:

Re: [PHP-DB] DB and mssql

2004-04-14 Thread Matt Matijevich
[snip] Hi Matt Before sending the result set, the mssql extension stores the entire result set into memory. However, PHP limits the amount of memory that can be allocated by a script to 8MB. So, the query will fail if the result set is larger than 8MB. You can change this value in php.ini with

Re: [PHP-DB] quotations in value field

2004-04-14 Thread Mikael Grön
Well, I guess a combination of htmlspecialchars and some other function to convert it back, before it gets sent of in the _plain text mails_. Thanks for the help dude! Mike On Apr 14, 2004, at 15:14, H-Mac Moderator wrote: Mikael- I suspect you want htmlspecialchars, Not stripslashes. See:

RE: [PHP-DB] quotations in value field

2004-04-14 Thread Ford, Mike [LSS]
On 14 April 2004 15:21, Mikael Grön wrote: On Apr 14, 2004, at 15:14, H-Mac Moderator wrote: Mikael- I suspect you want htmlspecialchars, Not stripslashes. See: http://us4.php.net/manual/en/function.htmlspecialchars.php Well, I guess a combination of htmlspecialchars and some other

[PHP-DB] headers already sent

2004-04-14 Thread matthew perry
When I insert the following header: header (Content-type: application/vnd.ms-excel); header (Content-Disposition: attachment ); I get the messages: *Warning*: Cannot modify header information - headers already sent by (output started at C:\Program Files\Apache

[PHP-DB] postgresql

2004-04-14 Thread Adam Williams
Hi, I know this isn't PHP related but I have a quick question about postgresql. I come from a mysql enviroment so I'm a little clueless, even after reading the postgresql docs. I am moving a postgresql database from one server to another. As the user that owns the database, lculber, I ran

Re: [PHP-DB] headers already sent

2004-04-14 Thread Jorge Oliveira
You have some content at line 2 in file trial.php. Check if there is a space (or a session command) at that line. -- Jorge Oliveira » Cloreto.com matthew perry wrote: When I insert the following header: header (Content-type: application/vnd.ms-excel); header (Content-Disposition:

[PHP-DB] Re: headers already sent

2004-04-14 Thread pete M
make susre that the ?php does not have any whitespace before it.. caught me out on a few ocassions - eg in an include file as trailing spaces pete Matthew Perry wrote: When I insert the following header: header (Content-type: application/vnd.ms-excel); header (Content-Disposition:

Re: [PHP-DB] DB and mssql

2004-04-14 Thread Robert Twitty
On Wed, 14 Apr 2004, Matt Matijevich wrote: [snip] [/snip] Thanks for the response. If I was hitting the memory limit, wouldn't php throw me some kind of error? Or would it just abort? It's normally the job of the extesion to report the error. But, I am not completely sure because I have

[PHP-DB] PHP OO Problem

2004-04-14 Thread Andre Matos
Hi List, Two months ago I developed a project using PHP and MySQL without problem. Now, I am developing using PHP and MySQL, but using PHP Object Oriented. My problem is that the access is become slowly after few accesses or if I perform a reload some times. The unique way to revert is to

[PHP-DB] Re: postgresql

2004-04-14 Thread Jason S Motes
if i remember correctly you have to do this su su postgres createuser your-user-id Adam Williams wrote: Hi, I know this isn't PHP related but I have a quick question about postgresql. I come from a mysql enviroment so I'm a little clueless, even after reading the postgresql docs. I

[PHP-DB] Re: PHP OO Problem

2004-04-14 Thread Justin Patrin
Andre Matos wrote: Hi List, Two months ago I developed a project using PHP and MySQL without problem. Now, I am developing using PHP and MySQL, but using PHP Object Oriented. My problem is that the access is become slowly after few accesses or if I perform a reload some times. The unique way

Re: [PHP-DB] Anybody using PostgreSQL?

2004-04-14 Thread Martin Marques
El Mié 14 Abr 2004 07:39, Tumurbaatar S. escribió: In PHP5 manual, it says that when using large objects functions of PostgreSQL, a program should manually begin/end transaction. But what about other query/exec functions? Do I need to control transactions or every function call implicitly

[PHP-DB] about unsecure connection to mysql

2004-04-14 Thread Sukanto Kho
Hi all, I've created a file named 'connection'(used to connect to mysql server)... This file connect to mysql server with user=root en password inserted The problem is user name (in this case root) and password appeared in file... so that anyone who get the file may know what the password

RE: [PHP-DB] Pass database id through href

2004-04-14 Thread Gavin Amm
Thanks John, Pointed me in the right direction. This was the actual code I ended up needing. (! Ignore this e-mail if it will offend you containing JavaScript info rather than php/db info; I did need to figure this out for my db to be updated appropriately...) (1st you need to define the

Re: [PHP-DB] about unsecure connection to mysql

2004-04-14 Thread John W. Holmes
Sukanto Kho wrote: I've created a file named 'connection'(used to connect to mysql server)... This file connect to mysql server with user=root en password inserted The problem is user name (in this case root) and password appeared in file... so that anyone who get the file may know what the

[PHP-DB] I am new to PHP

2004-04-14 Thread andy amol
Hi. This is the qmail-send program at pb1.pair.com.I'm afraid I wasn't able to deliver your message to the following addresses.This is a permanent error; I've given up. Sorry it didn't work out.[EMAIL PROTECTED]:ezmlm-manage: fatal: I don't accept messages at this address (inlocal and/or

Re: [PHP-DB] about unsecure connection to mysql

2004-04-14 Thread John Newbigin
I have a proposal for a solution to this problem. At the moment it is not ready for use but I welcome feedback on the idea. You can read my proposal and download the code from here: http://uranus.it.swin.edu.au/~jn/linux/php/passwords.htm John. Sukanto Kho wrote: Hi all, I've created a

[PHP-DB] I am new to PHP

2004-04-14 Thread andy amol
Hi, I have a problem with the second file. I am not able to update the data from the php program. Any help on that would be appreciated. Any modification which would be reduce the code like directly using the Update command would be appreciated. thanks in advance. Here are the 3 files.

[PHP-DB] links to maps

2004-04-14 Thread matthew perry
Anyone know a quick and easy way to fill in the address on a yahoo maps form? I want a link from my page to fill in all the details I already know so my users don't have to enter it. - Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] links to maps

2004-04-14 Thread Kosala Atapattu
Anyone know a quick and easy way to fill in the address on a yahoo maps form? I want a link from my page to fill in all the details I already know so my users don't have to enter it. Ok this is not just quick-way but dirty as well. Forge the front-end page anyway U want (but with the same

Re: [PHP-DB] links to maps

2004-04-14 Thread Ignatius Reilly
Use the cURL library. _ - Original Message - From: matthew perry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 15, 2004 6:39 AM Subject: [PHP-DB] links to maps Anyone know a quick and easy way to fill in the address on a yahoo maps form? I

[PHP-DB] PHP - Dom -XML

2004-04-14 Thread santhosh
How do I install my php which support dom-xml. PHP on my RHlinux 7.2 and PHP 4.3 Regards, Santhosh Kumar.M