php-general Digest 20 Jul 2006 04:01:47 -0000 Issue 4248

2006-07-19 Thread php-general-digest-help
php-general Digest 20 Jul 2006 04:01:47 - Issue 4248 Topics (messages 239570 through 239603): Class ADODB - Method GenID() in MySQL 239570 by: Renne Rocha 239571 by: John Meyer 239573 by: chris smith 239575 by: John Meyer 239578 by: Renne Rocha

[PHP] Re: User defined function problem

2006-07-19 Thread Stephen Lake
Thanx Jon and Jochem for the reminders, they were much appreciated. :) Best Regards, Steve Stephen Lake [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hey Guys and Gals, I am having a small problem with a user defined function, I placed it in a config file and it works as

[PHP] Class ADODB - Method GenID() in MySQL

2006-07-19 Thread Renne Rocha
Hello, I am using the ADODB class to connect to a MySQL server. I am trying to generate an ID with the method GenID(), but when I tried this: $id = $db-GenID('table'); The value of $id is equal to zero. I know that MySQL doesn't use sequences like PostgreSQL does (I've used this code in a

Re: [PHP] Class ADODB - Method GenID() in MySQL

2006-07-19 Thread John Meyer
Renne Rocha wrote: Hello, I am using the ADODB class to connect to a MySQL server. I am trying to generate an ID with the method GenID(), but when I tried this: $id = $db-GenID('table'); The value of $id is equal to zero. I know that MySQL doesn't use sequences like PostgreSQL does (I've

Re: [PHP] pg_query and COPY in transaction

2006-07-19 Thread David Tulloh
Luis Magaña wrote: I have the following code: pg_query($conn,BEGIN TRANSACTION; DELETE FROM codigo_postal; COPY codigo_postal(codigo_postal,asentamiento,tipo_asentamiento,municipio,estado) FROM '$tmpfname2' DELIMITER '|'; COMMIT); It is suppoused as I

Re: [PHP] Class ADODB - Method GenID() in MySQL

2006-07-19 Thread chris smith
On 7/19/06, Renne Rocha [EMAIL PROTECTED] wrote: Hello, I am using the ADODB class to connect to a MySQL server. I am trying to generate an ID with the method GenID(), but when I tried this: $id = $db-GenID('table'); The value of $id is equal to zero. I know that MySQL doesn't use

[PHP] Return XML using PHP and Content-Type with UTF-8 breaks the UTF-8

2006-07-19 Thread Mathijs
Hello there, I Have an problem with UTF-8 and XML. I Output perfect XML (according to IE, Opera and Firefox). I use the Content-Type header with text/xml; charset=utf-8. For some reason this breaks UTF-8 output. When i remove it it works. But i need the text/xml header. If i save an document

Re: [PHP] Class ADODB - Method GenID() in MySQL

2006-07-19 Thread John Meyer
Wouldn't this: $id = mysql_insert_id(); $query = UPDATE tablename SET id= . ($id + 1); $result = mysql_query($query); Be a little simpler. But like I said, I'm confused over the need for this in the first place, seeing as how an auto_incremented primary key is self-descriptive. or are you saving

Re: [PHP] Return XML using PHP and Content-Type with UTF-8 breaks the UTF-8

2006-07-19 Thread Ray Hauge
On Wednesday 19 July 2006 09:27, Mathijs wrote: Hello there, I Have an problem with UTF-8 and XML. I Output perfect XML (according to IE, Opera and Firefox). I use the Content-Type header with text/xml; charset=utf-8. For some reason this breaks UTF-8 output. When i remove it it works. But

[PHP] Basic PHP knowledge test

2006-07-19 Thread John Nichel
We're looking to hire an entry level php programmer here, and I've been tasked with writing the test to evaluate the potential candidates. Being the lazy guy that I am, I naturally turned to Google to see if I could find some tests that I could use. After clicking thru many links, and finding

Re: [PHP] Class ADODB - Method GenID() in MySQL

2006-07-19 Thread Renne Rocha
Yes, using the PHP functions for MySQL, it works. But I am using the abstraction class ADODB to make the queries in my database. Why? Probably we will change the database system (probably to PostgreSQL) and we don want to change all the code to make the things work in the new BD. I don't know

Re: [PHP] Basic PHP knowledge test

2006-07-19 Thread Ray Hauge
On Wednesday 19 July 2006 10:31, John Nichel wrote: We're looking to hire an entry level php programmer here, and I've been tasked with writing the test to evaluate the potential candidates. Being the lazy guy that I am, I naturally turned to Google to see if I could find some tests that I

RE: [PHP] Basic PHP knowledge test

2006-07-19 Thread Jim Moseby
We're looking to hire an entry level php programmer here, and I've been tasked with writing the test to evaluate the potential candidates. Being the lazy guy that I am, I naturally turned to Google to see if I could find some tests that I could use. After clicking thru many links,

RE: [PHP] Basic PHP knowledge test

2006-07-19 Thread KermodeBear
Does anyone have any links/resources for a basic php knowledge test? If not, I'll have to write one from scratch myself, and mess up the rest of my day of goofing off/sleeping. It wouldn't hurt to pick up one of those Zend PHP Certification study guides and pull some things from there.

Re: [PHP] Basic PHP knowledge test

2006-07-19 Thread John Nichel
Jim Moseby wrote: stock answer STFW! RTFM!! STFA!! STFU!! /stock answer That totally goes against my being lazy. Hell, I didn't get to where I am today by *not* exploiting the 'little people' :-p -- John C. Nichel IV Programmer/System Admin (ÜberGeek) Dot Com Holdings of Buffalo

Re: [PHP] Basic PHP knowledge test

2006-07-19 Thread John Nichel
Ray Hauge wrote: On Wednesday 19 July 2006 10:31, John Nichel wrote: We're looking to hire an entry level php programmer here, and I've been tasked with writing the test to evaluate the potential candidates. Being the lazy guy that I am, I naturally turned to Google to see if I could find some

Re: [PHP] Basic PHP knowledge test

2006-07-19 Thread Ray Hauge
On Wednesday 19 July 2006 11:12, John Nichel wrote: Yeah, reading the writing on the wall, I think I'm just going to have to suck it up, and write it. The worst part of it is, I'm going to have to be involved in the interview process, and I'm *not* a people person. ;) I think I'll go with a

Re: [PHP] Class ADODB - Method GenID() in MySQL

2006-07-19 Thread Lester Caine
Renne Rocha wrote: Yes, using the PHP functions for MySQL, it works. But I am using the abstraction class ADODB to make the queries in my database. Why? Probably we will change the database system (probably to PostgreSQL) and we don want to change all the code to make the things work in the

Re: [PHP] Basic PHP knowledge test

2006-07-19 Thread Rory Browne
On 7/19/06, KermodeBear [EMAIL PROTECTED] wrote: Does anyone have any links/resources for a basic php knowledge test? If not, I'll have to write one from scratch myself, and mess up the rest of my day of goofing off/sleeping. It wouldn't hurt to pick up one of those Zend PHP Certification

Re: [PHP] Class ADODB - Method GenID() in MySQL

2006-07-19 Thread Lester Caine
Renne Rocha wrote: Yes, using the PHP functions for MySQL, it works. But I am using the abstraction class ADODB to make the queries in my database. Why? Probably we will change the database system (probably to PostgreSQL) and we don want to change all the code to make the things work in the

[PHP] Problem With Cookies

2006-07-19 Thread Prathaban Mookiah
I have run into a wierd problem with cookies. I am trying to set a cookie as usual: $COOKIE_EXPIRES = 3600; $COOKIE_VALID_PATH = /mydirectory/; $COOKIE_DOMAIN = .myhost.com setcookie(mycookie1, somevalue, time()+$COOKIE_EXPIRES, $COOKIE_VALID_PATH, $COOKIE_DOMAIN, 0) I want this cookie to be

Re: [PHP] pg_query and COPY in transaction

2006-07-19 Thread Luis Magaña
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've found the problem and this is not a PHP issue with the pg_query function at all. It turned out the COPY command was executing properly since the specified file for copying records was empty, therefore the COPY was not issuing any error as it

RE: [PHP] GD to database directly

2006-07-19 Thread Jay Blanchard
[snip] ... some research ... [/snip] So, am I to assume that this issue about storing images in databases is dead? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] pg_query and COPY in transaction

