[PHP-DB] COPY with PostgreSQL

2004-10-22 Thread Robert Fitzpatrick
I am using COPY for PostgreSQL and having problems now that the incoming file contains more than approx 1500 lines. Is this an issue anyone is aware of? Lot's of files over 1000 lines have worked fine, but after getting a file over 1800 I began having problems. I have broke the file down to a

RE: [PHP-DB] Logging Into A MySQL (Web) Database

2004-10-22 Thread Graham Cossey
Probably an off-list posting. That's the problem of just using 'Reply' instead of 'Reply to All' on this list. Other lists I subscribe to always only ever have the list email address when replying, which in my opinion is a better way of doing things. [snip] Ok, who is Alex? If you are

RE: [PHP-DB] Logging Into A MySQL (Web) Database

2004-10-22 Thread Alex Egberink
Hi, I don't post much, because not very busy with php, but did send it with a reply to all. Only my mail was not accepted ( html format :P ) return mail : 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

Re: [PHP-DB] Cookies with databases

2004-10-22 Thread Bastien Koert
Run the setcookie code, and open the folder where your browser stores its cookies. Look for your cookie and see it whats in it is what you expect. Another suggestions is to echo out the code before you execute it to see if the values you expected are there echo setcookie ('USERcookie',

[PHP-DB] How to send a SID in a security way

2004-10-22 Thread Andre Matos
Hi List, How can I send a SID (SessionID) in a security way from one page to another? Is it security to do this? Thanks for any help in advance. Andre -- Andre Matos [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] How to send a SID in a security way

2004-10-22 Thread Bart Baaten
The session ID will always remain inside the session as long as you're in the session. http://www.php.net/manual/en/function.session-id.php You don't have to 'send' it, it's already there. Hope this helps... -Original Message- From: Matt M. [mailto:[EMAIL PROTECTED] Sent: vrijdag 22

Re: [PHP-DB] How to send a SID in a security way

2004-10-22 Thread Jason Wong
On Saturday 23 October 2004 01:00, Bart Baaten wrote: The session ID will always remain inside the session as long as you're in the session. http://www.php.net/manual/en/function.session-id.php You don't have to 'send' it, it's already there. And to 'stay in the session', the session id has

RE: [PHP-DB] How to send a SID in a security way

2004-10-22 Thread Bastien Koert
What about writing a function that will store some of those required variables into a db. Then on the second site, open a link to the first db and query for those values that you need? bastien From: Andre Matos [EMAIL PROTECTED] To: 'Matt M.' [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject:

RE: [PHP-DB] How to send a SID in a security way

2004-10-22 Thread Norland, Martin
I'm sorry - but performing a slight bastardization of Achems Razor is the best way to solve this dilemma. You have two web-based php applications that you have written yourself, and you have a single user (and browser) who wants to access those applications. The applications reside on the same

RE: [PHP-DB] How to send a SID in a security way

2004-10-22 Thread Andre Matos
I had thought about this idea to storage the session information in a database. However, what's happening if a user just closes the browser without logout from the application or if the browser crashes. The session will be in the database and the user is gone. How to track this? Thanks. Andre

[PHP-DB] imagecreatefromjpeg()

2004-10-22 Thread Perry, Matthew (Fire Marshal's Office)
I am using PHP 4.1 Why would the php function imagecreatefromjpeg() not be recognized? Fatal error: Call to undefined function: imagecreatefromjpeg() in C:\Program Files\Apache Group\Apache2\htdocs\Inventory\updateitem.php on line 77 -Matthew Perry

RE: [PHP-DB] imagecreatefromjpeg()

2004-10-22 Thread Bastien Koert
Have you enabled the gd library? If windows, have you copied the php_gd2.dll to the c:/windows/ folder? bastien From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] imagecreatefromjpeg() Date: Fri, 22 Oct 2004 13:45:02 -0500 I am using PHP 4.1

RE: [PHP-DB] imagecreatefromjpeg()

2004-10-22 Thread Norland, Martin
Check phpinfo() and see what options it was compiled with - at the very least you need gd support (--with-gd) and probably need to specify (--with-jpeg-dir) to point to jpeg libs. Aside from your configure line, you should be able to see from perusing whether the image functions are supported.

RE: [PHP-DB] How to send a SID in a security way

2004-10-22 Thread Bastien Koert
Write a function that gets called frequently (or with a cron job) to clean out session records every half an hour or so... Each time a page loads with those session vars, update the timestamp in that record. bastien From: Andre Matos [EMAIL PROTECTED] To: 'Bastien Koert' [EMAIL PROTECTED] CC:

[PHP-DB] Making php to make xml file with mysql query results.

2004-10-22 Thread Juan Stiller
Ok guys, after reading some tutorials, and seraching flash mailing lists, i don´t remember if someone here recommend me it too, i need to make php to insert a mysql query results on an xml file. I don´t have a clue how to do that, can anyone help me with this? This is the php content that sends

RE: [PHP-DB] How to send a SID in a security way - SOLVED!!!

2004-10-22 Thread Andre Matos
Hi list, Thanks for all people who tried to help me in my session problem. I have found a simple and easy way to have to web-based php applications running in the same server and having one user using both on the same web browser (two different windows or tabs). I did this in one system:

RE: [PHP-DB] How to send a SID in a security way - SOLVED!!!

2004-10-22 Thread dpgirago
Andre, Did you intend to write that both sessions have the same name? Doesn't that result in the same issue with the session identification? dave Andre Matos [EMAIL PROTECTED] 10/22/2004 03:25 PM To: [EMAIL PROTECTED] cc: Subject: RE: [PHP-DB] How to send a SID in a security way

RE: [PHP-DB] COPY with PostgreSQL

2004-10-22 Thread Robert Fitzpatrick
On Fri, 2004-10-22 at 15:45, Norland, Martin wrote: What are the line endings of the file? Maybe php is getting confused. How many KB is the file on disk when it's the ~1500 line version? There's length of each line (which you want under 1KB, probably not a problem unless you have BLOBS or

[PHP-DB] Aliased mysql queries and mysql_fetch_array()

2004-10-22 Thread Philip Thompson
Hi all. I am having a problem obtaining the specific information I need. I have a table of people that can have multiple rows - ie, Director, Manager, etc. However, in the projects table, each project has a director AND manager, but not necessarily the same person. I have the query to pull the

Re: [PHP-DB] Aliased mysql queries and mysql_fetch_array()

2004-10-22 Thread John Holmes
Philip Thompson wrote: I have the query to pull the information - and I know it works for everything else. Now how do I reference the director/manager to store it in a variable without having to use numerical indexing? $query = select projects.*, locations.*, funding.*,

Re: [PHP-DB] Two session for the same user, possible?

2004-10-22 Thread Micah Stevens
You can have two scripts talking to the same browser session by setting different session cookie names. Depending on which script is being loaded it will look at a different cookie to find out the session ID, once again, I have not tried it, but there is no reason why it wouldn't work, and not

RE: [PHP-DB] How to send a SID in a security way - SOLVED!!!

2004-10-22 Thread Bart Baaten
I think he meant one was named System1 and the other System2. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: vrijdag 22 oktober 2004 22:34 To: Andre Matos Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] How to send a SID in a security way - SOLVED!!! Andre, Did