2006-07-19 Thread Jochem Maas
Luis Magaña wrote: I've found the problem and this is not a PHP issue with the pg_query function at all. It turned out the COPY command was executing properly since the specified file for copying records was empty, therefore the COPY was not issuing any error as it should be. LOL. It's

RE: [PHP] Class ADODB - Method GenID() in MySQL

2006-07-19 Thread Brady Mitchell
-Original Message- I am using the ADODB class to connect to a MySQL server. I am trying to generate an ID with the method GenID(), but when I tried this: $id = $db-GenID('table'); The value of $id is equal to zero. I know that MySQL doesn't use sequences like PostgreSQL

[PHP] Re: Different php.ini files for different apache processes on one server

2006-07-19 Thread spam
On 19 Jul 2006, [EMAIL PROTECTED] wrote: You could chroot each apache instance but I would probably try to modify the apache module to accept a parameter (and in the process verify that one does not already exist). Thanks to all for the answers. As the solution has to work with Apache 1 I

Re: [PHP] forcing a script to run on page unload

2006-07-19 Thread tedd
At 9:32 PM -0700 7/18/06, jekillen wrote: Hi: I have a web application that creates files and directories to save info for a user. If the user decides to link to another page or site altogether I want to run a script that will clean up after him or her but won't interfere with where they are

Re: [PHP] Problem With Cookies

2006-07-19 Thread Prathaban Mookiah
This is with regard to my earlier mail today morning. In fact I found out that, that problem is due to the way the timestamp is handled. Are there any safe ways to handle cookie expiry time regardless of the time system the client uses? Prathap -- Original Message --- From:

Re: [PHP] Basic PHP knowledge test

2006-07-19 Thread tedd
At 12:12 PM -0400 7/19/06, John Nichel wrote: The worst part of it is, I'm going to have to be involved in the interview process, and I'm *not* a people person. ;) Really, who would have guessed that? ;) tedd --

[PHP] Open Source mailinglist?

2006-07-19 Thread Gustav Wiberg
Hi there! I hope you don't kill me out there, but I'm totally out of luck here. I've been doing some research on Open Source questions because I want a product of mine to become better in any ways (yes, it's written in PHP and yes, it's Open Source). Because of not doing advertising here,

Re: [PHP] Basic PHP knowledge test

2006-07-19 Thread tedd
At 11:31 AM -0400 7/19/06, John Nichel wrote: We're looking to hire an entry level php programmer here, and I've been tasked with writing the test to evaluate the potential candidates. Being the lazy guy that I am, I naturally turned to Google to see if I could find some tests that I could use.

RE: [PHP] Open Source mailinglist?

2006-07-19 Thread Jay Blanchard
[snip] I hope you don't kill me out there, but I'm totally out of luck here. I've been doing some research on Open Source questions because I want a product of mine to become better in any ways (yes, it's written in PHP and yes, it's Open Source). Because of not doing advertising here, I'll

RE: [PHP] GD to database directly

2006-07-19 Thread tedd
At 12:36 PM -0500 7/19/06, Jay Blanchard wrote: [snip] ... some research ... [/snip] So, am I to assume that this issue about storing images in databases is dead? Yes, it was dead before it started, as it was the last time this issue was discussed. Simply put, there are tradeoffs, but both

Re: [PHP] Open Source mailinglist?

2006-07-19 Thread Gustav Wiberg
[snip] I hope you don't kill me out there, but I'm totally out of luck here. I've been doing some research on Open Source questions because I want a product of mine to become better in any ways (yes, it's written in PHP and yes, it's Open Source). Because of not doing advertising here, I'll skip

Re: [PHP] Class ADODB - Method GenID() in MySQL

2006-07-19 Thread Chris
John Meyer wrote: Wouldn't this: $id = mysql_insert_id(); $query = UPDATE tablename SET id= . ($id + 1); $result = mysql_query($query); Be a little simpler. But like I said, I'm confused over the need for this in the first place, seeing as how an auto_incremented primary key is

[PHP] ROZ pdf

2006-07-19 Thread weetat
Hi all, I am using EZpdf class to create pdf in mysql database . The Ezpdf class is open source tool for auto-creation of pdf in php , the link is http://sourceforge.net/projects/pdf-php I have the problem with tool , the pdf page is blank , eventhough have some data in my MySQL database .

Re: [PHP] ROZ pdf

2006-07-19 Thread Chris
weetat wrote: Hi all, I am using EZpdf class to create pdf in mysql database . The Ezpdf class is open source tool for auto-creation of pdf in php , the link is http://sourceforge.net/projects/pdf-php I have the problem with tool , the pdf page is blank , eventhough have some data in my

RE: [PHP] Open Source mailinglist?

2006-07-19 Thread Paul Scott
On Wed, 2006-07-19 at 17:03 -0500, Jay Blanchard wrote: I can't seem to find any place on the net where you can discuss Open Source-related questions in general??? [/snip] Don't Sourceforge and Freshmeat have lists? You could also join your local LUG, or a site like

[PHP] doubt - session file size

2006-07-19 Thread suresh kumar
Hi, I am having one doubt,i am using session variable for storing details.but i am afraid if there is around 1 users,wherether session will be able to store all the datas of 1 users,as i know abt session is that a temporary file will be created in /tmp directory with session id